| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | RLS1 | Reference Links Sources Definition | 3 | SrcObjType | Source Object Type | nVarChar | 20 | 0 | | |
| 2 | TPL1 | Template - Records | 5 | SrcObjType | Source Object Type | Int | 11 | 0 | -1 | |
| TOPFinance |
| 3 | OFIX | Fixed Asset Transactions | 2 | SrcObjType | Source Object Type | nVarChar | 20 | 0 | | |
| 4 | 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 |
| 5 | 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, 540000006=Purchase Quotation, 59=Goods Receipt, 60=Goods Issue |
| 6 | OUWTX | Unreported WTax Transactions | 2 | SrcObjType | Source Object Type | nVarChar | 20 | 0 | -1 | 13=A/R Invoice, 14=A/R Credit Memo, 18=A/P Invoice, 19=A/P Credit Memo, 24=Incoming Payment, 46=Outgoing Payment |
| 7 | OWTX | WTax Transactions | 2 | SrcObjType | Source Object Type | nVarChar | 20 | 0 | -1 | 13=A/R Invoice, 14=A/R Credit Memo, 18=A/P Invoice, 19=A/P Credit Memo, 24=Incoming Payment, 46=Outgoing Payment |
| TOPGeneral |
| 8 | ORCJ | Resource Capacity Log | 7 | SrcObjType | Source Object Type | Int | 11 | 0 | -1 | -13=A/R Reserve Invoice, -18=A/P Reserve Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 202=Production Order, 20=Goods Receipt PO, 21=Go |
| TOPMarketing Documents |
| 9 | OLGL | Legal Data | 2 | SrcObjType | Source Object Type | nVarChar | 20 | 0 | -1 | 13=A/R Invoice, 14=A/R Credit Memo |
| TOPReports |
| 10 | AEC2 | Electronic Transactions | 14 | SrcObjType | Source Object Type | nVarChar | 20 | 0 | | |
| 11 | ECM2 | Electronic Transactions | 14 | SrcObjType | Source Object Type | nVarChar | 20 | 0 | | |
