| 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 | |
TOPMarketing Documents |
3 | OLGL | Legal Data | 2 | SrcObjType | Source Object Type | nVarChar | 20 | 0 | -1 | |