	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

97 COLUMNS | 6 INDEXES | 920 | 30 | F300211 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
30: Product Data Management
1	920	F300211	ED	97	6	Lean Multi Level Bill of Material Detail	Files	30: Product Data Management

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 EDUKID, EDOKIT, EDMCU0, EDOTBM, ED#BQT, EDKIT, EDTBM, EDMMCU, EDLBQTY, EDITM, EDCMCU, EDBQTE1, EDUOM1, EDCPNT, EDBRVN, EDDFMLINE, EDOPSQ, EDLBOM, EDSTKT, EDUOM, EDLQNTY, EDQNTY, EDUM, EDOPSC, EDTYCOMP, EDBOSTR, EDSBNT, EDPRTA, EDFVBT, EDUEFFD, EDUEFTD, EDFSER, EDTSER, EDFTRC, EDITC, EDOPTK, EDFORV, EDCSTM, EDCSMP, EDORDW, EDFORQ, EDCOBY, EDCOTY, EDFRGD, EDTHGD, EDFRMP, EDTHRP, EDFTRP, EDRSCP, EDF$RP, EDSTPP, EDSCRP, EDREWP, EDASIP, EDCPYP, EDLOVD, EDECO, EDECOD, EDDSC1, EDIFLOCN, EDLOCN, EDLOTN, EDAING, EDBSEQ, EDSUBAF, EDEBTKID, EDSRNK, EDSRKF, EDDRAW, EDLNTY, EDPRIC, EDSHNO, EDPCTK, EDUNCS, EDOMCU, EDOBJ, EDSUB, EDBREV, EDCMRV, EDRVNO, EDUUPG, EDURCD, EDURAT, EDURDT, EDURRF, EDURAB, EDSUCO, EDSTRC, EDENDC, EDCPNB, EDBSEQAN, EDAPSC, EDUSER, EDPID, EDMKEY, EDUUPMJ, EDPRUKID FROM F300211

TOP 920 | 30 | F300211 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	EDUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	EDOKIT	Parent (short) Item Number - Overrides	Numeric	Generic Edit	8	0	Allow NULL?
3	EDMCU0	Business Unit	String	Generic Edit	12	0	Allow NULL?
4	EDOTBM	Type Bill of Material - Overrides	String	UDC (40 TB)	3	0	Allow NULL?
5	ED#BQT	Units - Batch Quanity	Numeric	Generic Edit	15	0	Allow NULL?
6	EDKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
7	EDTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
8	EDMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
9	EDLBQTY	Lean Batch Quantity	Numeric	Generic Edit	20	4	Allow NULL?
10	EDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
11	EDCMCU	Component Branch	String	Generic Edit	12	0	Allow NULL?
12	EDBQTE1	Units - Batch Quantity	Numeric	Generic Edit	15	0	Allow NULL?
13	EDUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
14	EDCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
15	EDBRVN	BOM Revision Number	Numeric	Generic Edit	15	0	Allow NULL?
16	EDDFMLINE	DFM Line Identifier	String	Generic Edit	12	0	Allow NULL?
17	EDOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
18	EDLBOM	Level of BOM	Numeric	Generic Edit	15	0	Allow NULL?
19	EDSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
20	EDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
21	EDLQNTY	Lean Quantity Per	Numeric	Generic Edit	20	4	Allow NULL?
22	EDQNTY	Quantity - Standard Required Quantity	Numeric	Generic Edit	15	0	Allow NULL?
23	EDUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
24	EDOPSC	Type Operation Code	String	UDC (30 OT)	2	0	Allow NULL?
25	EDTYCOMP	Type of Component	String	Generic Edit	2	0	Allow NULL?
26	EDBOSTR	Prep Code	String	UDC (F30L PC)	4	0	Allow NULL?
27	EDSBNT	Substitute Item Sequence Number	Numeric	Generic Edit	5	2	Allow NULL?
28	EDPRTA	Partials Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
29	EDFVBT	Fixed or Variable Batch Size	Character	Generic Edit	1	0	Allow NULL?
30	EDUEFFD	Effective From Date	JDE UTime	Generic Edit	11	0
31	EDUEFTD	Effective To Date	JDE UTime	Generic Edit	11	0
32	EDFSER	Effective From Serial Number	String	Generic Edit	25	0	Allow NULL?
33	EDTSER	Effective Thru Serial Number	String	Generic Edit	25	0	Allow NULL?
34	EDFTRC	Required	Character	Generic Edit	1	0	Allow NULL?
35	EDITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
36	EDOPTK	Optional Item (Kit)	Character	UDC (H40 OP)	1	0	Allow NULL?
37	EDFORV	Default Component	Character	Generic Edit	1	0	Allow NULL?
38	EDCSTM	Component Costing Method	Character	UDC (H40 CV)	1	0	Allow NULL?
39	EDCSMP	Costing Method - Purchasing	Character	Generic Edit	1	0	Allow NULL?
40	EDORDW	Order With	Character	Generic Edit	1	0	Allow NULL?
41	EDFORQ	Fixed or Variable Quantity	Character	UDC (H40 FO)	1	0	Allow NULL?
42	EDCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
43	EDCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
44	EDFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
45	EDTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
46	EDFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
47	EDTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
48	EDFTRP	Feature Planned Percent	Numeric	Generic Edit	5	2	Allow NULL?
49	EDRSCP	Resource Percent	Numeric	Generic Edit	5	2	Allow NULL?
50	EDF$RP	Feature Cost Percent	Numeric	Generic Edit	5	2	Allow NULL?
51	EDSTPP	Operation Scrap Percent	Numeric	Generic Edit	5	2	Allow NULL?
52	EDSCRP	Percent - Percent of Scrap	Numeric	Generic Edit	5	2	Allow NULL?
53	EDREWP	Percent - Rework	Numeric	Generic Edit	5	2	Allow NULL?
54	EDASIP	Percent - As is	Numeric	Generic Edit	5	2	Allow NULL?
55	EDCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
56	EDLOVD	Leadtime Offset Days	Numeric	Generic Edit	6	0	Allow NULL?
57	EDECO	ECO Number	String	Generic Edit	12	0	Allow NULL?
58	EDECOD	Date - Engineering Change Date	Date	Generic Edit	6	0
59	EDDSC1	Description	String	Generic Edit	30	0	Allow NULL?
60	EDIFLOCN	Issue From Location	String	Generic Edit	20	0	Allow NULL?
61	EDLOCN	Location	String	Generic Edit	20	0	Allow NULL?
62	EDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
63	EDAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
64	EDBSEQ	Sequence - Bubble Sequence	Numeric	Generic Edit	5	0	Allow NULL?
65	EDSUBAF	Sub Assembly Flag	Character	Generic Edit	1	0	Allow NULL?
66	EDEBTKID	Exploded BOM Table Key ID	String	Generic Edit	32	0	Allow NULL?
67	EDSRNK	Shrink Factor	Numeric	Generic Edit	15	2	Allow NULL?
68	EDSRKF	Shrink Factor Method	Character	UDC (H40 SR)	1	0	Allow NULL?
69	EDDRAW	Drawing Number	String	Generic Edit	20	0	Allow NULL?
70	EDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
71	EDPRIC	Unit Price per Primary	Numeric	Generic Edit	15	4	Allow NULL?
72	EDSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
73	EDPCTK	Percent Assembly Sales Price	Numeric	Generic Edit	7	3	Allow NULL?
74	EDUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
75	EDOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
76	EDOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
77	EDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
78	EDBREV	Bill Revision Level	String	Generic Edit	3	0	Allow NULL?
79	EDCMRV	Component Revision Level	String	Generic Edit	3	0	Allow NULL?
80	EDRVNO	Last Revision No.	String	Generic Edit	2	0	Allow NULL?
81	EDUUPG	Item Number - Use Up/Go To	Numeric	Generic Edit	8	0	Allow NULL?
82	EDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
83	EDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
84	EDURDT	User Reserved Date	Date	Generic Edit	6	0
85	EDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
86	EDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
87	EDSUCO	Substitute Counter	Integer	Generic Edit	11	0	Allow NULL?
88	EDSTRC	Consumption Start	Numeric	Generic Edit	15	4	Allow NULL?
89	EDENDC	Consumption End	Numeric	Generic Edit	15	4	Allow NULL?
90	EDCPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
91	EDBSEQAN	Bubble Sequence Alpha Numeric	String	Generic Edit	5	0	Allow NULL?
92	EDAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
93	EDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
94	EDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
95	EDMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
96	EDUUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
97	EDPRUKID	Parent Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?

