JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

176 COLUMNS | 11 INDEXES | Print definition?910 | 41 | F4102 TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4102IB17611Item Branch FileSecondary Master Files41: Inventory ManagementBusiness Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT IBITM, IBLITM, IBAITM, IBMCU, IBSRP1, IBSRP2, IBSRP3, IBSRP4, IBSRP5, IBSRP6, IBSRP7, IBSRP8, IBSRP9, IBSRP0, IBPRP1, IBPRP2, IBPRP3, IBPRP4, IBPRP5, IBPRP6, IBPRP7, IBPRP8, IBPRP9, IBPRP0, IBCDCD, IBPDGR, IBDSGP, IBVEND, IBANPL, IBBUYR, IBGLPT, IBORIG, IBROPI, IBROQI, IBRQMX, IBRQMN, IBWOMO, IBSERV, IBSAFE, IBSLD, IBCKAV, IBSRCE, IBLOTS, IBOT1Y, IBOT2Y, IBSTDP, IBFRMP, IBTHRP, IBSTDG, IBFRGD, IBTHGD, IBCOTY, IBMMPC, IBPRGR, IBRPRC, IBORPR, IBBACK, IBIFLA, IBABCS, IBABCM, IBABCI, IBOVR, IBSHCM, IBCARS, IBCARP, IBSHCN, IBSTKT, IBLNTY, IBFIFO, IBCYCL, IBINMG, IBWARR, IBSRNR, IBPCTM, IBCMCG, IBFUF1, IBTX, IBTAX1, IBMPST, IBMRPD, IBMRPC, IBUPC, IBSNS, IBMERL, IBLTLV, IBLTMF, IBLTCM, IBOPC, IBOPV, IBACQ, IBMLQ, IBLTPU, IBMPSP, IBMRPP, IBITC, IBECO, IBECTY, IBECOD, IBMTF1, IBMTF2, IBMTF3, IBMTF4, IBMTF5, IBMOVD, IBQUED, IBSETL, IBSRNK, IBSRKF, IBTIMB, IBBQTY, IBORDW, IBEXPD, IBDEFD, IBMULT, IBSFLT, IBMAKE, IBLFDJ, IBLLX, IBCMGL, IBURCD, IBURDT, IBURAT, IBURAB, IBURRF, IBUSER, IBPID, IBJOBN, IBUPMJ, IBTDAY, IBTFLA, IBCOMH, IBAVRT, IBPOC, IBAING, IBBBDD, IBCMDM, IBLECM, IBLEDD, IBMLOT, IBPEFD, IBSBDD, IBU1DD, IBU2DD, IBU3DD, IBU4DD, IBU5DD, IBXDCK, IBLAF, IBLTFM, IBRWLA, IBLNPA, IBLOTC, IBAPSC, IBPRI1, IBPRI2, IBLTCV, IBASHL, IBOPTH, IBCUTH, IBUMTH, IBLMFG, IBLINE, IBDFTPCT, IBKBIT, IBDFENDITM, IBKANEXLL, IBSCPSELL, IBMOPTH, IBMCUTH, IBCUMTH, IBATPRN, IBATPCA, IBATPAC, IBCOORE, IBVCPFC, IBPNYN FROM F4102

