	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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

64 COLUMNS | 8 INDEXES | 920 | 31B | F31B65 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31B: Blend Management
1	920	F31B65	OH	64	8	Operation Header	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 OHWOPID, OHWOPN, OHWDC, OHMMCU, OHWDOCO, OHWCFGID, OHWOPST, OHWCRTR, OHWOPYL, OHWSDT, OHWEDT, OHWDUR, OHWUOMT, OHWASDT, OHWAEDT, OHWADUR, OHINSTMET, OHDISTMET, OHWPSD, OHWPAD, OHWSBDV, OHWH1, OHWH2, OHWH3, OHWH4, OHWH5, OHEAURST1, OHEAURST2, OHEAURST3, OHEAURST4, OHEAURST5, OHWSD, OHWALOP, OHWCDT, OHWRI, OHWSRC, OHWOPRC, OHWTOGL, OHWTSGL, OHWTMQ, OHWPOPID, OHWRLOPF, OHWOPRVF, OHWSGTCHGF, OHWJOBN, OHWTI, OHWEID, OHWAB, OHWMDT, OHWNUM, OHWCD, OHWRF, OHUSER, OHPID, OHJOBN, OHUPMJ, OHTDAY, OHCMATYPE, OHWAWOR, OHDGL, OHWADDORC, OHWADDCRC, OHWTBID, OHPRCPTF FROM F31B65

TOP 920 | 31B | F31B65 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	OHWOPID	Operation ID	Integer	Generic Edit	11	0	Allow NULL?
2	OHWOPN	Operation Number	Numeric	Generic Edit	8	0	Allow NULL?
3	OHWDC	Dependency Counter	Integer	Generic Edit	11	2	Allow NULL?
4	OHMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
5	OHWDOCO	Work Order ID	Numeric	Generic Edit	15	0	Allow NULL?
6	OHWCFGID	Configured Operation ID	Integer	Generic Edit	11	0	Allow NULL?
7	OHWOPST	Operation Status	String	UDC (31B WF)	10	0	Allow NULL?
8	OHWCRTR	Creator ID	Numeric	Generic Edit	8	0	Allow NULL?
9	OHWOPYL	WIM Operation Yield	Numeric	Generic Edit	15	4	Allow NULL?
10	OHWSDT	Instructed Start Date	JDE UTime	Generic Edit	11	0
11	OHWEDT	Instructed End Date	JDE UTime	Generic Edit	11	0
12	OHWDUR	Elapsed Time	Numeric	Generic Edit	15	4	Allow NULL?
13	OHWUOMT	Time Unit Of Measure	Character	UDC (31B TU)	1	0	Allow NULL?
14	OHWASDT	Actual Start Date	JDE UTime	Generic Edit	11	0
15	OHWAEDT	WIM Actual End Date	JDE UTime	Generic Edit	11	0
16	OHWADUR	WIM Actual Duration	Numeric	Generic Edit	15	4	Allow NULL?
17	OHINSTMET	Instruction Method	Character	UDC (31B VI)	1	0	Allow NULL?
18	OHDISTMET	Distribution Method	Character	UDC (31B DM)	1	0	Allow NULL?
19	OHWPSD	Perform Survey Measure	Character	UDC (31B OS)	1	0	Allow NULL?
20	OHWPAD	Perform After Measure	Character	UDC (31B AM)	1	0	Allow NULL?
21	OHWSBDV	Show Planned Measures	Character	Generic Edit	1	0	Allow NULL?
22	OHWH1	Operation Category Code 1	String	UDC (31B B1)	10	0	Allow NULL?
23	OHWH2	Operation Category Code 2	String	UDC (31B B2)	10	0	Allow NULL?
24	OHWH3	Operation Category Code 3	String	UDC (31B B3)	10	0	Allow NULL?
25	OHWH4	Operation Category Code 4	String	UDC (31B B4)	10	0	Allow NULL?
26	OHWH5	Operation Category Code 5	String	UDC (31B B5)	10	0	Allow NULL?
27	OHEAURST1	User Reserved String 01	String	Generic Edit	5	0	Allow NULL?
28	OHEAURST2	User Reserved String 02	String	Generic Edit	5	0	Allow NULL?
29	OHEAURST3	User Reserved String 03	String	Generic Edit	15	0	Allow NULL?
30	OHEAURST4	User Reserved String 04	String	Generic Edit	15	0	Allow NULL?
31	OHEAURST5	User Reserved String 05	String	Generic Edit	15	0	Allow NULL?
32	OHWSD	Workflow Status Name	String	Generic Edit	30	0	Allow NULL?
33	OHWALOP	Alternate Operation Number	String	UDC	20	0	Allow NULL?
34	OHWCDT	Creation Date	JDE UTime	Generic Edit	11	0
35	OHWRI	Released Indicator	Character	UDC (31B RI)	1	0	Allow NULL?
36	OHWSRC	Survey Reason Code	String	Generic Edit	30	0	Allow NULL?
37	OHWOPRC	Operation Reason Code	String	Generic Edit	30	0	Allow NULL?
38	OHWTOGL	Total Operation Gain/Loss	Numeric	Generic Edit	15	4	Allow NULL?
39	OHWTSGL	Total Survey Gain/Loss	Numeric	Generic Edit	15	4	Allow NULL?
40	OHWTMQ	Total Move Quantity	Numeric	Generic Edit	15	4	Allow NULL?
41	OHWPOPID	Parent Operation ID	Integer	Generic Edit	11	0	Allow NULL?
42	OHWRLOPF	Related Operation Flag	Character	Generic Edit	1	0	Allow NULL?
43	OHWOPRVF	Operation Reverse Flag	Character	Generic Edit	1	0	Allow NULL?
44	OHWSGTCHGF	Significant Change Indicator	Character	Generic Edit	1	0	Allow NULL?
45	OHWJOBN	Job Number	Integer	Generic Edit	11	0	Allow NULL?
46	OHWTI	Template Indicator	Character	Generic Edit	1	0	Allow NULL?
47	OHWEID	Error ID	String	Generic Edit	10	0	Allow NULL?
48	OHWAB	Blend Mgmt Number	Numeric	Generic Edit	8	0	Allow NULL?
49	OHWMDT	Blend Mgmt Date	Date	Generic Edit	6	0
50	OHWNUM	Blend Mgmt Numeric	Numeric	Generic Edit	15	4	Allow NULL?
51	OHWCD	Blend Mgmt Code	String	Generic Edit	3	0	Allow NULL?
52	OHWRF	Blend Mgmt Reference	String	Generic Edit	30	0	Allow NULL?
53	OHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
54	OHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
55	OHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
56	OHUPMJ	Date - Updated	Date	Generic Edit	6	0
57	OHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
58	OHCMATYPE	Composition Material Type	String	UDC (31B CO)	4	0	Allow NULL?
59	OHWAWOR	WIM Work Order Reference Number	String	Generic Edit	20	0	Allow NULL?
60	OHDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
61	OHWADDORC	Additive Operational Reason Code	String	Generic Edit	30	0	Allow NULL?
62	OHWADDCRC	Additive Cumulative Reason Code	String	Generic Edit	30	0	Allow NULL?
63	OHWTBID	Trial Blend ID	Integer	Generic Edit	11	0	Allow NULL?
64	OHPRCPTF	Partial Receipts Control Flag	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 31B | F31B65 INDEXES

