	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

116 COLUMNS | 5 INDEXES | 812 | 31B | F31B03 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	812	F31B03	BM	116	5	Barrel Master Table	Files	31B: Blend Management

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT BMBATP, BMBATV, BMBPCO, BMMCU, BMBARID, BMBARCN, BMVBID, BMIDNOFR, BMRKNUM, BMIDMTHD, BMLOCN, BMWODOC, BMCTRO, BMOLOC, BMBCST, BMRECY, BMOYRC, BMBARCO, BMPOWN, BMSUPL, BMCPNUM, BMFORES, BMTLEV, BMTSTH, BMTOCAP, BMBCUOM, BMFCAP, BMNUMHP, BMSCTM, BMSTAVT, BMSDRM, BMSBDM, BMSDRL, BMSDDR, BMBSMK, BMGRAIN, BMBNMS, BMBAVC, BMAJRS, BMDAOS, BMBVST, BMSHAV, BMSHAVD, BMSHAVB, BMTSTR, BMDAFU, BMCUSE, BMNXUSE, BMNUMFL, BMMTDLT, BMDALT, BMDALS, BMBOWN, BMLEAS, BMLESTM, BMLESDT, BMLESDN, BMLESCO, BMLESCN, BMANUMW, BMWBPO, BMBRLC, BMIUOM, BMINUM, BMINSU, BMINLG, BMINWD, BMINHG, BMINGR, BMINQT, BMINTS, BMINFO, BMINMS, BMINUS, BMSYAR, BMINOO, BMISAR, BMIUMSA, BMISVR, BMDAFC, BMINSF, BMQTOR, BMQTRC, BMQTCU, BMURAT, BMURCD, BMURDT, BMURAB, BMURRF, BMUSER, BMDTE, BMTDAY, BMUPMJ, BMUPMT, BMJOBN, BMMKEY, BMPID, BMGECM, BMLDREF, BMBRLNUM, BMBPDESC, BMBRLCLA, BMRKNMR, BMSHAVEBY, BMWOTC, BMWRF, BMWCD, BMWAB, BMWNUM, BMWMDT, BMNXTUSEID, BMCURUSEID, BMWCG, BMCOOP, BMWCTRO, BMWVID FROM F31B03

