| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | WTM3 | Approval Templates - Documents | 2 | TransType | Original Document | nVarChar | 20 | 0 | | |
| TOPFinance |
| 2 | AJD1 | Journal Entry - History - Rows | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 3 | AJDT | Journal Entry - History | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 4 | BTF1 | Journal Voucher | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 5 | JDT1 | Journal Entry - Rows | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 6 | OBTF | Journal Voucher Entry | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 7 | OCFT | Cash Flow Transactions - Rows | 14 | TransType | Source Object | nVarChar | 20 | 0 | | |
| 8 | OJDT | Journal Entry | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 9 | SLM1 | Special Ledger - Analytical Accounting Report Lines: Material | 5 | TransType | Transaction Type Number | Int | 6 | 0 | | |
| 10 | SLR1 | Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses | 5 | TransType | Transaction Type Number | Int | 6 | 0 | | |
| TOPInventory and Production |
| 11 | OAIM | Archive Inventory Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 12 | OILM | Inventory Log Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 13 | OIMT | Templates for Inventory JE | 2 | TransType | Transaction type | Int | 11 | 0 | -1 | |
| 14 | OINM | Whse Journal | 2 | TransType | Transaction Type | Int | 11 | 0 | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, 10000071=Inventory Posting, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 310000001=Initial Quantity, 58=Stock Update, 59=Goods Receipt, 60=Goods Issue, 67= |
| 15 | OIVL | Whse Journal | 1 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 16 | SIVL | Whse Journal | 1 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 17 | UILM | IVI Inventory Log Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 18 | UIVL | Whse Journal | 1 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
