| 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 | OMAO | Mobile Addon Setting | 4 | Type | Addon Type | VarChar | 1 | 0 | M | H=Home Add-On, M=Module Add-On |
| 7 | OPRO | Property Object | 4 | Type | Property Type | nVarChar | 5 | 0 | String | String=String type property, XML=XML type property |
| 8 | OSTA | Sales Tax Authorities | 6 | Type | Type | Int | 11 | 0 | | |
| 9 | OUDO | User-Defined Object | 5 | TYPE | Object Type | VarChar | 1 | 0 | 1 | 1=Master Data, 3=Document |
| 10 | 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 |
| 11 | 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 |
| 12 | OPFT | Portfolio Definitions | 3 | Type | Type | VarChar | 1 | 0 | C | B=Bill of Exchange, C=Cheque |
| 13 | OPYM | Payment Methods for Payment Wizard | 3 | Type | Type | VarChar | 1 | 0 | | I=Incoming, O=Outgoing |
| TOPBusiness Partners |
| 14 | OCLS | Activity Subjects | 3 | Type | Related Type | Int | 6 | 0 | -1 | |
| TOPFinance |
| 15 | AWHT | Withholding Tax | 12 | Type | Withholding Type | VarChar | 1 | 0 | V | I=Income Tax Withholding, V=VAT Withholding |
| 16 | JST1 | TDS Adjustment - Rows | 18 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Incoming Tax Withholding, V=VAT Withholding |
| 17 | OASG | Account Segmentation | 4 | Type | Type | VarChar | 1 | 0 | A | A=Alphanumeric, N=Numeric |
| 18 | OWHT | Withholding Tax | 12 | Type | Withholding Type | VarChar | 1 | 0 | V | I=Income Tax Withholding, V=VAT Withholding |
| TOPHuman Resources |
| 19 | AHE2 | Education | 5 | type | Education Type | Int | 11 | 0 | | |
| 20 | AHEM | Employees | 7 | type | Employee Type | Int | 11 | 0 | | |
| 21 | HEM2 | Education | 5 | type | Education Type | Int | 11 | 0 | | |
| 22 | OHEM | Employees | 7 | type | Employee Type | Int | 11 | 0 | | |
| TOPInventory and Production |
| 23 | AWOR | Production Order - History | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | D=Disassembly, P=Special, S=Standard |
| 24 | IGE5 | Goods Issue - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 25 | IGN5 | Goods Receipt - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 26 | OCYC | Cycle | 8 | Type | Cycle Type | VarChar | 1 | 0 | C | C=Cycle, M=MRP |
| 27 | OWOR | Production Order | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | D=Disassembly, P=Special, S=Standard |
| 28 | UWOR | Production Order | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | D=Disassembly, P=Special, S=Standard |
| 29 | WTR5 | Inventory Transfer - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| TOPMarketing Documents |
| 30 | ADO5 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 31 | AJD2 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 32 | BTF2 | Journal Voucher Withholding Tax - History | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 33 | CIN5 | AR Correction Invoice - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 34 | CPI5 | Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 35 | CPV5 | A/P Correction Invoice Reversal - WTax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 36 | CSI5 | A/R Correction Invoice - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 37 | CSV5 | A/R Correction Invoice Reversal - WTax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 38 | DLN5 | Delivery - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 39 | DPI5 | A/R Down Payment - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 40 | DPO5 | A/P Down Payment - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 41 | DRF5 | Draft Documents - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 42 | IEI5 | Incoming Excise Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 43 | INV5 | A/R Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 44 | JDT2 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 45 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 46 | PCH5 | A/P Invoice - Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 47 | PDN5 | Goods Reciept PO - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 48 | POR5 | Purchase Order - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 49 | QUT5 | Sales Quotation - Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 50 | RDN5 | Returns - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 51 | RDR5 | Sales Order - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 52 | RIN5 | A/R Credit Memo - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 53 | RPC5 | A/P Credit Memo - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 54 | RPD5 | Goods Return - Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| TOPReports |
| 55 | EJB2 | Docs List for ERV-JAb Wizard | 5 | Type | Type | nVarChar | 3 | 0 | | PDF=PDF, XML=XML |
| 56 | OTRX | Transformation Documents | 4 | Type | Type | nVarChar | 8 | 0 | XSLT | XSLT=XSLT Document |
| 57 | RITM | Reporting Element | 4 | Type | Type | Int | 6 | 0 | | 10=Text Field, 11=Picture Field, 12=User Field, 1=Page Header, 2=Start of Report, 3=Repetitive Area Header, 4=Repetitive Area, 5=Repetitive Area Footer, 6=End of Report, 7=Page Footer |
