| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFinance |
| 1 | TAX1 | VAT Transactions - Rows | 18 | BaseObjTyp | Base Object Type | nVarChar | 20 | 0 | -1 | 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 163=Correction A/P Invoice, 164=Correction A/P Invoice Reversals, 165=Correction A/R Invoice, 166=Correction A/R Invoice Reversals, 18=A/P Invoice, 19=A/P Credit Memo, 24=Incoming Payment, 25=Deposit, 30=Journal Transaction, 321=Intern |
| 2 | UTX1 | Unreported VAT Transactions - Rows | 18 | BaseObjTyp | Base Object Type | nVarChar | 20 | 0 | -1 | 112=Document Draft, 123=Checks for Payment Drafts, 140=Payment Draft, 15=Delivery notes, 16=Revert Delivery Notes, 17=Sales Order, 20=Goods Receipt, 21=Goods Return, 22=Purchase order, 23=Sales Quotation, 28=Journal Batches, 540000006=Purchase Quotation, 59=Goods Receipt, 60=Goods Issue |
| 3 | UWTX1 | WTax Transactions - Rows | 6 | BaseObjTyp | Base Object Type | nVarChar | 20 | 0 | -1 | |
| 4 | WTX1 | WTax Transactions - Rows | 6 | BaseObjTyp | Base Object Type | nVarChar | 20 | 0 | -1 | |
| TOPGeneral |
| 5 | ORCJ | Resource Capacity Log | 10 | BaseObjTyp | Base Object Type | Int | 11 | 0 | -1 | 202=Production Order |