TOP 812 | 31B | F31B03 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	BMBATP	Barrel Type	String	UDC (31B BT)	4	0	Allow NULL?
2	BMBATV	Barrel Type Variation	String	UDC (31B BV)	2	0	Allow NULL?
3	BMBPCO	Barrel Profile Code	String	Generic Edit	12	0	Allow NULL?
4	BMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
5	BMBARID	Barrel ID	String	Generic Edit	30	0	Allow NULL?
6	BMBARCN	Barrel Collection Number	Numeric	Generic Edit	6	0	Allow NULL?
7	BMVBID	Virtual Barrel ID	Numeric	Generic Edit	10	0	Allow NULL?
8	BMIDNOFR	ID Number From	Numeric	Generic Edit	6	0	Allow NULL?
9	BMRKNUM	Barrel Age	Numeric	Generic Edit	8	0	Allow NULL?
10	BMIDMTHD	ID Method	String	Generic Edit	6	0	Allow NULL?
11	BMLOCN	Location	String	Generic Edit	20	0	Allow NULL?
12	BMWODOC	Original Document Wine	Numeric	Generic Edit	8	0	Allow NULL?
13	BMCTRO	OriginCountry	String	UDC (00 CN)	3	0	Allow NULL?
14	BMOLOC	Origin Locality	String	UDC (31B OL)	6	0	Allow NULL?
15	BMBCST	Barrel Color Status	String	UDC (31B CB)	10	0	Allow NULL?
16	BMRECY	Year Received	Numeric	Generic Edit	4	0	Allow NULL?
17	BMOYRC	Other Year Code	Numeric	Generic Edit	4	0	Allow NULL?
18	BMBARCO	Barrel Condition	Character	UDC (31B BC)	1	0	Allow NULL?
19	BMPOWN	Previous Owner	Numeric	Generic Edit	8	0	Allow NULL?
20	BMSUPL	Blend Supplier	Numeric	Generic Edit	8	0	Allow NULL?
21	BMCPNUM	Cooper Number	Numeric	Generic Edit	8	0	Allow NULL?
22	BMFORES	Forest	String	UDC (31B FO)	8	0	Allow NULL?
23	BMTLEV	Toast Level	String	UDC (31B TL)	3	0	Allow NULL?
24	BMTSTH	Barrel Head Toast	Character	UDC (31B HT)	1	0	Allow NULL?
25	BMTOCAP	Barrel Total Capacity	Numeric	Generic Edit	15	4	Allow NULL?
26	BMBCUOM	Barrel Capacity UOM	String	UDC (31B UM)	2	0	Allow NULL?
27	BMFCAP	Fermentation Capacity	Numeric	Generic Edit	15	4	Allow NULL?
28	BMNUMHP	Number of Hoops	Numeric	Generic Edit	2	0	Allow NULL?
29	BMSCTM	Barrel Category Code 1	String	UDC (31B R1)	10	0	Allow NULL?
30	BMSTAVT	Stave Thickness	Numeric	Generic Edit	3	1	Allow NULL?
31	BMSDRM	Barrel Category Code 2	String	UDC (31B R2)	10	0	Allow NULL?
32	BMSBDM	Barrel Category Code 3	String	UDC (31B R3)	10	0	Allow NULL?
33	BMSDRL	Barrel Category Code 4	String	UDC (31B R4)	20	0	Allow NULL?
34	BMSDDR	Stave Dry Date	Date	Generic Edit	6	0
35	BMBSMK	Barrel Smoke	String	Generic Edit	8	0	Allow NULL?
36	BMGRAIN	Stave - Grain	String	Generic Edit	3	0	Allow NULL?
37	BMBNMS	Barrel Number Months Seasoned	Numeric	Generic Edit	2	0	Allow NULL?
38	BMBAVC	Barrel Availability Code	String	UDC (31B AC)	4	0	Allow NULL?
39	BMAJRS	Adjustment Reason Code	String	UDC (31B RC)	20	0	Allow NULL?
40	BMDAOS	Date Out of Service	Date	Generic Edit	6	0
41	BMBVST	Barrel Volume Status	String	UDC (31B VS)	3	0	Allow NULL?
42	BMSHAV	Barrel Shaved	Character	UDC (31B SH)	1	0	Allow NULL?
43	BMSHAVD	Shave Date	Date	Generic Edit	8	0
44	BMSHAVB	Shaved By	String	Generic Edit	8	0	Allow NULL?
45	BMTSTR	Toast Rework	Character	Generic Edit	1	0	Allow NULL?
46	BMDAFU	Date First Use	Date	Generic Edit	8	0
47	BMCUSE	Current Use	String	UDC (31B CU)	4	0	Allow NULL?
48	BMNXUSE	Next Use	String	UDC (31B NU)	4	0	Allow NULL?
49	BMNUMFL	Number of Fills	Numeric	Generic Edit	4	0	Allow NULL?
50	BMMTDLT	Method Last Treatment	String	UDC (31B LT)	8	0	Allow NULL?
51	BMDALT	Date Last Treatment	Date	Generic Edit	8	0
52	BMDALS	Date Last Sulfur	Date	Generic Edit	8	0
53	BMBOWN	Barrel Owner	Numeric	Generic Edit	8	0	Allow NULL?
54	BMLEAS	Leased YN	Character	UDC (31B LS)	1	0	Allow NULL?
55	BMLESTM	Lease Term	Numeric	Generic Edit	3	0	Allow NULL?
56	BMLESDT	Lease Date	Date	Generic Edit	8	0
57	BMLESDN	Lease Document Number	Numeric	Generic Edit	8	0	Allow NULL?
58	BMLESCO	Leasing Company	Numeric	Generic Edit	8	0	Allow NULL?
59	BMLESCN	Leasing Company Name	String	Generic Edit	30	0	Allow NULL?
60	BMANUMW	Asset Number Wine	Numeric	Generic Edit	8	0	Allow NULL?
61	BMWBPO	Barrel Purchase Order	Numeric	Generic Edit	8	0	Allow NULL?
62	BMBRLC	Barrel Receiving Location	String	Generic Edit	20	0	Allow NULL?
63	BMIUOM	Insert Unit of Measure	String	UDC (31B UM)	2	0	Allow NULL?
64	BMINUM	Insert Number	Numeric	Generic Edit	10	0	Allow NULL?
65	BMINSU	Insert Supplier	Numeric	Generic Edit	8	0	Allow NULL?
66	BMINLG	InsertLength	Numeric	Generic Edit	10	1	Allow NULL?
67	BMINWD	InsertWidth	Numeric	Generic Edit	10	1	Allow NULL?
68	BMINHG	InsertHeight	Numeric	Generic Edit	10	1	Allow NULL?
69	BMINGR	Insert Grain	String	Generic Edit	3	0	Allow NULL?
70	BMINQT	Insert Quantity	Numeric	Generic Edit	4	0	Allow NULL?
71	BMINTS	Insert Toast	String	Generic Edit	2	0	Allow NULL?
72	BMINFO	Barrel Category Code 5	String	UDC (31B R5)	10	0	Allow NULL?
73	BMINMS	Insert Number Months Seasoned	Numeric	Generic Edit	2	0	Allow NULL?
74	BMINUS	Insert Number Uses	Numeric	Generic Edit	4	0	Allow NULL?
75	BMSYAR	System Arrangement	String	Generic Edit	3	0	Allow NULL?
76	BMINOO	Insert Oak Origin	String	Generic Edit	20	0	Allow NULL?
77	BMISAR	Insert Surface Area	Numeric	Generic Edit	8	1	Allow NULL?
78	BMIUMSA	Unit of Measure - Insert Surface Area	String	UDC (31B UM)	2	0	Allow NULL?
79	BMISVR	Insert Surface Area to Volume Ratio	Numeric	Generic Edit	4	3	Allow NULL?
80	BMDAFC	Date First Commissioned	Date	Generic Edit	8	0
81	BMINSF	Insert Flag	Character	Generic Edit	1	0	Allow NULL?
82	BMQTOR	Quantity - Original	Numeric	Generic Edit	15	4	Allow NULL?
83	BMQTRC	Quantity - Received	Numeric	Generic Edit	15	4	Allow NULL?
84	BMQTCU	Quantity - Current	Numeric	Generic Edit	15	4	Allow NULL?
85	BMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
86	BMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
87	BMURDT	User Reserved Date	Date	Generic Edit	6	0
88	BMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
89	BMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
90	BMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
91	BMDTE	Date	Date	Generic Edit	6	0
92	BMTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
93	BMUPMJ	Date - Updated	Date	Generic Edit	6	0
94	BMUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
95	BMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
96	BMMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
97	BMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
98	BMGECM	General Comments	String	Generic Edit	40	0	Allow NULL?
99	BMLDREF	Lease Document Reference	String	Generic Edit	40	0	Allow NULL?
100	BMBRLNUM	Barrel Number	Numeric	Generic Edit	8	0	Allow NULL?
101	BMBPDESC	Barrel Profile Description	String	Generic Edit	40	0	Allow NULL?
102	BMBRLCLA	Barrel Classification	String	UDC (31B CL)	2	0	Allow NULL?
103	BMRKNMR	Rack Number	String	Generic Edit	20	0	Allow NULL?
104	BMSHAVEBY	Shave By	Numeric	Generic Edit	8	0	Allow NULL?
105	BMWOTC	One-Time Cost	Character	Generic Edit	1	0	Allow NULL?
106	BMWRF	Blend Mgmt Reference	String	Generic Edit	30	0	Allow NULL?
107	BMWCD	Blend Mgmt Code	String	Generic Edit	3	0	Allow NULL?
108	BMWAB	Blend Mgmt Number	Numeric	Generic Edit	8	0	Allow NULL?
109	BMWNUM	Blend Mgmt Numeric	Numeric	Generic Edit	15	4	Allow NULL?
110	BMWMDT	Blend Mgmt Date	Date	Generic Edit	6	0
111	BMNXTUSEID	Next Use EUR ID	Numeric	Generic Edit	10	0	Allow NULL?
112	BMCURUSEID	Current Use EUR ID	Numeric	Generic Edit	10	0	Allow NULL?
113	BMWCG	Cost Group	String	Generic Edit	12	0	Allow NULL?
114	BMCOOP	Cooper	String	UDC (31B CP)	3	0	Allow NULL?
115	BMWCTRO	Country	String	UDC (31B CN)	3	0	Allow NULL?
116	BMWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?

TOP 812 | 31B | F31B03 INDEXES

Number

Description

BarrelProfile MCU

Element	Alias	Description	Sequence
1	BPCO	Barrel Profile Code	Ascending
2	MCU	Business Unit	Ascending

BranchPlant

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

BarrelID (Unique)

Element	Alias	Description	Sequence
1	BARID	Barrel ID	Ascending

BarrelType MCU

Element	Alias	Description	Sequence
1	BATP	Barrel Type	Ascending
2	MCU	Business Unit	Ascending
3	BAVC	Barrel Availability Code	Ascending

BarrelNum (Primary/Unique)

Element	Alias	Description	Sequence
1	BRLNUM	Barrel Number	Ascending

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

116 COLUMNS | 5 INDEXES | 812 | 31B | F31B03 TABLE

TOP 812 | 31B | F31B03 COLUMNS

TOP 812 | 31B | F31B03 INDEXES

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

116 COLUMNS | 5 INDEXES | 812 | 31B | F31B03 TABLE

TOP812 | 31B | F31B03 COLUMNS

TOP812 | 31B | F31B03 INDEXES

TOP 812 | 31B | F31B03 COLUMNS

TOP 812 | 31B | F31B03 INDEXES