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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

315 columns | Print definition?B1 9.2  | ITEMCODE

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