| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBanking |
| 1 | OPWB | PWZ - Bank Account | 42 | ActType | Account Type | VarChar | 1 | 0 | | C=Checking Account, S=Savings Account |
| TOPBusiness Partners |
| 2 | ACRB | Business Partner Bank Accounts - History | 42 | ActType | Account Type | VarChar | 1 | 0 | | C=Checking Account, S=Savings Account |
| 3 | OCRB | BP - Bank Account | 42 | ActType | Account Type | VarChar | 1 | 0 | | C=Checking Account, S=Savings Account |
| TOPFinance |
| 4 | AACT | G/L Account - History | 24 | ActType | Account Category | VarChar | 1 | 0 | N | E=Expenditure, I=Sales, N=Other |
| 5 | OACT | G/L Accounts | 24 | ActType | Account Category | VarChar | 1 | 0 | N | E=Expenditure, I=Sales, N=Other |
| 6 | OIWZ | Inflation Wizard | 23 | ActType | Account Type | VarChar | 1 | 0 | A | A=Post amount to adjustment account, S=Post amount to inventory account |
| TOPReports |
| 7 | AEC2 | Electronic Transactions | 3 | ActType | Action Type | VarChar | 1 | 0 | | B=BP Check, C=Contingency, D=Document A/R, F=Draft, K=Skip, O=Other, P=Document A/P, R=Report, S=Setup |
| 8 | ECM2 | Electronic Transactions | 3 | ActType | Action Type | VarChar | 1 | 0 | | B=BP Check, C=Contingency, D=Document A/R, F=Draft, K=Skip, O=Other, P=Document A/P, R=Report, S=Setup |
