| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ANCM | NCM Code | 1 | AbsEntry | ID | Int | 11 | 0 | | |
2 | ATC1 | Attachments - Rows | 1 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
3 | CPL1 | Quick Copy - Instance Log | 1 | AbsEntry | Document Number | Int | 11 | 0 | | |
4 | CSPI | Solution Packager Information | 1 | AbsEntry | absEntry | Int | 11 | 0 | | |
5 | DADB | Data Archive DSA Balance | 1 | AbsEntry | Document Internal ID | Int | 11 | 0 | | |
6 | DATB | Data Archive Tax Balance | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
7 | DGP1 | Customer List | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
8 | DGP2 | Expanded Selection Criteria | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
9 | DGP3 | Expanded Consolidation Options | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
10 | DGP4 | Business Place List | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
11 | DGP5 | Sort By List | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
12 | FTT1 | Financial Template Import - Files | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
13 | MDC1 | Master Data Cleanup - Log | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
14 | MDC2 | Master Data Cleanup - MD Log | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
15 | OATC | Attachments | 1 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
16 | OCIF | Configuration of Intrastat Fields | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
17 | OCPC | Quick Copy Config. | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
18 | OCPL | Quick Copy Log Manager | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
19 | ODAR | Data Archiving | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
20 | ODCI | Intrastat Configuration | 1 | AbsEntry | Configuration Entry ID | Int | 11 | 0 | | |
21 | ODGP | Document Generation Parameter Sets | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
22 | OFRM | File Format | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
23 | OFTT | Financial Template Import | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
24 | OLLF | Legal List Format | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
25 | OMAP | Mapping Elements | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
26 | OMDC | Master Data Cleanup | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
27 | OMPS | Map Services | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
28 | OMTP | Material Type | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
29 | ONCM | NCM Code | 1 | AbsEntry | ID | Int | 11 | 0 | | |
30 | OOCC | BoE Occurrence Code | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
31 | OPPA | Password Administration | 1 | AbsEntry | Internal ID | Int | 11 | 0 | 1 | |
32 | OPQW | Purchase Quotation Generation: Parameter Sets | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
33 | OPRO | Property Object | 1 | AbsEntry | Property ID | Int | 11 | 0 | | |
34 | ORLD | Reference Links Definition | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
35 | OTRN | Multilingual Service Table | 1 | AbsEntry | Doc. Entry | Int | 11 | 0 | | |
36 | OWFER | Workflow Error Message | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
37 | PQW1 | Purchase Quotation Generation: Line Items | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
38 | RLD1 | Reference Links Definition | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
TOPBanking |
39 | ABO1 | External Bank Operation Code - Rows - Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
40 | ABOC | External Bank Operation Code - Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
41 | ABT1 | Internal Bank Operation Codes - Accounts - Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
42 | ABTC | Internal Bank Operation Codes - Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
43 | ADS1 | House Bank Accounts | 43 | AbsEntry | Internal Number | Int | 11 | 0 | | |
44 | BOC1 | External Bank Operation Code - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
45 | BOT1 | Bill of Exchange Transactions | 1 | AbsEntry | Transaction No. | Int | 11 | 0 | | |
46 | BTC1 | Internal Bank Operation Codes - Accounts | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
47 | CHO2 | Checks for Payment - Print Status | 1 | AbsEntry | Index | Int | 11 | 0 | | |
48 | DSC1 | House Bank Accounts | 43 | AbsEntry | Internal Number | Int | 11 | 0 | | |
49 | MTH3V | Filter for Query MTH | 1 | absEntry | Internal Number | Int | 11 | 0 | | |
50 | OBOC | External Bank Operation Code Category | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
51 | OBOT | Bill Of Exchang Transaction | 1 | AbsEntry | BOE Transaction key | Int | 11 | 0 | | |
52 | OBST | BoE Stamp Tax | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
53 | OBTC | Internal Bank Operation Codes | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
54 | ODSC | Bank Codes | 14 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
55 | ODTY | BoE Document Type | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
56 | OIPO | Internal Payment Order Number | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
57 | OIST | BoE Instruction | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
58 | OPEX | Payment Results Table | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
59 | OPOI | Incoming Payment Order | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
60 | OPOO | Outgoing Payment Order | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
61 | OPTF | BoE Portfolio | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
62 | OPWB | PWZ - Bank Account | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
63 | OPYB | Payment Block | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
64 | OROC | Retorno Operation Codes | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
65 | ORTW | Boleto Retorno Wizard: Parameter Sets | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
66 | OTPW | Tax Payment Wizard | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
67 | PEX1 | Payment Results Table - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
68 | RTW1 | Boleto Retorno Wizard: Import Table | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
69 | RTW2 | Boleto Retorno Wizard: Import Archive | 1 | AbsEntry | Absolute Entry | Int | 11 | 0 | | |
70 | TPW1 | Selection Criteria | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
71 | TPW2 | Payable Information | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
72 | TPW3 | Utilization and Payment | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
73 | TPW4 | VAT Refund | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
74 | TPW5 | Challan Information | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
75 | TPW6 | Journal Entry Information | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
TOPBusiness Partners |
76 | ACRB | Business Partner Bank Accounts - History | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
77 | OCRB | BP - Bank Account | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
78 | OVTP | Vendor Type | 1 | ABSEntry | Primary Key | Int | 11 | 0 | | |
TOPFinance |
79 | AACP | Periods Category-Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
80 | AFPR | Posting Period-Log | 1 | AbsEntry | System Number | Int | 11 | 0 | | |
81 | AGAR | G/L Account Advanced Rules - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
82 | AJD2 | Withholding Tax - History | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
83 | AMDR | Manual Distribution Rule | 9 | AbsEntry | Numerator | Int | 11 | 0 | | |
84 | AWH2 | WTax Definition - Rows2 | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
85 | BTF2 | Journal Voucher Withholding Tax - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
86 | CASE | Internal Recon. Upgrade 2007A | 1 | AbsEntry | Intl ID for Inconsistent Amt | Int | 11 | 0 | | |
87 | CASE1 | Internal Recon. Upgrade 2007A | 1 | AbsEntry | Header Internal ID | Int | 11 | 0 | | |
88 | FAC1 | Fixed Asset Parameter Change - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
89 | FAC2 | Fixed Asset Parameter Change - Period Control Change | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
90 | FIX1 | Fixed Asset Transaction - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
91 | IWZ1 | Accounts Revaluation History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
92 | IWZ2 | Inflation Warehouse Filter | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
93 | IWZ3 | Items Last Revaluation Data | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
94 | JDT2 | Withholding Tax - History | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
95 | OACP | Periods Category | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
96 | OBOS | Box Set Definition | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
97 | OCIG | CIG Codes | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
98 | OCUP | CUP Codes | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
99 | ODPV | Fixed Assets Depreciation Value | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
100 | OFAC | Fixed Asset Parameter Change | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
101 | OFIX | Fixed Asset Transactions | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
102 | OFPC | Fixed Assets Fiscal Year Change | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
103 | OFPR | Posting Period | 1 | AbsEntry | System Number | Int | 11 | 0 | | |
104 | OGAR | G/L Account Advanced Rules | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
105 | OGBI | GB Interface: Common Info | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
106 | OISW | Intrastat Wizard | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
107 | OIWZ | Inflation Wizard | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
108 | OKRT | Tax Report Type | 1 | AbsEntry | Tax Report Type ID | Int | 11 | 0 | | |
109 | OMDR | Manual Distribution Rule | 9 | AbsEntry | Numerator | Int | 11 | 0 | | |
110 | ONFM | Nota Fiscal Model | 1 | AbsEntry | NF Model ID | nVarChar | 6 | 0 | | |
111 | OSVT | Define Summary VAT Report Type | 1 | AbsEntry | VAT Report Type ID | Int | 11 | 0 | | |
112 | OTAX | VAT Transactions | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
113 | OUTX | Unreported VAT Transactions | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
114 | OVCP | Periods Category | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
115 | OVRW | VAT Reposting Wizard | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
116 | OVTR | Tax Report | 1 | AbsEntry | Abs Entry (Numerator) | Int | 11 | 0 | | |
117 | OZRD | POS Daily Summary | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
118 | TAX1 | VAT Transactions - Rows | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
119 | UTX1 | Unreported VAT Transactions - Rows | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
120 | VRW1 | VAT Reposting Wizard - Rows 1 | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
121 | VRW2 | VAT Reposting Wizard - Rows 2 | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
122 | VRW3 | VAT Reposting Wizard - Rows 3 | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
123 | VTR1 | Tax Groups | 1 | AbsEntry | Abs Entry (Numerator) | Int | 11 | 0 | | |
124 | VTR2 | Doc. Type Filter | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
125 | VTR3 | Series Filter | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
126 | VTR4 | Tax Groups | 1 | AbsEntry | Abs Entry (Numerator) | Int | 11 | 0 | | |
127 | VTR5 | Tax Groups | 1 | AbsEntry | Abs Entry (Numerator) | Int | 11 | 0 | | |
128 | WHT2 | Withholding Tax Definition - Rows2 | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
129 | ZRD1 | POS Daily Summary - Totals | 1 | AbsEntry | Document Internal ID | Int | 11 | 0 | | |
TOPGeneral |
130 | ACPA1 | Periods Category - WIP Mapping - Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
131 | AGRS | G/L Account Advanced Rules for Resources - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
132 | AHF1 | Hide Functions Configuration - Rows History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
133 | AHF2 | Hide Function Configuration - Rows History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
134 | AHFC | Hide Functions Configuration - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
135 | ARPA | Routing Permission Areas | 1 | AbsEntry | Routing Permission Area Internal Number | Int | 11 | 0 | | |
136 | ARPR | Routing Permissions | 1 | AbsEntry | Routing Permission Internal Number | Int | 11 | 0 | | |
137 | ARST | Route Stages - History | 1 | AbsEntry | Route Stage Internal Number | Int | 11 | 0 | | |
138 | CASEX | Internal Recon. Upgrade 2007A | 1 | AbsEntry | Header Internal ID | Int | 11 | 0 | | |
139 | CFN1 | Default Common Functions | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
140 | CPA1 | Periods Category - WIP Mapping | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
141 | CPT1 | Cockpit Subtable | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
142 | DAL1 | Mapping between form item and dashboard column | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
143 | HFC1 | Hide Functions Configuration - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
144 | HFC2 | Hide Function Configuration - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
145 | INV5V | Withholding Tax Data2 - A/R Invoice | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
146 | KPI1 | Key Performance Indicator Field | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
147 | KPI2 | Key Performance Indicator Scope | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
148 | KPI3 | Key Performance Indicator Parameter or Filter | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
149 | KPI4 | Key Performance Indicator Discrete Value | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
150 | KPI5 | Key Performance Indicator Formula's Variable | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
151 | LGL1 | Legal Data - Rows | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
152 | NCP1 | New Cockpit Tile | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
153 | OBTA | Brazil Tax Adujstment | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
154 | OBVL | Serial Numbers and Batch Valuation Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
155 | OCFN | Common Functions Widget | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
156 | OCIP | Configuration of Integration Packages | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
157 | OCPT | Cockpit Main Table | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
158 | OCUC | CUS Configuration | 1 | AbsEntry | Abs. Entry | Identity | 11 | 0 | | |
159 | ODAB | Dashboard | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
160 | ODAL | Link between dashboard and form | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
161 | ODCC | Dashboard Cache Configuration | 1 | AbsEntry | Abs Entry | Int | 11 | 0 | | |
162 | ODSL | Schedule Row Detail | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
163 | ODW1 | Default Open Documents | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
164 | OGPA | Gross Profit Adjustment | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
165 | OGRS | G/L Account Advanced Rules for Resources | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
166 | OHFC | Hide Functions Configuration | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
167 | OKPI | Key Performance Indicator Package | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
168 | OLNK | Help Links | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
169 | ONCP | New Cockpit Page | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
170 | OODW | Open Documents Widget | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
171 | ORND | Virtual table of rounding for SDK | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
172 | ORPA | Routing Permission Areas | 1 | AbsEntry | Routing Permission Area Internal Number | Int | 11 | 0 | | |
173 | ORPR | Routing Permissions | 1 | AbsEntry | Routing Permission Internal Number | Int | 11 | 0 | | |
174 | ORST | Route Stages | 1 | AbsEntry | Route Stage Internal Number | Int | 11 | 0 | | |
175 | OSAB | Social | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
176 | OSLD | Schedule Row Detail | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
177 | OSTB | Template | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
178 | OTCN | Tracking Note | 1 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
179 | OWDT | Widget Table | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
180 | OWPK | Dashboard Packages | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
181 | OXAP | XAPP Master Data | 1 | AbsEntry | Key of XAPP | Int | 11 | 0 | | |
182 | PACT | Pervasive's Insight to Action | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
183 | PACT1 | Pervasive's Insight to Actions' Subitem | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
184 | PACT3 | Pervasive's Insight to Action's Table Field | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
185 | SCUC | SCUC | 1 | AbsEntry | AbsEntry | Identity | 11 | 0 | | |
186 | SEWAD | SEWAD | 1 | AbsEntry | Absolute Entry | Int | 11 | 0 | | |
187 | SEWBU | SEWBU | 1 | AbsEntry | AbsEntry | Int | 11 | 0 | | |
188 | SEWDB | SEWDB | 1 | AbsEntry | Absolute Entry | nVarChar | 8 | 0 | | |
189 | SEWDQ | SEWDQ | 1 | AbsEntry | Absolute Entry | Int | 11 | 0 | | |
190 | SEWUS | SEWUS | 1 | AbsEntry | Absolute Entry | Int | 11 | 0 | | |
191 | SPRM | [SPRM] | 1 | AbsEntry | Abs entry | Int | 11 | 0 | | |
192 | TCN1 | Tracking Note - Line Data | 1 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
193 | TCN2 | Tracking Note - Brokers | 1 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
194 | TMDC | Master Data Cleanup - Temp Table | 1 | AbsEntry | Internal Key | Identity | 11 | 0 | | |
195 | UBVL | Serial Numbers and Batch Valuation Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
196 | WPK1 | Dashboard Packages' Parameter or Filter | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
197 | WPK2 | Dashboard Packages' Discrete Value | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
198 | XAP1 | Page of XAPP | 1 | AbsEntry | Key of page | Int | 11 | 0 | | |
199 | XAP2 | XAPP widget | 1 | AbsEntry | Key of widget | Int | 11 | 0 | | |
200 | XAP3 | XAP filter | 1 | AbsEntry | Key of XAPP filter | Int | 11 | 0 | | |
201 | XAP4 | Widget item | 1 | AbsEntry | Key of filter item | Int | 11 | 0 | | |
TOPInventory and Production |
202 | ABAT | Attribute - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
203 | ABFC | Bin Field Configuration - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
204 | ABIN | Bin Location - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
205 | ABSL | Warehouse Sublevel - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
206 | ABTN | Batch Numbers Master Data | 19 | AbsEntry | Abs Entry | Int | 11 | 0 | | |
207 | ABTW | Batch Attributes in Location | 9 | AbsEntry | Abs Entry | Int | 11 | 0 | | |
208 | ADG1 | Discount Groups Rows | 1 | AbsEntry | Unique Entry | Int | 11 | 0 | | |
209 | ADNF | DNF Code | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
210 | AEDG | Discount Groups | 1 | AbsEntry | Unique Entry | Int | 11 | 0 | | |
211 | AIGW | Item Group - Warehouse - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
212 | AKL1 | Pick List - Rows - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
213 | AKL2 | Pick List for SnB and Bin Details | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
214 | AMGP | Material Group | 1 | AbsEntry | ID | Int | 11 | 0 | | |
215 | APKL | Pick List - History | 1 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
216 | ASRN | Serial Numbers Master Data | 19 | AbsEntry | Abs Entry | Int | 11 | 0 | | |
217 | CIVI | IVI Config File | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
218 | EDG1 | Discount Groups Rows | 1 | AbsEntry | Unique Entry | Int | 11 | 0 | | |
219 | IGE16 | Goods Issue - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
220 | IGE5 | Goods Issue - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
221 | IGN16 | Goods Receipt - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
222 | IGN5 | Goods Receipt - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
223 | IVLG | Inventory Revaluation Log File | 1 | AbsEntry | Internal Unique Key | Int | 11 | 0 | | |
224 | IVRU | Inventory Valuation Utility | 1 | AbsEntry | Successive No. | Int | 11 | 0 | | |
225 | IWB1 | Batch No. Quantities Backup | 1 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
226 | IWB2 | Serial No. Quantities Backup | 1 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
227 | OBAT | Bin Location Attribute | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
228 | OBBQ | Item - Serial/Batch - Bin Accumulator | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
229 | OBFC | Bin Field Configuration | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
230 | OBIN | Bin Location | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
231 | OBSL | Warehouse Sublevel | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
232 | OBTL | Bin Transaction Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
233 | OBTN | Batch Numbers Master Data | 19 | AbsEntry | abs entry | Int | 11 | 0 | | |
234 | OBTQ | Batch No. Quantities | 7 | AbsEntry | abs entry | Int | 11 | 0 | | |
235 | OBTW | Batch Attributes in Location | 9 | AbsEntry | abs entry | Int | 11 | 0 | | |
236 | OCHP | India Chapter ID | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
237 | ODBN | Bat. Nos - Draft - Master Data | 19 | AbsEntry | abs entry | Int | 11 | 0 | | |
238 | ODBW | Batch Draft Attribs in Locat. | 9 | AbsEntry | abs entry | Int | 11 | 0 | | |
239 | ODNF | DNF Code | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
240 | ODSN | SNs - Draft - Master Data | 19 | AbsEntry | abs entry | Int | 11 | 0 | | |
241 | ODSW | SN Draft Attribs in Location | 9 | AbsEntry | abs entry | Int | 11 | 0 | | |
242 | OEDG | Discount Groups | 1 | AbsEntry | Unique Entry | Int | 11 | 0 | | |
243 | OIBQ | Item - Bin Accumulator | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
244 | OIGW | Item Group - Warehouse | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
245 | OIVE | FIFO Based Sales Return | 3 | AbsEntry | Internal Number | Int | 11 | 0 | | |
246 | OIVQ | FIFO Queue Working Table | 10 | AbsEntry | Internal ID | Int | 11 | 0 | | |
247 | OIWB | Items - Warehouse Counting Data Backup | 1 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
248 | OMGP | Material Group | 1 | AbsEntry | ID | Int | 11 | 0 | | |
249 | OPKL | Pick List | 1 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
250 | OSBQ | Item - Serial/Batch - Bin Accumulator | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
251 | OSCG | Service Category | 1 | AbsEntry | ID | Int | 11 | 0 | | |
252 | OSRN | Serial Numbers Master Data | 19 | AbsEntry | abs entry | Int | 11 | 0 | | |
253 | OSRQ | Serial No. Quantities | 7 | AbsEntry | abs entry | Int | 11 | 0 | | |
254 | OSRW | Serial No. Attribs in Location | 9 | AbsEntry | abs entry | Int | 11 | 0 | | |
255 | OSTQ | Inventory Valuation Utility Queries | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
256 | PKL1 | Pick List - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
257 | PKL2 | Pick List for SnB and Bin Details | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
258 | PLGW | Pick List Generation Wizard | 1 | AbsEntry | Internal Number | nVarChar | 11 | 0 | 0 | |
259 | RBTN | Batch Report Master Data List | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
260 | RSRN | Serial Number Report Master Data List | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
261 | SIVE | FIFO Based Sales Return | 3 | AbsEntry | Internal Number | Int | 11 | 0 | | |
262 | SIVQ | FIFO Queue Working Table | 10 | AbsEntry | Internal ID | Int | 11 | 0 | | |
263 | UBTN | Batch Numbers Master Data | 19 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
264 | UIVE | FIFO Based Sales Return | 3 | AbsEntry | Internal Number | Int | 11 | 0 | | |
265 | UIVQ | FIFO Queue Working Table | 10 | AbsEntry | Internal Number | Int | 11 | 0 | | |
266 | USRN | Serial Numbers Master Data | 19 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
267 | VBIN | Bin Location Virtual Table | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
268 | VLG1 | Validation of Recalc. From To | 1 | AbsEntry | Internal Unique Key | Int | 11 | 0 | | |
269 | WTQ16 | Inventory Transfer Request - SnB Properties | 1 | AbsEntry | Document Number | Int | 11 | 0 | | |
270 | WTQ5 | Inventory Transfer Request - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
271 | WTR16 | Inventory Transfer - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
272 | WTR5 | Inventory Transfer - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
TOPMarketing Documents |
273 | ADO16 | Draft - SnB properties | 1 | AbsEntry | Document Number | Int | 11 | 0 | | |
274 | ADO5 | Withholding Tax - History | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
275 | CIN5 | AR Correction Invoice - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
276 | CPI16 | A/P Corr. Inv - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
277 | CPI5 | Withholding Tax Data | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
278 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
279 | CPV5 | A/P Correction Invoice Reversal - WTax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
280 | CSI16 | A/R Corr. Inv. - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
281 | CSI5 | A/R Correction Invoice - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
282 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
283 | CSV5 | A/R Correction Invoice Reversal - WTax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
284 | DLN16 | Delivery - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
285 | DLN5 | Delivery - Withholding Tax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
286 | DOC16 | Mktg Docs - SnB property | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
287 | DOC5 | Mktg Docs - WithholdingTax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
288 | DPI16 | A/R Down Payment - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
289 | DPI5 | A/R Down Payment - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
290 | DPO16 | A/P Down Payment - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
291 | DPO5 | A/P Down Payment - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
292 | DRF16 | Draft - SnB - Rows | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
293 | DRF5 | Draft Documents - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
294 | GPA1 | Gross Profit Adjustment - Log | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
295 | GPA2 | Gross Profit Adjustments - Parameters | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
296 | GTI1 | GTS Invoice Details | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
297 | GTM1 | GTS Mapping Object Details | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
298 | IEI16 | Incoming Excise Invoice - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
299 | IEI5 | Incoming Excise Invoice - Withholding Tax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
300 | INV16 | A/R Invoice - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
301 | INV5 | A/R Invoice - Withholding Tax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
302 | IVM1 | Invoice Mapping Object Details | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
303 | MIN1 | Monthly Invoice Report Document Information | 2 | AbsEntry | Document Internal ID | Int | 11 | 0 | | |
304 | MIN2 | Item Imformation of MI | 17 | AbsEntry | Document Entry | Int | 11 | 0 | | |
305 | MIV1 | A/P Monthly Invoice - Document | 2 | AbsEntry | Internal Key | Int | 11 | 0 | | |
306 | MIV2 | A/P Monthly Invoice - Item | 17 | AbsEntry | Document Entry | Int | 11 | 0 | | |
307 | OEI16 | Outgoing Excise Invoice - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
308 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
309 | OGTI | GTS Invoice | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
310 | OGTM | GTS Mapping Object | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
311 | OIVM | GTS Invoice Mapping Object | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
312 | OLGL | Legal Data | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
313 | OPDT | Predefined Text | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
314 | OPQN | Purchase Quotation Group | 1 | AbsEntry | Internal Entry | Int | 11 | 0 | | |
315 | ORCL | Recurring Transaction Instances | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
316 | ORCP | Recurring Transaction Template | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
317 | PCH16 | A/P Invoice - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
318 | PCH5 | A/P Invoice - Withholding Tax Data | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
319 | PDN16 | Goods Receipt PO - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
320 | PDN5 | Goods Reciept PO - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
321 | POR16 | Purchase Order - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
322 | POR5 | Purchase Order - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
323 | PQT16 | Purchase Quotation - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
324 | PQT5 | Purchase Quotation - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
325 | PRQ16 | Purchase Request - SnB Properties | 1 | AbsEntry | Abs. Entry | Int | 11 | 0 | | |
326 | PRQ5 | Purchase Request - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
327 | QUT16 | Sales Quotation - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
328 | QUT5 | Sales Quotation - Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
329 | RDN16 | Returns - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
330 | RDN5 | Returns - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
331 | RDR16 | Sales Order - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
332 | RDR5 | Sales Order - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
333 | RIN16 | A/R Credit Memo - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
334 | RIN5 | A/R Credit Memo - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
335 | RPC16 | A/P Credit Memo - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
336 | RPC5 | A/P Credit Memo - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
337 | RPD16 | Goods Return - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
338 | RPD5 | Goods Return - Withholding Tax Data | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
339 | TGPA | Gross Profit Adjustment - Log | 1 | AbsEntry | Internal Key | Identity | 11 | 0 | | |
TOPMRP |
340 | MSN1 | MRP Scenarios - Warehouses Array | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
341 | MSN2 | MRP Run Results | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
342 | MSN3 | MRP Pegging Information | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
343 | MSN4 | MRP Scenarios - Items Array | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
344 | MSN5 | MRP-Specific Document | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
345 | OMSN | MRP Scenarios | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
TOPReports |
346 | AEC2 | Messages Processed via Electronic Communication | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
347 | AEC3 | Statuses and Logs for Actions in Electronic Communication | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
348 | ATHL | Thresholds | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
349 | BTA1 | Brazil Tax Adujstment - Tax Types | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
350 | BTA2 | Brazil Tax Adujstment - Taxes Paid in Advance | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
351 | EBL1 | E-Balance Report Data | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
352 | ECDW1 | ECD Wizard - Rows 1 | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
353 | ECM2 | Messages Processed via Electronic Communication | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
354 | ECM3 | Statuses and Logs for Actions in Electronic Communication | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
355 | EFDW1 | EFD Wizard - Rows 1 | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
356 | EJB1 | ERV-JAb Wizard Signing Persons | 9 | AbsEntry | Internal Number | Int | 11 | 0 | | |
357 | EJD1 | ERV-JAb Signing Persons List | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
358 | OEBL | E-Balance | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
359 | OECDW | ECD Wizard | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
360 | OEFDW | EFD Wizard | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
361 | OEJD | Company Details for ERV-JAb | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
362 | OLLR | Electronic Report Generation Result | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
363 | OTHL | Thresholds | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
364 | OTRB | Tax Report Wizard for Brazil | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
365 | OTRS | Tax Report Saving Object | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
366 | OTRX | Transformation Documents | 1 | AbsEntry | Internal Number | Identity | 11 | 0 | | |
367 | OTWS | E-Tax Web Site | 1 | AbsEntry | E-Tax Internal ID | Int | 6 | 0 | | |
368 | TRB1 | Tax Report Wizard Selected States | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
369 | TRB2 | Tax Report Wizard Selected Tax Types | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
370 | TRB3 | Tax Report Wizard Selected Tax Categories | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
371 | TRB4 | Tax Report Wizard Selected Tax Entries | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
372 | TRB5 | Tax Report Wizard Reported Tax Sums | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
373 | TRS1 | Tax Report Saving Object - Approved Documents | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
374 | TRS2 | Tax Rpt Sav Obj Man Chgd Vals | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
TOPSales Opportunities |
375 | AOCR | Distribution Rule | 9 | AbsEntry | Numerator | Int | 11 | 0 | | |
376 | ODOR | Doubtful Debts | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
377 | OOCR | Distribution Rule | 9 | AbsEntry | Numerator | Int | 11 | 0 | | |
TOPService |
378 | ASGP | Service Group for Brazil | 1 | AbsEntry | Service Group ID | Int | 11 | 0 | | |
379 | OREQ | External System Call Request | 1 | AbsEntry | Request ID | Int | 11 | 0 | | |
380 | OSCD | Service Code Table | 1 | AbsEntry | ID | Int | 11 | 0 | | |
381 | OSGP | Service Group for Brazil | 1 | AbsEntry | Service Group ID | Int | 11 | 0 | | |
382 | REQ1 | External System Call Request - Message List | 1 | AbsEntry | Request ID | Int | 11 | 0 | | |
383 | REQ2 | External System Call Request - Argument List | 1 | AbsEntry | Request ID | Int | 11 | 0 | | |
384 | REQ3 | External System Call Request - Message Argument List | 1 | AbsEntry | Request ID | Int | 11 | 0 | | |