| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | AUSR | Archive Users - History | 1 | USERID | User Signature | Int | 6 | 0 | | |
| 2 | AWFQ | SWFQ History Table | 9 | UserID | UserID | nVarChar | 8 | 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 | | |
| TOPFinance |
| 10 | OCFL | Cash Flow Additional Trans. | 10 | UserId | User ID | Int | 6 | 0 | | |
| TOPGeneral |
| 11 | OCMF | Common Functions of Fiori-Style Cockpit | 1 | UserID | User ID | Int | 6 | 0 | | |
| 12 | OUAL | User Action Log | 2 | UserId | User Id | Int | 6 | 0 | | |
| 13 | SEVT | SEVT | 11 | UserID | Modified by user | nVarChar | 155 | 0 | | |
| 14 | SWFQ | SWFQ | 9 | UserID | UserID | nVarChar | 8 | 0 | | |
| 15 | UIC3 | Template User Customization | 2 | UserID | User ID | Int | 6 | 0 | | |
| 16 | UIC4 | Forms in Assigned Templates | 3 | UserID | User ID | Int | 6 | 0 | | |
| 17 | UICU | Customized Template | 4 | UserID | User ID | Int | 6 | 0 | | |
| 18 | USR7 | Group User Association | 1 | UserId | User ID | Int | 6 | 0 | | |
| 19 | USR8 | Point of Issue User Association | 1 | UserId | User ID | Int | 6 | 0 | | |
| TOPHuman Resources |
| 20 | AHEM | Employees | 18 | userId | User ID | Int | 11 | 0 | | |
| 21 | OHEM | Employees | 18 | userId | User ID | Int | 11 | 0 | | |
| TOPMarketing Documents |
| 22 | WDD1 | Documents for Approval - Authorizers | 3 | UserID | Authorizer Code | Int | 11 | 0 | | |
| TOPReports |
| 23 | RDFL | Document Standards | 2 | UserId | User Signature | Int | 11 | 0 | | |
