	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

156 columns | 920 | 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
2	F0045	Services Error Recovery	21	ER	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
3	F0049	Business Function Call Abstraction Register	15	CA	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
4	F80D306	Action Definition	14	HD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
5	F80D307	Metric Action Cross Reference	11	HD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
6	F80D309	Metric Series Cross Ref	12	MS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
7	F80D310	Alert Definition	13	AL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
8	F80D312	Alert Subscription	12	AS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
9	F80D321	UI Metric Group Definition	12	MG	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
10	F80D322	UI Metric Group Detail	17	MD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP30: Product Data Management
11	F300210	Lean Multi Level Bill of Material Header	26	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
12	F300211	Lean Multi Level Bill of Material Detail	96	ED	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
13	F300311	Lean Multi-Level Routing Detail File	59	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP34A: Advanced Planning & Scheduling
14	F34A160	Work Center Resource Set	13	WR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
15	F34A170	Work Center Resource and Set XRef	14	WD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
16	F34A180	Routing Master Resource Set	22	RR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
17	F34A190	Routing Master Resource and Set XRef	21	RD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP40G: Grower Management
18	F40G002	Grower Block Defaults	16	GC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
19	F40G003	Harvest Period Patterns	16	HP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
20	F40G01	Grower Farm	61	GF	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
21	F40G02	Grower Block	119	GB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
22	F40G0200	Grower Block Update Profile	188	BU	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
23	F40G021	Block Descriptors	13	SB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
24	F40G022	Block Styles	12	BS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
25	F40G023	Block Coordinates	29	BC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
26	F40G03	Grower Harvest	127	GH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
27	F40G0300	Grower Harvest Update Profile	171	HU	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
28	F40G031	Harvest Estimate Freeze Hdr	20	FH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
29	F40G032	Harvest Estimate Freeze Detail	35	FD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
30	F40G033	Continous Harvest Estimates	14	CH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
31	F40G034	Harvest Item Master	16	HI	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
32	F40G041	Item Spray Information	35	IS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
33	F40G042	Spray Master EUR Restriction	14	SE	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
34	F40G043	Restricted Spray Style Information - F40G043	19	SS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
35	F40G101	Ownership Distribution	12	OD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
36	F40G102	Grower Contacts	14	GC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
37	F40G103	EUR - Intended Use Distribution	24	IU	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
38	F40G104	Grower Action Dates	21	AD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
39	F40G150	Crush and Purchase Report Details	67	CP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
40	F40G151	Quality Result Limits	22	QL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
41	F40G50	Maturity Calc Program Name Setup	16	MC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
42	F40G60	Scheduled Harvest	19	HS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
43	F40G65	Farming Operation Header	48	FO	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
44	F40G70	Harvest Operation Withholding Date	26	WH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
45	F40G75	Farming Operation Additional Configuration Setup	16	AC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
46	F40G80	Farming Operation Configuration Values Entry	16	CV	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
47	F40G90	Grower POP Item Cross Reference	15	PI	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
48	F40G95	Pay On Proceeds Log File	53	PP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP43: Procurement
49	F43147	Freight Distribution Workfile	59	FD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
50	F4317	Purchase Order Detail Non-Billable	24	PD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
51	F4320	Purchase Order Clauses	13	PC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
52	F43UI50C	PO Print Clauses Table	19	WC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP43A: Purchase Order Receipt/Routing
53	F43127	Purchase Order Receiver Non-Billable	31	PR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP43C: Contracts
54	F43C01	Contract Header	73	CH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
55	F43C010	Contract Header Profile	124	HP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
56	F43C05	Contract Action Dates	20	CA	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
57	F43C10	Contract Block	77	CB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
58	F43C100	Contract Block Profile	140	BP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
59	F43C11	Contract Detail	82	CD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
60	F43C110	Contract Harvest Profile	129	DP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
61	F43C20	Contract Payee	20	CP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
62	F43C30	Assessment Donations	24	AD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
63	F43C40	Contract Assessments Donations	15	AC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
64	F43C60	Contract Clauses	15	CC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
65	F43C600	Clauses Mass Update	14	CP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP43E: Requisition Self Service
66	F43E15	Shopping Cart Cross Reference	19	SX	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
67	F43E35	Direct Connect Communication Document BSSV Properties	16	CP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP46R: RFID Outbound
68	F46R060	EPC Partition Definition	14	EP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
69	F46R070	EPC Company Length Definition	12	EC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOP49: Transportation Management
70	F49T00	Integration Constants	15	IC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
71	F49T05	OTM Record Reservation	8	OR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
72	F49T10	Sales Order Release Staging Table	67	OR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
73	F49T100	Procurement Freight Request staging table	67	OB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
74	F49T11	Item Staging Table	36	IT	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
75	F49T20	Shipment Staging Table	45	SS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
76	F49T211	Sales Order Detail File - Secondary Tag Table	40	TP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
77	F49T219	Sales Order Detail File - Secondary Tag History Table	40	TP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
78	F49T30	Sales Confirm Staging Table	42	SO	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
79	F49T311	Purchase Order Detail - OTM	16	TP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
80	F49T380	Seal Numbers	15	SO	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
81	F49T40	Shipment Freight Cost Staging Table	30	TC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
82	F49T50	Order Release Location Staging	34	LO	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
83	F49T70	Corporations Staging Table	27	CS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
84	F49T80	Locations Staging Table	31	LC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF30L: DFM Line Design
85	FF30L002	DFM Bill of Material Master	77	DH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
86	FF30L005	DFM Task Master	24	TM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
87	FF30L010	Scenario Master	13	SC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
88	FF30L011	Line Design Control Parameters	25	LD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
89	FF30L012	Kanban Control Parameters	22	KB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
90	FF30L013	Default User Scenario	11	DS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
91	FF30L014	Branch/Plant Master	49	BP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
92	FF30L015	Resource Master	18	RE	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
93	FF30L016	Default User Branch/Plant	7	DB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
94	FF30L017	DFM Work Center Master	23	WM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
95	FF30L101	Mixed Model Family Master	14	FM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
96	FF30L102	Mixed Model Family Items	14	FD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
97	FF30L110	Standard Sequence Of Events	24	SS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
98	FF30L115	Sequence Of Events	30	SE	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
99	FF30L116	Components Consumed	22	CC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
100	FF30L117	DFM Event Summary Table	20	ES	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
101	FF30L201	Volume Design Master	14	VM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
102	FF30L202	Volume By Family	19	VF	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
103	FF30L203	Volume By Family By Part	24	FP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
104	FF30L301	DFM Customer Master	45	CM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
105	FF30L401	DFM Supplier Master	13	SM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
106	FF30L501	DFM Item Definition Master	110	IB	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
107	FF30L512	DFM Item Units of Measure Conversion Factors	12	UM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
108	FF30L513	DFM Units of Measure Standard Conversion	7	UC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
109	FF30L601	DFM Employee Master	13	EM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
110	FF30L701	DFM Process Master	21	PM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
111	FF30L702	Path Master	14	PH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
112	FF30L703	Process Path Relationship	23	PP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
113	FF30L705	Graphical Product Synch Properties	15	GP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
114	FF30L707	Path Links	21	PL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
115	FF30L708	Product Synchronization Results	17	PS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
116	FF30L801	Sales Order Master	36	SD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
117	FF30L901	Process Map Header Table	17	PH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
118	FF30L902	Process Map Detail Table	30	PD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
119	FF30L904	Process Map Work Content Table	24	WC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
120	FF30L910	Mixed Model Line Design Header	21	LH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
121	FF30L911	Mixed Model Line Design Detail	28	LD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
122	FF30L912	Line Master	15	LM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
123	FF30L920	Total Product Cycle Time Header	16	CH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
124	FF30L921	Total Product Cycle Time Detail	20	CL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
125	FF30L950	DFM Operation Definition Header	33	OD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
126	FF30L951	DFM Operation Definition Detail	36	OM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
127	FF30L990	DFM Data Move Configuration Header	7	MH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
128	FF30L991	DFM Data Move Configuration Detail	12	MD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF31: Lean Transactions
129	FF31010	Production Master File	49	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
130	FF31011	TransactionID Master File	43	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
131	FF31011S	Purge - TransactionID Master File	43	ER	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
132	FF31111	Lean Transaction Parts List	71	PL	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
133	FF311114	Related Purchase Orders for Lean Pay on Consumption Issues	19	PC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
134	FF31111S	Purge - Lean Transaction Parts List	71	PR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
135	FF31112	Routing Transaction Table	83	EH	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
136	FF31112S	Purge - Routing Transaction Table	83	ET	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
137	FF31113	Lean Transaction Labor Detail	50	LD	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
138	FF31113S	Purge - Lean Transaction Labor Detail	50	LR	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF31K: DFM Kanban Management
139	FF31K10	DFM Kanban Flow Capacity	14	FC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
140	FF31K11	DFM Kanban Parent Items	20	PI	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
141	FF31K20	DFM Kanban Component	21	KC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
142	FF31K21	DFM Kanban Component Pull Chain	18	CP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
143	FF31K22	DFM Kanban Component Pull Sequence	32	PS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
144	FF31K25	DFM Kanban Master -- TEMP	35	KM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
145	FF31K30	DFM Kanban Master	34	KM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
146	FF31K41	DFM Kanban Pull Chain	23	PC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
147	FF31K42	DFM Kanban Location	14	LC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
148	FF31K50	DFM Kanban Constants	18	DF	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
149	FF31K51	DFM Kanban Resize Filter	14	RF	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
150	FF31K52	DFM Kanban Label Message	12	LM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF34R: DFM Resource Management
151	FF34R010	Resource Design Master	21	RM	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
152	FF34R011	Resource Calendar Master	22	RC	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
153	FF34R012	Resource Simulation Master	17	RS	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
TOPF34S: DFM Production Sequencing
154	FF34S001	Sequence Detail	17	SQ	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
155	FF34S002	Daily Plan	34	DP	UUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
156	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

156 columns | 920 | UUPMJ