| 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 | ACLG | Activities - History | 85 | ActType | Activity Type | Int | 11 | 0 | | |
| 3 | ACRB | Business Partner Bank Accounts - History | 42 | ActType | Account Type | VarChar | 1 | 0 | | C=Checking Account, S=Savings Account |
| 4 | OCLG | Activities | 85 | ActType | Activity Type | Int | 11 | 0 | | |
| 5 | OCRB | BP - Bank Account | 42 | ActType | Account Type | VarChar | 1 | 0 | | C=Checking Account, S=Savings Account |
| TOPFinance |
| 6 | AACT | G/L Account - History | 24 | ActType | Account Type | VarChar | 1 | 0 | N | E=Expenditure, I=Sales, N=Other |
| 7 | OACT | G/L Accounts | 24 | ActType | Account Type | VarChar | 1 | 0 | N | E=Expenditure, I=Sales, N=Other |
| 8 | OIWZ | Inflation Wizard | 23 | ActType | Account Type | VarChar | 1 | 0 | A | A=Post amount to adjustment account, S=Post amount to inventory account |
| TOPGeneral |
| 9 | ASH1 | Project Management Time Sheet - Rows - History | 4 | ActType | Activity Type | Int | 11 | 0 | | |
| 10 | MACT | MACT | 7 | actType | Action Type | VarChar | 1 | 0 | | |
| 11 | PMC5 | Project Management Configuration - Activity Type | 2 | ActType | Activity Type | nVarChar | 100 | 0 | | |
| 12 | TSH1 | Project Management Time Sheet - Rows | 4 | ActType | Activity Type | Int | 11 | 0 | | |
| TOPReports |
| 13 | AEC2 | Electronic Transactions | 4 | ActType | Action Type | VarChar | 1 | 0 | | A=Internal Reconciliation, B=BP Check, C=Contingency, D=Document A/R, E=A/P Draft Document, F=A/R Draft Document, I=Payment - Incoming, K=Skip, O=Other, P=Document A/P, R=Report, S=Setup, T=Transportation Document, U=Payment - Outgoing, W=Inventory Transfer |
| 14 | ECM2 | Electronic Transactions | 4 | ActType | Action Type | VarChar | 1 | 0 | | A=Internal Reconciliation, B=BP Check, C=Contingency, D=Document A/R, E=A/P Draft Document, F=A/R Draft Document, I=Payment - Incoming, K=Skip, L=VAT Liabilities, N=VAT Declarations, O=Other, P=Document A/P, R=Report, S=Setup, T=Transportation Document, U=Payment - Outgoing, V=VAT Obligations, W=Inventory Transfer, Y=VAT Payments |
