SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data

344 columns | Print definition?B1 9.1  | ITEMCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DADBData Archive DSA Balance2ItemCodeItem NumbernVarChar200
2OSRDBatches and Serial Numbers1ItemCodeItem No.nVarChar200
3OSRLSerial Numbers1ItemCodeItem No.nVarChar200
4PQW1Purchase Quotation Generation: Line Items3ItemCodeItem No.nVarChar200
5TRN1Subtable of OTRN3ItemCodeItem CodenVarChar2540
TOPBusiness Partners
6ACP2Campaign - Items3ItemCodeItem No.nVarChar200
7AOA1Blanket Agreement - Rows3ItemCodeItem No.nVarChar200
8CPN2Campaign - Items3ItemCodeItem No.nVarChar200
9OAT1Blanket Agreement - Rows3ItemCodeItem No.nVarChar200
10OAT4VAgreement Document7ItemCodeItem No.nVarChar200
11OSCNCustomer/Vendor Cat. No.1ItemCodeItem No.nVarChar200
TOPFinance
12ACD1Credit Memo - Rows3ItemCodeItem CodenVarChar200
13ACD3Credit Memo - Item Areas3ItemCodeItem CodenVarChar200
14ACQ1Capitalization - Rows3ItemCodeItem CodenVarChar200
15ACQ3Capitalization - Item Areas3ItemCodeItem CodenVarChar200
16AFA1Asset Document - Rows3ItemCodeItem CodenVarChar200
17AGARG/L Account Advanced Rules - History18ItemCodeItem No.nVarChar200
18DRN2Depreciation Run - Posting - Asset3ItemCodeItem CodenVarChar200
19FAD1Asset Document - Rows3ItemCodeItem CodenVarChar200
20FAD3Asset Document - Item Areas3ItemCodeItem CodenVarChar200
21FAR1Fixed Asset Revaluation - Rows3ItemCodeItem CodenVarChar200
22FIX1Fixed Asset Transaction - Rows3ItemCodeItem CodenVarChar200
23FTR1Transfer - Rows3ItemCodeItem CodenVarChar200
24FTR3Transfer - Item Areas3ItemCodeItem CodenVarChar200
25ISW2Intrastat Reported Items2ItemCodeItem CodenVarChar200
26ISW3Declaration Rows3ItemCodeItem CodenVarChar200
27IWZ3Items Last Revaluation Data2ItemCodeItem NumbernVarChar200
28MDP1Manual Depreciation - Rows3ItemCodeItem CodenVarChar200
29MDP3Manual Depreciation - Item Areas3ItemCodeItem CodenVarChar200
30ODPVFixed Assets Depreciation Value2ItemCodeItem CodenVarChar200
31OFACFixed Asset Parameter Change2ItemCodeItem No.nVarChar200
32OGARG/L Account Advanced Rules18ItemCodeItem No.nVarChar200
33RTI1Retirement - Rows3ItemCodeItem CodenVarChar200
34RTI3Retirement - Item Areas3ItemCodeItem CodenVarChar200
TOPGeneral
35ARSC3Resouces - Fixed Assets - Log2ItemCodeItem CodenVarChar200
36CIFVInventory-FIFO Revaluation1ItemCodeItem CodenVarChar200
37FIFODI MRV for FIFO Item - Input1ItemCodeItem No.nVarChar200
38FIFO1DI MRV for FIFO Item - Output9ItemCodeItem No.nVarChar200
39OBTABrazil Tax Adujstment39ItemCodeItem CodenVarChar200
40OBVLSerial Numbers and Batch Valuation Log11ItemCodeItem No.nVarChar200
41ODSLSchedule Row Detail6ItemCodeItem CodenVarChar200
42OFDVAsset Item Values1ItemCodeItem CodenVarChar200
43OFEVFixed Asset End Balances1ItemCodeItem CodenVarChar200
44OSLDSchedule Row Detail6ItemCodeItem CodenVarChar200
45RBINBin Location Report2ItemCodeItem CodenVarChar200
46RSC3Resouces - Fixed Assets2ItemCodeItem CodenVarChar200
47TCN1Tracking Note - Line Data4ItemCodeItem CodenVarChar200
48UBVLSerial Numbers and Batch Valuation Log11ItemCodeItem No.nVarChar200
TOPInventory and Production
49ABTNBatch Numbers Master Data1ItemCodeItem No.nVarChar200
50ABTWBatch Attributes in Location1ItemCodeItem CodenVarChar200
51AIBTBatch No. for Item1ItemCodeItem No.nVarChar200
52AIN1Inventory Counting - Rows3ItemCodeItem CodenVarChar200
53AIN11Inventory Counting - Individual Counters - Row SnB4ItemCodeItem CodenVarChar200
54AIN3Inventory Count - SnB4ItemCodeItem CodenVarChar200
55AIN7Inventory Counting - Team Counter - Row SnB4ItemCodeItem CodenVarChar200
56AIT1Item - Prices - History1ItemCodeItem NumbernVarChar200
57AIT11Asset Item Period Control1ItemCodeItem No.nVarChar200
58AIT13Asset Attributes1ItemCodeItem No.nVarChar200
59AIT2Items - Multiple Preferred Vendors - History1ItemCodeItem No.nVarChar200
60AIT3Items - Localization Fields - History1ItemCodeItem No.nVarChar200
61AIT5Asset Item Projects - History1ItemCodeItem No.nVarChar200
62AIT6Asset Item Distribution Rules1ItemCodeItem No.nVarChar200
63AIT7Asset Item Depreciation Params - History1ItemCodeItem No.nVarChar200
64AIT8Asset Item Balances - History1ItemCodeItem No.nVarChar200
65AIT9Item - UoM Prices1ItemCodeItem No.nVarChar200
66AITMItems - History1ItemCodeItem NumbernVarChar200
67AITWItems - Warehouse - History1ItemCodeItem No.nVarChar200
68AKL2Pick List for SnB and Bin Details4ItemCodeItem No.nVarChar200
69AMR1Inventory Revaluation - History - Rows3ItemCodeItem CodenVarChar200
70AQI1Inventory Initial Qty Rows3ItemCodeItem No.nVarChar200
71AQI2Inventory Count - SnB4ItemCodeItem CodenVarChar200
72AQR1Inventory Stock Posting (Reconcile) Lines3ItemCodeItem No.nVarChar200
73AQR3Inventory Count - SnB4ItemCodeItem CodenVarChar200
74ASP1Special Prices - Data Areas1ItemCodeItem No.nVarChar200
75ASP2Special Prices - Quantity Areas1ItemCodeItem No.nVarChar200
76ASPPSpecial Prices1ItemCodeItem No.nVarChar200
77ASRNSerial Numbers Master Data1ItemCodeItem No.nVarChar200
78AWO1Production Order (Rows) - History3ItemCodeItem No.nVarChar200
79AWORProduction Order - History4ItemCodeProduct No.nVarChar200
80BTNTBatch Numbers in Document1ItemCodeItem CodenVarChar200
81BTNT1Batch Numbers in Inventory Counting1ItemCodeItem CodenVarChar200
82ENT1Entry - Rows13ItemCodeItem No.nVarChar200
83IBT1Batch Number Transactions1ItemCodeItem No.nVarChar200
84ICD1Inventory Counting Draft - Rows3ItemCodeItem CodenVarChar200
85ICD11Inventory Counting Draft - Individual Counter - Row SnB4ItemCodeItem CodenVarChar200
86ICD3Inventory Count Draft - SnB4ItemCodeItem CodenVarChar200
87ICD7Inventory Counting Draft - Team Counter - Row SnB4ItemCodeItem CodenVarChar200
88IFSTImported Temporary Table for Stock Taking2ItemCodeItem CodenVarChar200
89IGE1Goods Issue - Rows10ItemCodeItem No.nVarChar200
90IGE14Goods Issue - Assembly - Rows4ItemCodeItem no.nVarChar200
91IGE16Goods Issue - SnB properties4ItemCodeItem CodenVarChar200
92IGE19Goods Issue - Bin Allocation Data9ItemCodeItem CodenVarChar200
93IGE8Items in Package - Goods Issue3ItemCodeItem CodenVarChar200
94IGN1Goods Receipt - Rows10ItemCodeItem No.nVarChar200
95IGN14Goods Receipt - Assembly - Rows4ItemCodeItem no.nVarChar200
96IGN16Goods Receipt - SnB properties4ItemCodeItem CodenVarChar200
97IGN19Goods Receipt - Bin Allocation Data9ItemCodeItem CodenVarChar200
98IGN8Goods Receipt - Items in Package3ItemCodeItem CodenVarChar200
99ILM1Srl & Batch Det of Inv Log Msg2ItemCodeItem CodenVarChar200
100ILM3Non-Inventory and Resource Components Log Msg5ItemCodeItem No.nVarChar200
101INC1Inventory Counting - Rows3ItemCodeItem CodenVarChar200
102INC11Inventory Counting - Individual Counter - Row SnB4ItemCodeItem CodenVarChar200
103INC1VInventory Counting - Rows - Virtual6ItemCodeItem CodenVarChar200
104INC3Inventory Count - SnB4ItemCodeItem CodenVarChar200
105INC7Inventory Counting - Team Counter - Row SnB4ItemCodeItem CodenVarChar200
106IOD1Inventory Initial Qty Draft Rows3ItemCodeItem No.nVarChar200
107IOD2Inventory Count Draft - SnB4ItemCodeItem CodenVarChar200
108IPD1Inventory Stock Posting Draft (Reconcile) Lines3ItemCodeItem No.nVarChar200
109IPD3Inventory Posting Draft - SnB4ItemCodeItem CodenVarChar200
110IPF1Landed Costs - Rows5ItemCodeItem No.nVarChar200
111IQI1Inventory Initial Qty Rows3ItemCodeItem No.nVarChar200
112IQI2Inventory Count - SnB4ItemCodeItem CodenVarChar200
113IQR1Inventory Stock Posting (Reconcile) Lines3ItemCodeItem No.nVarChar200
114IQR3Inventory Posting - SnB4ItemCodeItem CodenVarChar200
115ITL1Srl & Batch Details in Transac2ItemCodeItem CodenVarChar200
116ITM1Items - Prices1ItemCodeItem No.nVarChar200
117ITM10OITM Extension1ItemCodeItem No.nVarChar200
118ITM11Asset Item Period Control1ItemCodeItem No.nVarChar200
119ITM12UoM in Item1ItemCodeItem No.nVarChar200
120ITM13Asset Attributes1ItemCodeItem No.nVarChar200
121ITM2Items - Multiple Preferred Vendors1ItemCodeItem No.nVarChar200
122ITM3Items - Localization Fields1ItemCodeItem No.nVarChar200
123ITM4Package in Items1ItemCodeItem No.nVarChar200
124ITM5Asset Item Projects1ItemCodeItem No.nVarChar200
125ITM6Asset Item Distribution Rules1ItemCodeItem No.nVarChar200
126ITM7Asset Item Depreciation Params1ItemCodeItem No.nVarChar200
127ITM8Asset Item Balances1ItemCodeItem No.nVarChar200
128ITM9Item - UoM Prices1ItemCodeItem No.nVarChar200
129ITW1Item Count Alert1ItemCodeItem No.nVarChar200
130MRV1Inventory Revaluation Information Array3ItemCodeItem CodenVarChar200
131OAIMArchive Inventory Message18ItemCodeItem CodenVarChar200
132OBBQItem - Serial/Batch - Bin Accumulator2ItemCodeItem CodenVarChar200
133OBCDBar Code Master Data4ItemCodeItem No.nVarChar200
134OBTNBatch Numbers Master Data1ItemCodeItem No.nVarChar200
135OBTQBatch No. Quantities1ItemCodeItem CodenVarChar200
136OBTWBatch Attributes in Location1ItemCodeItem CodenVarChar200
137ODBNBat. Nos - Draft - Master Data1ItemCodeItem No.nVarChar200
138ODBWBatch Draft Attribs in Locat.1ItemCodeItem CodenVarChar200
139ODIBBatch No. for Item Draft1ItemCodeItem No.nVarChar200
140ODSNSNs - Draft - Master Data1ItemCodeItem No.nVarChar200
141ODSRDraft Serial Numbers for Items1ItemCodeItem No.nVarChar200
142ODSWSN Draft Attribs in Location1ItemCodeItem CodenVarChar200
143OIBQItem - Bin Accumulator2ItemCodeItem CodenVarChar200
144OIBTBatch No. for Item1ItemCodeItem No.nVarChar200
145OILMInventory Log Message22ItemCodeItem CodenVarChar200
146OINMWhse Journal15ItemCodeItem No.nVarChar200
147OITLInventory Transactions Log3ItemCodeItem CodenVarChar200
148OITMItems1ItemCodeItem No.nVarChar200
149OITWItems - Warehouse1ItemCodeItem No.nVarChar200
150OIVEFIFO Based Sales Return11ItemCodeItem CodenVarChar200
151OIVLWhse Journal7ItemCodeItem No.nVarChar200
152OIVQFIFO Queue Working Table9ItemCodeItem CodenVarChar200
153OIWBItems - Warehouse Counting Data Backup2ItemCodeItem No.nVarChar200
154OSBQItem - Serial/Batch - Bin Accumulator2ItemCodeItem CodenVarChar200
155OSPPSpecial Prices1ItemCodeItem No.nVarChar200
156OSRISerial Numbers for Items1ItemCodeItem No.nVarChar200
157OSRNSerial Numbers Master Data1ItemCodeItem No.nVarChar200
158OSRQSerial No. Quantities1ItemCodeItem CodenVarChar200
159OSRWSerial No. Attribs in Location1ItemCodeItem CodenVarChar200
160OWORProduction Order4ItemCodeProduct No.nVarChar200
161PKL2Pick List for SnB and Bin Details4ItemCodeItem No.nVarChar200
162RBTNBatch Report Master Data List2ItemCodeItem CodenVarChar200
163RSRNSerial Number Report Master Data List2ItemCodeItem CodenVarChar200
164SBDRSerial Batches Document Row1ItemCodeItem CodenVarChar200
165SITMItems1ItemCodeItem No.nVarChar200
166SITWItems - Warehouse1ItemCodeItem No.nVarChar200
167SIVEFIFO Based Sales Return11ItemCodeItem CodenVarChar200
168SIVLWhse Journal7ItemCodeItem No.nVarChar200
169SIVQFIFO Queue Working Table9ItemCodeItem CodenVarChar200
170SPP1Special Prices - Data Areas1ItemCodeItem No.nVarChar200
171SPP2Special Prices - Quantity Areas1ItemCodeItem No.nVarChar200
172SRI1Serial No. Trans. for Item1ItemCodeItem No.nVarChar200
173SRNTSerial Numbers in Document1ItemCodeItem CodenVarChar200
174SRNT1Serial Numbers in Inventory Counting1ItemCodeItem CodenVarChar200
175UBTNBatch Numbers Master Data1ItemCodeItem No.nVarChar200
176UILMIVI Inventory Log Message22ItemCodeItem CodenVarChar200
177UILM1Srl & Batch Det of Inv Log Msg2ItemCodeItem CodenVarChar200
178UILM3Non-Inventory and Resource Components Log Msg5ItemCodeItem No.nVarChar200
179UITMItems1ItemCodeItem No.nVarChar200
180UITWItems - Warehouse1ItemCodeItem No.nVarChar200
181UIVEFIFO Based Sales Return11ItemCodeItem CodenVarChar200
182UIVLWhse Journal7ItemCodeItem No.nVarChar200
183UIVQFIFO Queue Working Table9ItemCodeItem CodenVarChar200
184USRNSerial Numbers Master Data1ItemCodeItem No.nVarChar200
185UWKO1Production Instructions - Rows3ItemCodeItem No.nVarChar200
186UWORProduction Order4ItemCodeProduct No.nVarChar200
187UWOR1Production Order - Rows3ItemCodeItem No.nVarChar200
188WKO1Production Instructions - Rows3ItemCodeItem No.nVarChar200
189WOR1Production Order - Rows3ItemCodeItem No.nVarChar200
190WTQ1Inventory Transfer Request - Rows10ItemCodeItem No.nVarChar200
191WTQ14Inventory Transfer Request - Assembly - Rows4ItemCodeItem No.nVarChar200
192WTQ16Inventory Transfer Request - SnB Properties4ItemCodeItem CodenVarChar200
193WTQ19Inventory Transfer Request - Bin Allocation Data9ItemCodeItem CodenVarChar200
194WTQ8Inventory Transfer Request - Items in Package3ItemCodeItem CodenVarChar200
195WTR1Inventory Transfer - Rows10ItemCodeItem CodenVarChar200
196WTR14Inventory Transfer - Assembly - Rows4ItemCodeItem no.nVarChar200
197WTR16Inventory Transfer - SnB properties4ItemCodeItem CodenVarChar200
198WTR19Inventory Transfer - Bin Allocation Data9ItemCodeItem CodenVarChar200
199WTR8Inventory Transfer - Items in Package3ItemCodeItem CodenVarChar200
TOPMarketing Documents
200ADO1A/R Invoice (Rows) - History10ItemCodeItem No.nVarChar200
201ADO14Invoice - Assembly - Rows - History4ItemCodeItem no.nVarChar200
202ADO16Draft - SnB properties4ItemCodeItem CodenVarChar200
203ADO19Bin Allocation Data - History9ItemCodeItem CodenVarChar200
204ADO8Items in Package - History3ItemCodeItem CodenVarChar200
205CIN1Correction Invoice - Rows10ItemCodeItem No.nVarChar200
206CIN19Correction Invoice - Bin Allocation Data9ItemCodeItem CodenVarChar200
207CIN8Items in Package - Correction Invoice3ItemCodeItem CodenVarChar200
208CPI1A/P Correction Invoice - Rows10ItemCodeItem No.nVarChar200
209CPI14A/P Correction Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
210CPI16A/P Corr. Inv - SnB properties4ItemCodeItem CodenVarChar200
211CPI19A/P Correction Invoice - Bin Allocation Data9ItemCodeItem CodenVarChar200
212CPI8A/P Correction Invoice - Items in Package3ItemCodeItem CodenVarChar200
213CPV1A/P Correction Invoice Reversal - Rows10ItemCodeItem No.nVarChar200
214CPV14A/P Correction Invoice Reversal - Assembly - Rows4ItemCodeItem no.nVarChar200
215CPV16A/P Correction Invoice Reversal - SnB properties4ItemCodeItem CodenVarChar200
216CPV19A/P Correction Invoice Reversal - Bin Allocation Data9ItemCodeItem CodenVarChar200
217CPV8A/P Correction Invoice Reversal - Items in Package3ItemCodeItem NumbernVarChar200
218CSI1A/R Correction Invoice - Rows10ItemCodeItem No.nVarChar200
219CSI14A/R Correction Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
220CSI16A/R Corr. Inv. - SnB properties4ItemCodeItem CodenVarChar200
221CSI19A/R Correction Invoice - Bin Allocation Data9ItemCodeItem CodenVarChar200
222CSI8A/R Corr. Inv. - Items in Pkg3ItemCodeItem CodenVarChar200
223CSV1A/R Correction Invoice Reversal - Rows10ItemCodeItem No.nVarChar200
224CSV14A/R Correction Invoice Reversal - Assembly - Rows4ItemCodeItem no.nVarChar200
225CSV16A/R Correction Invoice Reversal - SnB properties4ItemCodeItem CodenVarChar200
226CSV19A/R Correction Invoice Reversal - Bin Allocation Data9ItemCodeItem CodenVarChar200
227CSV8A/R Correction Invoice Reversal - Items in Package3ItemCodeItem NumbernVarChar200
228DLN1Delivery - Rows10ItemCodeItem No.nVarChar200
229DLN14Delivery Notes - Assembly - Rows4ItemCodeItem no.nVarChar200
230DLN16Delivery - SnB properties4ItemCodeItem CodenVarChar200
231DLN19Delivery - Bin Allocation Data9ItemCodeItem CodenVarChar200
232DLN8Items in Package - Delivery3ItemCodeItem NumbernVarChar200
233DOC1Mktg Docs - Row10ItemCodeItem No.nVarChar200
234DOC14Mktg Docs - Assembly Row4ItemCodeItem no.nVarChar200
235DOC16Mktg Docs - SnB property4ItemCodeItem CodenVarChar200
236DOC19Mktg Docs - Bin Allocation Data9ItemCodeItem CodenVarChar200
237DOC8Mktg Docs - Items in Package3ItemCodeItem CodenVarChar200
238DPI1A/R Down Payment - Rows10ItemCodeItem No.nVarChar200
239DPI14A/R Down Payment - Assembly - Rows4ItemCodeItem no.nVarChar200
240DPI16A/R Down Payment - SnB properties4ItemCodeItem CodenVarChar200
241DPI19A/R Down Payment - Bin Allocation Data9ItemCodeItem CodenVarChar200
242DPI8Items in Package - A/R Down Pmt.3ItemCodeItem CodenVarChar200
243DPO1A/P Down Payment - Rows10ItemCodeItem No.nVarChar200
244DPO14A/P Down Payment - Assembly - Rows4ItemCodeItem no.nVarChar200
245DPO16A/P Down Payment - SnB properties4ItemCodeItem CodenVarChar200
246DPO19A/P Down Payment - Bin Allocation Data9ItemCodeItem CodenVarChar200
247DPO8Items in Package - A/P Down Pmt.3ItemCodeItem CodenVarChar200
248DRF1Draft - Rows10ItemCodeItem No.nVarChar200
249DRF14Draft - Assembly - Rows4ItemCodeItem no.nVarChar200
250DRF16Draft - SnB - Rows4ItemCodeItem CodenVarChar200
251DRF19Draft - Bin Allocation Data9ItemCodeItem CodenVarChar200
252DRF8Items in Package - Draft3ItemCodeItem CodenVarChar200
253GPA1Gross Profit Adjustment - Log3ItemCodeItem No.nVarChar200
254GTM1GTS Mapping Object Details3ItemCodeItem CodenVarChar200
255IEI1Incoming Excise Invoice - Rows10ItemCodeItem No.nVarChar200
256IEI14Incoming Excise Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
257IEI16Incoming Excise Invoice - SnB properties4ItemCodeItem CodenVarChar200
258IEI19Incoming Excise Invoice - Bin Allocation Data9ItemCodeItem CodenVarChar200
259IEI8Incoming Excise Invoice - Items in Package3ItemCodeItem CodenVarChar200
260INV1A/R Invoice - Rows10ItemCodeItem No.nVarChar200
261INV14A/R Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
262INV16A/R Invoice - SnB properties4ItemCodeItem CodenVarChar200
263INV19A/R Invoice - Bin Allocation Data9ItemCodeItem CodenVarChar200
264INV8A/R Invoice - Items in Package3ItemCodeItem CodenVarChar200
265MIN2Item Imformation of MI6ItemCodeItem No.nVarChar200
266MIV2A/P Monthly Invoice - Item6ItemCodeItem No.nVarChar200
267OEI1Outgoing Excise Invoice - Rows10ItemCodeItem No.nVarChar200
268OEI14Outgoing Excise Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
269OEI16Outgoing Excise Invoice - SnB properties4ItemCodeItem CodenVarChar200
270OEI19Outgoing Excise Invoice - Bin Allocation Data9ItemCodeItem CodenVarChar200
271OEI8Outgoing Excise Invoice - Items in Package3ItemCodeItem CodenVarChar200
272PCH1A/P Invoice - Rows10ItemCodeItem No.nVarChar200
273PCH14A/P Invoice - Assembly - Rows4ItemCodeItem no.nVarChar200
274PCH16A/P Invoice - SnB properties4ItemCodeItem CodenVarChar200
275PCH19A/P Invoice - Bin Allocation Data9ItemCodeItem CodenVarChar200
276PCH8A/P Invoice - Items in Package3ItemCodeItem CodenVarChar200
277PDN1Goods Receipt PO - Rows10ItemCodeItem No.nVarChar200
278PDN14Goods Receipt PO - Assembly - Rows4ItemCodeItem no.nVarChar200
279PDN16Goods Receipt PO - SnB properties4ItemCodeItem CodenVarChar200
280PDN19Goods Receipt PO - Bin Allocation Data9ItemCodeItem CodenVarChar200
281PDN8Goods Receipt PO - Items in Package3ItemCodeItem CodenVarChar200
282POR1Purchase Order - Rows10ItemCodeItem No.nVarChar200
283POR14Purchase Order - Assembly - Rows4ItemCodeItem no.nVarChar200
284POR16Purchase Order - SnB properties4ItemCodeItem CodenVarChar200
285POR19Purchase Order - Bin Allocation Data9ItemCodeItem CodenVarChar200
286POR8Items in Package - Purchase Order3ItemCodeItem CodenVarChar200
287PQT1Purchase Quotation - Rows10ItemCodeItem No.nVarChar200
288PQT14Purchase Quotation - Assembly - Rows4ItemCodeItem no.nVarChar200
289PQT16Purchase Quotation - SnB properties4ItemCodeItem CodenVarChar200
290PQT19Purchase Quotation - Bin Allocation Data9ItemCodeItem CodenVarChar200
291PQT8Items in Package - Purchase Quotation3ItemCodeItem CodenVarChar200
292PRQ1Purchase Request - Rows10ItemCodeItem No.nVarChar200
293PRQ14Purchase Request - Assembly - Rows4ItemCodeItem No.nVarChar200
294PRQ16Purchase Request - SnB Properties4ItemCodeItem CodenVarChar200
295PRQ19Purchase Request - Bin Allocation Data9ItemCodeItem CodenVarChar200
296PRQ8Items in Package - Purchase Request3ItemCodeItem CodenVarChar200
297QUT1Sales Quotation - Rows10ItemCodeItem No.nVarChar200
298QUT14Sales Quotation - Assembly - Rows4ItemCodeItem no.nVarChar200
299QUT16Sales Quotation - SnB properties4ItemCodeItem CodenVarChar200
300QUT19Sales Quotation - Bin Allocation Data9ItemCodeItem CodenVarChar200
301QUT8Sales Quotation - Items in Package3ItemCodeItem CodenVarChar200
302RDN1Returns - Rows10ItemCodeItem No.nVarChar200
303RDN14Return - Assembly - Rows4ItemCodeItem no.nVarChar200
304RDN16Returns - SnB properties4ItemCodeItem CodenVarChar200
305RDN19Returns - Bin Allocation Data9ItemCodeItem CodenVarChar200
306RDN8Returns - Items in Package3ItemCodeItem CodenVarChar200
307RDR1Sales Order - Rows10ItemCodeItem No.nVarChar200
308RDR14Sales Order - Assembly - Rows4ItemCodeItem no.nVarChar200
309RDR16Sales Order - SnB properties4ItemCodeItem CodenVarChar200
310RDR19Sales Order - Bin Allocation Data9ItemCodeItem CodenVarChar200
311RDR8Sales Order - Items in Package3ItemCodeItem CodenVarChar200
312RIN1A/R Credit Memo - Rows10ItemCodeItem No.nVarChar200
313RIN14A/R Credit Memo - Assembly - Rows4ItemCodeItem no.nVarChar200
314RIN16A/R Credit Memo - SnB properties4ItemCodeItem CodenVarChar200
315RIN19A/R Credit Memo - Bin Allocation Data9ItemCodeItem CodenVarChar200
316RIN8Items in Package - A/R Credit Memo3ItemCodeItem CodenVarChar200
317RPC1A/P Credit Memo - Rows10ItemCodeItem No.nVarChar200
318RPC14A/P Credit Memo - Assembly - Rows4ItemCodeItem no.nVarChar200
319RPC16A/P Credit Memo - SnB properties4ItemCodeItem CodenVarChar200
320RPC19A/P Credit Memo - Bin Allocation Data9ItemCodeItem CodenVarChar200
321RPC8Items in Package - A/P Credit Memo3ItemCodeItem CodenVarChar200
322RPD1Goods Return - Rows10ItemCodeItem No.nVarChar200
323RPD14Goods Return - Assembly - Rows4ItemCodeItem no.nVarChar200
324RPD16Goods Return - SnB properties4ItemCodeItem CodenVarChar200
325RPD19Goods Return - Bin Allocation Data9ItemCodeItem CodenVarChar200
326RPD8Goods Return - Items in Package3ItemCodeItem CodenVarChar200
327SAL1Salida - Rows13ItemCodeItem No.nVarChar200
328TGPAGross Profit Adjustment - Log2ItemCodeItem No.nVarChar200
329TRA1Transition - Rows13ItemCodeItem No.nVarChar200
TOPMRP
330FCT1Sales Forecast - Rows3ItemCodeItem No.nVarChar200
331MSN2MRP Run Results2ItemCodeItem No.nVarChar200
332MSN3MRP Pegging Information2ItemCodeItem No.nVarChar200
333MSN4MRP Scenarios - Items Array2ItemCodeItem CodenVarChar200
334ORCMRecommendation Data4ItemCodeItem No.nVarChar200
TOPService
335AINSCustomer Equipment Card - History14itemCodeForeign Key To ItemnVarChar200
336ASC2Service Call Inventory Expenses - History3ItemCodeItem No. - HistorynVarChar200
337ASC3Service Call Travel/Labor Expenses - History3ItemCodeItem NumbernVarChar200
338ASCLHistory15itemCodeItem NumbernVarChar200
339CTR1Service Contract - Items5ItemCodeItem No.nVarChar200
340OINSCustomer Equipment Card14itemCodeItem No.nVarChar200
341OSCLService Calls15itemCodeItem No.nVarChar200
342OSLTService Call Solutions2ItemCodeItem No.nVarChar200
343SCL2Service Call Inventory Expenses3ItemCodeItem No.nVarChar200
344SCL3Service Call Travel/Labor Expenses3ItemCodeItem No.nVarChar200