	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

58 columns | 920 | WNUM

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

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

58 columns | 920 | WNUM