	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 | 812 | UUPMJ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00142	Due Date Rules	23	L4	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP30: Product Data Management
2	F300210	Lean Multi Level Bill of Material Header	26	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
3	F300211	Lean Multi Level Bill of Material Detail	96	ED	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
4	F300311	Lean Multi Level Routing Detail File	59	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP40G: Grower Management
5	F40G002	Grower Block Defaults	16	GC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
6	F40G003	Harvest Period Patterns	16	HP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
7	F40G01	Grower Farm	61	GF	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
8	F40G02	Grower Block	117	GB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
9	F40G0200	Grower Block Update Profile	186	BU	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
10	F40G021	Block Descriptors	13	SB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
11	F40G022	Block Styles	12	BS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
12	F40G023	Block Coordinates	29	BC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
13	F40G03	Grower Harvest	124	GH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
14	F40G0300	Grower Harvest Update Profile	168	HU	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
15	F40G031	Harvest Estimate Freeze Hdr	20	FH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
16	F40G032	Harvest Estimate Freeze Detail	35	FD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
17	F40G033	Continous Harvest Estimates	14	CH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
18	F40G041	Item Spray Information	35	IS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
19	F40G042	Spray Master EUR Restriction	14	SE	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
20	F40G043	Restricted Spray Style Information - F40G043	19	SS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
21	F40G101	Ownership Distribution	12	OD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
22	F40G102	Grower Contacts	14	GC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
23	F40G103	EUR - Intended Use Distribution	24	IU	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
24	F40G104	Grower Action Dates	21	AD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
25	F40G150	Crush and Purchase Report Details	67	CP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
26	F40G151	Quality Result Limits	22	QL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
27	F40G65	Farming Operation Header	48	FO	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
28	F40G70	Harvest Operation Withholding Date	26	WH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
29	F40G75	Farming Operation Additional Configuration Setup	16	AC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
30	F40G80	Farming Operation Configuration Values Entry	16	CV	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP43C: Contracts
31	F43C01	Contract Header	73	CH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
32	F43C05	Contract Action Dates	20	CA	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
33	F43C10	Contract Block	77	CB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
34	F43C11	Contract Detail	82	CD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
35	F43C20	Contract Payee	20	CP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
36	F43C30	Assessment Donations	24	AD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
37	F43C40	Contract Assessments Donations	15	AC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
38	F43C60	Contract Clauses	15	CC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP46R: RFID Outbound
39	F46R060	EPC Partition Definition	14	EP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
40	F46R070	EPC Company Length Definition	12	EC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF30L: DFM Line Design
41	FF30L002	DFM Bill of Material Master	77	DH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
42	FF30L005	DFM Task Master	24	TM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
43	FF30L010	Scenario Master	13	SC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
44	FF30L011	Line Design Control Parameters	25	LD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
45	FF30L012	Kanban Control Parameters	22	KB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
46	FF30L013	Default User Scenario	11	DS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
47	FF30L014	Branch/Plant Master	49	BP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
48	FF30L015	Resource Master	18	RE	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
49	FF30L016	Default User Branch/Plant	7	DB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
50	FF30L017	DFM Work Center Master	23	WM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
51	FF30L101	Mixed Model Family Master	14	FM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
52	FF30L102	Mixed Model Family Items	14	FD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
53	FF30L110	Standard Sequence Of Events	24	SS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
54	FF30L115	Sequence Of Events	30	SE	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
55	FF30L116	Components Consumed	22	CC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
56	FF30L117	DFM Event Summary Table	20	ES	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
57	FF30L201	Volume Design Master	14	VM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
58	FF30L202	Volume By Family	19	VF	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
59	FF30L203	Volume By Family By Part	24	FP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
60	FF30L301	DFM Customer Master	45	CM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
61	FF30L401	DFM Supplier Master	13	SM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
62	FF30L501	DFM Item Definition Master	110	IB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
63	FF30L512	DFM Item Units of Measure Conversion Factors	12	UM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
64	FF30L513	DFM Units of Measure Standard Conversion	7	UC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
65	FF30L601	DFM Employee Master	13	EM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
66	FF30L701	DFM Process Master	21	PM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
67	FF30L702	Path Master	14	PH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
68	FF30L703	Process Path Relationship	23	PP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
69	FF30L705	Graphical Product Synch Properties	15	GP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
70	FF30L707	Path Links	21	PL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
71	FF30L708	Product Synchronization Results	17	PS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
72	FF30L801	Sales Order Master	36	SD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
73	FF30L901	Process Map Header Table	17	PH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
74	FF30L902	Process Map Detail Table	30	PD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
75	FF30L904	Process Map Work Content Table	24	WC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
76	FF30L910	Mixed Model Line Design Header	21	LH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
77	FF30L911	Mixed Model Line Design Detail	28	LD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
78	FF30L912	Line Master	15	LM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
79	FF30L920	Total Product Cycle Time Header	16	CH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
80	FF30L921	Total Product Cycle Time Detail	20	CL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
81	FF30L950	DFM Operation Definition Header	33	OD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
82	FF30L951	DFM Operation Definition Detail	36	OM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
83	FF30L990	DFM Data Move Configuration Header	7	MH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
84	FF30L991	DFM Data Move Configuration Detail	12	MD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF31: Lean Transactions
85	FF31010	Production Master File	49	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
86	FF31011	TransactionID Master File	43	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
87	FF31011S	Purge - TransactionID Master File	43	ER	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
88	FF31111	Lean Transaction Parts List	71	PL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
89	FF311114	Related Purchase Orders for Lean Pay on Consumption Issues	19	PC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
90	FF31111S	Purge - Lean Transaction Parts List	71	PR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
91	FF31112	Routing Transaction Table	83	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
92	FF31112S	Purge - Routing Transaction Table	83	ET	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
93	FF31113	Lean Transaction Labor Detail	50	LD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
94	FF31113S	Purge - Lean Transaction Labor Detail	50	LR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF31K: DFM Kanban Management
95	FF31K10	DFM Kanban Flow Capacity	14	FC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
96	FF31K11	DFM Kanban Parent Items	20	PI	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
97	FF31K20	DFM Kanban Component	21	KC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
98	FF31K21	DFM Kanban Component Pull Chain	18	CP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
99	FF31K22	DFM Kanban Component Pull Sequence	32	PS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
100	FF31K25	DFM Kanban Master -- TEMP	35	KM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
101	FF31K30	DFM Kanban Master	34	KM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
102	FF31K41	DFM Kanban Pull Chain	23	PC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
103	FF31K42	DFM Kanban Location	14	LC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
104	FF31K50	DFM Kanban Constants	18	DF	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
105	FF31K51	DFM Kanban Resize Filter	14	RF	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
106	FF31K52	DFM Kanban Label Message	12	LM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF34R: DFM Resource Management
107	FF34R010	Resource Design Master	21	RM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
108	FF34R011	Resource Calendar Master	22	RC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
109	FF34R012	Resource Simulation Master	17	RS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF34S: DFM Production Sequencing
110	FF34S001	Sequence Detail	17	SQ	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
111	FF34S002	Daily Plan	34	DP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
112	FF34S003	DFM Planning Parameters	15	PP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0

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 | 812 | UUPMJ