	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

80 COLUMNS | 3 INDEXES | 920 | 31B | F31B03E TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	920	F31B03E	BE	80	3	Barrel Inquiry Work File	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 BEUKID, BEMCU, BEBRLNUM, BEBVST, BELOCN, BERKNUM, BEBATP, BENUMFL, BEWOPID, BETLEV, BETSTH, BEBCST, BEFORES, BEPOWN, BELDREF, BEWBPO, BERKNMR, BERECY, BEWVID, BEWBID, BEWISSC, BEMATYP, BESATTN1, BESATTN2, BESATTN3, BESATTN4, BESATTN5, BESATTN6, BESATTN7, BESATTN8, BESATTN9, BESATTN10, BESATTN11, BESATTN12, BESATTN13, BESATTN14, BESATTN15, BESATTS16, BESATTS17, BESATTS18, BESATTS19, BESATTS20, BESATTS21, BESATTS22, BESATTS23, BESATTS24, BESATTS25, BEINATTN1, BEINATTN2, BEINATTN3, BEINATTN4, BEINATTS5, BEINATTS6, BEINATTS7, BEINATTS8, BEINATTD9, BEINATTD10, BEINATTD11, BEINATTD12, BEWLOTN, BEBARID, BEWOPST, BEWAEDT, BEWASDT, BEBOWN, BEWOPN, BEVBTN, BEWSDT, BEWEDT, BEVBID, BECOOP, BEWCTRO, BECAPTYP, BETOCAP, BEFCAP, BEBAVC, BEWV2VLNID, BEBIDSEQ, BEDL01, BEDSCSMT FROM F31B03E

