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
F30L: DFM Line Design
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920FF30L501IB11210DFM Item Definition MasterMaster FilesF30L: DFM Line DesignBusiness 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 IBFSCID, IBDFITM, IBDFLITM, IBDFAITM, IBDFMCU, IBDSC1, IBDSC2, IBSRP1, IBSRP2, IBSRP3, IBSRP4, IBSRP5, IBSRP6, IBSRP7, IBSRP8, IBSRP9, IBSRP0, IBPRP1, IBPRP2, IBPRP3, IBPRP4, IBPRP5, IBPRP6, IBPRP7, IBPRP8, IBPRP9, IBPRP0, IBCDCD, IBPDGR, IBDSGP, IBDFVEND, IBDFANPL, IBDFBUYR, IBROPI, IBROQI, IBRQMX, IBRQMN, IBWOMO, IBSAFE, IBABCS, IBABCM, IBABCI, IBOVR, IBSHCM, IBSHCN, IBSTKT, IBLNTY, IBCYCL, IBINMG, IBMPST, IBSNS, IBMERL, IBDFLTLV, IBLTMF, IBLTCM, IBOPC, IBOPV, IBMLQ, IBLTPU, IBMPSP, IBMRPP, IBITC, IBMTF1, IBMTF2, IBMTF3, IBMTF4, IBMTF5, IBMOVD, IBQUED, IBSETL, IBSRNK, IBSRKF, IBTIMB, IBBQTY, IBEXPD, IBDEFD, IBMULT, IBSFLT, IBMAKE, IBLLX, IBTFLA, IBAVRT, IBDFTPCT, IBDFLINE, IBLBLKAN, IBPKUOM, IBPKQTY, IBKANCONT, IBKANTYPE, IBDFENDITM, IBDFKMCF, IBKANEXLL, IBUOM1, IBUOM2, IBUOM3, IBUOM4, IBUOM6, IBUOM8, IBUOM9, IBUWUM, IBUVM1, IBURCD, IBURDT, IBURAT, IBURAB, IBURRF, IBUSER, IBPID, IBMKEY, IBUUPMJ, IBDFLNID, IBDFMMCU FROM FF30L501

