| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AUSR | Users - History | 1 | USERID | User Signature | Int | 6 | 0 | | |
2 | AWFQ | SWFQ History Table | 9 | UserID | UserID | nVarChar | 25 | 0 | | |
3 | CDRU | Drag & Relate User Settings | 1 | UserID | User ID | Int | 11 | 0 | -1 | |
4 | CULG | Company Upgrade Log | 10 | UserID | User Signature | Int | 11 | 0 | | |
5 | OMSG | Messaging Service Settings | 1 | USERID | User Signature | Int | 6 | 0 | -1 | |
6 | OUSR | Users | 1 | USERID | User Signature | Int | 6 | 0 | | |
7 | WST1 | Confirmation Level - Rows | 2 | UserID | User Code | Int | 11 | 0 | -1 | |
8 | WTM1 | Approval Templates - Producers | 2 | UserID | User Code | Int | 11 | 0 | -1 | |
TOPBanking |
9 | OCHH | Check Register | 26 | UserID | User Signature | Int | 6 | 0 | | |
10 | OPEX | Payment Results Table | 134 | UserId | User ID | Int | 6 | 0 | | |
TOPFinance |
11 | OCFL | Cash Flow Additional Trans. | 10 | UserId | User ID | Int | 6 | 0 | | |
TOPGeneral |
12 | ATSH | Project Management Time Sheet - Header - History | 5 | UserID | User ID | Int | 11 | 0 | | |
13 | OCMF | Common Functions of Fiori-Style Cockpit | 1 | UserID | User ID | Int | 6 | 0 | | |
14 | OPRI | Browser Access Printers | 3 | UserID | User ID | Int | 6 | 0 | | |
15 | OTSH | Project Management Time Sheet - Header | 5 | UserID | User ID | Int | 11 | 0 | | |
16 | OUAL | User Action Log | 2 | UserId | User Id | Int | 6 | 0 | | |
17 | SEVT | SEVT | 11 | UserID | Modified by user | nVarChar | 155 | 0 | | |
18 | SWFQ | SWFQ | 9 | UserID | UserID | nVarChar | 25 | 0 | | |
19 | UIC3 | Template User Customization | 2 | UserID | User ID | Int | 6 | 0 | | |
20 | UIC4 | Forms in Assigned Templates | 3 | UserID | User ID | Int | 6 | 0 | | |
21 | UICU | Customized Template | 4 | UserID | User ID | Int | 6 | 0 | | |
22 | USR7 | Group User Association | 1 | UserId | User ID | Int | 6 | 0 | | |
23 | USR8 | Point of Issue User Association | 1 | UserId | User ID | Int | 6 | 0 | | |
TOPHuman Resources |
24 | AHEM | Employees - History | 18 | userId | User ID | Int | 11 | 0 | | |
25 | OHEM | Employees | 18 | userId | User ID | Int | 11 | 0 | | |
TOPMarketing Documents |
26 | WDD1 | Documents for Approval - Authorizers | 3 | UserID | Authorizer Code | Int | 11 | 0 | | |
TOPReports |
27 | OEML | E-mail Log | 10 | USERID | User Signature | Int | 6 | 0 | | |
28 | OSEL | Selection Lists | 1 | UserID | User Signature | Int | 6 | 0 | | |
29 | RDFL | Document Standards | 2 | UserId | User Signature | Int | 11 | 0 | | |