Number

Description

Operation ID (Primary/Unique)

Element	Alias	Description	Sequence
1	WOPID	Operation ID	Descending

OperationNumber

Element	Alias	Description	Sequence
1	WOPN	Operation Number	Descending

Dependency

Element	Alias	Description	Sequence
1	WDC	Dependency Counter	Ascending

WJOBN WOPID

Element	Alias	Description	Sequence
1	WJOBN	Job Number	Ascending
2	WOPID	Operation ID	Ascending

WPOPID WOPID

Element	Alias	Description	Sequence
1	WPOPID	Parent Operation ID	Ascending
2	WOPID	Operation ID	Ascending

WDOCO WOPID

Element	Alias	Description	Sequence
1	WDOCO	Work Order ID	Ascending
2	WOPID	Operation ID	Ascending

WDOCO MMCU

Element	Alias	Description	Sequence
1	WDOCO	Work Order ID	Ascending
2	MMCU	Branch	Ascending
3	WASDT	Actual Start Date	Ascending
4	WOPID	Operation ID	Ascending

MMCU Operation Number

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	WOPN	Operation Number	Descending

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

64 COLUMNS | 8 INDEXES | 920 | 31B | F31B65 TABLE

TOP 920 | 31B | F31B65 COLUMNS

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

64 COLUMNS | 8 INDEXES | 920 | 31B | F31B65 TABLE

TOP920 | 31B | F31B65 COLUMNS

TOP920 | 31B | F31B65 INDEXES

TOP 920 | 31B | F31B65 COLUMNS

TOP 920 | 31B | F31B65 INDEXES