| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | AUSR | Archive Users - History | 35 | Branch | Branch | Int | 6 | 0 | -2 | |
| 2 | OUSR | Users | 35 | Branch | Branch | Int | 6 | 0 | -2 | |
| TOPBanking |
| 3 | ACHO | Checks for Payment - History | 4 | Branch | Branch | nVarChar | 50 | 0 | | |
| 4 | ADS1 | House Bank Accounts | 3 | Branch | Branch | nVarChar | 50 | 0 | | |
| 5 | ARC1 | Incoming Payment - Checks - History | 6 | Branch | Branch Number | nVarChar | 50 | 0 | | |
| 6 | DSC1 | House Bank Accounts | 3 | Branch | Branch | nVarChar | 50 | 0 | | |
| 7 | OCHD | Checks for Payment Drafts | 4 | Branch | Branch | nVarChar | 50 | 0 | | |
| 8 | OCHH | Check Register | 4 | Branch | Branch Number | nVarChar | 50 | 0 | | |
| 9 | OCHO | Checks for Payment | 4 | Branch | Branch | nVarChar | 50 | 0 | | |
| 10 | OPYM | Payment Methods for Payment Wizard | 21 | Branch | Branch | nVarChar | 50 | 0 | | |
| 11 | PDF1 | Payment Draft - Checks | 6 | Branch | Branch Number | nVarChar | 50 | 0 | | |
| 12 | RCT1 | Incoming Payment - Checks | 6 | Branch | Branch Number | nVarChar | 50 | 0 | | |
| 13 | VPM1 | Outgoing Payments - Check Rows | 6 | Branch | Branch Number | nVarChar | 50 | 0 | | |
| TOPBusiness Partners |
| 14 | ACRB | Business Partner Bank Accounts - History | 6 | Branch | Bank No. | nVarChar | 50 | 0 | | |
| 15 | OCRB | BP - Bank Account | 6 | Branch | Branch No. | nVarChar | 50 | 0 | | |
| TOPHuman Resources |
| 16 | AHEM | Employees | 9 | branch | Branch | Int | 6 | 0 | | |
| 17 | HEM5 | Employee Data Ownership Authorization | 7 | Branch | Branch Authorization | VarChar | 1 | 0 | N | F=Full, N=None, R=Read Only, U=Undefined |
| 18 | OHEM | Employees | 9 | branch | Branch | Int | 6 | 0 | | |
