| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ATC1 | Attachments - Rows | 1 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
2 | CFN1 | Default Common Functions | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
3 | CPT1 | Cockpit Subtable | 1 | AbsEntry | Internal 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 | OATC | Attachments | 1 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
13 | OCFN | Common Functions Widget | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
14 | OCPT | Cockpit Main Table | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
15 | ODAR | Data Archiving | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
16 | ODGP | Document Generation Parameter Sets | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
17 | OFRM | File Format | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
18 | OLLF | Legal List Format | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
19 | OMAP | Mapping Elements | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
20 | OMTP | Material Type | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
21 | ONCM | NCM Code | 1 | AbsEntry | ID | Int | 11 | 0 | | |
22 | OPPA | Password Administration | 1 | AbsEntry | Internal ID | Int | 11 | 0 | 1 | |
23 | OPRO | Property Object | 1 | AbsEntry | Property ID | Int | 11 | 0 | | |
24 | OSTQ | Inventory Valuation Utility Queries | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
TOPBanking |
25 | ABO1 | External Bank Operation Code - Rows - Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
26 | ABOC | External Bank Operation Code - Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
27 | ABT1 | Internal Bank Operation Codes - Accounts - Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
28 | ABTC | Internal Bank Operation Codes - | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
29 | ADS1 | House Bank Accounts | 43 | AbsEntry | Internal Number | Int | 11 | 0 | | |
30 | BOC1 | External Bank Operation Code - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
31 | BOT1 | Bill of Exchange Transactions | 1 | AbsEntry | Transaction No. | Int | 11 | 0 | | |
32 | BTC1 | Internal Bank Operation Codes - Accounts | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
33 | CHO2 | Checks for Payment - Print Status | 1 | AbsEntry | Index | Int | 11 | 0 | | |
34 | DSC1 | House Bank Accounts | 43 | AbsEntry | Internal Number | Int | 11 | 0 | | |
35 | OBOC | External Bank Operation Code Category | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
36 | OBOT | Bill Of Exchang Transaction | 1 | AbsEntry | BOE Transaction key | Int | 11 | 0 | | |
37 | OBST | BoE Stamp Tax | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
38 | OBTC | Internal Bank Operation Codes | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
39 | ODSC | Bank Codes | 14 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
40 | ODTY | BoE Document Type | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
41 | OIST | BoE Instruction | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
42 | OPEX | Payment Results Table | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
43 | OPTF | BoE Portfolio | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
44 | OPYB | Payment Block | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
45 | OTPW | Tax Payment Wizard | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
46 | PEX1 | Payment Results Table - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
47 | TPW1 | Selection Criteria | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
48 | TPW2 | Payable Information | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
49 | TPW3 | Utilization and Payment | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
50 | TPW4 | VAT Refund | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
51 | TPW5 | Challan Information | 1 | AbsEntry | Absolute Entry No | Int | 11 | 0 | | |
52 | TPW6 | Journal Entry Information | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
TOPBusiness Partners |
53 | ACRB | Business Partner Bank Accounts - History | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
54 | OCRB | BP - Bank Account | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
55 | OVTP | Vendor Type | 1 | ABSEntry | Primary Key | Int | 11 | 0 | | |
TOPFinance |
56 | AACP | Periods Category-Log | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
57 | AFPR | Posting Period-Log | 1 | AbsEntry | System Number | Int | 11 | 0 | | |
58 | AWH2 | WTax Definition - Rows2 | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
59 | CASE | Internal Recon. Upgrade 2007A | 1 | AbsEntry | Intl ID for Inconsistent Amt | Int | 11 | 0 | | |
60 | CASE1 | Internal Recon. Upgrade 2007A | 1 | AbsEntry | Header Internal ID | Int | 11 | 0 | | |
61 | IWZ1 | Accounts Revaluation History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
62 | IWZ2 | Inflation Warehouse Filter | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
63 | IWZ3 | Items Last Revaluation Data | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
64 | OACP | Periods Category | 1 | AbsEntry | Internal Number | Int | 11 | 0 | 0 | |
65 | OFPR | Posting Period | 1 | AbsEntry | System Number | Int | 11 | 0 | | |
66 | OGBI | GB Interface: Common Info | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
67 | OIWZ | Inflation Wizard | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
68 | OKRT | Tax Report Type | 1 | AbsEntry | Tax Report Type ID | Int | 11 | 0 | | |
69 | OMDR | Manual Distribution Rule | 9 | AbsEntry | Numerator | Int | 11 | 0 | | |
70 | OSVT | Define Summary VAT Report Type | 1 | AbsEntry | VAT Report Type ID | Int | 11 | 0 | | |
71 | OTAX | VAT Transactions | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
72 | OUTX | Unreported VAT Transactions | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
73 | OVTR | Tax Report | 1 | AbsEntry | Abs Entry (Numerator) | Int | 11 | 0 | | |
74 | TAX1 | VAT Transactions - Rows | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
75 | UTX1 | Unreported VAT Transactions - Rows | 1 | AbsEntry | Internal ID | Int | 11 | 0 | | |
76 | VTR1 | Tax Groups | 1 | AbsEntry | Abs Entry (Numerator) | Int | 11 | 0 | | |
77 | VTR2 | Doc. Type Filter | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
78 | VTR3 | Series Filter | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
79 | WHT2 | Withholding Tax Definition - Rows2 | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
TOPInventory and Production |
80 | AKL1 | Pick List - Rows - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
81 | APKL | Pick List - History | 1 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
82 | CIVI | IVI Config File | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
83 | IGE5 | Goods Issue - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
84 | IGN5 | Goods Receipt - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
85 | IVLG | Inventory Revaluation Log File | 1 | AbsEntry | Internal Unique Key | Int | 11 | 0 | | |
86 | IVRU | Inventory Valuation Utility | 1 | AbsEntry | Successive No. | Int | 11 | 0 | | |
87 | OBTN | Batch Numbers Master Data | 19 | AbsEntry | abs entry | Int | 11 | 0 | | |
88 | OBTQ | Batch No. Quantities | 7 | AbsEntry | abs entry | Int | 11 | 0 | | |
89 | OBTW | Batch Attributes in Location | 9 | AbsEntry | abs entry | Int | 11 | 0 | | |
90 | OCHP | India Chapter ID | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
91 | ODBN | Bat. Nos - Draft - Master Data | 19 | AbsEntry | abs entry | Int | 11 | 0 | | |
92 | ODBW | Batch Draft Attribs in Locat. | 9 | AbsEntry | abs entry | Int | 11 | 0 | | |
93 | ODNF | DNF Code | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
94 | ODSN | SNs - Draft - Master Data | 19 | AbsEntry | abs entry | Int | 11 | 0 | | |
95 | ODSW | SN Draft Attribs in Location | 9 | AbsEntry | abs entry | Int | 11 | 0 | | |
96 | OIVE | FIFO Based Sales Return | 3 | AbsEntry | Internal Number | Int | 11 | 0 | | |
97 | OIVQ | FIFO Queue Working Table | 10 | AbsEntry | Internal ID | Int | 11 | 0 | | |
98 | OMGP | Material Group | 1 | AbsEntry | ID | Int | 11 | 0 | | |
99 | OPKL | Pick List | 1 | AbsEntry | Absolute entry | Int | 11 | 0 | | |
100 | OSCG | Service Category | 1 | AbsEntry | ID | Int | 11 | 0 | | |
101 | OSRN | Serial Numbers Master Data | 19 | AbsEntry | abs entry | Int | 11 | 0 | | |
102 | OSRQ | Serial No. Quantities | 7 | AbsEntry | abs entry | Int | 11 | 0 | | |
103 | OSRW | Serial No. Attribs in Location | 9 | AbsEntry | abs entry | Int | 11 | 0 | | |
104 | PKL1 | Pick List - Rows | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
105 | UIVE | FIFO Based Sales Return | 3 | AbsEntry | Internal Number | Int | 11 | 0 | | |
106 | UIVQ | FIFO Queue Working Table | 10 | AbsEntry | Internal Number | Int | 11 | 0 | | |
107 | VLG1 | Validation of Recalc. From To | 1 | AbsEntry | Internal Unique Key | Int | 11 | 0 | | |
108 | WTR5 | Inventory Transfer - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
TOPMarketing Documents |
109 | ADO16 | Draft - SnB properties | 1 | AbsEntry | Document Number | Int | 11 | 0 | | |
110 | ADO5 | Withholding Tax - History | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
111 | AJD2 | Withholding Tax - History | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
112 | BTF2 | Journal Voucher Withholding Tax - History | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
113 | CIN5 | AR Correction Invoice - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
114 | CPI16 | A/P Corr. Inv - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
115 | CPI5 | Withholding Tax Data | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
116 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
117 | CPV5 | A/P Correction Invoice Reversal - WTax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
118 | CSI16 | A/R Corr. Inv. - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
119 | CSI5 | A/R Correction Invoice - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
120 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
121 | CSV5 | A/R Correction Invoice Reversal - WTax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
122 | DLN16 | Delivery - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
123 | DLN5 | Delivery - Withholding Tax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
124 | DPI16 | A/R Down Payment - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
125 | DPI5 | A/R Down Payment - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
126 | DPO16 | A/P Down Payment - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
127 | DPO5 | A/P Down Payment - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
128 | DRF16 | Draft - SnB - Rows | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
129 | DRF5 | Draft Documents - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
130 | IEI16 | Incoming Excise Invoice - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
131 | IEI5 | Incoming Excise Invoice - Withholding Tax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
132 | IGE16 | Goods Issue - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
133 | IGN16 | Goods Receipt - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
134 | INV16 | A/R Invoice - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
135 | INV5 | A/R Invoice - Withholding Tax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
136 | JDT2 | Withholding Tax - History | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
137 | MIN1 | Monthly Invoice Report Document Information | 2 | AbsEntry | Document Internal ID | Int | 11 | 0 | | |
138 | MIN2 | Item Imformation of MI | 17 | AbsEntry | Document Entry | Int | 11 | 0 | | |
139 | MIV1 | A/P Monthly Invoice - Document | 2 | AbsEntry | Internal Key | Int | 11 | 0 | | |
140 | MIV2 | A/P Monthly Invoice - Item | 17 | AbsEntry | Document Entry | Int | 11 | 0 | | |
141 | OEI16 | Outgoing Excise Invoice - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
142 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
143 | OPDT | Predefined Text | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
144 | PCH16 | A/P Invoice - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
145 | PCH5 | A/P Invoice - Withholding Tax Data | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
146 | PDN16 | Goods Receipt PO - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
147 | PDN5 | Goods Reciept PO - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
148 | POR16 | Purchase Order - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
149 | POR5 | Purchase Order - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
150 | QUT16 | Sales Quotation - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
151 | QUT5 | Sales Quotation - Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
152 | RDN16 | Returns - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
153 | RDN5 | Returns - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
154 | RDR16 | Sales Order - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
155 | RDR5 | Sales Order - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
156 | RIN16 | A/R Credit Memo - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
157 | RIN5 | A/R Credit Memo - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
158 | RPC16 | A/P Credit Memo - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
159 | RPC5 | A/P Credit Memo - Withholding Tax | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
160 | RPD16 | Goods Return - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
161 | RPD5 | Goods Return - Withholding Tax Data | 1 | AbsEntry | Numerator | Int | 11 | 0 | | |
162 | WTR16 | Inventory Transfer - SnB properties | 1 | AbsEntry | abs entry | Int | 11 | 0 | | |
TOPMRP |
163 | MSN1 | MRP Scenarios - Warehouses Array | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
164 | MSN2 | MRP Run Results | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
165 | MSN3 | MRP Pegging Information | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
166 | OMSN | MRP Scenarios | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
TOPReports |
167 | EJB1 | ERV-JAb Wizard Signing Persons | 9 | AbsEntry | Internal Number | Int | 11 | 0 | | |
168 | EJD1 | ERV-JAb Signing Persons List | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
169 | OEJD | Company Details for ERV-JAb | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
170 | OLLR | Electronic Report Generation Result | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
171 | OTRS | Tax Report Saving Object | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
172 | OTRX | Transformation Documents | 1 | AbsEntry | Internal Number | Internal Number | 11 | 0 | | |
173 | TRS1 | Tax Report Saving Object - Approved Documents | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
174 | TRS2 | Tax Rpt Sav Obj Man Chgd Vals | 1 | AbsEntry | Internal Number | Int | 11 | 0 | | |
TOPSales Opportunities |
175 | ODOR | Doubtful Debts | 1 | AbsEntry | Internal Key | Int | 11 | 0 | | |
176 | OOCR | Loading Factors | 9 | AbsEntry | Numerator | Int | 11 | 0 | | |
TOPService |
177 | OREQ | External System Call Request | 1 | AbsEntry | Request ID | Int | 11 | 0 | | |
178 | OSCD | Service Code Table | 1 | AbsEntry | ID | Int | 11 | 0 | | |
179 | OSGP | Service Group for Brazil | 1 | AbsEntry | Service Group ID | Int | 11 | 0 | | |
180 | REQ1 | External System Call Request - Message List | 1 | AbsEntry | Request ID | Int | 11 | 0 | | |
181 | REQ2 | External System Call Request - Argument List | 1 | AbsEntry | Request ID | Int | 11 | 0 | | |
182 | REQ3 | External System Call Request - Message Argument List | 1 | AbsEntry | Request ID | Int | 11 | 0 | | |