	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

91 COLUMNS | 5 INDEXES | 812 | 31B | F31B31 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	812	F31B31	WL	91	5	Blend Lot Master	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 WLMCU, WLWLOTN, WLWBID, WLWBIDAPP, WLAWBID, WLLTQNTY, WLLTUOM, WLLTSTAT, WLMATYP, WLWISSC, WLSRVGAV, WLSRVGAP, WLOPRGAV, WLOPRGAP, WLLOTYLD, WLCUMYLD, WLSATTN1, WLSATTN2, WLSATTN3, WLSATTN4, WLSATTN5, WLSATTN6, WLSATTN7, WLSATTN8, WLSATTN9, WLSATTN10, WLSATTN11, WLSATTN12, WLSATTN13, WLSATTN14, WLSATTN15, WLSATTS16, WLSATTS17, WLSATTS18, WLSATTS19, WLSATTS20, WLSATTS21, WLSATTS22, WLSATTS23, WLSATTS24, WLSATTS25, WLINATTN1, WLINATTN2, WLINATTN3, WLINATTN4, WLINATTS5, WLINATTS6, WLINATTS7, WLINATTS8, WLINATTD9, WLINATTD10, WLINATTD11, WLINATTD12, WLDECLOV, WLSAMLOV, WLMATOVR, WLWSOVR, WLINATOVR1, WLINATOVR2, WLINATOVR3, WLINATOVR4, WLINATOVR5, WLINATOVR6, WLINATOVR7, WLINATOVR8, WLINATOVR9, WLINAOVR10, WLINAOVR11, WLINAOVR12, WLEUROVR, WLOWNOVR, WLLTCMTOVR, WLVLI, WLWRF, WLWCD, WLWAB, WLWNUM, WLWMDT, WLURCD, WLURDT, WLURAT, WLURRF, WLURAB, WLUSER, WLPID, WLJOBN, WLUPMJ, WLUPMT, WLBIDOVR, WLWERCS, WLWOVC FROM F31B31

