	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

61 COLUMNS | 4 INDEXES | 920 | 30 | F300311 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
30: Product Data Management
1	920	F300311	EH	61	4	Lean Multi-Level Routing Detail File	Files	30: Product Data Management

TOP 920 | 30 | F300311 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	EHUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	EHTRT	Type of Routing	String	UDC (40 TR)	3	0	Allow NULL?
3	EHKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
4	EHMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
5	EHDSC1	Description	String	Generic Edit	30	0	Allow NULL?
6	EHLINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
7	EHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
8	EHOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
9	EHUEFFD	Effective From Date	JDE UTime	Generic Edit	11	0
10	EHUEFTD	Effective To Date	JDE UTime	Generic Edit	11	0
11	EHBFPF	Pay Point Code	Character	UDC (30 BF)	1	0	Allow NULL?
12	EHLAMC	Labor or Machine	Character	UDC (H40 LA)	1	0	Allow NULL?
13	EHTIMB	Time Basis Code	Character	UDC (30 TB)	1	0	Allow NULL?
14	EHOPSR	Factor - Operation Shrinkage Factor	Numeric	Generic Edit	15	4	Allow NULL?
15	EHBQTY	Units - Batch Quantity	Numeric	Generic Edit	15	0	Allow NULL?
16	EHUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
17	EHRUNM	Run Machine - Standard	Numeric	Generic Edit	15	2	Allow NULL?
18	EHERUNM	Run Machine - Extended	Numeric	Generic Edit	15	2	Allow NULL?
19	EHRUNL	Run Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
20	EHERUNL	Run Labor - Extended	Numeric	Generic Edit	15	2	Allow NULL?
21	EHSETL	Setup Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
22	EHSETC	Crew Size	Numeric	Generic Edit	5	1	Allow NULL?
23	EHMOVD	Move Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
24	EHQUED	Queue Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
25	EHPOVR	Percent - Overlap	Numeric	Generic Edit	5	2	Allow NULL?
26	EHNXOP	Sequence Number - Next Operation	Numeric	Generic Edit	5	2	Allow NULL?
27	EHOPYP	Percent - Operational Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
28	EHCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
29	EHAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
30	EHOPSC	Type Operation Code	String	UDC (30 OT)	2	0	Allow NULL?
31	EHJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
32	EHAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
33	EHVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
34	EHPOY	Purchase Order (Y/N)	Character	UDC (00 MN)	1	0	Allow NULL?
35	EHCOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
36	EHOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
37	EHOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
38	EHRREV	Routing Revision Level	String	Generic Edit	3	0	Allow NULL?
39	EHSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
40	EHWMCU	Workcenter Branch	String	Generic Edit	12	0	Allow NULL?
41	EHLOCN	Location	String	Generic Edit	20	0	Allow NULL?
42	EHCMPE	Competency Type	String	UDC (05 CY)	3	0	Allow NULL?
43	EHCMPC	Competency Code	String	Generic Edit	10	0	Allow NULL?
44	EHCPLVLFR	Competency Level From	Numeric	Generic Edit	6	3	Allow NULL?
45	EHCPLVLTO	Competency Level To	Numeric	Generic Edit	6	3	Allow NULL?
46	EHITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
47	EHCMCU	Component Branch	String	Generic Edit	12	0	Allow NULL?
48	EHBQTE1	Units - Batch Quantity	Numeric	Generic Edit	15	0	Allow NULL?
49	EHLROUT	Level Of Routing	Numeric	Generic Edit	5	0	Allow NULL?
50	EHDFMLINE	DFM Line Identifier	String	Generic Edit	12	0	Allow NULL?
51	EHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
52	EHURDT	User Reserved Date	Date	Generic Edit	6	0
53	EHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
54	EHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
55	EHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
56	EHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
57	EHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
58	EHMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
59	EHUUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
60	EHRUNLEX	Run Labor Extended	Numeric	Generic Edit	28	8	Allow NULL?
61	EHRUNMEX	Run Machine Extended	Numeric	Generic Edit	28	8	Allow NULL?

TOP 920 | 30 | F300311 INDEXES

Number

Description

UniqueKeyId (Primary/Unique)

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

Parent Item Branch Type +

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	MMCU	Branch	Ascending
3	TRT	Type of Routing	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	ITM	Item Number - Short	Ascending
6	CMCU	Component Branch	Ascending
7	BQTE1	Units - Batch Quantity	Ascending
8	DFMLINE	DFM Line Identifier	Ascending

Parent Item Branch Line ITM

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	MMCU	Branch	Ascending
3	ITM	Item Number - Short	Ascending
4	DFMLINE	DFM Line Identifier	Ascending
5	BQTE1	Units - Batch Quantity	Ascending
6	UOM	Unit of Measure as Input	Ascending

Parent Item Line Branch+

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	DFMLINE	DFM Line Identifier	Ascending
3	MMCU	Branch	Ascending
4	TRT	Type of Routing	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

61 COLUMNS | 4 INDEXES | 920 | 30 | F300311 TABLE

TOP 920 | 30 | F300311 COLUMNS

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

61 COLUMNS | 4 INDEXES | 920 | 30 | F300311 TABLE

TOP920 | 30 | F300311 COLUMNS

TOP920 | 30 | F300311 INDEXES

TOP 920 | 30 | F300311 COLUMNS

TOP 920 | 30 | F300311 INDEXES