| 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 | |
| 6 | OLLF | Legal List Format | 14 | Type | Format Type | nVarChar | 5 | 0 | L | AR=Electronic Document, ARA=Electronic Authority Report, IM=Electronic Document - Input Message, INTER=Internally Used, L=Generic Electronic File, NFeC=NF-e Cancelation Document, NFeD=NF-e Invoice Document, NFeS=NF-e Number Skipping Request |
| 7 | OMAO | Mobile Add-On Setting | 4 | Type | Type | VarChar | 1 | 0 | M | H=Home, M=Module |
| 8 | OPRO | Property Object | 4 | Type | Property Type | nVarChar | 6 | 0 | Strin | Strin=String, XML=XML |
| 9 | OSTA | Sales Tax Authorities | 6 | Type | Type | Int | 11 | 0 | | |
| 10 | OSUS | Support Usage Statistics | 3 | Type | Type | Int | 11 | 0 | | |
| 11 | OUDO | User-Defined Object | 5 | TYPE | Object Type | VarChar | 1 | 0 | 1 | 1=Master Data, 3=Document |
| 12 | OWJB | Workflow Job Entity | 7 | Type | Type | nVarChar | 250 | 0 | | |
| 13 | 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 |
| 14 | TCD5 | Tax Code by Usage | 5 | Type | Tax Code Type | VarChar | 1 | 0 | L | L=Line Item Tax Code, P=A/P Default Tax Code, R=A/R Default Tax Code |
| TOPBanking |
| 15 | OPFT | Portfolio Definitions | 3 | Type | Type | VarChar | 1 | 0 | C | B=Bill of Exchange, C=Cheque |
| 16 | OPYM | Payment Methods for Payment Wizard | 3 | Type | Type | VarChar | 1 | 0 | | I=Incoming, O=Outgoing |
| TOPBusiness Partners |
| 17 | ACPN | Campaign | 3 | Type | Campaign Type | VarChar | 1 | 0 | E | E=E-Mail, F=Fax, M=Mail, O=Other, P=Phone Call, S=SMS, T=Meeting, W=Web |
| 18 | AOAT | Blanket Agreement | 9 | Type | Agreement Type | VarChar | 1 | 0 | G | G=General, S=Specific |
| 19 | OCLS | Activity Subjects | 3 | Type | Related Type | Int | 6 | 0 | -1 | |
| 20 | OCPN | Campaign | 3 | Type | Campaign Type | VarChar | 1 | 0 | E | E=E-Mail, F=Fax, M=Mail, O=Other, P=Phone Call, S=SMS, T=Meeting, W=Web |
| 21 | OOAT | Blanket Agreement | 9 | Type | Agreement Type | VarChar | 1 | 0 | G | G=General, S=Specific |
| TOPFinance |
| 22 | AJD2 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 23 | AWHT | Withholding Tax | 12 | Type | Withholding Type | VarChar | 1 | 0 | V | I=Income Tax Withholding, V=VAT Withholding |
| 24 | BTF2 | Journal Voucher Withholding Tax - History | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 25 | JDT2 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 26 | JST1 | TDS Adjustment - Rows | 18 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Incoming Tax Withholding, V=VAT Withholding |
| 27 | OASG | Account Segmentation | 4 | Type | Type | VarChar | 1 | 0 | A | A=Alphanumeric, N=Numeric |
| 28 | OWHT | Withholding Tax | 12 | Type | Withholding Type | VarChar | 1 | 0 | V | I=Income Tax Withholding, V=VAT Withholding |
| TOPGeneral |
| 29 | AHFC | Hide Functions Configuration - History | 4 | Type | Type | nVarChar | 6 | 0 | 0 | 0=System, 1=User |
| 30 | ELCFG | ELCFG | 3 | Type | | nVarChar | 10 | 0 | | |
| 31 | FORM | FORM resource | 5 | Type | Form type | Int | 11 | 0 | 0 | 0=Resize Document, 1=Dialog Box, 3=No Title Document, 4=Fixed Document, 5=Resize No Title Document, 6=Toolbar, 7=Fixed No Minimize |
| 32 | ITMR | ITMR | 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 |
| 33 | KPI1 | Key Performance Indicator Field | 3 | Type | KPI Field Type | Int | 11 | 0 | | |
| 34 | KPI2 | Key Performance Indicator Scope | 3 | Type | KPI Scope Type | nVarChar | 250 | 0 | | |
| 35 | KPI3 | Key Performance Indicator Parameter or Filter | 3 | Type | Type | nVarChar | 20 | 0 | | |
| 36 | MFLD | MetaData Tables Fields | 6 | Type | Type | VarChar | 1 | 0 | A | A=DB Alpha, B=DB Binary, D=DB Date, I=DB Auto Key, M=DB Memo, N=DB Numeric |
| 37 | MTBL | MetaData Tables | 3 | Type | Table Type | Int | 6 | 0 | 1 | 1=User OM, 2=User, 3=System OM, 4=System |
| 38 | NCP1 | New Cockpit Tile | 3 | Type | Type | nVarChar | 20 | 0 | | |
| 39 | NCP2 | New Cockpit Tile | 2 | Type | Type | nVarChar | 20 | 0 | | |
| 40 | OBTA | Brazil - Tax Adjustment | 7 | Type | Type | Int | 6 | 0 | 1 | 10=ICMS-ST Obligations to Pay or Paid - Own Operations, 11=Adjustment of IPI Appraisal, 12=Adjustment of PIS Appraisal, 13=Adjustment of COFINS appraisal, 1=Referred Collection Document, 2=Other Obligations, Adjustments, and Information Originating from Fiscal Documents, 3=Adjustment of ICMS Appraisal, 4=Adjustment and Additional Informati |
| 41 | OCPT | Cockpit Main Table | 18 | Type | Type | VarChar | 1 | 0 | U | T=Template, U=User |
| 42 | OCUC | CUS Configuration | 2 | Type | Type | Int | 11 | 0 | | |
| 43 | OHFC | Hide Functions Configuration | 4 | Type | Type | nVarChar | 6 | 0 | 0 | 0=System, 1=User |
| 44 | OPTI | Point of Issue | 3 | Type | Type | VarChar | 1 | 0 | P | E=Domestic Electronic, F=Fiscal, P=Domestic Printing, T=Export Electronic, X=Export Printing |
| 45 | PACT | Pervasive's Insight to Action | 3 | Type | Insight to Action Type | nVarChar | 50 | 0 | | |
| 46 | RFRM | FORM resource | 9 | Type | Form type | Int | 11 | 0 | 0 | 0=Resize Document, 1=Dialog Box, 3=No Title Document, 4=Fixed Document, 5=Resize No Title Document, 6=Toolbar |
| 47 | SCUC | SCUC | 2 | Type | Type | Int | 11 | 0 | | |
| 48 | SLSC | Local Settings Components CABs | 4 | Type | Type | VarChar | 1 | 0 | | C=Chart of accounts, H=HANA Content, L=CR Layout, O=Objects, P=CR Report, R=Reports |
| 49 | SXREL | XLR Event Log | 2 | Type | Type | Int | 11 | 0 | | |
| 50 | SXRET | XLR Enum Types | 3 | type | type | Int | 11 | 0 | | |
| 51 | SXRPD | XLR Property Definitions | 7 | type | type | Int | 11 | 0 | 0 | |
| 52 | SXRTE | XLR Terms | 3 | Type | Type | Int | 11 | 0 | | |
| 53 | WPK1 | Dashboard Packages' Parameter or Filter | 3 | Type | Type | nVarChar | 20 | 0 | | |
| 54 | XAP2 | XAPP Widget | 3 | Type | Widget Type | nVarChar | 250 | 0 | | |
| 55 | XAP3 | XAP Filter | 4 | Type | Type of filter | nVarChar | 250 | 0 | | |
| TOPHuman Resources |
| 56 | AHE2 | Education | 5 | type | Education Type | Int | 11 | 0 | | |
| 57 | AHEM | Employees | 7 | type | Employee Type | Int | 11 | 0 | | |
| 58 | HEM2 | Education | 5 | type | Education Type | Int | 11 | 0 | | |
| 59 | OHEM | Employees | 7 | type | Employee Type | Int | 11 | 0 | | |
| TOPInventory and Production |
| 60 | AEDG | Discount Groups | 2 | Type | Type | VarChar | 1 | 0 | | A=All BPs, C=Customer Group, S=Specific BP, V=Vendor Group |
| 61 | ATT1 | Bill of Materials - Components - History | 23 | Type | Component Type | Int | 11 | 0 | 4 | -18=Text, 290=Resource, 4=Item |
| 62 | AWOR | Production Order - History | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | D=Disassembly, P=Special, S=Standard |
| 63 | IGE5 | Goods Issue - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 64 | IGN5 | Goods Receipt - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 65 | ITT1 | Bill of Materials - Components | 23 | Type | Component Type | Int | 11 | 0 | 4 | -18=Text, 290=Resource, 4=Item |
| 66 | OCYC | Cycle | 8 | Type | Cycle Type | VarChar | 1 | 0 | C | C=Cycle, M=MRP |
| 67 | OEDG | Discount Groups | 2 | Type | Type | VarChar | 1 | 0 | | A=All BPs, C=Customer Group, S=Specific BP, V=Vendor Group |
| 68 | OWOR | Production Order | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | D=Disassembly, P=Special, S=Standard |
| 69 | UWOR | Production Order | 6 | Type | Production Order Type | VarChar | 1 | 0 | S | D=Disassembly, P=Special, S=Standard |
| 70 | WTQ5 | Inventory Transfer Request - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 71 | WTR5 | Inventory Transfer - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| TOPMarketing Documents |
| 72 | ADO5 | Withholding Tax - History | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 73 | CIN5 | AR Correction Invoice - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 74 | CPI5 | Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 75 | CPV5 | A/P Correction Invoice Reversal - WTax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 76 | CSI5 | A/R Correction Invoice - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 77 | CSV5 | A/R Correction Invoice Reversal - WTax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 78 | DLN5 | Delivery - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 79 | DPI5 | A/R Down Payment - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 80 | DPO5 | A/P Down Payment - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 81 | DRF5 | Draft Documents - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 82 | IEI5 | Incoming Excise Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 83 | INV5 | A/R Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 84 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 16 | Type | Withholding Tax Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 85 | PCH5 | A/P Invoice - Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 86 | PDN5 | Goods Reciept PO - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 87 | POR5 | Purchase Order - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 88 | PQT5 | Purchase Quotation - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 89 | PRQ5 | Purchase Request - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 90 | QUT5 | Sales Quotation - Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 91 | RDN5 | Returns - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 92 | RDR5 | Sales Order - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 93 | RIN5 | A/R Credit Memo - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 94 | RPC5 | A/P Credit Memo - Withholding Tax | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| 95 | RPD5 | Goods Return - Withholding Tax Data | 16 | Type | Withholding Type | VarChar | 1 | 0 | | I=Income Tax Withholding, V=VAT Withholding |
| TOPReports |
| 96 | EJB2 | Docs List for ERV-JAb Wizard | 5 | Type | Type | nVarChar | 3 | 0 | | PDF=PDF, XML=XML |
| 97 | OTRX | Transformation Documents | 4 | Type | Type | nVarChar | 8 | 0 | XSLT | XSLT=XSLT Document |
| 98 | RDFL | Document Standards | 6 | TYPE | Type | VarChar | 1 | 0 | L | L=Layout, P=Print Sequence |
| 99 | 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 |
| 100 | RTYP | Document Type List | 9 | TYPE | Type | VarChar | 1 | 0 | L | L=Layout, P=Print Sequence |
