| 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 | | |
| TOPBanking |
| 4 | ARCT | Incoming Payment - History | 3 | DocType | Document Type | VarChar | 1 | 0 | C | A=Account, C=Customer, D=Yes, P=P.L.A, S=Vendor, T=TDS |
| 5 | 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 |
| 6 | ODTY | BoE Document Type | 2 | DocType | Document Type | nVarChar | 2 | 0 | | |
| 7 | OPDF | Payment Draft | 3 | DocType | Document Type | VarChar | 1 | 0 | C | A=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor |
| 8 | OPYM | Payment Methods for Payment Wizard | 36 | DocType | BoE Document Type | nVarChar | 2 | 0 | | |
| 9 | ORCT | Incoming Payment | 3 | DocType | Document Type | VarChar | 1 | 0 | C | A=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor, T=Tax |
| 10 | OVPM | Outgoing Payments | 3 | DocType | Document Type | VarChar | 1 | 0 | S | A=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor, T=Tax |
| TOPBusiness Partners |
| 11 | OCLG | Activities | 14 | DocType | Linked Document | nVarChar | 20 | 0 | -1 | 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery notes, 162=Material Revaluation, 163=Correction A/P Invoice, 164=Correction A/P Invoice Reversal, 165=Correction A/R Invoice, 166=Correction A/R Invoice Reversal, 16=A/R Return, 17=Sales Order, 18=A/ |
| TOPFinance |
| 12 | AJDT | Journal Entry - History | 52 | DocType | Document Type | nVarChar | 12 | 0 | | |
| 13 | GBI7 | GBI Row 7 - Accounting Vouchers | 4 | DocType | Document Type | nVarChar | 12 | 0 | | |
| 14 | OBTF | Journal Voucher Entry | 52 | DocType | Transact. Type | nVarChar | 12 | 0 | | |
| 15 | OFRT | Financial Report Templates | 3 | DocType | Document Type | VarChar | 1 | 0 | B | A=Cost Accounting, B=Balance Sheet, C=Trial Balance, D=Profit Distribution, E=Asset Devalue Provision, F=Cash Flow, L=e-Balance Sheet, O=e-Profit and Loss, P=Profit and Loss, R=Shareholder's Rights and Interests Changing, S=Sales Unit, T=Form 6111, V=VAT Payable Detail |
| 16 | OJDT | Journal Entry | 52 | DocType | Document Type | nVarChar | 12 | 0 | | |
| 17 | OVTR | Tax Report | 17 | DocType | A/P or A/R | VarChar | 1 | 0 | P | P=Purchasing Documents, R=Sales Documents |
| TOPInventory and Production |
| 18 | OIGE | Goods Issue | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 19 | OIGN | Goods Receipt | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 20 | OITL | Inventory Transactions Log | 8 | DocType | Transact. Type | Int | 11 | 0 | -1 | |
| 21 | OWTR | Inventory Transfer | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| TOPMarketing Documents |
| 22 | ADOC | Invoice - History | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 23 | ATX1 | Tax Invoice - History - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment, R=Payment Request |
| 24 | ATXI | Tax Invoice - History | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment |
| 25 | DWZ2 | Dunning Wizard Array 2-Invoice Filter | 17 | DocType | Source Table | Int | 11 | 0 | | -2=Open Balance, -3=Close Balance, 13=A/R Invoice, 14=A/R Credit Memo, 165=Correction A/R Invoice, 203=Down Payment Incoming, 24=Incoming Payment, 30=Journal Transactions |
| 26 | MIN1 | Monthly Invoice Report Document Information | 4 | DocType | Document Object ID | nVarChar | 20 | 0 | | 13=A/R Invoice, 14=A/R Credit Memo |
| 27 | MIN2 | Item Imformation of MI | 3 | DocType | Document Type | nVarChar | 20 | 0 | | 13=A/R Invoice, 14=A/R Credit Memo |
| 28 | MIV1 | A/P Monthly Invoice - Document | 4 | DocType | Document Object ID | nVarChar | 20 | 0 | | 18=A/P Invoice, 19=A/P Credit Memo |
| 29 | MIV2 | A/P Monthly Invoice - Item | 3 | DocType | Document Type | nVarChar | 20 | 0 | | 18=A/P Invoice, 19=A/P Credit Memo |
| 30 | OCIN | A/R Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 31 | OCPI | A/P Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 32 | OCPV | A/P Correction Invoice Reversal | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 33 | OCSI | A/R Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 34 | OCSV | A/R Correction Invoice Reversal | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 35 | ODLN | Delivery | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 36 | ODPI | A/R Down Payment | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 37 | ODPO | A/P Down Payment | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 38 | ODRF | Drafts | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 39 | OIEI | Incoming Excise Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 40 | OINV | A/R Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 41 | OOEI | Outgoing Excise Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 42 | OPCH | A/P Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 43 | OPDN | Goods Receipt PO | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 44 | OPOR | Purchase Order | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 45 | OQUT | Sales Quotation | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 46 | ORDN | Returns | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 47 | ORDR | Sales Order | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 48 | ORIN | A/R Credit Memo | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 49 | ORPC | A/P Credit Memo | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 50 | ORPD | Goods Return | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 51 | OTPI | Purchase Tax Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment |
| 52 | OTSI | Sales Tax Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment |
| 53 | OTXD | Tax Invoice Draft | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment |
| 54 | TPI1 | Purchase Tax Invoice - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment |
| 55 | TSI1 | Sales Tax Invoice - Rows1 | 4 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment |
| 56 | TXD1 | Tax Invoice Drafts - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | I=Invoice, J=Journal Entry, P=Payment, R=Payment Request |
| 57 | 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 |
| TOPReports |
| 58 | 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 |
| 59 | OOPR | Sales Opportunity | 46 | DocType | Linked Document Type | nVarChar | 2 | 0 | -1 | 13=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 23=Quotations |
