JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | 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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

176 COLUMNS | 13 INDEXES | Print definition?920 | 41 | F4102 TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F4102IB17613Item 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

TOP920 | 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 Catalog SectionStringUDC (41 S1)30 Allow NULL? 
6IBSRP2Sub 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? 
10IBSRP6Category Code 6StringUDC (41 06)60 Allow NULL? 
11IBSRP7Category Code 7StringUDC (41 07)60 Allow NULL? 
12IBSRP8Category Code 8StringUDC (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 Edit150 Allow NULL? 
34IBROQIReorder Quantity - InputNumericGeneric Edit150 Allow NULL? 
35IBRQMXReorder Quantity - MaximumNumericGeneric Edit150 Allow NULL? 
36IBRQMNReorder Quantity - MinimumNumericGeneric Edit150 Allow NULL? 
37IBWOMOQuantity - Order Multiples (SO/PO)NumericGeneric Edit70 Allow NULL? 
38IBSERVService LevelNumericGeneric Edit70 Allow NULL? 
39IBSAFESafety StockNumericGeneric Edit150 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 Edit150 Allow NULL? 
91IBMLQQuantity - MFG LeadtimeNumericGeneric Edit150 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 Edit150 Allow NULL? 
111IBORDWOrder WithCharacterGeneric Edit10 Allow NULL? 
112IBEXPDExpedite Damper DaysNumericGeneric Edit50 Allow NULL? 
113IBDEFDDefer Damper DaysNumericGeneric Edit50 Allow NULL? 
114IBMULTQuantity - Order Multiples (MRP)NumericGeneric Edit150 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? 

TOP920 | 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
13Item Group Category Codes
ElementAliasDescriptionSequence
1PRGRItem Price GroupAscending
2SRP1Sales Catalog SectionAscending
3SRP2Sub SectionAscending
4SRP3Sales Category Code 3Ascending
5SRP4Sales Category Code 4Ascending
6SRP5Sales Category Code 5Ascending
7PRP1Commodity ClassAscending
8PRP2Commodity Sub ClassAscending
9PRP3Supplier Rebate CodeAscending
10PRP4Master Planning FamilyAscending
11PRP5Purchasing Category Code 5Ascending
12SHCNShipping Conditions CodeAscending
13SHCMShipping Commodity ClassAscending
14CYCLCycle Count CategoryAscending
15PRP6Group - Item DimensionAscending
16PRP7Group - Warehouse Process 1Ascending
14Stocking Type
ElementAliasDescriptionSequence
1STKTStocking TypeAscending