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

57 columns | 920 | WMDT

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP31B: Blend Management
1	F31B02	Staff Master	38	ST	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
2	F31B03	Barrel Master Table	110	BM	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
3	F31B032	Barrel Types and Capacities	20	BT	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
4	F31B033	Current Barrel Segment Master	9	BS	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
5	F31B05	Equipment Master	47	EM	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
6	F31B052	Equipment Assignments	22	EA	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
7	F31B053	Consumable Assignments	27	CA	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
8	F31B07	EUR Master File	38	EU	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
9	F31B0700	Specification Master	16	SM	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
10	F31B0701	Specification Detail	22	SD	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
11	F31B0702	EUR Specifications	15	ES	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
12	F31B0703	Specification Wine Statuses	17	WS	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
13	F31B0704	Specification Version Detail	23	VD	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
14	F31B0705	Blend Named Calculation Version	39	BN	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
15	F31B0710	Harvest Assumptions	25	HA	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
16	F31B0720	Protocol Master	26	PM	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
17	F31B0721	EUR Protocols	28	EP	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
18	F31B0730	EUR Loss Assumptions	18	LA	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
19	F31B0731	EUR Wine Status Loss Assumptions	18	WS	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
20	F31B0740	Planning Assumptions	49	PA	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
21	F31B0741	EUR Cull and Cascade	17	CC	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
22	F31B0750	EUR Operation List Flag	16	OF	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
23	F31B0751	Operation List	17	OL	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
24	F31B0760	EUR Conversion Assumptions	19	CA	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
25	F31B0770	Brand Master	27	BM	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
26	F31B0790	Specification Validation	36	SV	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
27	F31B08	Tank Master	89	TM	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
28	F31B104	Named Calculation User Default Paths	14	DP	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
29	F31B105	Named Calculation Path Header	16	PH	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
30	F31B106	Named Calculation Path Detail	12	PD	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
31	F31B107	Named Calculation Format Header	16	FH	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
32	F31B108	Named Calculation Format Detail	13	FD	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
33	F31B109	Blend Named Calculation	34	NC	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
34	F31B11	Work Group Master	23	WG	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
35	F31B110	Mass Barrel Update	95	MB	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
36	F31B114	Trial Blend Header	30	TB	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
37	F31B115	Trial Blend Lot Details	26	BD	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
38	F31B115W	Trial Blend Input Lot Workfile	75	LW	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
39	F31B116	Temperature Conversion Chart Header	15	CH	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
40	F31B117	Temperature Conversion Chart Detail	14	CD	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
41	F31B13	Winery Constants	33	WC	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
42	F31B130	Container Master Table	14	CM	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
43	F31B31	Blend Lot Master	78	WL	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
44	F31B45	Additive Templates	26	AT	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
45	F31B46	Consumable Templates	24	CT	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
46	F31B60	Operation Trace Track Workfile	90	OT	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
47	F31B65	Operation Header	49	OH	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
48	F31B66	Blend Transactions	35	BT	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
49	F31B70	Operation Vessel Assignments	30	VA	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
50	F31B73	Base Operation Configuration.	51	BC	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
51	F31B75	Operation Configuration	88	OC	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
52	F31B751	Operation Configuration for Vessel Attributes	78	OA	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
53	F31B91	Bill Of Lading Master	37	BL	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
54	F31B93	Work Order Header	27	WH	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
55	F31B97	Human Resource Assignments	15	HR	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
56	F31BSPZ1	Sample Transactions	26	ST	WMDT	Blend Mgmt Date	Date	Generic Edit	6	0
TOP37: Quality Management
57	F3712	Sample Detail	23	SD	WMDT	Blend Mgmt Date	Date	Generic Edit	6	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

57 columns | 920 | WMDT