TOP 920 | 31B | F31B03E COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	BEUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	BEMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	BEBRLNUM	Barrel Number	Numeric	Generic Edit	8	0	Allow NULL?
4	BEBVST	Barrel Volume Status	String	UDC (31B VS)	3	0	Allow NULL?
5	BELOCN	Location	String	Generic Edit	20	0	Allow NULL?
6	BERKNUM	Barrel Age	Numeric	Generic Edit	8	0	Allow NULL?
7	BEBATP	Barrel Type	String	UDC (31B BT)	4	0	Allow NULL?
8	BENUMFL	Number of Fills	Numeric	Generic Edit	4	0	Allow NULL?
9	BEWOPID	Operation ID	Integer	Generic Edit	11	0	Allow NULL?
10	BETLEV	Toast Level	String	UDC (31B TL)	3	0	Allow NULL?
11	BETSTH	Barrel Head Toast	Character	UDC (31B HT)	1	0	Allow NULL?
12	BEBCST	Barrel Color Status	String	UDC (31B CB)	10	0	Allow NULL?
13	BEFORES	Forest	String	UDC (31B FO)	8	0	Allow NULL?
14	BEPOWN	Previous Owner	Numeric	Generic Edit	8	0	Allow NULL?
15	BELDREF	Lease Document Reference	String	Generic Edit	40	0	Allow NULL?
16	BEWBPO	Barrel Purchase Order	Numeric	Generic Edit	8	0	Allow NULL?
17	BERKNMR	Rack Number	String	Generic Edit	20	0	Allow NULL?
18	BERECY	Year Received	Numeric	Generic Edit	4	0	Allow NULL?
19	BEWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
20	BEWBID	Blend ID	String	Generic Edit	30	0	Allow NULL?
21	BEWISSC	Wine Status	String	Generic Edit	6	0	Allow NULL?
22	BEMATYP	Material Type Code	String	Generic Edit	4	0	Allow NULL?
23	BESATTN1	Summary Attribute 1	Numeric	Generic Edit	15	4	Allow NULL?
24	BESATTN2	Summary Attribute 2	Numeric	Generic Edit	15	4	Allow NULL?
25	BESATTN3	Summary Attribute 3	Numeric	Generic Edit	15	4	Allow NULL?
26	BESATTN4	Summary Attribute 4	Numeric	Generic Edit	15	4	Allow NULL?
27	BESATTN5	Summary Attribute 5	Numeric	Generic Edit	15	4	Allow NULL?
28	BESATTN6	Summary Attribute 6	Numeric	Generic Edit	15	4	Allow NULL?
29	BESATTN7	Summary Attribute 7	Numeric	Generic Edit	15	4	Allow NULL?
30	BESATTN8	Summary Attribute 8	Numeric	Generic Edit	15	4	Allow NULL?
31	BESATTN9	Summary Attribute 9	Numeric	Generic Edit	15	4	Allow NULL?
32	BESATTN10	Summary Attribute 10	Numeric	Generic Edit	15	4	Allow NULL?
33	BESATTN11	Summary Attribute 11	Numeric	Generic Edit	15	4	Allow NULL?
34	BESATTN12	Summary Attribute 12	Numeric	Generic Edit	15	4	Allow NULL?
35	BESATTN13	Summary Attribute 13	Numeric	Generic Edit	15	4	Allow NULL?
36	BESATTN14	Summary Attribute 14	Numeric	Generic Edit	15	4	Allow NULL?
37	BESATTN15	Summary Attribute 15	Numeric	Generic Edit	15	4	Allow NULL?
38	BESATTS16	Summary Attribute 16	String	Generic Edit	20	0	Allow NULL?
39	BESATTS17	Summary Attribute 17	String	Generic Edit	20	0	Allow NULL?
40	BESATTS18	Summary Attribute 18	String	Generic Edit	20	0	Allow NULL?
41	BESATTS19	Summary Attribute 19	String	Generic Edit	20	0	Allow NULL?
42	BESATTS20	Summary Attribute 20	String	Generic Edit	20	0	Allow NULL?
43	BESATTS21	Summary Attribute 21	String	Generic Edit	20	0	Allow NULL?
44	BESATTS22	Summary Attribute 22	String	Generic Edit	20	0	Allow NULL?
45	BESATTS23	Summary Attribute 23	String	Generic Edit	20	0	Allow NULL?
46	BESATTS24	Summary Attribute 24	String	Generic Edit	20	0	Allow NULL?
47	BESATTS25	Summary Attribute 25	String	Generic Edit	20	0	Allow NULL?
48	BEINATTN1	Instructed Attribute 1	Numeric	Generic Edit	15	4	Allow NULL?
49	BEINATTN2	Instructed Attribute 2	Numeric	Generic Edit	15	4	Allow NULL?
50	BEINATTN3	Instructed Attribute 3	Numeric	Generic Edit	15	4	Allow NULL?
51	BEINATTN4	Instructed Attribute 4	Numeric	Generic Edit	15	4	Allow NULL?
52	BEINATTS5	Instructed Attribute 5	String	Generic Edit	20	0	Allow NULL?
53	BEINATTS6	Instructed Attribute 6	String	Generic Edit	20	0	Allow NULL?
54	BEINATTS7	Instructed Attribute 7	String	Generic Edit	20	0	Allow NULL?
55	BEINATTS8	Instructed Attribute 8	String	Generic Edit	20	0	Allow NULL?
56	BEINATTD9	Instructed Attribute 9	Date	Generic Edit	6	0
57	BEINATTD10	Instructed Attribute 10	Date	Generic Edit	6	0
58	BEINATTD11	Instructed Attribute 11	Date	Generic Edit	6	0
59	BEINATTD12	Instructed Attribute 12	Date	Generic Edit	6	0
60	BEWLOTN	Blend Lot Number	String	Generic Edit	30	0	Allow NULL?
61	BEBARID	Barrel ID	String	Generic Edit	30	0	Allow NULL?
62	BEWOPST	Operation Status	String	UDC (31B WF)	10	0	Allow NULL?
63	BEWAEDT	WIM Actual End Date	JDE UTime	Generic Edit	11	0
64	BEWASDT	Actual Start Date	JDE UTime	Generic Edit	11	0
65	BEBOWN	Barrel Owner	Numeric	Generic Edit	8	0	Allow NULL?
66	BEWOPN	Operation Number	Numeric	Generic Edit	8	0	Allow NULL?
67	BEVBTN	Virtual Barrel Tank Number	String	Generic Edit	30	0	Allow NULL?
68	BEWSDT	Instructed Start Date	JDE UTime	Generic Edit	11	0
69	BEWEDT	Instructed End Date	JDE UTime	Generic Edit	11	0
70	BEVBID	Virtual Barrel ID	Numeric	Generic Edit	10	0	Allow NULL?
71	BECOOP	Cooper	String	UDC (31B CP)	3	0	Allow NULL?
72	BEWCTRO	Country	String	UDC (31B CN)	3	0	Allow NULL?
73	BECAPTYP	Barrel Capacity Type	Character	UDC (31B CT)	1	0	Allow NULL?
74	BETOCAP	Barrel Total Capacity	Numeric	Generic Edit	15	4	Allow NULL?
75	BEFCAP	Fermentation Capacity	Numeric	Generic Edit	15	4	Allow NULL?
76	BEBAVC	Barrel Availability Code	String	UDC (31B AC)	4	0	Allow NULL?
77	BEWV2VLNID	WIM Vessel to Vessel Line Number	Numeric	Generic Edit	6	0	Allow NULL?
78	BEBIDSEQ	BlendID Sequence Number	Numeric	Generic Edit	5	0	Allow NULL?
79	BEDL01	Description	String	Generic Edit	30	0	Allow NULL?
80	BEDSCSMT	Description of Material Type	String	Generic Edit	30	0	Allow NULL?

TOP 920 | 31B | F31B03E INDEXES

Number

Description

UKID BRLNUM WLOTN (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending
2	BRLNUM	Barrel Number	Ascending
3	WLOTN	Blend Lot Number	Ascending
4	BARID	Barrel ID	Ascending
5	MCU	Business Unit	Ascending
6	WOPID	Operation ID	Ascending
7	WVID	Vessel ID	Ascending
8	WV2VLNID	WIM Vessel to Vessel Line Number	Ascending
9	BIDSEQ	BlendID Sequence Number	Ascending

BRLNUM WASDT

Element	Alias	Description	Sequence
1	BRLNUM	Barrel Number	Ascending
2	WASDT	Actual Start Date	Descending

BarrelID

Element	Alias	Description	Sequence
1	BARID	Barrel ID	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

80 COLUMNS | 3 INDEXES | 920 | 31B | F31B03E TABLE

TOP 920 | 31B | F31B03E COLUMNS

TOP 920 | 31B | F31B03E 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

80 COLUMNS | 3 INDEXES | 920 | 31B | F31B03E TABLE

TOP920 | 31B | F31B03E COLUMNS

TOP920 | 31B | F31B03E INDEXES

TOP 920 | 31B | F31B03E COLUMNS

TOP 920 | 31B | F31B03E INDEXES