TOP910 | 41 | F4102 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1IBITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
2IBLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
3IBAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
4IBMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5IBSRP1Sales Rpt 01 - Product FamilyStringUDC (41 S1)30 Allow NULL? 
6IBSRP2Sales Rpt 02 - Family SectionStringUDC (41 S2)30 Allow NULL? 
7IBSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
8IBSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
9IBSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
10IBSRP6Sales Rpt 06 - Product Line (Revenue)StringUDC (41 06)60 Allow NULL? 
11IBSRP7Category Code 7StringUDC (41 07)60 Allow NULL? 
12IBSRP8Sales Rpt 08 - Product Discount GroupStringUDC (41 08)60 Allow NULL? 
13IBSRP9Category Code 9StringUDC (41 09)60 Allow NULL? 
14IBSRP0Category Code 10StringUDC (41 10)60 Allow NULL? 
15IBPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
16IBPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
17IBPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
18IBPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
19IBPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
20IBPRP6Group - Item DimensionStringUDC (41 01)60 Allow NULL? 
21IBPRP7Group - Warehouse Process 1StringUDC (41 02)60 Allow NULL? 
22IBPRP8Group - Warehouse Process 2StringUDC (41 02)60 Allow NULL? 
23IBPRP9Group - Warehouse Process 3StringUDC (41 02)60 Allow NULL? 
24IBPRP0Item PoolStringUDC (41 05)60 Allow NULL? 
25IBCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
26IBPDGRProduct GroupStringUDC (41B PG)30 Allow NULL? 
27IBDSGPDispatch GroupStringUDC (41B DG)30 Allow NULL? 
28IBVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
29IBANPLPlanner NumberNumericGeneric Edit80 Allow NULL? 
30IBBUYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
31IBGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
32IBORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 
33IBROPIReorder Point - InputNumericGeneric Edit152 Allow NULL? 
34IBROQIReorder Quantity - InputNumericGeneric Edit152 Allow NULL? 
35IBRQMXReorder Quantity - MaximumNumericGeneric Edit152 Allow NULL? 
36IBRQMNReorder Quantity - MinimumNumericGeneric Edit152 Allow NULL? 
37IBWOMOQuantity - Order Multiples (SO/PO)NumericGeneric Edit70 Allow NULL? 
38IBSERVService LevelNumericGeneric Edit70 Allow NULL? 
39IBSAFESafety StockNumericGeneric Edit152 Allow NULL? 
40IBSLDDays - Shelf Life DaysNumericGeneric Edit60 Allow NULL? 
41IBCKAVCheck Availability Y/NCharacterGeneric Edit10 Allow NULL? 
42IBSRCELayer Code - SourceCharacterUDC (H41 SR)10 Allow NULL? 
43IBLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
44IBOT1YPotency ControlCharacterGeneric Edit10 Allow NULL? 
45IBOT2YGrade ControlCharacterGeneric Edit10 Allow NULL? 
46IBSTDPStandard PotencyNumericGeneric Edit73 Allow NULL? 
47IBFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
48IBTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
49IBSTDGStandard GradeStringUDC (40 LG)30 Allow NULL? 
50IBFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
51IBTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
52IBCOTYComponent TypeCharacterUDC (H40 CP)10 Allow NULL? 
53IBMMPCMargin Maintenance (%)NumericGeneric Edit73 Allow NULL? 
54IBPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
55IBRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
56IBORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
57IBBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
58IBIFLAItem Flash MessageStringUDC (40 FL)20 Allow NULL? 
59IBABCSABC Code 1 - Sales - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
60IBABCMABC Code 1 - Margin - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
61IBABCIABC Code 3 - Investment - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
62IBOVRABC Code Override IndicatorCharacterGeneric Edit10 Allow NULL? 
63IBSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
64IBCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
65IBCARPPreferred Carrier - PurchasingNumericGeneric Edit80 Allow NULL? 
66IBSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
67IBSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
68IBLNTYLine TypeStringGeneric Edit20 Allow NULL? 
69IBFIFOFIFO ProcessingCharacterGeneric Edit10 Allow NULL? 
70IBCYCLCycle Count CategoryStringUDC (41 8)30 Allow NULL? 
71IBINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
72IBWARRType WarrantyStringGeneric Edit80 Allow NULL? 
73IBSRNRSerial Number RequiredCharacterUDC (H41 NR)10 Allow NULL? 
74IBPCTMPercent MarginNumericGeneric Edit73 Allow NULL? 
75IBCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
76IBFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
77IBTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
78IBTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
79IBMPSTPlanning CodeCharacterUDC (H41 MP)10 Allow NULL? 
80IBMRPDItem Display CodeCharacterUDC (H41 MR)10 Allow NULL? 
81IBMRPCFlag - Net ChangeCharacterUDC (H41 MQ)10 Allow NULL? 
82IBUPCUnits - Per ContainerNumericGeneric Edit150 Allow NULL? 
83IBSNSRound to Whole NumberCharacterUDC (H41 SN)10 Allow NULL? 
84IBMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
85IBLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
86IBLTMFLeadtime MFGNumericGeneric Edit50 Allow NULL? 
87IBLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
88IBOPCOrder Policy CodeCharacterUDC (H41 OP)10 Allow NULL? 
89IBOPVValue - Order PolicyNumericGeneric Edit150 Allow NULL? 
90IBACQQuantity - Accounting CostNumericGeneric Edit152 Allow NULL? 
91IBMLQQuantity - MFG LeadtimeNumericGeneric Edit152 Allow NULL? 
92IBLTPULeadtime Per UnitNumericGeneric Edit52 Allow NULL? 
93IBMPSPPlanning Time Fence RuleCharacterUDC (34 TF)10 Allow NULL? 
94IBMRPPFixed or Variable LeadtimeCharacterUDC (H41 MS)10 Allow NULL? 
95IBITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
96IBECOECO NumberStringGeneric Edit120 Allow NULL? 
97IBECTYEngineering Change ReasonStringUDC (40 CR)20 Allow NULL? 
98IBECODDate - Engineering Change DateDateGeneric Edit60
99IBMTF1Planning Time Fence DaysNumericGeneric Edit50 Allow NULL? 
100IBMTF2Freeze Time Fence DaysNumericGeneric Edit50 Allow NULL? 
101IBMTF3Message Time Fence DaysNumericGeneric Edit50 Allow NULL? 
102IBMTF4MPS/MRP Time Fence 4NumericGeneric Edit50 Allow NULL? 
103IBMTF5Shipment Leadtime OffsetNumericGeneric Edit50 Allow NULL? 
104IBMOVDMove Hours - StandardNumericGeneric Edit52 Allow NULL? 
105IBQUEDQueue Hours - StandardNumericGeneric Edit52 Allow NULL? 
106IBSETLSetup Labor - StandardNumericGeneric Edit152 Allow NULL? 
107IBSRNKShrink FactorNumericGeneric Edit152 Allow NULL? 
108IBSRKFShrink Factor MethodCharacterUDC (H40 SR)10 Allow NULL? 
109IBTIMBTime Basis CodeCharacterUDC (30 TB)10 Allow NULL? 
110IBBQTYUnits - Batch QuantityNumericGeneric Edit152 Allow NULL? 
111IBORDWOrder WithCharacterGeneric Edit10 Allow NULL? 
112IBEXPDExpedite Damper DaysNumericGeneric Edit50 Allow NULL? 
113IBDEFDDefer Damper DaysNumericGeneric Edit50 Allow NULL? 
114IBMULTQuantity - Order Multiples (MRP)NumericGeneric Edit152 Allow NULL? 
115IBSFLTSafety LeadtimeNumericGeneric Edit50 Allow NULL? 
116IBMAKEMake/Buy CodeCharacterUDC (H40 MA)10 Allow NULL? 
117IBLFDJDate - Future UseDateGeneric Edit60
118IBLLXLow Level CodeNumericGeneric Edit30 Allow NULL? 
119IBCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
120IBURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
121IBURDTUser Reserved DateDateGeneric Edit60
122IBURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
123IBURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
124IBURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
125IBUSERUser IDStringGeneric Edit100 Allow NULL? 
126IBPIDProgram IDStringGeneric Edit100 Allow NULL? 
127IBJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
128IBUPMJDate - UpdatedDateGeneric Edit60
129IBTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
130IBTFLAStandard Unit of Measure ConversionStringUDC (H40 ST)20 Allow NULL? 
131IBCOMHCommitment - Specific (Days)NumericGeneric Edit30 Allow NULL? 
132IBAVRTReplenishment Hours - StandardNumericGeneric Edit152 Allow NULL? 
133IBPOCIssue and ReceiptCharacterUDC (43 IR)10 Allow NULL? 
134IBAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
135IBBBDDBest Before Default DaysNumericGeneric Edit60 Allow NULL? 
136IBCMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
137IBLECMLot Expiraton Date Calculation MethodCharacterUDC (H41 EC)10 Allow NULL? 
138IBLEDDLot Effective Default DaysNumericGeneric Edit60 Allow NULL? 
139IBMLOTMix Dates / Lots (Y/N)CharacterGeneric Edit10 Allow NULL? 
140IBPEFDPurchasing Effective DaysNumericGeneric Edit60 Allow NULL? 
141IBSBDDSell By Default DaysNumericGeneric Edit60 Allow NULL? 
142IBU1DDUser Lot Date 1 Default DaysNumericGeneric Edit60 Allow NULL? 
143IBU2DDUser Lot Date 2 Default DaysNumericGeneric Edit60 Allow NULL? 
144IBU3DDUser Lot Date 3 Default DaysNumericGeneric Edit60 Allow NULL? 
145IBU4DDUser Lot Date 4 Default DaysNumericGeneric Edit60 Allow NULL? 
146IBU5DDUser Lot Date 5 Default DaysNumericGeneric Edit60 Allow NULL? 
147IBXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
148IBLAFLot Audit FlagCharacterGeneric Edit10 Allow NULL? 
149IBLTFMSpecial Lot FormatCharacterGeneric Edit10 Allow NULL? 
150IBRWLARestrict Work Order Lot AssignmentCharacterGeneric Edit10 Allow NULL? 
151IBLNPALot Number Pre-AssignmentCharacterGeneric Edit10 Allow NULL? 
152IBLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
153IBAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
154IBPRI1Priority One Alert LevelNumericGeneric Edit154 Allow NULL? 
155IBPRI2Priority Two Alert LevelNumericGeneric Edit154 Allow NULL? 
156IBLTCVLeadtime Conversion FactorNumericGeneric Edit157 Allow NULL? 
157IBASHLAllow Shipping of Held LotsCharacterGeneric Edit10 Allow NULL? 
158IBOPTHMinimum Operational ThresholdNumericGeneric Edit154 Allow NULL? 
159IBCUTHMinimum Cumulative ThresholdNumericGeneric Edit154 Allow NULL? 
160IBUMTHOperational Threshold Unit of MeasureStringUDC (31B UM)30 Allow NULL? 
161IBLMFGLean Manufacturing FlagCharacterGeneric Edit10 Allow NULL? 
162IBLINELine/Cell IdentifierStringGeneric Edit120 Allow NULL? 
163IBDFTPCTTotal Product Cycle TimeNumericGeneric Edit205 Allow NULL? 
164IBKBITKanban ItemCharacterGeneric Edit10 Allow NULL? 
165IBDFENDITMDemand Flow End Item FlagCharacterGeneric Edit10 Allow NULL? 
166IBKANEXLLKanban Explode to Lower LevelCharacterGeneric Edit10 Allow NULL? 
167IBSCPSELLSellable ItemCharacterUDC (34A SA)10 Allow NULL? 
168IBMOPTHMaximum Operational ThresholdNumericGeneric Edit154 Allow NULL? 
169IBMCUTHMaximum Cumulative ThresholdNumericGeneric Edit154 Allow NULL? 
170IBCUMTHCumulative Threshold Unit of MeasureStringUDC (31B UM)30 Allow NULL? 
171IBATPRNATP Rule NameStringGeneric Edit800 Allow NULL? 
172IBATPCACheck ATPCharacterUDC (34A CA)10 Allow NULL? 
173IBATPACATP ComponentsStringUDC (34A AP)50 Allow NULL? 
174IBCOORECountry of Origin Required FlagCharacterGeneric Edit10 Allow NULL? 
175IBVCPFCATO Forecast ControlStringUDC (34A CF)200 Allow NULL? 
176IBPNYNProduction Number ControlledCharacterGeneric Edit10 Allow NULL? 

