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