	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

151 tables920 | 31B

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	920	F31B01	WI	45	2	Winery Master	Files	31B: Blend Management
2	920	F31B02	ST	38	2	Staff Master	Files	31B: Blend Management
3	920	F31B03	BM	116	5	Barrel Master Table	Files	31B: Blend Management
4	920	F31B031	BP	58	1	Barrel Profile Table	Files	31B: Blend Management
5	920	F31B032	BT	20	1	Barrel Types and Capacities	Files	31B: Blend Management
6	920	F31B033	BS	18	1	Current Barrel Segment Master	Files	31B: Blend Management
7	920	F31B03E	BE	80	3	Barrel Inquiry Work File	Files	31B: Blend Management
8	920	F31B04	MT	23	2	Material Type Master	Files	31B: Blend Management
9	920	F31B042	MT	12	1	Material Type Combination	Files	31B: Blend Management
10	920	F31B05	EM	49	3	Equipment Master	Files	31B: Blend Management
11	920	F31B051	EC	18	3	Equipment Consumables	Files	31B: Blend Management
12	920	F31B052	EA	25	4	Equipment Assignments	Files	31B: Blend Management
13	920	F31B053	CA	28	5	Consumable Assignments	Files	31B: Blend Management
14	920	F31B06	WV	16	3	Weight/Volume Conversions	Files	31B: Blend Management
15	920	F31B07	EU	53	4	EUR Master File	Files	31B: Blend Management
16	920	F31B0700	SM	18	2	Specification Master	Files	31B: Blend Management
17	920	F31B0701	SD	24	1	Specification Detail	Files	31B: Blend Management
18	920	F31B0702	ES	17	1	EUR Specifications	Files	31B: Blend Management
19	920	F31B0703	WS	19	1	Specification Wine Statuses	Files	31B: Blend Management
20	920	F31B0704	VD	25	2	Specification Version Detail	Files	31B: Blend Management
21	920	F31B0705	BN	41	2	Blend Named Calculation Version	Files	31B: Blend Management
22	920	F31B0710	HA	27	1	Harvest Assumptions	Files	31B: Blend Management
23	920	F31B0720	PM	28	2	Protocol Master	Files	31B: Blend Management
24	920	F31B0721	EP	30	3	EUR Protocols	Files	31B: Blend Management
25	920	F31B0730	LA	20	1	EUR Loss Assumptions	Files	31B: Blend Management
26	920	F31B0731	WS	20	1	EUR Wine Status Loss Assumptions	Files	31B: Blend Management
27	920	F31B0740	PA	51	1	Planning Assumptions	Files	31B: Blend Management
28	920	F31B0741	CC	22	1	EUR Cull and Cascade	Files	31B: Blend Management
29	920	F31B0750	OF	18	1	EUR Operation List Flag	Files	31B: Blend Management
30	920	F31B0751	OL	19	1	Operation List	Files	31B: Blend Management
31	920	F31B0760	CA	21	1	EUR Conversion Assumptions	Files	31B: Blend Management
32	920	F31B0770	BM	29	2	Brand Master	Files	31B: Blend Management
33	920	F31B0790	SV	41	1	Specification Validation	Files	31B: Blend Management
34	920	F31B07AG	AG	7	1	EUR Accounting Groups	Files	31B: Blend Management	Business Data
35	920	F31B08	TM	105	4	Tank Master	Files	31B: Blend Management
36	920	F31B0800	RE	19	3	F31B0800 Recalculation Error Handling	Files	31B: Blend Management
37	920	F31B10	VB	20	2	VBT Header	Files	31B: Blend Management
38	920	F31B100	BC	25	1	Bill Of Lading Composition Details	Files	31B: Blend Management	Business Data
39	920	F31B101	VD	25	4	VBT Detail	Files	31B: Blend Management
40	920	F31B103	UV	15	2	Unknown Vessel Master	Files	31B: Blend Management
41	920	F31B104	DP	21	2	Named Calculation User Default Paths	Files	31B: Blend Management
42	920	F31B105	PH	23	2	Named Calculation Path Header	Files	31B: Blend Management
43	920	F31B106	PD	19	2	Named Calculation Path Detail	Files	31B: Blend Management
44	920	F31B107	FH	23	2	Named Calculation Format Header	Files	31B: Blend Management
45	920	F31B108	FD	20	2	Named Calculation Format Detail	Files	31B: Blend Management
46	920	F31B109	NC	41	2	Blend Named Calculation	Files	31B: Blend Management
47	920	F31B11	WG	23	1	Work Group Master	Files	31B: Blend Management
48	920	F31B110	MB	112	1	Mass Barrel Update	Files	31B: Blend Management
49	920	F31B111	GS	19	2	Work Group Staff Allocation	Files	31B: Blend Management
50	920	F31B112	AA	16	2	Work Group Work Area Assignment	Files	31B: Blend Management
51	920	F31B114	TB	40	2	Trial Blend Header	Files	31B: Blend Management
52	920	F31B115	BD	34	7	Trial Blend Lot Details	Files	31B: Blend Management
53	920	F31B115W	LW	113	6	Trial Blend Input Lot Workfile	Files	31B: Blend Management
54	920	F31B116	CH	22	2	Temperature Conversion Chart Header	Files	31B: Blend Management
55	920	F31B117	CD	21	2	Temperature Conversion Chart Detail	Files	31B: Blend Management
56	920	F31B12	PA	29	2	Work Area Master	Files	31B: Blend Management
57	920	F31B120	HI	34	1	Vessel Inquiry Work File	Files	31B: Blend Management
58	920	F31B13	WC	55	1	Winery Constants	Files	31B: Blend Management
59	920	F31B130	CM	26	3	Container Master Table	Files	31B: Blend Management
60	920	F31B14	MC	23	1	WIM Constants	Files	31B: Blend Management
61	920	F31B15	TD	30	2	Setup Tank Dip Chart	Files	31B: Blend Management
62	920	F31B151	DC	11	5	Setup Tank Dip Chart Details	Files	31B: Blend Management
63	920	F31B17Z1	SZ	31	2	Operation EUR Transaction File	Files	31B: Blend Management
64	920	F31B18Z1	SZ	38	2	VBT Barrel Transaction File	Files	31B: Blend Management
65	920	F31B19Z1	SZ	51	2	Instructed Attributes Transaction File	Files	31B: Blend Management
66	920	F31B20	CC	7	1	Cost Components	Master Files	31B: Blend Management	Business Data
67	920	F31B21	CG	8	1	Cost Groups Header	Master Files	31B: Blend Management	Business Data
68	920	F31B211	CG	12	1	Cost Groups Detail	Master Files	31B: Blend Management	Business Data
69	920	F31B23	CR	7	1	GL Category Cost Group Cross Reference	Master Files	31B: Blend Management	Business Data
70	920	F31B25	TR	28	5	QA History Results Workfile	Files	31B: Blend Management
71	920	F31B31	WL	91	5	Blend Lot Master	Files	31B: Blend Management
72	920	F31B311	LC	25	9	Lot Composition	Files	31B: Blend Management
73	920	F31B314	LS	12	2	Lot Style	Files	31B: Blend Management
74	920	F31B315	LO	11	3	Lot Owners	Files	31B: Blend Management
75	920	F31B316	LE	11	4	Lot EUR	Files	31B: Blend Management
76	920	F31B317	LC	19	2	Lot Comments	Files	31B: Blend Management
77	920	F31B318	AC	15	1	Lot Accumulated Additives	Files	31B: Blend Management
78	920	F31B31C	BC	13	1	Blend Lot Costs	Master Files	31B: Blend Management	Business Data
79	920	F31B31Z1	SZ	36	7	Operations Composition Transaction File	Transaction Files	31B: Blend Management	Business Data
80	920	F31B32	WS	18	1	Wine Status	Files	31B: Blend Management
81	920	F31B33	OD	14	4	Operation Dependency	Files	31B: Blend Management
82	920	F31B33DC	DT	20	1	Dependency Chain Cache Structure	Files	31B: Blend Management
83	920	F31B33W	RW	11	2	Related TB Report Workfile	Files	31B: Blend Management
84	920	F31B34	ST	28	2	Style Definition	Files	31B: Blend Management
85	920	F31B341	SW	14	4	Style Invisible By Winery	Files	31B: Blend Management
86	920	F31B342	SA	16	2	Style Assigment	Files	31B: Blend Management
87	920	F31B343	BS	28	2	Barrel Style Definition	Files	31B: Blend Management
88	920	F31B34Z1	SZ	31	7	Operations Style Transaction File	Transaction Files	31B: Blend Management	Business Data
89	920	F31B35	OM	17	2	Owner Master	Files	31B: Blend Management
90	920	F31B37	GA	19	4	Geographic Area Master	Files	31B: Blend Management
91	920	F31B371	GR	15	6	Geographic Area Relationship	Files	31B: Blend Management
92	920	F31B372	GD	2	3	Growing Area Descendents	Files	31B: Blend Management
93	920	F31B373	GD	2	3	Appellation Descendents	Files	31B: Blend Management
94	920	F31B38	VR	23	2	Variety Master	Files	31B: Blend Management
95	920	F31B3CZ1	SZ	31	7	Operations Cost Transaction File	Transaction Files	31B: Blend Management	Business Data
96	920	F31B40	SA	22	2	Summary Attributes Definition File	Files	31B: Blend Management
97	920	F31B40W	QW	16	4	Summary Attributes Query Work File	Files	31B: Blend Management
98	920	F31B42	IN	16	2	Instructed Attributes Definition	Files	31B: Blend Management
99	920	F31B45	AT	34	2	Additive Templates	Files	31B: Blend Management
100	920	F31B46	CT	32	3	Consumable Templates	Files	31B: Blend Management
101	920	F31B50	BD	18	3	Blend ID Definition	Files	31B: Blend Management
102	920	F31B501	BS	3	1	Blend ID Sequence Numbers	Files	31B: Blend Management
103	920	F31B5100	AC	24	1	Wine Premises Report Attribute Table	Files	31B: Blend Management
104	920	F31B5101	WL	24	1	Wine Premises Report Line Definition	Files	31B: Blend Management
105	920	F31B5102	WC	28	2	Wine Premises Report Configuration	Files	31B: Blend Management
106	920	F31B5103	AD	29	2	Wine Premises Report Operation Detail	Files	31B: Blend Management
107	920	F31B5120	WP	40	1	Wine Premises Report Preview	Files	31B: Blend Management
108	920	F31B52Z1	SZ	31	7	Operations Equipment Transaction File	Transaction Files	31B: Blend Management	Business Data
109	920	F31B53Z1	SZ	32	7	Operations Consumables Transaction File	Transaction Files	31B: Blend Management	Business Data
110	920	F31B60	OT	100	1	Operation Trace Track Workfile	Files	31B: Blend Management
111	920	F31B61	EL	76	1	End Wine Lots Workfile	Files	31B: Blend Management
112	920	F31B62	SS	47	1	Sample Search Work Table	Files	31B: Blend Management
113	920	F31B65	OH	64	8	Operation Header	Files	31B: Blend Management
114	920	F31B65Z1	SZ	99	8	Operations Transaction File	Transaction Files	31B: Blend Management	Business Data
115	920	F31B66	BT	59	2	Blend Transactions	Master Files	31B: Blend Management	Business Data
116	920	F31B66B	AO	18	1	Blend As Of Balance	Files	31B: Blend Management
117	920	F31B67	QA	17	2	Quality Assignments	Files	31B: Blend Management	Business Data
118	920	F31B68	RO	10	1	Reversed Operations	Files	31B: Blend Management
119	920	F31B70	VA	49	4	Operation Vessel Assignments	Files	31B: Blend Management
120	920	F31B71	VV	26	3	Operation - Vessel to Vessel Detail	Files	31B: Blend Management
121	920	F31B72	VD	20	1	Operation Vessel Dips	Files	31B: Blend Management
122	920	F31B73	BC	67	2	Base Operation Configuration.	Files	31B: Blend Management
123	920	F31B74	WM	8	2	Operation Workflow Status Mapping	Files	31B: Blend Management
124	920	F31B75	OC	130	2	Operation Configuration	Files	31B: Blend Management
125	920	F31B751	OA	78	1	Operation Configuration for Vessel Attributes	Files	31B: Blend Management
126	920	F31B75C	CG	13	1	Configured Op Cost Groups by Winery	Files	31B: Blend Management
127	920	F31B76	VW	14	2	Wineries for Configured Operation	Files	31B: Blend Management
128	920	F31B77	VM	14	2	Material Types for Configured Operation	Files	31B: Blend Management
129	920	F31B78	WS	15	2	Wine Statuses for Configured Operation	Files	31B: Blend Management
130	920	F31B79	DS	18	2	Default Styles for Operation Configuration	Files	31B: Blend Management
131	920	F31B80	LC	18	2	Default Lot Comments for Configured Operation	Files	31B: Blend Management
132	920	F31B81	VT	15	2	Vessel Types for Configured Operation	Files	31B: Blend Management
133	920	F31B82	VE	13	2	Equipment Types for Configured Operation	Files	31B: Blend Management
134	920	F31B84	OA	25	2	Operation Additives	Files	31B: Blend Management
135	920	F31B85	WT	75	4	Weigh Tag Master	Files	31B: Blend Management
136	920	F31B87	LO	43	1	List of Operations View Work File	Files	31B: Blend Management
137	920	F31B88	IV	107	1	Inventory By Vessel Workfile	Files	31B: Blend Management
138	920	F31B90	QA	12	1	QA for Operation Configuration	Files	31B: Blend Management	Business Data
139	920	F31B91	BL	65	3	Bill Of Lading Master	Files	31B: Blend Management	Business Data
140	920	F31B922	PL	11	1	Permission List Definition	Files	31B: Blend Management
141	920	F31B93	WH	38	3	Work Order Header	Files	31B: Blend Management	Business Data
142	920	F31B93Z1	SZ	38	7	WIM Work Order Transaction File	Transaction Files	31B: Blend Management	Business Data
143	920	F31B95	OV	13	1	QA Test Result Blend Override for Operation Configuration	Files	31B: Blend Management	Business Data
144	920	F31B96	BD	21	1	Bill Of Lading Details	Files	31B: Blend Management	Business Data
145	920	F31B97	HR	22	1	Human Resource Assignments	Files	31B: Blend Management	Business Data
146	920	F31B97Z1	SZ	30	7	Operations Resource Transaction File	Transaction Files	31B: Blend Management	Business Data
147	920	F31B98	BM	31	2	Bottling Master	Files	31B: Blend Management	Business Data
148	920	F31B99	DD	18	1	Decant Detail	Files	31B: Blend Management	Business Data
149	920	F31BAAI	BL	15	1	Blend Automatic Accounting Instructions	Master Files	31B: Blend Management	Business Data
150	920	F31BQAZ1	SZ	37	7	Operations Quality Test Transaction File	Transaction Files	31B: Blend Management	Business Data
151	920	F31BSPZ1	ST	45	3	Sample Transactions	Files	31B: Blend Management

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

151 tables920 | 31B