	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

110 COLUMNS | 6 INDEXES | 812 | 31B | F31B115W TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	812	F31B115W	LW	110	6	Trial Blend Input Lot Workfile	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 LWWTBID, LWMCU, LWWTBINOT, LWWLOTN, LWWTBLOSE, LWWVID, LWWVNUM, LWWBID, LWEURID, LWEURSCD, LWWISSC, LWAWBID, LWMATYP, LWWOPID, LWSATTN1, LWSATTN2, LWSATTN3, LWSATTN4, LWSATTN5, LWSATTN6, LWSATTN7, LWSATTN8, LWSATTN9, LWSATTN10, LWSATTN11, LWSATTN12, LWSATTN13, LWSATTN14, LWSATTN15, LWSATTS16, LWSATTS17, LWSATTS18, LWSATTS19, LWSATTS20, LWSATTS21, LWSATTS22, LWSATTS23, LWSATTS24, LWSATTS25, LWLTQNTY, LWLTUOM, LWWTBQCN, LWWTBPCN, LWWTBCPER, LWWPERLQTY, LWWPERTBE, LWWPERTBQ, LWWTBSTAT, LWWNCCOLN1, LWWNCCOLN2, LWWNCCOLN3, LWWNCCOLN4, LWWNCCOLN5, LWWNCCOLN6, LWWNCCOLS1, LWWNCCOLS2, LWWNCCOLS3, LWWNCCOLS4, LWWNCCOLS5, LWWNCCOLS6, LWWNCCOLD1, LWWNCCOLD2, LWWNCCOLD3, LWWNCCOLD4, LWWNCCOLD5, LWWNCCOLD6, LWURAB, LWURAT, LWURCD, LWURDT, LWURRF, LWWAB, LWWNUM, LWWCD, LWWMDT, LWWRF, LWUSER, LWUPMJ, LWUPMT, LWJOBN, LWMKEY, LWPID, LWINATTN1, LWINATTN2, LWINATTN3, LWINATTN4, LWINATTS5, LWINATTS6, LWINATTS7, LWINATTS8, LWINATTD9, LWINATTD10, LWINATTD11, LWINATTD12, LWWVTY, LWWTBOQTY, LWWTBOUOM, LWWTBOTB, LWWTBOMAT, LWWTBOST, LWWTBQOP, LWDL01, LWEURQTY, LWWTBCLOTN, LWWTBCMAT, LWWTBCTB, LWWTBCUOM, LWWTBCWST, LWWTBCQTY, LWWTBCOPID FROM F31B115W