TOP920 | F30L | FF30L501 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1IBFSCIDScenario IDNumericGeneric Edit150 Allow NULL? 
2IBDFITMItem Number DFM - ShortNumericGeneric Edit80 Allow NULL? 
3IBDFLITM2nd Item Number DFMStringGeneric Edit250 Allow NULL? 
4IBDFAITM3rd Item Number DFMStringGeneric Edit250 Allow NULL? 
5IBDFMCUBranch/PlantStringGeneric Edit120 Allow NULL? 
6IBDSC1DescriptionStringGeneric Edit300 Allow NULL? 
7IBDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
8IBSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
9IBSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
10IBSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
11IBSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
12IBSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
13IBSRP6Category Code 6StringUDC (41 06)60 Allow NULL? 
14IBSRP7Category Code 7StringUDC (41 07)60 Allow NULL? 
15IBSRP8Category Code 8StringUDC (41 08)60 Allow NULL? 
16IBSRP9Category Code 9StringUDC (41 09)60 Allow NULL? 
17IBSRP0Category Code 10StringUDC (41 10)60 Allow NULL? 
18IBPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
19IBPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
20IBPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
21IBPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
22IBPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
23IBPRP6Group - Item DimensionStringUDC (41 01)60 Allow NULL? 
24IBPRP7Group - Warehouse Process 1StringUDC (41 02)60 Allow NULL? 
25IBPRP8Group - Warehouse Process 2StringUDC (41 02)60 Allow NULL? 
26IBPRP9Group - Warehouse Process 3StringUDC (41 02)60 Allow NULL? 
27IBPRP0Item PoolStringUDC (41 05)60 Allow NULL? 
28IBCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
29IBPDGRProduct GroupStringUDC (41B PG)30 Allow NULL? 
30IBDSGPDispatch GroupStringUDC (41B DG)30 Allow NULL? 
31IBDFVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
32IBDFANPLPlanner NumberNumericGeneric Edit80 Allow NULL? 
33IBDFBUYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
34IBROPIReorder Point - InputNumericGeneric Edit150 Allow NULL? 
35IBROQIReorder Quantity - InputNumericGeneric Edit150 Allow NULL? 
36IBRQMXReorder Quantity - MaximumNumericGeneric Edit150 Allow NULL? 
37IBRQMNReorder Quantity - MinimumNumericGeneric Edit150 Allow NULL? 
38IBWOMOQuantity - Order Multiples (SO/PO)NumericGeneric Edit70 Allow NULL? 
39IBSAFESafety StockNumericGeneric Edit150 Allow NULL? 
40IBABCSABC Code 1 - Sales - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
41IBABCMABC Code 1 - Margin - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
42IBABCIABC Code 3 - Investment - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
43IBOVRABC Code Override IndicatorCharacterGeneric Edit10 Allow NULL? 
44IBSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
45IBSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
46IBSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
47IBLNTYLine TypeStringGeneric Edit20 Allow NULL? 
48IBCYCLCycle Count CategoryStringUDC (41 8)30 Allow NULL? 
49IBINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
50IBMPSTPlanning CodeCharacterUDC (H41 MP)10 Allow NULL? 
51IBSNSRound to Whole NumberCharacterUDC (H41 SN)10 Allow NULL? 
52IBMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
53IBDFLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
54IBLTMFLeadtime MFGNumericGeneric Edit50 Allow NULL? 
55IBLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
56IBOPCOrder Policy CodeCharacterUDC (H41 OP)10 Allow NULL? 
57IBOPVValue - Order PolicyNumericGeneric Edit150 Allow NULL? 
58IBMLQQuantity - MFG LeadtimeNumericGeneric Edit150 Allow NULL? 
59IBLTPULeadtime Per UnitNumericGeneric Edit52 Allow NULL? 
60IBMPSPPlanning Time Fence RuleCharacterUDC (34 TF)10 Allow NULL? 
61IBMRPPFixed or Variable LeadtimeCharacterUDC (H41 MS)10 Allow NULL? 
62IBITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
63IBMTF1Planning Time Fence DaysNumericGeneric Edit50 Allow NULL? 
64IBMTF2Freeze Time Fence DaysNumericGeneric Edit50 Allow NULL? 
65IBMTF3Message Time Fence DaysNumericGeneric Edit50 Allow NULL? 
66IBMTF4MPS/MRP Time Fence 4NumericGeneric Edit50 Allow NULL? 
67IBMTF5Shipment Leadtime OffsetNumericGeneric Edit50 Allow NULL? 
68IBMOVDMove Hours - StandardNumericGeneric Edit52 Allow NULL? 
69IBQUEDQueue Hours - StandardNumericGeneric Edit52 Allow NULL? 
70IBSETLSetup Labor - StandardNumericGeneric Edit152 Allow NULL? 
71IBSRNKShrink FactorNumericGeneric Edit152 Allow NULL? 
72IBSRKFShrink Factor MethodCharacterUDC (H40 SR)10 Allow NULL? 
73IBTIMBTime Basis CodeCharacterUDC (30 TB)10 Allow NULL? 
74IBBQTYUnits - Batch QuantityNumericGeneric Edit150 Allow NULL? 
75IBEXPDExpedite Damper DaysNumericGeneric Edit50 Allow NULL? 
76IBDEFDDefer Damper DaysNumericGeneric Edit50 Allow NULL? 
77IBMULTQuantity - Order Multiples (MRP)NumericGeneric Edit150 Allow NULL? 
78IBSFLTSafety LeadtimeNumericGeneric Edit50 Allow NULL? 
79IBMAKEMake/Buy CodeCharacterUDC (H40 MA)10 Allow NULL? 
80IBLLXLow Level CodeNumericGeneric Edit30 Allow NULL? 
81IBTFLAStandard Unit of Measure ConversionStringUDC (H40 ST)20 Allow NULL? 
82IBAVRTReplenishment Hours - StandardNumericGeneric Edit152 Allow NULL? 
83IBDFTPCTTotal Product Cycle TimeNumericGeneric Edit205 Allow NULL? 
84IBDFLINELine/Cell IdentifierStringGeneric Edit120 Allow NULL? 
85IBLBLKANReplenishable Kanban Label TypeStringUDC (F31K LT)30 Allow NULL? 
86IBPKUOMPackage UOMStringUDC (00 UM)20 Allow NULL? 
87IBPKQTYPackage QuantityNumericGeneric Edit204 Allow NULL? 
88IBKANCONTKanban Controlled Item or NotStringGeneric Edit20 Allow NULL? 
89IBKANTYPEReplenishable or Non ReplenishableStringGeneric Edit30 Allow NULL? 
90IBDFENDITMDemand Flow End Item FlagCharacterGeneric Edit10 Allow NULL? 
91IBDFKMCFKanban Management Change FlagCharacterGeneric Edit10 Allow NULL? 
92IBKANEXLLKanban Explode to Lower LevelCharacterGeneric Edit10 Allow NULL? 
93IBUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
94IBUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
95IBUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
96IBUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
97IBUOM6Unit of Measure - ShippingStringUDC (00 UM)20 Allow NULL? 
98IBUOM8Unit of Measure - ProductionStringUDC (00 UM)20 Allow NULL? 
99IBUOM9Unit of Measure - ComponentStringUDC (00 UM)20 Allow NULL? 
100IBUWUMUnit of Measure - WeightStringUDC (00 UM)20 Allow NULL? 
101IBUVM1Unit of Measure - VolumeStringUDC (00 UM)20 Allow NULL? 
102IBURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
103IBURDTUser Reserved DateDateGeneric Edit60
104IBURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
105IBURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
106IBURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
107IBUSERUser IDStringGeneric Edit100 Allow NULL? 
108IBPIDProgram IDStringGeneric Edit100 Allow NULL? 
109IBMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
110IBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
111IBDFLNIDDFM Line IDNumericGeneric Edit150 Allow NULL? 
112IBDFMMCUBranchStringGeneric Edit120 Allow NULL? 

TOP920 | F30L | FF30L501 INDEXES

NumberDescription
1Scenario Branch Item (Primary/Unique)
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2DFMCUBranch/PlantAscending
3DFITMItem Number DFM - ShortAscending
2Item Branch
ElementAliasDescriptionSequence
1DFITMItem Number DFM - ShortAscending
2DFMCUBranch/PlantAscending
11Scenario Item
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2DFITMItem Number DFM - ShortAscending
12Scenario Branch 2ndItem
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2DFMCUBranch/PlantAscending
3DFLITM2nd Item Number DFMAscending
13Scenario Branch 3rdItem
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2DFMCUBranch/PlantAscending
3DFAITM3rd Item Number DFMAscending
14Scenario Buyer
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2DFBUYRBuyer NumberAscending
15Scenario Planner
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2DFANPLPlanner NumberAscending
16Scenario Vender
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2DFVENDPrimary / Last Supplier NumberAscending
17Scenario
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
18Scenario WC WCBranch
ElementAliasDescriptionSequence
1FSCIDScenario IDAscending
2DFLINELine/Cell IdentifierAscending
3DFMMCUBranchAscending