TOP 812 | 31B | F31B31 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
2	WLWLOTN	Blend Lot Number	String	Generic Edit	30	0	Allow NULL?
3	WLWBID	Blend ID	String	Generic Edit	30	0	Allow NULL?
4	WLWBIDAPP	Blend ID Approved	Character	Generic Edit	1	0	Allow NULL?
5	WLAWBID	Alternate Blend ID	String	Generic Edit	30	0	Allow NULL?
6	WLLTQNTY	Blend Lot Quantity	Numeric	Generic Edit	15	4	Allow NULL?
7	WLLTUOM	Blend Lot Unit of Measure	String	Generic Edit	3	0	Allow NULL?
8	WLLTSTAT	Blend Lot Status	String	UDC (31B WF)	10	0	Allow NULL?
9	WLMATYP	Material Type Code	String	Generic Edit	4	0	Allow NULL?
10	WLWISSC	Wine Status Short Code	String	Generic Edit	6	0	Allow NULL?
11	WLSRVGAV	Survey Gain Volume	Numeric	Generic Edit	15	4	Allow NULL?
12	WLSRVGAP	Survey Gain Percentage	Numeric	Generic Edit	15	4	Allow NULL?
13	WLOPRGAV	Operation Gain Quantity	Numeric	Generic Edit	15	4	Allow NULL?
14	WLOPRGAP	Operation Gain Percentage	Numeric	Generic Edit	15	4	Allow NULL?
15	WLLOTYLD	Lot Yield Percentage	Numeric	Generic Edit	15	4	Allow NULL?
16	WLCUMYLD	Cumulative Lot Yield	Numeric	Generic Edit	15	4	Allow NULL?
17	WLSATTN1	Summary Attribute 1	Numeric	Generic Edit	15	4	Allow NULL?
18	WLSATTN2	Summary Attribute 2	Numeric	Generic Edit	15	4	Allow NULL?
19	WLSATTN3	Summary Attribute 3	Numeric	Generic Edit	15	4	Allow NULL?
20	WLSATTN4	Summary Attribute 4	Numeric	Generic Edit	15	4	Allow NULL?
21	WLSATTN5	Summary Attribute 5	Numeric	Generic Edit	15	4	Allow NULL?
22	WLSATTN6	Summary Attribute 6	Numeric	Generic Edit	15	4	Allow NULL?
23	WLSATTN7	Summary Attribute 7	Numeric	Generic Edit	15	4	Allow NULL?
24	WLSATTN8	Summary Attribute 8	Numeric	Generic Edit	15	4	Allow NULL?
25	WLSATTN9	Summary Attribute 9	Numeric	Generic Edit	15	4	Allow NULL?
26	WLSATTN10	Summary Attribute 10	Numeric	Generic Edit	15	4	Allow NULL?
27	WLSATTN11	Summary Attribute 11	Numeric	Generic Edit	15	4	Allow NULL?
28	WLSATTN12	Summary Attribute 12	Numeric	Generic Edit	15	4	Allow NULL?
29	WLSATTN13	Summary Attribute 13	Numeric	Generic Edit	15	4	Allow NULL?
30	WLSATTN14	Summary Attribute 14	Numeric	Generic Edit	15	4	Allow NULL?
31	WLSATTN15	Summary Attribute 15	Numeric	Generic Edit	15	4	Allow NULL?
32	WLSATTS16	Summary Attribute 16	String	Generic Edit	20	0	Allow NULL?
33	WLSATTS17	Summary Attribute 17	String	Generic Edit	20	0	Allow NULL?
34	WLSATTS18	Summary Attribute 18	String	Generic Edit	20	0	Allow NULL?
35	WLSATTS19	Summary Attribute 19	String	Generic Edit	20	0	Allow NULL?
36	WLSATTS20	Summary Attribute 20	String	Generic Edit	20	0	Allow NULL?
37	WLSATTS21	Summary Attribute 21	String	Generic Edit	20	0	Allow NULL?
38	WLSATTS22	Summary Attribute 22	String	Generic Edit	20	0	Allow NULL?
39	WLSATTS23	Summary Attribute 23	String	Generic Edit	20	0	Allow NULL?
40	WLSATTS24	Summary Attribute 24	String	Generic Edit	20	0	Allow NULL?
41	WLSATTS25	Summary Attribute 25	String	Generic Edit	20	0	Allow NULL?
42	WLINATTN1	Instructed Attribute 1	Numeric	Generic Edit	15	4	Allow NULL?
43	WLINATTN2	Instructed Attribute 2	Numeric	Generic Edit	15	4	Allow NULL?
44	WLINATTN3	Instructed Attribute 3	Numeric	Generic Edit	15	4	Allow NULL?
45	WLINATTN4	Instructed Attribute 4	Numeric	Generic Edit	15	4	Allow NULL?
46	WLINATTS5	Instructed Attribute 5	String	Generic Edit	20	0	Allow NULL?
47	WLINATTS6	Instructed Attribute 6	String	Generic Edit	20	0	Allow NULL?
48	WLINATTS7	Instructed Attribute 7	String	Generic Edit	20	0	Allow NULL?
49	WLINATTS8	Instructed Attribute 8	String	Generic Edit	20	0	Allow NULL?
50	WLINATTD9	Instructed Attribute 9	Date	Generic Edit	6	0
51	WLINATTD10	Instructed Attribute 10	Date	Generic Edit	6	0
52	WLINATTD11	Instructed Attribute 11	Date	Generic Edit	6	0
53	WLINATTD12	Instructed Attribute 12	Date	Generic Edit	6	0
54	WLDECLOV	Declared Loss Quantity	Numeric	Generic Edit	15	4	Allow NULL?
55	WLSAMLOV	Sample Loss Volume	Numeric	Generic Edit	15	4	Allow NULL?
56	WLMATOVR	Material Type Override	Character	Generic Edit	1	0	Allow NULL?
57	WLWSOVR	Wine Status Override	Character	Generic Edit	1	0	Allow NULL?
58	WLINATOVR1	Instructed Attribute Override1	Character	Generic Edit	1	0	Allow NULL?
59	WLINATOVR2	Instructed Attribute Override2	Character	Generic Edit	1	0	Allow NULL?
60	WLINATOVR3	Instructed Attribute Override3	Character	Generic Edit	1	0	Allow NULL?
61	WLINATOVR4	Instructed Attribute Override4	Character	Generic Edit	1	0	Allow NULL?
62	WLINATOVR5	Instructed Attribute Override5	Character	Generic Edit	1	0	Allow NULL?
63	WLINATOVR6	Instructed Attribute Override6	Character	Generic Edit	1	0	Allow NULL?
64	WLINATOVR7	Instructed Attribute Override7	Character	Generic Edit	1	0	Allow NULL?
65	WLINATOVR8	Instructed Attribute Override8	Character	Generic Edit	1	0	Allow NULL?
66	WLINATOVR9	Instructed Attribute Override9	Character	Generic Edit	1	0	Allow NULL?
67	WLINAOVR10	Instructed Attribute Override10	Character	Generic Edit	1	0	Allow NULL?
68	WLINAOVR11	Instructed Attribute Override11	Character	Generic Edit	1	0	Allow NULL?
69	WLINAOVR12	Instructed Attribute Override12	Character	Generic Edit	1	0	Allow NULL?
70	WLEUROVR	EUR Override	Character	Generic Edit	1	0	Allow NULL?
71	WLOWNOVR	Owner Override	Character	Generic Edit	1	0	Allow NULL?
72	WLLTCMTOVR	Lot Comment Override	Character	Generic Edit	1	0	Allow NULL?
73	WLVLI	Virtual Lot Indicator	Character	UDC (31B VL)	1	0	Allow NULL?
74	WLWRF	Blend Mgmt Reference	String	Generic Edit	30	0	Allow NULL?
75	WLWCD	Blend Mgmt Code	String	Generic Edit	3	0	Allow NULL?
76	WLWAB	Blend Mgmt Number	Numeric	Generic Edit	8	0	Allow NULL?
77	WLWNUM	Blend Mgmt Numeric	Numeric	Generic Edit	15	4	Allow NULL?
78	WLWMDT	Blend Mgmt Date	Date	Generic Edit	6	0
79	WLURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
80	WLURDT	User Reserved Date	Date	Generic Edit	6	0
81	WLURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
82	WLURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
83	WLURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
84	WLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
85	WLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
86	WLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
87	WLUPMJ	Date - Updated	Date	Generic Edit	6	0
88	WLUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
89	WLBIDOVR	Blend ID Override	Character	Generic Edit	1	0	Allow NULL?
90	WLWERCS	Recalculation Operation Lot Status	Character	Generic Edit	1	0	Allow NULL?
91	WLWOVC	Composition Override	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 31B | F31B31 INDEXES

Number

Description

MCU LotNumber (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	WLOTN	Blend Lot Number	Ascending

WineStatus

Element	Alias	Description	Sequence
1	WISSC	Wine Status Short Code	Ascending

MatlType

Element	Alias	Description	Sequence
1	MATYP	Material Type Code	Ascending

Blend Lot Number

Element	Alias	Description	Sequence
1	WLOTN	Blend Lot Number	Ascending

VLI MCU

Element	Alias	Description	Sequence
1	VLI	Virtual Lot Indicator	Ascending
2	MCU	Business Unit	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

91 COLUMNS | 5 INDEXES | 812 | 31B | F31B31 TABLE

TOP 812 | 31B | F31B31 COLUMNS

TOP 812 | 31B | F31B31 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

91 COLUMNS | 5 INDEXES | 812 | 31B | F31B31 TABLE

TOP812 | 31B | F31B31 COLUMNS

TOP812 | 31B | F31B31 INDEXES

TOP 812 | 31B | F31B31 COLUMNS

TOP 812 | 31B | F31B31 INDEXES