	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

96 COLUMNS | 7 INDEXES | 812 | 31B | F31B65Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	812	F31B65Z1	SZ	96	7	Operations Transaction File	Transaction Files	31B: Blend Management	Business Data

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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZWAPRN, SZWAWOR, SZWDOCO, SZWOPID, SZWOPN, SZWCRTR, SZWCOPCD, SZWALOP, SZWOPDSC, SZWSD, SZMMCU, SZWASJDT, SZWWAST, SZWWASTZ, SZWAEJDT, SZWWAET, SZWWAETZ, SZWADUR, SZWRDOCO, SZBLSCD, SZVINTAG, SZFRVNUM, SZTOVNUM, SZWAM, SZWACTVLMV, SZWACTUOM, SZWFBAQFLG, SZWFBAQTY, SZWFBAUOM, SZWFAAQFLG, SZWFAAQTY, SZWFAAUOM, SZWTBAQFLG, SZWTBAQTY, SZWTBAUOM, SZWTAAQFLG, SZWTAAQTY, SZWTAAUOM, SZWADDLITM, SZADDQTY, SZADTUOM, SZWADDLOTN, SZWADDLOCN, SZWADDMCU, SZWFRMAT, SZWTRMAT, SZWFAWS, SZWTAWS, SZWFAABID, SZWTAABID, SZWFABID, SZWTABID, SZWFAEUR, SZWTAEUR, SZWFVBTTYP, SZWFCAPTYP, SZWTVBTTYP, SZWTCAPTYP, SZWH1, SZWH2, SZWH3, SZWH4, SZWH5, SZWOFACO, SZWOFACC, SZWOFACM, SZWOFACT, SZWOTACO, SZWOTACC, SZWOTACM, SZWOTACT, SZURCD, SZURDT, SZURAT, SZURRF, SZURAB, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZHARPER, SZHARSFX FROM F31B65Z1

