| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBanking |
| 1 | ADS1 | House Bank Accounts | 35 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 2 | ARC4 | Incoming Payment - Account List - History | 10 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 3 | DSC1 | House Bank Accounts | 35 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 4 | OBNK | External Bank Statement Received | 4 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 5 | PDF4 | Payment Draft - Account List | 10 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 6 | RCC4 | Incoming Payment - Credit Vouchers | 10 | AcctName | Payment Method Code | nVarChar | 100 | 0 | -1 | |
| 7 | RCT4 | Incoming Payment - Account List | 10 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 8 | VPM4 | Outgoing Payments - Accounts | 10 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| TOPBusiness Partners |
| 9 | ACRB | Business Partner Bank Accounts - History | 25 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 10 | OCRB | BP - Bank Account | 25 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| TOPFinance |
| 11 | AACT | G/L Account - History | 2 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 12 | GBI2 | GBI Row 2 - G/L Account Master Records | 4 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 13 | GBI8 | GBI Row 8 - Enterprise's Balance Sheet | 3 | AcctName | Account Name | nVarChar | 100 | 0 | | |
| 14 | OACT | G/L Accounts | 2 | AcctName | Account Name | nVarChar | 100 | 0 | | |