TOP 812 | 31B | F31B115W COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	LWWTBID	Trial Blend ID	Integer	Generic Edit	11	0	Allow NULL?
2	LWMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	LWWTBINOT	Input Output Flag	Character	Generic Edit	1	0	Allow NULL?
4	LWWLOTN	Blend Lot Number	String	Generic Edit	30	0	Allow NULL?
5	LWWTBLOSE	Lot Selection	Character	UDC (31B SE)	1	0	Allow NULL?
6	LWWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
7	LWWVNUM	Vessel Number	String	Generic Edit	30	0	Allow NULL?
8	LWWBID	Blend ID	String	Generic Edit	30	0	Allow NULL?
9	LWEURID	EUR Identifier	Numeric	Generic Edit	10	0	Allow NULL?
10	LWEURSCD	EUR Short Code	String	Generic Edit	10	0	Allow NULL?
11	LWWISSC	Wine Status Short Code	String	Generic Edit	6	0	Allow NULL?
12	LWAWBID	Alternate Blend ID	String	Generic Edit	30	0	Allow NULL?
13	LWMATYP	Material Type Code	String	Generic Edit	4	0	Allow NULL?
14	LWWOPID	Operation ID	Integer	Generic Edit	11	0	Allow NULL?
15	LWSATTN1	Summary Attribute 1	Numeric	Generic Edit	15	4	Allow NULL?
16	LWSATTN2	Summary Attribute 2	Numeric	Generic Edit	15	4	Allow NULL?
17	LWSATTN3	Summary Attribute 3	Numeric	Generic Edit	15	4	Allow NULL?
18	LWSATTN4	Summary Attribute 4	Numeric	Generic Edit	15	4	Allow NULL?
19	LWSATTN5	Summary Attribute 5	Numeric	Generic Edit	15	4	Allow NULL?
20	LWSATTN6	Summary Attribute 6	Numeric	Generic Edit	15	4	Allow NULL?
21	LWSATTN7	Summary Attribute 7	Numeric	Generic Edit	15	4	Allow NULL?
22	LWSATTN8	Summary Attribute 8	Numeric	Generic Edit	15	4	Allow NULL?
23	LWSATTN9	Summary Attribute 9	Numeric	Generic Edit	15	4	Allow NULL?
24	LWSATTN10	Summary Attribute 10	Numeric	Generic Edit	15	4	Allow NULL?
25	LWSATTN11	Summary Attribute 11	Numeric	Generic Edit	15	4	Allow NULL?
26	LWSATTN12	Summary Attribute 12	Numeric	Generic Edit	15	4	Allow NULL?
27	LWSATTN13	Summary Attribute 13	Numeric	Generic Edit	15	4	Allow NULL?
28	LWSATTN14	Summary Attribute 14	Numeric	Generic Edit	15	4	Allow NULL?
29	LWSATTN15	Summary Attribute 15	Numeric	Generic Edit	15	4	Allow NULL?
30	LWSATTS16	Summary Attribute 16	String	Generic Edit	20	0	Allow NULL?
31	LWSATTS17	Summary Attribute 17	String	Generic Edit	20	0	Allow NULL?
32	LWSATTS18	Summary Attribute 18	String	Generic Edit	20	0	Allow NULL?
33	LWSATTS19	Summary Attribute 19	String	Generic Edit	20	0	Allow NULL?
34	LWSATTS20	Summary Attribute 20	String	Generic Edit	20	0	Allow NULL?
35	LWSATTS21	Summary Attribute 21	String	Generic Edit	20	0	Allow NULL?
36	LWSATTS22	Summary Attribute 22	String	Generic Edit	20	0	Allow NULL?
37	LWSATTS23	Summary Attribute 23	String	Generic Edit	20	0	Allow NULL?
38	LWSATTS24	Summary Attribute 24	String	Generic Edit	20	0	Allow NULL?
39	LWSATTS25	Summary Attribute 25	String	Generic Edit	20	0	Allow NULL?
40	LWLTQNTY	Blend Lot Quantity	Numeric	Generic Edit	15	4	Allow NULL?
41	LWLTUOM	Blend Lot Unit of Measure	String	Generic Edit	3	0	Allow NULL?
42	LWWTBQCN	Quantity Contributed	Numeric	Generic Edit	15	4	Allow NULL?
43	LWWTBPCN	Percent Contributed	Numeric	Generic Edit	15	4	Allow NULL?
44	LWWTBCPER	Contribution Trial Blend Percent	Numeric	Generic Edit	15	4	Allow NULL?
45	LWWPERLQTY	Total EUR Qty	Numeric	Generic Edit	15	4	Allow NULL?
46	LWWPERTBE	Percent EUR	Numeric	Generic Edit	15	4	Allow NULL?
47	LWWPERTBQ	Percent of Target Trial Blend Quantity	Numeric	Generic Edit	15	4	Allow NULL?
48	LWWTBSTAT	Trial Blend Lot Base Status	Character	UDC (31B TS)	1	0	Allow NULL?
49	LWWNCCOLN1	Named Calculation Column Number 1	Numeric	Generic Edit	15	4	Allow NULL?
50	LWWNCCOLN2	Named Calculation Column Number 2	Numeric	Generic Edit	15	4	Allow NULL?
51	LWWNCCOLN3	Named Calculation Column Number 3	Numeric	Generic Edit	15	4	Allow NULL?
52	LWWNCCOLN4	Named Calculation Column Number 4	Numeric	Generic Edit	15	4	Allow NULL?
53	LWWNCCOLN5	Named Calculation Column Number 5	Numeric	Generic Edit	15	4	Allow NULL?
54	LWWNCCOLN6	Named Calculation Column Number 6	Numeric	Generic Edit	15	4	Allow NULL?
55	LWWNCCOLS1	Named Calculation Column String 1	String	Generic Edit	20	0	Allow NULL?
56	LWWNCCOLS2	Named Calculation Column String 2	String	Generic Edit	20	0	Allow NULL?
57	LWWNCCOLS3	Named Calculation Column String 3	String	Generic Edit	20	0	Allow NULL?
58	LWWNCCOLS4	Named Calculation Column String 4	String	Generic Edit	20	0	Allow NULL?
59	LWWNCCOLS5	Named Calculation Column String 5	String	Generic Edit	20	0	Allow NULL?
60	LWWNCCOLS6	Named Calculation Column String 6	String	Generic Edit	20	0	Allow NULL?
61	LWWNCCOLD1	Named Calculation Column Date 1	Date	Generic Edit	6	0
62	LWWNCCOLD2	Named Calculation Column Date 2	Date	Generic Edit	6	0
63	LWWNCCOLD3	Named Calculation Column Date 3	Date	Generic Edit	6	0
64	LWWNCCOLD4	Named Calculation Column Date 4	Date	Generic Edit	6	0
65	LWWNCCOLD5	Named Calculation Column Date 5	Date	Generic Edit	6	0
66	LWWNCCOLD6	Named Calculation Column Date 6	Date	Generic Edit	6	0
67	LWURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
68	LWURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
69	LWURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
70	LWURDT	User Reserved Date	Date	Generic Edit	6	0
71	LWURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
72	LWWAB	Blend Mgmt Number	Numeric	Generic Edit	8	0	Allow NULL?
73	LWWNUM	Blend Mgmt Numeric	Numeric	Generic Edit	15	4	Allow NULL?
74	LWWCD	Blend Mgmt Code	String	Generic Edit	3	0	Allow NULL?
75	LWWMDT	Blend Mgmt Date	Date	Generic Edit	6	0
76	LWWRF	Blend Mgmt Reference	String	Generic Edit	30	0	Allow NULL?
77	LWUSER	User ID	String	Generic Edit	10	0	Allow NULL?
78	LWUPMJ	Date - Updated	Date	Generic Edit	6	0
79	LWUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
80	LWJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
81	LWMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
82	LWPID	Program ID	String	Generic Edit	10	0	Allow NULL?
83	LWINATTN1	Instructed Attribute 1	Numeric	Generic Edit	15	4	Allow NULL?
84	LWINATTN2	Instructed Attribute 2	Numeric	Generic Edit	15	4	Allow NULL?
85	LWINATTN3	Instructed Attribute 3	Numeric	Generic Edit	15	4	Allow NULL?
86	LWINATTN4	Instructed Attribute 4	Numeric	Generic Edit	15	4	Allow NULL?
87	LWINATTS5	Instructed Attribute 5	String	Generic Edit	20	0	Allow NULL?
88	LWINATTS6	Instructed Attribute 6	String	Generic Edit	20	0	Allow NULL?
89	LWINATTS7	Instructed Attribute 7	String	Generic Edit	20	0	Allow NULL?
90	LWINATTS8	Instructed Attribute 8	String	Generic Edit	20	0	Allow NULL?
91	LWINATTD9	Instructed Attribute 9	Date	Generic Edit	6	0
92	LWINATTD10	Instructed Attribute 10	Date	Generic Edit	6	0
93	LWINATTD11	Instructed Attribute 11	Date	Generic Edit	6	0
94	LWINATTD12	Instructed Attribute 12	Date	Generic Edit	6	0
95	LWWVTY	Vessel Class	Character	Generic Edit	1	0	Allow NULL?
96	LWWTBOQTY	Original Lot Quantity	Numeric	Generic Edit	15	4	Allow NULL?
97	LWWTBOUOM	Original Lot Unit of Measure	String	Generic Edit	3	0	Allow NULL?
98	LWWTBOTB	Original Blend ID	String	Generic Edit	30	0	Allow NULL?
99	LWWTBOMAT	Original Material Type	String	Generic Edit	4	0	Allow NULL?
100	LWWTBOST	Original Wine Status	String	Generic Edit	6	0	Allow NULL?
101	LWWTBQOP	Quantity Or Percent Contributed	Character	Generic Edit	1	0	Allow NULL?
102	LWDL01	Description	String	Generic Edit	30	0	Allow NULL?
103	LWEURQTY	Quantity of EUR	Numeric	Generic Edit	15	4	Allow NULL?
104	LWWTBCLOTN	Current Blend Lot Number	String	Generic Edit	30	0	Allow NULL?
105	LWWTBCMAT	Current Material Type	String	Generic Edit	4	0	Allow NULL?
106	LWWTBCTB	Current Blend ID	String	Generic Edit	30	0	Allow NULL?
107	LWWTBCUOM	Current Lot Unit of Measure	String	Generic Edit	3	0	Allow NULL?
108	LWWTBCWST	Current Wine Status	String	Generic Edit	6	0	Allow NULL?
109	LWWTBCQTY	Current Lot Quantity	Numeric	Generic Edit	15	4	Allow NULL?
110	LWWTBCOPID	Current Operation ID	Integer	Generic Edit	11	0	Allow NULL?

