| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | OTAX | VAT Transactions | 2 | SrcObjType | Source 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 | OUTX | Unreported VAT Transactions | 2 | SrcObjType | Source 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, 59=Goods Receipt, 60=Goods Issue |