	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

78 COLUMNS | 6 INDEXES | 812 | F30L | FF30L002 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
F30L: DFM Line Design
1	812	FF30L002	DH	78	6	DFM Bill of Material Master	Files	F30L: DFM Line Design

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 DHDFTBM, DHDFKIT, DHDFMCU, DHDFITM, DHDFCMCU, DHCPNT, DHSBNT, DHPRTA, DHQNTY, DHUM, DHBQTY, DHUOM, DHFVBT, DHEFFF, DHEFFT, DHITC, DHFTRC, DHOPTK, DHFORV, DHCSTM, DHCSMP, DHORDW, DHFORQ, DHCOBY, DHCOTY, DHFRMP, DHTHRP, DHFRGD, DHTHGD, DHOPSQ, DHBSEQ, DHFTRP, DHF$RP, DHRSCP, DHSCRP, DHREWP, DHASIP, DHCPYP, DHSTPP, DHLOVD, DHECO, DHECTY, DHECOD, DHDSC1, DHLNTY, DHPRIC, DHUNCS, DHPCTK, DHSHNO, DHBREV, DHCMRV, DHRVNO, DHUUPG, DHAING, DHSUCO, DHSTRC, DHENDC, DHAPSC, DHCPNB, DHBSEQAN, DHPKUOM, DHFSCID, DHBCHAR, DHTYCOMP, DHCOLOCN, DHIMPM, DHIFLOCN, DHBOSTR, DHURCD, DHURDT, DHURAT, DHURRF, DHURAB, DHUSER, DHPID, DHMKEY, DHUUPMJ, DHDFUPDA FROM FF30L002

TOP 812 | F30L | FF30L002 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	DHDFTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
2	DHDFKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
3	DHDFMCU	Branch/Plant	String	Generic Edit	12	0	Allow NULL?
4	DHDFITM	Item Number DFM - Short	Numeric	Generic Edit	8	0	Allow NULL?
5	DHDFCMCU	DF Branch/Plant	String	Generic Edit	12	0	Allow NULL?
6	DHCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
7	DHSBNT	Substitute Item Sequence Number	Numeric	Generic Edit	5	2	Allow NULL?
8	DHPRTA	Partials Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
9	DHQNTY	Quantity - Standard Required Quantity	Numeric	Generic Edit	15	0	Allow NULL?
10	DHUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
11	DHBQTY	Units - Batch Quantity	Numeric	Generic Edit	15	2	Allow NULL?
12	DHUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
13	DHFVBT	Fixed or Variable Batch Size	Character	Generic Edit	1	0	Allow NULL?
14	DHEFFF	Effective - From Date	Date	Generic Edit	6	0
15	DHEFFT	Effective - Thru Date	Date	Generic Edit	6	0
16	DHITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
17	DHFTRC	Required	Character	Generic Edit	1	0	Allow NULL?
18	DHOPTK	Optional Item (Kit)	Character	UDC (H40 OP)	1	0	Allow NULL?
19	DHFORV	Default Component	Character	Generic Edit	1	0	Allow NULL?
20	DHCSTM	Component Costing Method	Character	UDC (H40 CV)	1	0	Allow NULL?
21	DHCSMP	Costing Method - Purchasing	Character	Generic Edit	1	0	Allow NULL?
22	DHORDW	Order With	Character	Generic Edit	1	0	Allow NULL?
23	DHFORQ	Fixed or Variable Quantity	Character	UDC (H40 FO)	1	0	Allow NULL?
24	DHCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
25	DHCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
26	DHFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
27	DHTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
28	DHFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
29	DHTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
30	DHOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
31	DHBSEQ	Sorszám - Buborék sorszám	Numeric	Generic Edit	5	0	Allow NULL?
32	DHFTRP	Feature Planned Percent	Numeric	Generic Edit	5	2	Allow NULL?
33	DHF$RP	Feature Cost Percent	Numeric	Generic Edit	5	2	Allow NULL?
34	DHRSCP	Resource Percent	Numeric	Generic Edit	5	2	Allow NULL?
35	DHSCRP	Percent - Percent of Scrap	Numeric	Generic Edit	5	2	Allow NULL?
36	DHREWP	Percent - Rework	Numeric	Generic Edit	5	2	Allow NULL?
37	DHASIP	Percent - As is	Numeric	Generic Edit	5	2	Allow NULL?
38	DHCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
39	DHSTPP	Operation Scrap Percent	Numeric	Generic Edit	5	2	Allow NULL?
40	DHLOVD	Leadtime Offset Days	Numeric	Generic Edit	6	0	Allow NULL?
41	DHECO	ECO Number	String	Generic Edit	12	0	Allow NULL?
42	DHECTY	Engineering Change Reason	String	UDC (40 CR)	2	0	Allow NULL?
43	DHECOD	Date - Engineering Change Date	Date	Generic Edit	6	0
44	DHDSC1	Description	String	Generic Edit	30	0	Allow NULL?
45	DHLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
46	DHPRIC	Unit Price per Primary	Numeric	Generic Edit	15	4	Allow NULL?
47	DHUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
48	DHPCTK	Percent Assembly Sales Price	Numeric	Generic Edit	7	3	Allow NULL?
49	DHSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
50	DHBREV	Bill Revision Level	String	Generic Edit	3	0	Allow NULL?
51	DHCMRV	Component Revision Level	String	Generic Edit	3	0	Allow NULL?
52	DHRVNO	Last Revision No.	String	Generic Edit	2	0	Allow NULL?
53	DHUUPG	Item Number - Use Up/Go To	Numeric	Generic Edit	8	0	Allow NULL?
54	DHAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
55	DHSUCO	Substitute Counter	Integer	Generic Edit	11	0	Allow NULL?
56	DHSTRC	Consumption Start	Numeric	Generic Edit	15	4	Allow NULL?
57	DHENDC	Consumption End	Numeric	Generic Edit	15	4	Allow NULL?
58	DHAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
59	DHCPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
60	DHBSEQAN	Bubble Sequence Alpha Numeric	String	Generic Edit	5	0	Allow NULL?
61	DHPKUOM	Package UOM	String	UDC (00 UM)	2	0	Allow NULL?
62	DHFSCID	Scenario ID	Numeric	Generic Edit	15	0	Allow NULL?
63	DHBCHAR	Lean Superflush Flag	Character	Generic Edit	1	0	Allow NULL?
64	DHTYCOMP	Type of Component	String	Generic Edit	2	0	Allow NULL?
65	DHCOLOCN	Completed to Location	String	Generic Edit	20	0	Allow NULL?
66	DHIMPM	Import Parameters	String	Generic Edit	4	0	Allow NULL?
67	DHIFLOCN	Issue From Location	String	Generic Edit	20	0	Allow NULL?
68	DHBOSTR	Prep Code	String	UDC (F30L PC)	4	0	Allow NULL?
69	DHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
70	DHURDT	User Reserved Date	Date	Generic Edit	6	0
71	DHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
72	DHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
73	DHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
74	DHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
75	DHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
76	DHMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
77	DHUUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
78	DHDFUPDA	EnterpriseOne BOM Source	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | F30L | FF30L002 INDEXES