TOP 812 | 31B | F31B65Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SZEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	SZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	SZEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	SZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	SZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SZTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	SZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	SZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	SZDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	SZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	SZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	SZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	SZTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	SZWAPRN	Operation Reference Number	String	Generic Edit	20	0	Allow NULL?
15	SZWAWOR	WIM Work Order Reference Number	String	Generic Edit	20	0	Allow NULL?
16	SZWDOCO	Work Order ID	Numeric	Generic Edit	15	0	Allow NULL?
17	SZWOPID	Operation ID	Integer	Generic Edit	11	0	Allow NULL?
18	SZWOPN	Operation Number	Numeric	Generic Edit	8	0	Allow NULL?
19	SZWCRTR	Creator ID	Numeric	Generic Edit	8	0	Allow NULL?
20	SZWCOPCD	Configured Operation Short Code	String	Generic Edit	10	0	Allow NULL?
21	SZWALOP	Alternate Operation Number	String	UDC	20	0	Allow NULL?
22	SZWOPDSC	Operation Description	String	Generic Edit	30	0	Allow NULL?
23	SZWSD	Workflow Status Name	String	Generic Edit	30	0	Allow NULL?
24	SZMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
25	SZWASJDT	Actual Start Date	Date	Generic Edit	6	0
26	SZWWAST	Actual Start Time	Numeric	Generic Edit	6	0	Allow NULL?
27	SZWWASTZ	Actual Start Time Zone	String	Generic Edit	3	0	Allow NULL?
28	SZWAEJDT	Actual End Date	Date	Generic Edit	6	0
29	SZWWAET	Actual End Time	Numeric	Generic Edit	6	0	Allow NULL?
30	SZWWAETZ	Actual End Time Zone	String	Generic Edit	3	0	Allow NULL?
31	SZWADUR	WIM Actual Duration	Numeric	Generic Edit	15	4	Allow NULL?
32	SZWRDOCO	Receipt Document Number	Numeric	Generic Edit	8	0	Allow NULL?
33	SZBLSCD	Block Short Code	String	Generic Edit	10	0	Allow NULL?
34	SZVINTAG	Year - Vintage	Numeric	Generic Edit	4	0	Allow NULL?
35	SZFRVNUM	From Vessel Number	String	Generic Edit	30	0	Allow NULL?
36	SZTOVNUM	To Vessel Number	String	Generic Edit	30	0	Allow NULL?
37	SZWAM	Actual Move Flag	Character	Generic Edit	1	0	Allow NULL?
38	SZWACTVLMV	Actual Move Quantity	Numeric	Generic Edit	15	4	Allow NULL?
39	SZWACTUOM	Actual Move UOM	String	Generic Edit	3	0	Allow NULL?
40	SZWFBAQFLG	From Before Actual Quantity Flag	Character	Generic Edit	1	0	Allow NULL?
41	SZWFBAQTY	From Before Actual Quantity	Numeric	Generic Edit	15	4	Allow NULL?
42	SZWFBAUOM	From Before Actual UOM	String	Generic Edit	3	0	Allow NULL?
43	SZWFAAQFLG	From After Actual Quantity Flag	Character	Generic Edit	1	0	Allow NULL?
44	SZWFAAQTY	From After Actual Quantity	Numeric	Generic Edit	15	4	Allow NULL?
45	SZWFAAUOM	From After Actual UOM	String	Generic Edit	3	0	Allow NULL?
46	SZWTBAQFLG	To Before Actual Quantity Flag	Character	Generic Edit	1	0	Allow NULL?
47	SZWTBAQTY	To Before Actual Quantity	Numeric	Generic Edit	15	4	Allow NULL?
48	SZWTBAUOM	To Before Actual UOM	String	Generic Edit	3	0	Allow NULL?
49	SZWTAAQFLG	To After Actual Quantity Flag	Character	Generic Edit	1	0	Allow NULL?
50	SZWTAAQTY	To After Actual Quantity	Numeric	Generic Edit	15	4	Allow NULL?
51	SZWTAAUOM	To After Actual UOM	String	Generic Edit	3	0	Allow NULL?
52	SZWADDLITM	Additive Item	String	Generic Edit	25	0	Allow NULL?
53	SZADDQTY	Additive Quantity	Numeric	Generic Edit	15	4	Allow NULL?
54	SZADTUOM	Additive Unit of Measure	String	UDC (31B UM)	2	0	Allow NULL?
55	SZWADDLOTN	Additive Lot Number	String	Generic Edit	30	0	Allow NULL?
56	SZWADDLOCN	Additive Location	String	Generic Edit	20	0	Allow NULL?
57	SZWADDMCU	Additive Branch	String	Generic Edit	12	0	Allow NULL?
58	SZWFRMAT	From After Material Type Code	String	Generic Edit	4	0	Allow NULL?
59	SZWTRMAT	To After Material Type Code	String	Generic Edit	4	0	Allow NULL?
60	SZWFAWS	From After Wine Status Short Code	String	Generic Edit	6	0	Allow NULL?
61	SZWTAWS	To After Wine Status Short Code	String	Generic Edit	6	0	Allow NULL?
62	SZWFAABID	From After Alternate Blend ID	String	Generic Edit	30	0	Allow NULL?
63	SZWTAABID	To After Alternate Blend ID	String	Generic Edit	30	0	Allow NULL?
64	SZWFABID	From After Blend ID	String	Generic Edit	30	0	Allow NULL?
65	SZWTABID	To After Blend ID	String	Generic Edit	30	0	Allow NULL?
66	SZWFAEUR	From After EUR	String	Generic Edit	10	0	Allow NULL?
67	SZWTAEUR	To After EUR	String	Generic Edit	10	0	Allow NULL?
68	SZWFVBTTYP	From VBT Type	String	UDC	4	0	Allow NULL?
69	SZWFCAPTYP	From VBT Capacity Type	Character	Generic Edit	1	0	Allow NULL?
70	SZWTVBTTYP	To VBT Type	String	UDC	4	0	Allow NULL?
71	SZWTCAPTYP	To VBT Capacity Type	Character	Generic Edit	1	0	Allow NULL?
72	SZWH1	Operation Category Code 1	String	UDC (31B B1)	10	0	Allow NULL?
73	SZWH2	Operation Category Code 2	String	UDC (31B B2)	10	0	Allow NULL?
74	SZWH3	Operation Category Code 3	String	UDC (31B B3)	10	0	Allow NULL?
75	SZWH4	Operation Category Code 4	String	UDC (31B B4)	10	0	Allow NULL?
76	SZWH5	Operation Category Code 5	String	UDC (31B B5)	10	0	Allow NULL?
77	SZWOFACO	From After Comment Option	Character	Generic Edit	1	0	Allow NULL?
78	SZWOFACC	From After Comment Code	String	Generic Edit	6	0	Allow NULL?
79	SZWOFACM	From After Comments	String	Generic Edit	200	0	Allow NULL?
80	SZWOFACT	From After Comment Tester	String	Generic Edit	30	0	Allow NULL?
81	SZWOTACO	To After Comment Option	Character	Generic Edit	1	0	Allow NULL?
82	SZWOTACC	To After Comment Code	String	Generic Edit	6	0	Allow NULL?
83	SZWOTACM	To After Comments	String	Generic Edit	200	0	Allow NULL?
84	SZWOTACT	To After Comment Tester	String	Generic Edit	30	0	Allow NULL?
85	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
86	SZURDT	User Reserved Date	Date	Generic Edit	6	0
87	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
88	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
89	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
90	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
91	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
92	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
93	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
94	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
95	SZHARPER	Harvest Period	String	Generic Edit	6	0	Allow NULL?
96	SZHARSFX	Harvest Suffix	String	Generic Edit	10	0	Allow NULL?

TOP 812 | 31B | F31B65Z1 INDEXES

Number

Description

User Id Batch Number A (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

User Id Batch Number B

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDSP	EDI - Successfully Processed	Ascending

User Id Batch Number C

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDSP	EDI - Successfully Processed	Ascending

User Id Batch Number D

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending

Batch Number Trans Number B

Element	Alias	Description	Sequence
1	EDBT	EDI - Batch Number	Ascending
2	EDTN	EDI - Transaction Number	Ascending
3	WAWOR	WIM Work Order Reference Number	Ascending
4	WAPRN	Operation Reference Number	Ascending

User Id Batch Number E

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Descending

WORefNo OpRefNo

Element	Alias	Description	Sequence
1	WAWOR	WIM Work Order Reference Number	Ascending
2	WAPRN	Operation Reference 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

96 COLUMNS | 7 INDEXES | 812 | 31B | F31B65Z1 TABLE

TOP 812 | 31B | F31B65Z1 COLUMNS

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

96 COLUMNS | 7 INDEXES | 812 | 31B | F31B65Z1 TABLE

TOP812 | 31B | F31B65Z1 COLUMNS

TOP812 | 31B | F31B65Z1 INDEXES

TOP 812 | 31B | F31B65Z1 COLUMNS

TOP 812 | 31B | F31B65Z1 INDEXES