| 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 | FTT1 | Financial Template Import - Files | 8 | DocType | Template Type | VarChar | 1 | 0 | B | A=Cost Accounting, B=Balance Sheet, C=Trial Balance, D=Profit Distribution, E=Asset Devalue Provision, F=Statement of Cash Flows, G=Others, H=Asset History Sheet, I=Taxable Profit and Loss, J=Appropriation of Net Profit, K=E-Asset History Sheet, L=e-Balance Sheet, O=e-Profit and Loss, P=Profit and Loss, R=Shareholder's Rights and Interests |
| 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 | A=Account, C=Customer, D=Yes, P=P.L.A, S=Vendor, T=TDS |
| 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 | | A=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor |
| 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 | A=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor, T=Tax |
| 12 | 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 |
| 13 | ACP1 | Campaign - BPs | 29 | DocType | Document Type | nVarChar | 20 | 0 | -1 | D=Deliveries, I=A/R Invoices, O=Sales Orders, P=Opportunities, Q=Sales Quotations |
| 14 | CPN1 | Campaign - BPs | 29 | DocType | Document Type | nVarChar | 20 | 0 | -1 | 13=A/R Invoices, 15=Deliveries, 17=Sales Orders, 23=Sales Quotations, 97=Opportunities |
| 15 | OCLG | Activities | 14 | DocType | Linked Document | nVarChar | 20 | 0 | -1 | 1250000001=Inventory Transfer Request, 1250000025=Blanket Agreements, 1320000012=Campaign, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 1470000113=Purchase Request, 14=A/R Credit Memo, 15=Delivery, 162=Material Revaluation, 163=A/P Correction Invoice, 164=A/P Correction Invoi |
| TOPFinance |
| 16 | AFAD | Asset Document - History | 31 | DocType | Document Type | nVarChar | 15 | 0 | PL | AP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation |
| 17 | AJDT | Journal Entry - History | 52 | DocType | Document Type | nVarChar | 60 | 0 | | |
| 18 | GBI7 | GBI Row 7 - Accounting Vouchers | 4 | DocType | Document Type | nVarChar | 12 | 0 | | |
| 19 | OACD | Credit Memo | 31 | DocType | Document Type | nVarChar | 15 | 0 | PL | AP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation |
| 20 | OACQ | Capitalization | 31 | DocType | Document Type | nVarChar | 15 | 0 | PL | AP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation |
| 21 | OBTF | Journal Voucher Entry | 52 | DocType | Transact. Type | nVarChar | 60 | 0 | | |
| 22 | OFRT | Financial Report Templates | 3 | DocType | Template Type | VarChar | 1 | 0 | B | A=Cost Accounting, B=Balance Sheet, C=Trial Balance, D=Profit Distribution, E=Asset Devalue Provision, F=Statement of Cash Flows, G=Others, H=Asset History Sheet, I=Taxable Profit and Loss, J=Appropriation of Net Profit, K=E-Asset History Sheet, L=e-Balance Sheet, O=e-Profit and Loss, P=Profit and Loss, R=Shareholder's Rights and Interests |
| 23 | OFTR | Transfer | 31 | DocType | Document Type | nVarChar | 15 | 0 | PL | AP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation |
| 24 | OJDT | Journal Entry | 52 | DocType | Document Type | nVarChar | 60 | 0 | | |
| 25 | OMDP | Manual Depreciation | 31 | DocType | Document Type | nVarChar | 15 | 0 | PL | AP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation |
| 26 | ORTI | Retirement | 31 | DocType | Document Type | nVarChar | 15 | 0 | PL | AP=Appreciation, NC=Sales, PL=Ordinary Depreciation, SC=Scrapping, SD=Special Depreciation, TC=Asset Class Transfer, TR=Asset Transfer, UP=Unplanned Depreciation |
| 27 | OVTR | Tax Report | 17 | DocType | A/P or A/R | VarChar | 1 | 0 | P | P=Purchasing Documents, R=Sales Documents |
| TOPGeneral |
| 28 | ITMR | ITMR | 80 | DocType | Document Type | nVarChar | 4 | 0 | | |
| 29 | OBVL | Serial Numbers and Batch Valuation Log | 4 | DocType | Transact. Type | Int | 11 | 0 | -1 | |
| 30 | ODW1 | Default Open Documents | 2 | DocType | Open Document Type | Int | 11 | 0 | | |
| 31 | UBVL | Serial Numbers and Batch Valuation Log | 4 | DocType | Transact. Type | Int | 11 | 0 | -1 | |
| TOPInventory and Production |
| 32 | OIGE | Goods Issue | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 33 | OIGN | Goods Receipt | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 34 | OITL | Inventory Transactions Log | 8 | DocType | Transact. Type | Int | 11 | 0 | -1 | |
| 35 | ORTL | Resource Transaction Log | 3 | DocType | Transact. Type | Int | 11 | 0 | | |
| 36 | OWTQ | Inventory Transfer Request | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 37 | OWTR | Inventory Transfer | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| TOPMarketing Documents |
| 38 | ADOC | Invoice - History | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 39 | ATX1 | Tax Invoice - History - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | C=Correction Invoice, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment |
| 40 | ATXI | Tax Invoice - History | 3 | DocType | Document Type | VarChar | 1 | 0 | I | A=Alteration Invoice, B=Alteration Correction Invoice, C=Correction Invoice, D=Down Payment, I=Invoice, J=Journal Entry, P=Payment |
| 41 | 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, 46=Outgoing Payments |
| 42 | DWZ4 | Dunning Wizard Array 4-Paging Grid | 10 | 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 |
| 43 | GPA1 | Gross Profit Adjustment - Documents | 5 | DocType | Document Type | nVarChar | 20 | 0 | | |
| 44 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 9 | DocType | Choose | VarChar | 1 | 0 | I | I=Issue for Production, R=Receipt from Production |
| 45 | GPA9 | Applied Gross Profit Adjustments | 4 | DocType | Document Type | nVarChar | 20 | 0 | | |
| 46 | IVM1 | Invoice Mapping Object Details | 3 | DocType | Document Type | nVarChar | 20 | 0 | | |
| 47 | MIN1 | Monthly Invoice Report Document Information | 4 | DocType | Document Object ID | nVarChar | 20 | 0 | | 13=A/R Invoice, 14=A/R Credit Memo |
| 48 | MIN2 | Item Imformation of MI | 3 | DocType | Document Type | nVarChar | 20 | 0 | | 13=A/R Invoice, 14=A/R Credit Memo |
| 49 | MIV1 | A/P Monthly Invoice - Document | 4 | DocType | Document Object ID | nVarChar | 20 | 0 | | 18=A/P Invoice, 19=A/P Credit Memo |
| 50 | MIV2 | A/P Monthly Invoice - Item | 3 | DocType | Document Type | nVarChar | 20 | 0 | | 18=A/P Invoice, 19=A/P Credit Memo |
| 51 | OCIN | A/R Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 52 | OCPI | A/P Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 53 | OCPV | A/P Correction Invoice Reversal | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 54 | OCSI | A/R Correction Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 55 | OCSV | A/R Correction Invoice Reversal | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 56 | ODLN | Delivery | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 57 | ODPI | A/R Down Payment | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 58 | ODPO | A/P Down Payment | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 59 | ODRF | Drafts | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 60 | OIEI | Incoming Excise Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 61 | OINV | A/R Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 62 | OOEI | Outgoing Excise Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 63 | OPCH | A/P Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 64 | OPDN | Goods Receipt PO | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 65 | OPOR | Purchase Order | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 66 | OPQT | Purchase Quotation | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 67 | OPRQ | Purchase Request | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 68 | OQUT | Sales Quotation | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 69 | ORDN | Returns | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 70 | ORDR | Sales Order | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 71 | ORIN | A/R Credit Memo | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 72 | ORPC | A/P Credit Memo | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 73 | ORPD | Goods Return | 3 | DocType | Document Type | VarChar | 1 | 0 | I | I=Item, S=Service |
| 74 | OTPI | Purchase Tax Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | A=Alteration Invoice, B=Alteration Correction Invoice, C=Correction Invoice, D=Down Payment, I=Invoice, J=Journal Entry |
| 75 | OTSI | Sales Tax Invoice | 3 | DocType | Document Type | VarChar | 1 | 0 | I | A=Alteration Invoice, B=Alteration Correction Invoice, C=Correction Invoice, I=Invoice, J=Journal Entry, P=Payment |
| 76 | OTXD | Tax Invoice Draft | 3 | DocType | Document Type | VarChar | 1 | 0 | I | A=Alteration Invoice, B=Alteration Correction Invoice, C=Correction Invoice, D=Down Payment, I=Invoice, J=Journal Entry, P=Payment |
| 77 | TGPA | Gross Profit Adjustment - Log | 6 | DocType | Document Type | nVarChar | 20 | 0 | | |
| 78 | TPI1 | Purchase Tax Invoice - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | C=Correction Invoice, D=Down Payment, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment |
| 79 | TSI1 | Sales Tax Invoice - Rows1 | 4 | DocType | Document Type | VarChar | 1 | 0 | I | C=Correction Invoice, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment |
| 80 | TXD1 | Tax Invoice Drafts - Rows | 4 | DocType | Document Type | VarChar | 1 | 0 | I | C=Correction Invoice, I=Invoice, J=Journal Entry, L=Landed Cost, P=Payment, R=Payment Request |
| 81 | 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 |
| 82 | MSN5 | MRP-Specific Document | 2 | DocType | Document Type | nVarChar | 20 | 0 | | |
| TOPReports |
| 83 | EBL1 | E-Balance Report Data | 6 | DocType | Document Type | VarChar | 1 | 0 | | 0=XBRL |
| 84 | ECDW1 | ECD Wizard - Rows 1 | 2 | DocType | Template Type | VarChar | 1 | 0 | | B=Balance Sheet, P=Profit and Loss |
| 85 | 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 |
| 86 | AOPR | Opportunity | 46 | DocType | Linked Document Type | nVarChar | 9 | 0 | -1 | 13=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 18=Purchase Invoices, 20=Goods Receipt POs, 22=Purchase Orders, 23=Quotations, 540000006=Purchase Quotations |
| 87 | OOPR | Opportunity | 46 | DocType | Linked Document Type | nVarChar | 9 | 0 | -1 | 13=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 18=Purchase Invoices, 20=Goods Receipt POs, 22=Purchase Orders, 23=Quotations, 540000006=Purchase Quotations |
