| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ASTC | Sales Tax Codes | 2 | Name | Name | nVarChar | 100 | 0 | | |
2 | ASTT | Sales Tax Authorities Type | 2 | Name | Type Name | nVarChar | 40 | 0 | | |
3 | AWMG | Workflow Manager | 4 | Name | Name | nVarChar | 100 | 0 | | |
4 | AWTS | Workflow Engine Task Table | 7 | Name | Name | nVarChar | 254 | 0 | | |
5 | CDPM | Dynamic Permission | 2 | Name | Name | nVarChar | 64 | 0 | | |
6 | CSPI | Solution Packager Information | 2 | Name | Parameter Name | nVarChar | 50 | 0 | | |
7 | GFL2 | Grid Filter Name | 5 | Name | Name | nVarChar | 100 | 0 | | |
8 | MAP2 | Mapping Input and Output Relation | 5 | Name | Parameter Name | nVarChar | 20 | 0 | | |
9 | MDC1 | Master Data Cleanup - Log | 5 | Name | Name | nVarChar | 100 | 0 | | |
10 | OADF | Address Formats | 2 | Name | Name | nVarChar | 50 | 0 | | |
11 | OALT | Alerts Template | 2 | Name | Name | nVarChar | 254 | 0 | | |
12 | OBOI | Count Widget | 3 | Name | Name | nVarChar | 100 | 0 | | |
13 | OCDT | Credit Card Payment | 2 | Name | Credit Card Payment Name | nVarChar | 30 | 0 | | |
14 | OCMN | Customized Menu | 2 | Name | Menu Item Name | nVarChar | 100 | 0 | | |
15 | OCNT | Counties | 5 | Name | County Name | nVarChar | 100 | 0 | | |
16 | OCRY | Countries | 2 | Name | Name | nVarChar | 100 | 0 | | |
17 | OCSC | Crystal Server Configuration | 2 | Name | Server Name | nVarChar | 100 | 0 | | |
18 | OCST | States | 3 | Name | Name | nVarChar | 100 | 0 | | |
19 | ODMW | Data Migration | 2 | Name | Package Name | nVarChar | 20 | 0 | | |
20 | OENC | Encryption Types | 1 | Name | Name | nVarChar | 100 | 0 | | |
21 | OFRM | File Format | 2 | Name | File Format Name | nVarChar | 100 | 0 | | |
22 | OGSP | Goods Shipment | 2 | Name | Name | nVarChar | 50 | 0 | | |
23 | OIND | Triangular Deal | 2 | Name | Name | nVarChar | 50 | 0 | | |
24 | OLLF | Legal List Format | 2 | Name | Electronic File Name | nVarChar | 100 | 0 | | |
25 | OLNG | User Language Table | 3 | Name | Language | nVarChar | 30 | 0 | | |
26 | OMAO | Mobile Add-On Setting | 2 | Name | Name | nVarChar | 200 | 0 | | |
27 | OMDC | Master Data Cleanup | 2 | Name | Master Data Cleanup Name | nVarChar | 100 | 0 | | |
28 | OMLS | Distribution List | 2 | Name | Name | nVarChar | 30 | 0 | | |
29 | OMPS | Map Services | 2 | Name | Name | nVarChar | 20 | 0 | | |
30 | OPRO | Property Object | 5 | Name | Property Name | nVarChar | 50 | 0 | | |
31 | OPVL | Lender - Pelecard | 2 | Name | Name | nVarChar | 50 | 0 | | |
32 | ORIT | Dunning Interest Rate | 2 | Name | Interest Name | nVarChar | 50 | 0 | | |
33 | OSSP | Service Supply | 2 | Name | Name | nVarChar | 50 | 0 | | |
34 | OSTA | Sales Tax Authorities | 2 | Name | Name | nVarChar | 100 | 0 | | |
35 | OSTC | Sales Tax Codes | 2 | Name | Name | nVarChar | 100 | 0 | | |
36 | OSTT | Sales Tax Authorities Type | 2 | Name | Type Name | nVarChar | 40 | 0 | | |
37 | OUDG | User Defaults | 2 | Name | Name | nVarChar | 20 | 0 | | |
38 | OUDO | User-Defined Object | 2 | Name | Name | nVarChar | 100 | 0 | | |
39 | OUPT | User Autorization Tree | 2 | Name | Name | nVarChar | 64 | 0 | | |
40 | OWMG | Workflow Manager | 4 | Name | Name | nVarChar | 100 | 0 | | |
41 | OWST | Confirmation Level | 2 | Name | Name | nVarChar | 20 | 0 | | |
42 | OWTI | Workflow Timer Definition | 2 | Name | Name | nVarChar | 50 | 0 | | |
43 | OWTM | Approval Templates | 2 | Name | Name | nVarChar | 20 | 0 | | |
44 | OWTS | Workflow Engine Task Table | 7 | Name | Name | nVarChar | 254 | 0 | | |
45 | SPRG | Application Start | 3 | Name | Application Name | nVarChar | 128 | 0 | | |
TOPBanking |
46 | OBCA | Bank Charges Allocation Codes | 2 | Name | Description | nVarChar | 50 | 0 | | |
47 | OPFT | Portfolio Definitions | 2 | Name | Name | nVarChar | 50 | 0 | | |
48 | OPYD | Payment Run | 2 | Name | Payment Run Name | nVarChar | 50 | 0 | | |
49 | OUBR | Branches | 2 | Name | Branches Name | nVarChar | 20 | 0 | | |
50 | OUDP | Departments | 2 | Name | Departments Name | nVarChar | 20 | 0 | | |
TOPBusiness Partners |
51 | ACPN | Campaign | 2 | Name | Campaign Name | nVarChar | 100 | 0 | | |
52 | ACPR | Contact Persons - History | 3 | Name | Contact Person Name | nVarChar | 50 | 0 | | |
53 | OCLA | Activity Status | 2 | name | Status Name | nVarChar | 30 | 0 | | |
54 | OCLO | Meetings Location | 2 | Name | Name | nVarChar | 50 | 0 | | |
55 | OCLS | Activity Subjects | 2 | Name | Name | nVarChar | 20 | 0 | | |
56 | OCLT | Activity Types | 2 | Name | Name | nVarChar | 20 | 0 | | |
57 | OCPN | Campaign | 2 | Name | Campaign Name | nVarChar | 100 | 0 | | |
58 | OCPR | Contact Persons | 3 | Name | Contact Person Name | nVarChar | 50 | 0 | | |
59 | OPRT | Partners | 2 | Name | Name | nVarChar | 15 | 0 | | |
TOPFinance |
60 | AACS | Asset Classes - History | 2 | Name | Name | nVarChar | 100 | 0 | | |
61 | AFPR | Posting Period-Log | 3 | Name | Period Name | nVarChar | 20 | 0 | | |
62 | AVTG | Tax Definition | 2 | Name | Name | nVarChar | 50 | 0 | | |
63 | OACG | Account Category | 2 | Name | Name | nVarChar | 40 | 0 | | |
64 | OACR | Accrual Type | 2 | Name | Accrual Type Name | nVarChar | 30 | 0 | | |
65 | OACS | Asset Classes | 2 | Name | Name | nVarChar | 100 | 0 | | |
66 | OASC | Account Segmentation Categories | 3 | Name | Name | nVarChar | 100 | 0 | | |
67 | OASG | Account Segmentation | 2 | Name | Name | nVarChar | 100 | 0 | | |
68 | OBGS | Budget Scenario | 2 | Name | Name | nVarChar | 100 | 0 | | |
69 | OFAA | Asset Attributes | 2 | Name | Name | nVarChar | 100 | 0 | | |
70 | OFPR | Posting Period | 3 | Name | Period Name | nVarChar | 20 | 0 | | |
71 | OFRC | Financial Report Categories | 3 | Name | Name | nVarChar | 254 | 0 | | |
72 | OFRT | Financial Report Templates | 2 | Name | Name | nVarChar | 100 | 0 | | |
73 | OIDC | Indicator | 2 | Name | Indicator Name | nVarChar | 50 | 0 | | |
74 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 6 | Name | Rule Name | nVarChar | 100 | 0 | | |
75 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 6 | Name | Rule Name | nVarChar | 100 | 0 | | |
76 | OSHR | Shareholder's Rights and Interests Report History | 2 | Name | Report Name | nVarChar | 40 | 0 | | |
77 | OSVT | Define Summary VAT Report Type | 2 | Name | Summary VAT Report Type | nVarChar | 254 | 0 | | |
78 | OVTG | Tax Definition | 2 | Name | Name | nVarChar | 50 | 0 | | |
TOPGeneral |
79 | CFN1 | Default Common Functions | 5 | Name | Name | nVarChar | 100 | 0 | | |
80 | COLM | COLM resource | 3 | Name | Table Name | nVarChar | 64 | 0 | | |
81 | ELCFG | ELCFG | 2 | Name | | nVarChar | 100 | 0 | | |
82 | FORM | FORM resource | 3 | Name | Form name | nVarChar | 64 | 0 | | |
83 | ITEM | Item Resource | 3 | Name | Form Name | nVarChar | 64 | 0 | | |
84 | LOCL | Localizations Table | 3 | Name | Name | nVarChar | 32 | 0 | | |
85 | MFLD | MetaData Tables Fields | 3 | Name | Field Name | nVarChar | 20 | 0 | | |
86 | MHKY | MetaData Tables HKeys | 3 | Name | Key Name | nVarChar | 10 | 0 | | |
87 | MTBL | MetaData Tables | 1 | Name | Table Name | nVarChar | 5 | 0 | | |
88 | OCIP | Configuration of Integration Packages | 3 | Name | Package Name | nVarChar | 254 | 0 | | |
89 | OCPT | Cockpit Main Table | 3 | Name | Name | nVarChar | 20 | 0 | | |
90 | OFNS | Folio Numbering - Series | 2 | Name | Name | nVarChar | 100 | 0 | | |
91 | OGPA | Gross Profit Adjustment | 2 | Name | Gross Profit Adjustment Name | nVarChar | 100 | 0 | | |
92 | OKPI | Key Performance Indicator Package | 3 | Name | KPI Name | nVarChar | 250 | 0 | | |
93 | ONCP | New Cockpit Page | 2 | Name | Name | nVarChar | 100 | 0 | | |
94 | OPST | Service Call Problem Subtype | 2 | Name | Name | nVarChar | 20 | 0 | | |
95 | OWDT | Widget Table | 2 | Name | Widget Name | nVarChar | 20 | 0 | | |
96 | OXAP | XAPP Master Data | 2 | Name | Name of XAPP | nVarChar | 250 | 0 | | |
97 | PACT | Pervasive's Insight to Action | 2 | Name | Insight to Action Name | nVarChar | 250 | 0 | | |
98 | RFRM | FORM resource | 4 | Name | Form name | nVarChar | 64 | 0 | | |
99 | RFTL | FITL resource | 4 | Name | FITL name | nVarChar | 64 | 0 | | |
100 | RLNG | RLNG | 4 | Name | Language name | nVarChar | 50 | 0 | | |
101 | RMTL | MITL resource | 4 | Name | MITL name | nVarChar | 64 | 0 | | |
102 | RMTX | MATX resource | 4 | Name | MATX name | nVarChar | 64 | 0 | | |
103 | ROBJ | TM Import/Export Obj | 2 | Name | Name | nVarChar | 100 | 0 | | |
104 | RSTI | STRI resource | 4 | Name | STRL name | nVarChar | 64 | 0 | | |
105 | RSTR | STRL resource | 4 | Name | STRL name | nVarChar | 64 | 0 | | |
106 | RUSR | Resource Users | 2 | Name | User Name | nVarChar | 30 | 0 | | |
107 | SEWH1 | SEWH1 | 4 | Name | AddOn Name | nVarChar | 40 | 0 | | |
108 | SEWST | SEWST | 2 | Name | Name | nVarChar | 30 | 0 | | |
109 | SLSC | Local Settings Components CABs | 3 | Name | Name | nVarChar | 100 | 0 | | |
110 | SLSD | Local Settings | 2 | Name | Name | nVarChar | 100 | 0 | | |
111 | SPAR | SPAR | 2 | Name | Name | nVarChar | 254 | 0 | | |
112 | STRI | String list item resource | 3 | Name | STRL name | nVarChar | 64 | 0 | | |
113 | STRL | String List resource | 3 | Name | STRL name | nVarChar | 64 | 0 | | |
114 | SWDP | SWDP | 2 | Name | Deployment Name | nVarChar | 254 | 0 | | |
115 | SWID | SWID | 1 | Name | Name | nVarChar | 200 | 0 | | |
116 | SWPD | SWPD | 5 | Name | WF process definition name | nVarChar | 254 | 0 | | |
117 | SWRS | SWRS | 2 | Name | Workflow Resouce Name | nVarChar | 254 | 0 | | |
118 | SXRCD | XLR Class Definitions | 2 | name | name | nVarChar | 50 | 0 | | |
119 | SXRDB | XLR Databases | 1 | Name | Name | nVarChar | 50 | 0 | | |
120 | SXRET | XLR Enum Types | 2 | name | name | nVarChar | 50 | 0 | | |
121 | SXREV | XLR Enum Values | 2 | name | name | nVarChar | 50 | 0 | | |
122 | SXRME | XLR Members | 5 | Name | Name | nVarChar | 244 | 0 | | |
123 | SXROB | XLR Objects | 3 | name | name | nVarChar | 50 | 0 | | |
124 | SXRPD | XLR Property Definitions | 4 | name | name | nVarChar | 50 | 0 | | |
125 | SXRRO | XLR Relations | 4 | Name | Name | nVarChar | 50 | 0 | | |
126 | TABL | Table resource | 3 | Name | Table name | nVarChar | 64 | 0 | | |
127 | TYPR | TYPR | 2 | NAME | Type Name | nVarChar | 250 | 0 | | |
128 | XAP1 | Page of XAPP | 3 | Name | Page name | nVarChar | 250 | 0 | | |
129 | XAP3 | XAP Filter | 3 | Name | Name of filter | nVarChar | 250 | 0 | | |
130 | XSXA | XS XApp Registration Info | 2 | NAME | NAME | nVarChar | 254 | 0 | | |
TOPHuman Resources |
131 | OHED | Education Types | 2 | name | Name | nVarChar | 20 | 0 | | |
132 | OHPS | Employee Position | 2 | name | Position Name | nVarChar | 20 | 0 | | |
133 | OHST | Employee Status | 2 | name | Name | nVarChar | 20 | 0 | | |
134 | OHTM | Employee Teams | 2 | name | Team Name | nVarChar | 20 | 0 | | |
135 | OHTR | Termination Reason | 2 | name | Name | nVarChar | 20 | 0 | | |
136 | OHTY | Employee Types | 2 | name | Name | nVarChar | 20 | 0 | | |
TOPInventory and Production |
137 | APKL | Pick List - History | 2 | Name | Name | nVarChar | 155 | 0 | | |
138 | OCYC | Cycle | 2 | Name | Cycle Name | nVarChar | 20 | 0 | | |
139 | OPKL | Pick List | 2 | Name | Name | nVarChar | 155 | 0 | | |
TOPMarketing Documents |
140 | GPA2 | Gross Profit Adjustments - Parameters | 2 | Name | Wizard Parameters Name | nVarChar | 100 | 0 | | |
TOPMRP |
141 | OFCT | Sales Forecast | 3 | Name | Forecast Name | nVarChar | 100 | 0 | | |
TOPReports |
142 | OQWZ | Query Wizard | 2 | Name | Query Name | nVarChar | 50 | 0 | | |
143 | RTYP | Document Type List | 2 | NAME | Type Name | nVarChar | 250 | 0 | | |
144 | SRA3 | Scheduled Report Recipients | 5 | Name | Name | nVarChar | 155 | 0 | | |
145 | XROBJ | XLR Company Report Objects | 2 | Name | Name | nVarChar | 50 | 0 | | |
TOPSales Opportunities |
146 | AOPR | Opportunity | 36 | Name | Opportunity Name | nVarChar | 100 | 0 | | |
147 | OCMT | Competitors | 2 | Name | Name | nVarChar | 15 | 0 | | |
148 | OOPR | Opportunity | 36 | Name | Opportunity Name | nVarChar | 100 | 0 | | |
TOPService |
149 | OSCO | Service Call Origins | 2 | Name | Name | nVarChar | 20 | 0 | | |
150 | OSCP | Service Call Problem Types | 2 | Name | Name | nVarChar | 20 | 0 | | |
151 | OSCS | Service Call Statuses | 2 | Name | Name | nVarChar | 20 | 0 | | |
152 | OSCT | Service Call Types | 2 | Name | Name | nVarChar | 20 | 0 | | |
153 | OSST | Service Call Solution Statuses | 2 | Name | Name | nVarChar | 20 | 0 | | |