SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

344 columns | Print definition?B1 9.3  | ITEMCODE

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