| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBanking |
| 1 | ADS1 | House Bank Accounts | 32 | AcctType | Account Type | VarChar | 1 | 0 | | |
| 2 | DSC1 | House Bank Accounts | 32 | AcctType | Account Type | VarChar | 1 | 0 | | |
| 3 | OPWB | PWZ - Bank Account | 22 | AcctType | Account Type | VarChar | 1 | 0 | | |
| TOPBusiness Partners |
| 4 | ACR3 | Business Partner Control Accounts - History | 2 | AcctType | Account Type | VarChar | 1 | 0 | M | A=Assets Account, C=Bill of Exchange on Collection, D=Down Payment, F=Foreign, I=Bill of Exchange Discounted, M=Domestic, O=Open Debts, P=Bill of Exchange Accounts Payable, R=Bill of Exchange Accounts Receivable, S=Bill of Exchange Presentation, U=Unpaid Bill of Exchange, Y=Assets Bill of Exchange Acct Payable |
| 5 | ACRB | Business Partner Bank Accounts - History | 22 | AcctType | Account Type | VarChar | 1 | 0 | | |
| 6 | CRD3 | BP Control Account | 2 | AcctType | Account Type | VarChar | 1 | 0 | M | A=Assets Account, C=Bill of Exchange on Collection, D=Down Payment, E=Exchange Rate Interim, F=Foreign, H=Cash Discount Interim, I=Bill of Exchange Discounted, M=Domestic, O=Open Debts, P=Bill of Exchange Accounts Payable, R=Bill of Exchange Accounts Receivable, S=Bill of Exchange Presentation, U=Unpaid Bill of Exchange, Y=Assets Bill of E |
| 7 | OCRB | BP - Bank Account | 22 | AcctType | Account Type | VarChar | 1 | 0 | | |
| TOPFinance |
| 8 | GBI2 | GBI Row 2 - G/L Account Master Records | 8 | AcctType | Account Type | nVarChar | 20 | 0 | | |
