| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | DATB | Data Archive Tax Balance | 5 | MatType | Material Type | Int | 11 | 0 | | |
| 2 | OMTP | Material Type | 2 | MatType | Material Type | nVarChar | 50 | 0 | | |
| TOPBanking |
| 3 | ARC4 | Incoming Payment - Account List - History | 31 | MatType | Material Type | Int | 11 | 0 | 0 | |
| 4 | PDF4 | Payment Draft - Account List | 31 | MatType | Material Type | Int | 11 | 0 | 0 | |
| 5 | RCC4 | Incoming Payment - Credit Vouchers | 31 | MatType | Material Type | Int | 11 | 0 | 0 | |
| 6 | RCT4 | Incoming Payment - Account List | 31 | MatType | Material Type | Int | 11 | 0 | 0 | |
| 7 | TPW3 | Utilization and Payment | 12 | MatType | Material Type | Int | 11 | 0 | 0 | |
| 8 | VPM4 | Outgoing Payments - Accounts | 31 | MatType | Material Type | Int | 11 | 0 | 0 | |
| TOPFinance |
| 9 | AJD1 | Journal Entry - History - Rows | 88 | MatType | Material Type | Int | 11 | 0 | -1 | |
| 10 | AJDT | Journal Entry - History | 57 | MatType | Material Type | Int | 11 | 0 | | |
| 11 | BTF1 | Journal Voucher | 88 | MatType | Material Type | Int | 11 | 0 | -1 | |
| 12 | JDT1 | Journal Entry - Rows | 88 | MatType | Material Type | Int | 11 | 0 | -1 | |
| 13 | OBTF | Journal Voucher Entry | 57 | MatType | Material Type | Int | 11 | 0 | | |
| 14 | OJDT | Journal Entry | 57 | MatType | Material Type | Int | 11 | 0 | | |
| TOPInventory and Production |
| 15 | AITB | Item Groups - History | 65 | MatType | Material Type | nVarChar | 3 | 0 | 1 | |
| 16 | AITM | Items - History | 238 | MatType | Material Type | nVarChar | 3 | 0 | 1 | |
| 17 | OITB | Item Groups | 65 | MatType | Material Type | nVarChar | 3 | 0 | 1 | |
| 18 | OITM | Items | 238 | MatType | Material Type | nVarChar | 3 | 0 | 1 | |
| 19 | SITM | Items | 238 | MatType | Material Type | nVarChar | 3 | 0 | 1 | |
| 20 | UITM | Items | 238 | MatType | Material Type | nVarChar | 3 | 0 | 1 | |