TOP910 | 41 | F4102 INDEXES

NumberDescription
1Branch Item (Primary/Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
2Item Branch
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3Vend Item
ElementAliasDescriptionSequence
1VENDPrimary / Last Supplier NumberAscending
2ITMItem Number - ShortAscending
4Purch Category Code 5 Item
ElementAliasDescriptionSequence
1PRP5Purchasing Category Code 5Ascending
2ITMItem Number - ShortAscending
5Planning Family Branch +
ElementAliasDescriptionSequence
1PRP4Master Planning FamilyAscending
2MCUBusiness UnitAscending
3MPSTPlanning CodeAscending
6Planner Branch +
ElementAliasDescriptionSequence
1ANPLPlanner NumberAscending
2MCUBusiness UnitAscending
3PRP4Master Planning FamilyAscending
4MPSTPlanning CodeAscending
7Buyer Branch +
ElementAliasDescriptionSequence
1BUYRBuyer NumberAscending
2MCUBusiness UnitAscending
3PRP4Master Planning FamilyAscending
4MPSTPlanning CodeAscending
8Pool Item +
ElementAliasDescriptionSequence
1PRP0Item PoolAscending
2ITMItem Number - ShortAscending
3MCUBusiness UnitAscending
10Branch Purch Cat Code 7 +
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2PRP7Group - Warehouse Process 1Ascending
3PRP8Group - Warehouse Process 2Ascending
4PRP9Group - Warehouse Process 3Ascending
11Low Level Item +
ElementAliasDescriptionSequence
1LLXLow Level CodeAscending
2ITMItem Number - ShortAscending
3MCUBusiness UnitAscending
12ATP Rule Name
ElementAliasDescriptionSequence
1ATPRNATP Rule NameAscending