| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | DADB | Data Archive DSA Balance | 2 | ItemCode | Item Number | nVarChar | 20 | 0 | | |
2 | OSRL | Serial Numbers | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
3 | PQW1 | Purchase Quotation Generation: Line Items | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
4 | TRN1 | Subtable of OTRN | 3 | ItemCode | Item Code | nVarChar | 254 | 0 | | |
TOPBusiness Partners |
5 | ACP2 | Campaign - Items | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
6 | AOA1 | Blanket Agreement - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
7 | AWD4 | WTax Codes Details for Item | 4 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
8 | CPN2 | Campaign - Items | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
9 | OAT1 | Blanket Agreement - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
10 | OSCN | Customer/Vendor Cat. No. | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
11 | WTD4 | WTax Codes Details for Item | 4 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
TOPFinance |
12 | ACD1 | Credit Memo - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
13 | ACD3 | Credit Memo - Item Areas | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
14 | ACQ1 | Capitalization - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
15 | ACQ3 | Capitalization - Item Areas | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
16 | AFA1 | Asset Document - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
17 | AGAR | G/L Account Advanced Rules - History | 18 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
18 | DRN2 | Depreciation Run - Posting - Asset | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
19 | FAR1 | Fixed Asset Revaluation - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
20 | FIX1 | Fixed Asset Transaction - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
21 | FTR1 | Transfer - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
22 | FTR3 | Transfer - Item Areas | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
23 | ISW2 | Intrastat Reported Items | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
24 | ISW3 | Declaration Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
25 | IWZ3 | Items Last Revaluation Data | 2 | ItemCode | Item Number | nVarChar | 20 | 0 | | |
26 | MDP1 | Manual Depreciation - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
27 | MDP3 | Manual Depreciation - Item Areas | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
28 | ODPV | Fixed Assets Depreciation Value | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
29 | OFAC | Fixed Asset Parameter Change | 2 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
30 | OGAR | G/L Account Advanced Rules | 18 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
31 | RTI1 | Retirement - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
32 | RTI3 | Retirement - Item Areas | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
TOPGeneral |
33 | ARSC3 | Resouces - Fixed Assets - Log | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
34 | OBTA | Brazil - Tax Adjustment | 41 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
35 | OBVL | Serial Numbers and Batch Valuation Log | 11 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
36 | ODSL | Schedule Row Detail | 6 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
37 | OSLD | Schedule Row Detail | 6 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
38 | RSC3 | Resouces - Fixed Assets | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
39 | TCN1 | Tracking Note - Line Data | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
40 | UBVL | Serial Numbers and Batch Valuation Log | 11 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
TOPInventory and Production |
41 | ABTN | Batch Numbers Master Data | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
42 | ABTW | Batch Attributes in Location | 1 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
43 | AIN1 | Inventory Counting - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
44 | AIN11 | Inventory Counting - Individual Counters - Row SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
45 | AIN3 | Inventory Count - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
46 | AIN7 | Inventory Counting - Team Counter - Row SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
47 | AIT1 | Item - Prices - History | 1 | ItemCode | Item Number | nVarChar | 20 | 0 | | |
48 | AIT11 | Asset Item Period Control | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
49 | AIT13 | Asset Attributes | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
50 | AIT2 | Items - Multiple Preferred Vendors - History | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
51 | AIT3 | Items - Localization Fields - History | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
52 | AIT5 | Asset Item Projects - History | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
53 | AIT6 | Asset Item Distribution Rules | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
54 | AIT7 | Asset Item Depreciation Params - History | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
55 | AIT8 | Asset Item Balances - History | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
56 | AIT9 | Item - UoM Prices | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
57 | AITM | Items - History | 1 | ItemCode | Item Number | nVarChar | 20 | 0 | | |
58 | AITW | Items - Warehouse - History | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
59 | AKL2 | Pick List for SnB and Bin Details | 4 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
60 | AMR1 | Inventory Revaluation - History - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
61 | AQI1 | Inventory Opening Balance - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
62 | AQI2 | Inventory Opening Balance - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
63 | AQR1 | Inventory Posting - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
64 | AQR3 | Inventory Count - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
65 | ASP1 | Special Prices - Data Areas | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
66 | ASP2 | Special Prices - Quantity Areas | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
67 | ASPP | Special Prices | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
68 | ASRN | Serial Numbers Master Data | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
69 | AWO1 | Production Order (Rows) - History | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
70 | AWOR | Production Order - History | 4 | ItemCode | Product No. | nVarChar | 20 | 0 | | |
71 | ENT1 | Entry - Rows | 13 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
72 | ICD1 | Inventory Counting Draft - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
73 | ICD11 | Inventory Counting Draft - Individual Counter - Row SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
74 | ICD3 | Inventory Count Draft - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
75 | ICD7 | Inventory Counting Draft - Team Counter - Row SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
76 | IGE1 | Goods Issue - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
77 | IGE14 | Goods Issue - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
78 | IGE16 | Goods Issue - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
79 | IGE19 | Goods Issue - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
80 | IGE8 | Items in Package - Goods Issue | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
81 | IGN1 | Goods Receipt - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
82 | IGN14 | Goods Receipt - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
83 | IGN16 | Goods Receipt - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
84 | IGN19 | Goods Receipt - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
85 | IGN8 | Goods Receipt - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
86 | ILM1 | Srl & Batch Det of Inv Log Msg | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
87 | ILM3 | Non-Inventory and Resource Components Log Msg | 5 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
88 | INC1 | Inventory Counting - Rows | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
89 | INC11 | Inventory Counting - Individual Counter - Row SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
90 | INC3 | Inventory Count - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
91 | INC7 | Inventory Counting - Team Counter - Row SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
92 | IOD1 | Inventory Opening Balance Draft - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
93 | IOD2 | Inventory Opening Balance Draft - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
94 | IPD1 | Inventory Posting Draft - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
95 | IPD3 | Inventory Posting Draft - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
96 | IPF1 | Landed Costs - Rows | 5 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
97 | IQI1 | Inventory Opening Balance - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
98 | IQI2 | Inventory Opening Balance - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
99 | IQR1 | Inventory Posting - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
100 | IQR3 | Inventory Posting - SnB | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
101 | ITL1 | Srl & Batch Details in Transac | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
102 | ITM1 | Items - Prices | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
103 | ITM10 | OITM Extension | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
104 | ITM11 | Asset Item Period Control | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
105 | ITM12 | UoM in Item | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
106 | ITM13 | Asset Attributes | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
107 | ITM2 | Items - Multiple Preferred Vendors | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
108 | ITM3 | Items - Localization Fields | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
109 | ITM4 | Package in Items | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
110 | ITM5 | Asset Item Projects | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
111 | ITM6 | Asset Item Distribution Rules | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
112 | ITM7 | Asset Item Depreciation Params | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
113 | ITM8 | Asset Item Balances | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
114 | ITM9 | Item - UoM Prices | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
115 | ITW1 | Item Count Alert | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
116 | MRV1 | Inventory Revaluation Information Array | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
117 | OAIM | Archive Inventory Message | 18 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
118 | OBBQ | Item - Serial/Batch - Bin Accumulator | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
119 | OBCD | Bar Code Master Data | 4 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
120 | OBTN | Batch Numbers Master Data | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
121 | OBTQ | Batch No. Quantities | 1 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
122 | OBTW | Batch Attributes in Location | 1 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
123 | ODBN | Bat. Nos - Draft - Master Data | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
124 | ODBW | Batch Draft Attribs in Locat. | 1 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
125 | ODSN | SNs - Draft - Master Data | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
126 | ODSW | SN Draft Attribs in Location | 1 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
127 | OIBQ | Item - Bin Accumulator | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
128 | OILM | Inventory Log Message | 22 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
129 | OITL | Inventory Transactions Log | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
130 | OITM | Items | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
131 | OITW | Items - Warehouse | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
132 | OIVE | FIFO Based Sales Return | 11 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
133 | OIVL | Whse Journal | 7 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
134 | OIVQ | FIFO Queue Working Table | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
135 | OIWB | Items - Warehouse Counting Data Backup | 2 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
136 | OSBQ | Item - Serial/Batch - Bin Accumulator | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
137 | OSPP | Special Prices | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
138 | OSRN | Serial Numbers Master Data | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
139 | OSRQ | Serial No. Quantities | 1 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
140 | OSRW | Serial No. Attribs in Location | 1 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
141 | OWOR | Production Order | 4 | ItemCode | Product No. | nVarChar | 20 | 0 | | |
142 | PKL2 | Pick List for SnB and Bin Details | 4 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
143 | SITM | Items | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
144 | SITW | Items - Warehouse | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
145 | SIVE | FIFO Based Sales Return | 11 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
146 | SIVL | Whse Journal | 7 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
147 | SIVQ | FIFO Queue Working Table | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
148 | SPP1 | Special Prices - Data Areas | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
149 | SPP2 | Special Prices - Quantity Areas | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
150 | UBTN | Batch Numbers Master Data | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
151 | UILM | IVI Inventory Log Message | 22 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
152 | UILM1 | Srl & Batch Det of Inv Log Msg | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
153 | UILM3 | Non-Inventory and Resource Components Log Msg | 5 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
154 | UITM | Items | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
155 | UITW | Items - Warehouse | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
156 | UIVE | FIFO Based Sales Return | 11 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
157 | UIVL | Whse Journal | 7 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
158 | UIVQ | FIFO Queue Working Table | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
159 | USRN | Serial Numbers Master Data | 1 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
160 | UWKO1 | Production Instructions - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
161 | UWOR | Production Order | 4 | ItemCode | Product No. | nVarChar | 20 | 0 | | |
162 | UWOR1 | Production Order - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
163 | WKO1 | Production Instructions - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
164 | WOR1 | Production Order - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
165 | WTQ1 | Inventory Transfer Request - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
166 | WTQ14 | Inventory Transfer Request - Assembly - Rows | 4 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
167 | WTQ16 | Inventory Transfer Request - SnB Properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
168 | WTQ19 | Inventory Transfer Request - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
169 | WTQ8 | Inventory Transfer Request - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
170 | WTR1 | Inventory Transfer - Rows | 10 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
171 | WTR14 | Inventory Transfer - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
172 | WTR16 | Inventory Transfer - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
173 | WTR19 | Inventory Transfer - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
174 | WTR8 | Inventory Transfer - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
TOPMarketing Documents |
175 | ADO1 | A/R Invoice (Rows) - History | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
176 | ADO14 | Invoice - Assembly - Rows - History | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
177 | ADO16 | Draft - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
178 | ADO19 | Bin Allocation Data - History | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
179 | ADO8 | Items in Package - History | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
180 | CIN1 | Correction Invoice - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
181 | CIN19 | Correction Invoice - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
182 | CIN8 | Items in Package - Correction Invoice | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
183 | CPI1 | A/P Correction Invoice - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
184 | CPI14 | A/P Correction Invoice - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
185 | CPI16 | A/P Corr. Inv - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
186 | CPI19 | A/P Correction Invoice - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
187 | CPI8 | A/P Correction Invoice - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
188 | CPV1 | A/P Correction Invoice Reversal - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
189 | CPV14 | A/P Correction Invoice Reversal - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
190 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
191 | CPV19 | A/P Correction Invoice Reversal - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
192 | CPV8 | A/P Correction Invoice Reversal - Items in Package | 3 | ItemCode | Item Number | nVarChar | 20 | 0 | | |
193 | CSI1 | A/R Correction Invoice - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
194 | CSI14 | A/R Correction Invoice - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
195 | CSI16 | A/R Corr. Inv. - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
196 | CSI19 | A/R Correction Invoice - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
197 | CSI8 | A/R Corr. Inv. - Items in Pkg | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
198 | CSV1 | A/R Correction Invoice Reversal - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
199 | CSV14 | A/R Correction Invoice Reversal - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
200 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
201 | CSV19 | A/R Correction Invoice Reversal - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
202 | CSV8 | A/R Correction Invoice Reversal - Items in Package | 3 | ItemCode | Item Number | nVarChar | 20 | 0 | | |
203 | DLN1 | Delivery - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
204 | DLN14 | Delivery Notes - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
205 | DLN16 | Delivery - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
206 | DLN19 | Delivery - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
207 | DLN8 | Items in Package - Delivery | 3 | ItemCode | Item Number | nVarChar | 20 | 0 | | |
208 | DPI1 | A/R Down Payment - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
209 | DPI14 | A/R Down Payment - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
210 | DPI16 | A/R Down Payment - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
211 | DPI19 | A/R Down Payment - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
212 | DPI8 | Items in Package - A/R Down Pmt. | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
213 | DPO1 | A/P Down Payment - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
214 | DPO14 | A/P Down Payment - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
215 | DPO16 | A/P Down Payment - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
216 | DPO19 | A/P Down Payment - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
217 | DPO8 | Items in Package - A/P Down Pmt. | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
218 | DRF1 | Draft - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
219 | DRF14 | Draft - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
220 | DRF16 | Draft - SnB - Rows | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
221 | DRF19 | Draft - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
222 | DRF8 | Items in Package - Draft | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
223 | GPA1 | Gross Profit Adjustment - Documents | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
224 | GPA5 | Product Cost Adjustment - Recalculation of Product Cost | 14 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
225 | GTM1 | GTS Mapping Object Details | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
226 | IEI1 | Incoming Excise Invoice - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
227 | IEI14 | Incoming Excise Invoice - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
228 | IEI16 | Incoming Excise Invoice - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
229 | IEI19 | Incoming Excise Invoice - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
230 | IEI8 | Incoming Excise Invoice - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
231 | INV1 | A/R Invoice - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
232 | INV14 | A/R Invoice - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
233 | INV16 | A/R Invoice - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
234 | INV19 | A/R Invoice - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
235 | INV8 | A/R Invoice - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
236 | MIN2 | Item Imformation of MI | 6 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
237 | MIV2 | A/P Monthly Invoice - Item | 6 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
238 | OEI1 | Outgoing Excise Invoice - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
239 | OEI14 | Outgoing Excise Invoice - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
240 | OEI16 | Outgoing Excise Invoice - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
241 | OEI19 | Outgoing Excise Invoice - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
242 | OEI8 | Outgoing Excise Invoice - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
243 | PCH1 | A/P Invoice - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
244 | PCH14 | A/P Invoice - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
245 | PCH16 | A/P Invoice - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
246 | PCH19 | A/P Invoice - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
247 | PCH8 | A/P Invoice - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
248 | PDN1 | Goods Receipt PO - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
249 | PDN14 | Goods Receipt PO - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
250 | PDN16 | Goods Receipt PO - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
251 | PDN19 | Goods Receipt PO - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
252 | PDN8 | Goods Receipt PO - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
253 | POR1 | Purchase Order - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
254 | POR14 | Purchase Order - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
255 | POR16 | Purchase Order - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
256 | POR19 | Purchase Order - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
257 | POR8 | Items in Package - Purchase Order | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
258 | PQT1 | Purchase Quotation - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
259 | PQT14 | Purchase Quotation - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
260 | PQT16 | Purchase Quotation - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
261 | PQT19 | Purchase Quotation - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
262 | PQT8 | Items in Package - Purchase Quotation | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
263 | PRQ1 | Purchase Request - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
264 | PRQ14 | Purchase Request - Assembly - Rows | 4 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
265 | PRQ16 | Purchase Request - SnB Properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
266 | PRQ19 | Purchase Request - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
267 | PRQ8 | Items in Package - Purchase Request | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
268 | QUT1 | Sales Quotation - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
269 | QUT14 | Sales Quotation - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
270 | QUT16 | Sales Quotation - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
271 | QUT19 | Sales Quotation - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
272 | QUT8 | Sales Quotation - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
273 | RDN1 | Returns - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
274 | RDN14 | Return - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
275 | RDN16 | Returns - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
276 | RDN19 | Returns - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
277 | RDN8 | Returns - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
278 | RDR1 | Sales Order - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
279 | RDR14 | Sales Order - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
280 | RDR16 | Sales Order - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
281 | RDR19 | Sales Order - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
282 | RDR8 | Sales Order - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
283 | RIN1 | A/R Credit Memo - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
284 | RIN14 | A/R Credit Memo - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
285 | RIN16 | A/R Credit Memo - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
286 | RIN19 | A/R Credit Memo - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
287 | RIN8 | Items in Package - A/R Credit Memo | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
288 | RPC1 | A/P Credit Memo - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
289 | RPC14 | A/P Credit Memo - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
290 | RPC16 | A/P Credit Memo - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
291 | RPC19 | A/P Credit Memo - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
292 | RPC8 | Items in Package - A/P Credit Memo | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
293 | RPD1 | Goods Return - Rows | 10 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
294 | RPD14 | Goods Return - Assembly - Rows | 4 | ItemCode | Item no. | nVarChar | 20 | 0 | | |
295 | RPD16 | Goods Return - SnB properties | 4 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
296 | RPD19 | Goods Return - Bin Allocation Data | 9 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
297 | RPD8 | Goods Return - Items in Package | 3 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
298 | SAL1 | Salida - Rows | 13 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
299 | TGPA | Gross Profit Adjustment - Log | 2 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
300 | TRA1 | Transition - Rows | 13 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
TOPMRP |
301 | FCT1 | Sales Forecast - Rows | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
302 | MSN2 | MRP Run Results | 2 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
303 | MSN3 | MRP Pegging Information | 2 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
304 | MSN4 | MRP Scenarios - Items Array | 2 | ItemCode | Item Code | nVarChar | 20 | 0 | | |
305 | ORCM | Recommendation Data | 4 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
TOPService |
306 | AINS | Customer Equipment Card - History | 14 | itemCode | Foreign Key To Item | nVarChar | 20 | 0 | | |
307 | ASC2 | Service Call Inventory Expenses - History | 3 | ItemCode | Item No. - History | nVarChar | 20 | 0 | | |
308 | ASC3 | Service Call Travel/Labor Expenses - History | 3 | ItemCode | Item Number | nVarChar | 20 | 0 | | |
309 | ASCL | History | 15 | itemCode | Item Number | nVarChar | 20 | 0 | | |
310 | CTR1 | Service Contract - Items | 5 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
311 | OINS | Customer Equipment Card | 14 | itemCode | Item No. | nVarChar | 20 | 0 | | |
312 | OSCL | Service Calls | 15 | itemCode | Item No. | nVarChar | 20 | 0 | | |
313 | OSLT | Service Call Solutions | 2 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
314 | SCL2 | Service Call Inventory Expenses | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |
315 | SCL3 | Service Call Travel/Labor Expenses | 3 | ItemCode | Item No. | nVarChar | 20 | 0 | | |