TOP 920 | 30 | F300211 INDEXES

Number

Description

UKID (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

Kit Tbm Mmcu itm Opsq

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	TBM	Type Bill of Material	Ascending
3	MMCU	Branch	Ascending
4	ITM	Item Number - Short	Ascending
5	OPSQ	Sequence Number - Operations	Ascending

Kit MMCU BRVN LBOM

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	MMCU	Branch	Ascending
3	BRVN	BOM Revision Number	Ascending
4	LBOM	Level of BOM	Ascending

EndItem

Element	Alias	Description	Sequence
1	OKIT	Parent (short) Item Number - Overrides	Ascending
2	MCU0	Business Unit	Ascending
3	OTBM	Type Bill of Material - Overrides	Ascending
4	#BQT	Units - Batch Quanity	Ascending
5	DFMLINE	DFM Line Identifier	Ascending

EndItem + SubAssmbly

Element	Alias	Description	Sequence
1	OKIT	Parent (short) Item Number - Overrides	Ascending
2	MCU0	Business Unit	Ascending
3	OTBM	Type Bill of Material - Overrides	Ascending
4	#BQT	Units - Batch Quanity	Ascending
5	KIT	Parent (short) Item Number	Ascending
6	MMCU	Branch	Ascending
7	TBM	Type Bill of Material	Ascending
8	LBQTY	Lean Batch Quantity	Ascending
9	DFMLINE	DFM Line Identifier	Ascending
10	UOM	Unit of Measure as Input	Ascending

ParentUKID

Element	Alias	Description	Sequence
1	PRUKID	Parent Unique Key ID (Internal)	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

97 COLUMNS | 6 INDEXES | 920 | 30 | F300211 TABLE

TOP 920 | 30 | F300211 COLUMNS

TOP 920 | 30 | F300211 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

97 COLUMNS | 6 INDEXES | 920 | 30 | F300211 TABLE

TOP920 | 30 | F300211 COLUMNS

TOP920 | 30 | F300211 INDEXES

TOP 920 | 30 | F300211 COLUMNS

TOP 920 | 30 | F300211 INDEXES