Number

Description

ScenarioID DFMParentItem + (Primary/Unique)

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFKIT	Parent (short) Item Number	Ascending
3	DFMCU	Branch/Plant	Ascending
4	DFTBM	Type Bill of Material	Ascending
5	BQTY	Units - Batch Quantity	Ascending
6	CPNB	Component Line Number BOM	Ascending
7	SBNT	Substitute Item Sequence Number	Ascending
8	COBY	Co-Products/By-Products/Intermediate	Ascending

ScenarioId

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending

ScenarioID DFMCompItem +

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	SBNT	Substitute Item Sequence Number	Ascending
3	COBY	Co-Products/By-Products/Intermediate	Ascending
4	DFITM	Item Number DFM - Short	Ascending
5	DFCMCU	DF Branch/Plant	Ascending

FSCID DFKIT DFMCU +

Element	Alias	Description	Sequence
1	FSCID	Scenario ID	Ascending
2	DFKIT	Parent (short) Item Number	Ascending
3	DFMCU	Branch/Plant	Ascending
4	DFTBM	Type Bill of Material	Ascending
5	BQTY	Units - Batch Quantity	Ascending
6	DFITM	Item Number DFM - Short	Ascending
7	BOSTR	Prep Code	Ascending
8	SBNT	Substitute Item Sequence Number	Ascending
9	COBY	Co-Products/By-Products/Intermediate	Ascending

Scenario BranchPlant Item

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

ParentItem

Element	Alias	Description	Sequence
1	DFKIT	Parent (short) Item Number	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

78 COLUMNS | 6 INDEXES | 812 | F30L | FF30L002 TABLE

TOP 812 | F30L | FF30L002 COLUMNS

TOP 812 | F30L | FF30L002 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

78 COLUMNS | 6 INDEXES | 812 | F30L | FF30L002 TABLE

TOP812 | F30L | FF30L002 COLUMNS

TOP812 | F30L | FF30L002 INDEXES

TOP 812 | F30L | FF30L002 COLUMNS

TOP 812 | F30L | FF30L002 INDEXES