| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | DAR1 | Data Archive - Transaction Log | 3 | DocType | Document Type | nVarChar | 20 | 0 | | |
| 2 | DAR2 | Data Archive - Transaction Log | 4 | DocType | Document Type | Int | 11 | 0 | | |
| 3 | DAR3 | Data Archive - Handwritten Documents | 3 | DocType | Document Type | nVarChar | 20 | 0 | | |
| 4 | ODW1 | Default Open Documents | 2 | DocType | Open Document Type | Int | 11 | 0 | | |
| 5 | OTCX | Tax Code Determination | 3 | DocType | Document Type | Int | 11 | 0 | | 0=Item, 1=Service, 2=Item & Service |
| TOPBanking |
| 6 | ARCT | Incoming Payment - History | 3 | DocType | Document Type | VarChar | 1 | 0 | C | |
| 7 | BNK2 | Bank Statement - Recommendation List | 5 | DocType | Document Type | Int | 6 | 0 | | -1=All transactions, -2=Opening Balance, -3=Closing Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Returns, 24=Incoming Payment, 25=Deposit, 30=Journal Entry, 46=Payment Advice, 57=Che |
| 8 | ODTY | BoE Document Type | 2 | DocType | Document Type | nVarChar | 2 | 0 | | |
| 9 | OPDF | Payment Draft | 3 | DocType | Document Type | VarChar | 1 | 0 | | |
| 10 | OPYM | Payment Methods for Payment Wizard | 36 | DocType | BoE Document Type | nVarChar | 2 | 0 | | |
| 11 | ORCT | Incoming Payment | 3 | DocType | Document Type | VarChar | 1 | 0 | C | |
| 12 | OVPM | Outgoing Payments | 3 | DocType | Document Type | VarChar | 1 | 0 | S | |
| TOPBusiness Partners |
| 13 | ACP1 | Campaign - BPs | 29 | DocType | Document Type | VarChar | 1 | 0 | E | |
| 14 | CPN1 | Campaign - BPs | 29 | DocType | Document Type | VarChar | 1 | 0 | E | |
| 15 | OCLG | Activities | 14 | DocType | Linked Document | nVarChar | 20 | 0 | -1 | |
| TOPFinance |
| 16 | AJDT | Journal Entry - History | 52 | DocType | Document Type | nVarChar | 60 | 0 | | |
| 17 | GBI7 | GBI Row 7 - Accounting Vouchers | 4 | DocType | Document Type | nVarChar | 12 | 0 | | |
| 18 | OBTF | Journal Voucher Entry | 52 | DocType | Transact. Type | nVarChar | 60 | 0 | | |
| 19 | OFRT | Financial Report Templates | 3 | DocType | Document Type | VarChar | 1 | 0 | B | |
| 20 | OJDT | Journal Entry | 52 | DocType | Document Type | nVarChar | 60 | 0 | | |
| 21 | OVTR | Tax Report | 17 | DocType | A/P or A/R | VarChar | 1 | 0 | P | |
| TOPInventory and Production |
| 22 | OIGE | Goods Issue | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 23 | OIGN | Goods Receipt | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 24 | OITL | Inventory Transactions Log | 8 | DocType | Transact. Type | Int | 11 | 0 | -1 | |
| 25 | OWTQ | Inventory Transfer Request | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 26 | OWTR | Inventory Transfer | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| TOPMarketing Documents |
| 27 | ADOC | Invoice - History | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 28 | ATX1 | Tax Invoice - History - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment, R=Payment Request |
| 29 | ATXI | Tax Invoice - History | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 30 | DWZ2 | Dunning Wizard Array 2-Invoice Filter | 17 | DocType | Source Table | Int | 11 | 0 | | |
| 31 | IVM1 | Invoice Mapping Object Details | 3 | DocType | Document Type | nVarChar | 20 | 0 | | |
| 32 | MIN1 | Monthly Invoice Report Document Information | 4 | DocType | Document Object ID | nVarChar | 20 | 0 | | 13=A/R Invoice, 14=A/R Credit Memo |
| 33 | MIN2 | Item Imformation of MI | 3 | DocType | Document Type | nVarChar | 20 | 0 | | 13=A/R Invoice, 14=A/R Credit Memo |
| 34 | MIV1 | A/P Monthly Invoice - Document | 4 | DocType | Document Object ID | nVarChar | 20 | 0 | | 18=A/P Invoice, 19=A/P Credit Memo |
| 35 | MIV2 | A/P Monthly Invoice - Item | 3 | DocType | Document Type | nVarChar | 20 | 0 | | 18=A/P Invoice, 19=A/P Credit Memo |
| 36 | OCIN | A/R Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 37 | OCPI | A/P Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 38 | OCPV | A/P Correction Invoice Reversal | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 39 | OCSI | A/R Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 40 | OCSV | A/R Correction Invoice Reversal | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 41 | ODLN | Delivery | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 42 | ODPI | A/R Down Payment | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 43 | ODPO | A/P Down Payment | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 44 | ODRF | Drafts | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 45 | OIEI | Incoming Excise Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 46 | OINV | A/R Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 47 | OOEI | Outgoing Excise Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 48 | OPCH | A/P Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 49 | OPDN | Goods Receipt PO | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 50 | OPOR | Purchase Order | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 51 | OPQT | Purchase Quotation | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 52 | OQUT | Sales Quotation | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 53 | ORDN | Returns | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 54 | ORDR | Sales Order | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 55 | ORIN | A/R Credit Memo | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 56 | ORPC | A/P Credit Memo | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 57 | ORPD | Goods Return | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 58 | OTPI | Purchase Tax Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 59 | OTSI | Sales Tax Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 60 | OTXD | Tax Invoice Draft | 3 | DocType | Document Type | VarChar | 1 | 0 | I | |
| 61 | TPI1 | Purchase Tax Invoice - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment |
| 62 | TSI1 | Sales Tax Invoice - Rows1 | 4 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment |
| 63 | TXD1 | Tax Invoice Drafts - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment, R=Payment Request |
| 64 | VRT2 | Tax Invoice Report Grid Info | 16 | DocType | Document Type | Int | 11 | 0 | | 13=A/R Invoice, 14=A/R Credit Memo, 203=A/R Down Payment |
| TOPMRP |
| 65 | MSN5 | MRP-Specific Document | 2 | DocType | Document Type | nVarChar | 20 | 0 | | |
| TOPReports |
| 66 | ORFL | Already Displayed 347, 349 and WTax Reports | 2 | DocType | Document Type | nVarChar | 20 | 0 | | 13=Invoice, 14=Revert Invoice, 18=Purchase, 19=Revert purchase, 203=A/R Down Payment, 204=A/P Down Payment |
| TOPSales Opportunities |
| 67 | OOPR | Sales Opportunity | 46 | DocType | Linked Document Type | nVarChar | 2 | 0 | -1 | 13=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 23=Quotations |
