	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

112 COLUMNS | 10 INDEXES | 920 | F30L | FF30L501 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
F30L: DFM Line Design
1	920	FF30L501	IB	112	10	DFM Item Definition Master	Master Files	F30L: DFM Line Design	Business 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

TOP 920 | F30L | FF30L501 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IBFSCID	Scenario ID	Numeric	Generic Edit	15	0	Allow NULL?
2	IBDFITM	Item Number DFM - Short	Numeric	Generic Edit	8	0	Allow NULL?
3	IBDFLITM	2nd Item Number DFM	String	Generic Edit	25	0	Allow NULL?
4	IBDFAITM	3rd Item Number DFM	String	Generic Edit	25	0	Allow NULL?
5	IBDFMCU	Branch/Plant	String	Generic Edit	12	0	Allow NULL?
6	IBDSC1	Description	String	Generic Edit	30	0	Allow NULL?
7	IBDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
8	IBSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
9	IBSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
10	IBSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
11	IBSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
12	IBSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
13	IBSRP6	Category Code 6	String	UDC (41 06)	6	0	Allow NULL?
14	IBSRP7	Category Code 7	String	UDC (41 07)	6	0	Allow NULL?
15	IBSRP8	Category Code 8	String	UDC (41 08)	6	0	Allow NULL?
16	IBSRP9	Category Code 9	String	UDC (41 09)	6	0	Allow NULL?
17	IBSRP0	Category Code 10	String	UDC (41 10)	6	0	Allow NULL?
18	IBPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
19	IBPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
20	IBPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
21	IBPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
22	IBPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
23	IBPRP6	Group - Item Dimension	String	UDC (41 01)	6	0	Allow NULL?
24	IBPRP7	Group - Warehouse Process 1	String	UDC (41 02)	6	0	Allow NULL?
25	IBPRP8	Group - Warehouse Process 2	String	UDC (41 02)	6	0	Allow NULL?
26	IBPRP9	Group - Warehouse Process 3	String	UDC (41 02)	6	0	Allow NULL?
27	IBPRP0	Item Pool	String	UDC (41 05)	6	0	Allow NULL?
28	IBCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
29	IBPDGR	Product Group	String	UDC (41B PG)	3	0	Allow NULL?
30	IBDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
31	IBDFVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
32	IBDFANPL	Planner Number	Numeric	Generic Edit	8	0	Allow NULL?
33	IBDFBUYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
34	IBROPI	Reorder Point - Input	Numeric	Generic Edit	15	0	Allow NULL?
35	IBROQI	Reorder Quantity - Input	Numeric	Generic Edit	15	0	Allow NULL?
36	IBRQMX	Reorder Quantity - Maximum	Numeric	Generic Edit	15	0	Allow NULL?
37	IBRQMN	Reorder Quantity - Minimum	Numeric	Generic Edit	15	0	Allow NULL?
38	IBWOMO	Quantity - Order Multiples (SO/PO)	Numeric	Generic Edit	7	0	Allow NULL?
39	IBSAFE	Safety Stock	Numeric	Generic Edit	15	0	Allow NULL?
40	IBABCS	ABC Code 1 - Sales - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
41	IBABCM	ABC Code 1 - Margin - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
42	IBABCI	ABC Code 3 - Investment - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
43	IBOVR	ABC Code Override Indicator	Character	Generic Edit	1	0	Allow NULL?
44	IBSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
45	IBSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
46	IBSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
47	IBLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
48	IBCYCL	Cycle Count Category	String	UDC (41 8)	3	0	Allow NULL?
49	IBINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
50	IBMPST	Planning Code	Character	UDC (H41 MP)	1	0	Allow NULL?
51	IBSNS	Round to Whole Number	Character	UDC (H41 SN)	1	0	Allow NULL?
52	IBMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
53	IBDFLTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
54	IBLTMF	Leadtime MFG	Numeric	Generic Edit	5	0	Allow NULL?
55	IBLTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
56	IBOPC	Order Policy Code	Character	UDC (H41 OP)	1	0	Allow NULL?
57	IBOPV	Value - Order Policy	Numeric	Generic Edit	15	0	Allow NULL?
58	IBMLQ	Quantity - MFG Leadtime	Numeric	Generic Edit	15	0	Allow NULL?
59	IBLTPU	Leadtime Per Unit	Numeric	Generic Edit	5	2	Allow NULL?
60	IBMPSP	Planning Time Fence Rule	Character	UDC (34 TF)	1	0	Allow NULL?
61	IBMRPP	Fixed or Variable Leadtime	Character	UDC (H41 MS)	1	0	Allow NULL?
62	IBITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
63	IBMTF1	Planning Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
64	IBMTF2	Freeze Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
65	IBMTF3	Message Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
66	IBMTF4	MPS/MRP Time Fence 4	Numeric	Generic Edit	5	0	Allow NULL?
67	IBMTF5	Shipment Leadtime Offset	Numeric	Generic Edit	5	0	Allow NULL?
68	IBMOVD	Move Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
69	IBQUED	Queue Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
70	IBSETL	Setup Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
71	IBSRNK	Shrink Factor	Numeric	Generic Edit	15	2	Allow NULL?
72	IBSRKF	Shrink Factor Method	Character	UDC (H40 SR)	1	0	Allow NULL?
73	IBTIMB	Time Basis Code	Character	UDC (30 TB)	1	0	Allow NULL?
74	IBBQTY	Units - Batch Quantity	Numeric	Generic Edit	15	0	Allow NULL?
75	IBEXPD	Expedite Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
76	IBDEFD	Defer Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
77	IBMULT	Quantity - Order Multiples (MRP)	Numeric	Generic Edit	15	0	Allow NULL?
78	IBSFLT	Safety Leadtime	Numeric	Generic Edit	5	0	Allow NULL?
79	IBMAKE	Make/Buy Code	Character	UDC (H40 MA)	1	0	Allow NULL?
80	IBLLX	Low Level Code	Numeric	Generic Edit	3	0	Allow NULL?
81	IBTFLA	Standard Unit of Measure Conversion	String	UDC (H40 ST)	2	0	Allow NULL?
82	IBAVRT	Replenishment Hours - Standard	Numeric	Generic Edit	15	2	Allow NULL?
83	IBDFTPCT	Total Product Cycle Time	Numeric	Generic Edit	20	5	Allow NULL?
84	IBDFLINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
85	IBLBLKAN	Replenishable Kanban Label Type	String	UDC (F31K LT)	3	0	Allow NULL?
86	IBPKUOM	Package UOM	String	UDC (00 UM)	2	0	Allow NULL?
87	IBPKQTY	Package Quantity	Numeric	Generic Edit	20	4	Allow NULL?
88	IBKANCONT	Kanban Controlled Item or Not	String	Generic Edit	2	0	Allow NULL?
89	IBKANTYPE	Replenishable or Non Replenishable	String	Generic Edit	3	0	Allow NULL?
90	IBDFENDITM	Demand Flow End Item Flag	Character	Generic Edit	1	0	Allow NULL?
91	IBDFKMCF	Kanban Management Change Flag	Character	Generic Edit	1	0	Allow NULL?
92	IBKANEXLL	Kanban Explode to Lower Level	Character	Generic Edit	1	0	Allow NULL?
93	IBUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
94	IBUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
95	IBUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
96	IBUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
97	IBUOM6	Unit of Measure - Shipping	String	UDC (00 UM)	2	0	Allow NULL?
98	IBUOM8	Unit of Measure - Production	String	UDC (00 UM)	2	0	Allow NULL?
99	IBUOM9	Unit of Measure - Component	String	UDC (00 UM)	2	0	Allow NULL?
100	IBUWUM	Unit of Measure - Weight	String	UDC (00 UM)	2	0	Allow NULL?
101	IBUVM1	Unit of Measure - Volume	String	UDC (00 UM)	2	0	Allow NULL?
102	IBURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
103	IBURDT	User Reserved Date	Date	Generic Edit	6	0
104	IBURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
105	IBURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
106	IBURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
107	IBUSER	User ID	String	Generic Edit	10	0	Allow NULL?
108	IBPID	Program ID	String	Generic Edit	10	0	Allow NULL?
109	IBMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
110	IBUUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
111	IBDFLNID	DFM Line ID	Numeric	Generic Edit	15	0	Allow NULL?
112	IBDFMMCU	Branch	String	Generic Edit	12	0	Allow NULL?

