	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

147 tables812 | 31B

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

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

147 tables812 | 31B