| 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 | |