TOP 812 | 31B | F31B115W INDEXES

Number

Description

TrialBlendID LotNo Winery (Primary/Unique)

Element	Alias	Description	Sequence
1	WTBID	Trial Blend ID	Ascending
2	WTBINOT	Input Output Flag	Ascending
3	MCU	Business Unit	Ascending
4	WLOTN	Blend Lot Number	Ascending

TrialBlendID LotNo VesselID

Element	Alias	Description	Sequence
1	WTBID	Trial Blend ID	Ascending
2	WLOTN	Blend Lot Number	Ascending
3	WVID	Vessel ID	Ascending

VesselID OperationID

Element	Alias	Description	Sequence
1	WVID	Vessel ID	Ascending
2	WOPID	Operation ID	Ascending

VesselID TrialBlendID

Element	Alias	Description	Sequence
1	WVID	Vessel ID	Ascending
2	WTBID	Trial Blend ID	Ascending

VesselID EurID

Element	Alias	Description	Sequence
1	WVID	Vessel ID	Ascending
2	EURID	EUR Identifier	Ascending

AlternateBlendID OperationID

Element	Alias	Description	Sequence
1	AWBID	Alternate Blend ID	Ascending
2	WOPID	Operation 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

110 COLUMNS | 6 INDEXES | 812 | 31B | F31B115W TABLE

TOP 812 | 31B | F31B115W COLUMNS

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

110 COLUMNS | 6 INDEXES | 812 | 31B | F31B115W TABLE

TOP812 | 31B | F31B115W COLUMNS

TOP812 | 31B | F31B115W INDEXES

TOP 812 | 31B | F31B115W COLUMNS

TOP 812 | 31B | F31B115W INDEXES