| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | CSPI | Solution Packager Information | 3 | Type | Parameter Type | nVarChar | 20 | 0 | | |
| 2 | MAP1 | Input and Output of Mapping | 3 | Type | Type | nVarChar | 10 | 0 | NA | CRYSTAL=Crystal Report, CSV=CSV File, NA=Not Avalible, TXT=Text File, XML=XML File |
| 3 | OALR | Alerts | 2 | Type | Type | VarChar | 1 | 0 | A | A=Alert, M=Message |
| 4 | OALT | Alerts Template | 3 | Type | Type | VarChar | 1 | 0 | U | S=System Alert, U=User Alert |
| 5 | OCMN | Customized Menu | 4 | Type | Menu Type | VarChar | 1 | 0 | C | A=Add-On, C=Customized, S=System |
| 6 | OLLF | Legal List Format | 14 | Type | Format Type | nVarChar | 5 | 0 | L | |
| 7 | OMAO | Mobile Add-On Setting | 4 | Type | Add-On Type | VarChar | 1 | 0 | M | |
| 8 | OPRO | Property Object | 4 | Type | Property Type | nVarChar | 5 | 0 | String | String=String type property, XML=XML type property |
| 9 | OSTA | Sales Tax Authorities | 6 | Type | Type | Int | 11 | 0 | | |
| 10 | OUDO | User-Defined Object | 5 | TYPE | Object Type | VarChar | 1 | 0 | 1 | |
| 11 | TCD4 | Withholding Tax Code Determination | 4 | Type | WTax Code Type | VarChar | 1 | 0 | L | L=Line Item WT Code, P=AP Default WT Code, R=AR Default WT Code |
| 12 | TCD5 | Tax Code by Usage | 5 | Type | Tax Code Type | VarChar | 1 | 0 | L | L=Line Item Tax Code, P=AP Default Tax Code, R=AR Default Tax Code |
| TOPBanking |
| 13 | OPFT | Portfolio Definitions | 3 | Type | Type | VarChar | 1 | 0 | C | B=Bill of Exchange, C=Cheque |
| 14 | OPYM | Payment Methods for Payment Wizard | 3 | Type | Type | VarChar | 1 | 0 | | |
| TOPBusiness Partners |
| 15 | ACPN | Campaign | 3 | Type | Campaign Type | VarChar | 1 | 0 | E | |
| 16 | AOAT | Blanket Agreement | 9 | Type | Agreement Type | VarChar | 1 | 0 | G | |
| 17 | OCLS | Activity Subjects | 3 | Type | Related Type | Int | 6 | 0 | -1 | |
| 18 | OCPN | Campaign | 3 | Type | Campaign Type | VarChar | 1 | 0 | E | |
| 19 | OOAT | Blanket Agreement | 9 | Type | Agreement Type | VarChar | 1 | 0 | G | |
| TOPFinance |
| 20 | AJD2 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 21 | AWHT | Withholding Tax | 12 | Type | Withholding Type | VarChar | 1 | 0 | V | |
| 22 | BTF2 | Journal Voucher Withholding Tax - History | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | |
| 23 | JDT2 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 24 | JST1 | TDS Adjustment - Rows | 18 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Incoming Tax Withholding, V=VAT Withholding |
| 25 | OASG | Account Segmentation | 4 | Type | Type | VarChar | 1 | 0 | A | A=Alphanumeric, N=Numeric |
| 26 | OWHT | Withholding Tax | 12 | Type | Withholding Type | VarChar | 1 | 0 | V | |
| TOPHuman Resources |
| 27 | AHE2 | Education | 5 | type | Education Type | Int | 11 | 0 | | |
| 28 | AHEM | Employees | 7 | type | Employee Type | Int | 11 | 0 | | |
| 29 | HEM2 | Education | 5 | type | Education Type | Int | 11 | 0 | | |
| 30 | OHEM | Employees | 7 | type | Employee Type | Int | 11 | 0 | | |
| TOPInventory and Production |
| 31 | AWOR | Production Order - History | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | |
| 32 | IGE5 | Goods Issue - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 33 | IGN5 | Goods Receipt - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 34 | OCYC | Cycle | 8 | Type | Cycle Type | VarChar | 1 | 0 | C | C=Cycle, M=MRP |
| 35 | OWOR | Production Order | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | |
| 36 | UWOR | Production Order | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | |
| 37 | WTQ5 | Inventory Transfer Request - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 38 | WTR5 | Inventory Transfer - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| TOPMarketing Documents |
| 39 | ADO5 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 40 | CIN5 | AR Correction Invoice - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 41 | CPI5 | Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 42 | CPV5 | A/P Correction Invoice Reversal - WTax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 43 | CSI5 | A/R Correction Invoice - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 44 | CSV5 | A/R Correction Invoice Reversal - WTax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 45 | DLN5 | Delivery - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | |
| 46 | DPI5 | A/R Down Payment - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 47 | DPO5 | A/P Down Payment - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 48 | DRF5 | Draft Documents - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 49 | IEI5 | Incoming Excise Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | |
| 50 | INV5 | A/R Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | |
| 51 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | |
| 52 | PCH5 | A/P Invoice - Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 53 | PDN5 | Goods Reciept PO - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 54 | POR5 | Purchase Order - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 55 | PQT5 | Purchase Quotation - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 56 | QUT5 | Sales Quotation - Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 57 | RDN5 | Returns - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 58 | RDR5 | Sales Order - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 59 | RIN5 | A/R Credit Memo - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 60 | RPC5 | A/P Credit Memo - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| 61 | RPD5 | Goods Return - Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | |
| TOPReports |
| 62 | EJB2 | Docs List for ERV-JAb Wizard | 5 | Type | Type | nVarChar | 3 | 0 | | PDF=PDF, XML=XML |
| 63 | OTRX | Transformation Documents | 4 | Type | Type | nVarChar | 8 | 0 | XSLT | XSLT=XSLT Document |
| 64 | RDFL | Document Standards | 6 | TYPE | Type | VarChar | 1 | 0 | L | |
| 65 | RITM | Reporting Element | 4 | Type | Type | Int | 6 | 0 | | |
| 66 | RTYP | Document Type List | 9 | TYPE | Type | VarChar | 1 | 0 | L | |
