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