TOP 920 | F30L | FF30L501 INDEXES

Number

Description

Scenario Branch Item (Primary/Unique)

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFMCU	Branch/Plant	Ascending
3	DFITM	Item Number DFM - Short	Ascending

Item Branch

Element	Alias	Description	Sequence
1	DFITM	Item Number DFM - Short	Ascending
2	DFMCU	Branch/Plant	Ascending

Scenario Item

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFITM	Item Number DFM - Short	Ascending

Scenario Branch 2ndItem

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFMCU	Branch/Plant	Ascending
3	DFLITM	2nd Item Number DFM	Ascending

Scenario Branch 3rdItem

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFMCU	Branch/Plant	Ascending
3	DFAITM	3rd Item Number DFM	Ascending

Scenario Buyer

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFBUYR	Buyer Number	Ascending

Scenario Planner

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFANPL	Planner Number	Ascending

Scenario Vender

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFVEND	Primary / Last Supplier Number	Ascending

Scenario

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending

Scenario WC WCBranch

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFLINE	Line/Cell Identifier	Ascending
3	DFMMCU	Branch	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

112 COLUMNS | 10 INDEXES | 920 | F30L | FF30L501 TABLE

TOP 920 | F30L | FF30L501 COLUMNS

TOP 920 | F30L | FF30L501 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

112 COLUMNS | 10 INDEXES | 920 | F30L | FF30L501 TABLE

TOP920 | F30L | FF30L501 COLUMNS

TOP920 | F30L | FF30L501 INDEXES

TOP 920 | F30L | FF30L501 COLUMNS

TOP 920 | F30L | FF30L501 INDEXES