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

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