	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

87 COLUMNS | 14 INDEXES | 812 | 31 | F3111 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31: Shop Floor Control
1	812	F3111	WM	87	14	Work Order Parts List	Transaction Files	31: Shop Floor Control	AS400 Coexistence Tables

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 WMDOCO, WMDCTO, WMSFXO, WMTBM, WMFORQ, WMITC, WMCOBY, WMCOTY, WMCPNT, WMFRMP, WMTHRP, WMFRGD, WMTHGD, WMRKCO, WMRORN, WMRCTO, WMRLLN, WMOPSQ, WMBSEQ, WMRSCP, WMSCRP, WMREWP, WMASIP, WMCPYP, WMSTPP, WMLOVD, WMCPIT, WMCPIL, WMCPIA, WMCMCU, WMDSC1, WMDSC2, WMLOCN, WMLOTN, WMAN8, WMLNTY, WMSERN, WMTRDJ, WMDRQJ, WMUORG, WMTRQT, WMSOCN, WMSOBK, WMCTS1, WMQNTA, WMUM, WMEA, WMRTG, WMMTST, WMDCT, WMSHNO, WMMCU, WMOMCU, WMOBJ, WMSUB, WMCMRV, WMSTRX, WMPARS, WMCOMM, WMURCD, WMURDT, WMURAT, WMURRF, WMURAB, WMUSER, WMPID, WMJOBN, WMUPMJ, WMTDAY, WMUKID, WMVEND, WMPOC, WMCTS4, WMCTS7, WMCTS8, WMGLD, WMSBFL, WMAING, WMSSTQ, WMUOM2, WMAPSC, WMPSN, WMDLEJ, WMCOST, WMCHPP, WMCPNB, WMBSEQAN FROM F3111

TOP 812 | 31 | F3111 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WMDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	WMDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	WMSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
4	WMTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
5	WMFORQ	Fixed or Variable Quantity	Character	UDC (H40 FO)	1	0	Allow NULL?
6	WMITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
7	WMCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
8	WMCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
9	WMCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
10	WMFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
11	WMTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
12	WMFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
13	WMTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
14	WMRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
15	WMRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
16	WMRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
17	WMRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
18	WMOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
19	WMBSEQ	Sorszám - Buborék sorszám	Numeric	Generic Edit	5	0	Allow NULL?
20	WMRSCP	Resource Percent	Numeric	Generic Edit	5	2	Allow NULL?
21	WMSCRP	Percent - Percent of Scrap	Numeric	Generic Edit	5	2	Allow NULL?
22	WMREWP	Percent - Rework	Numeric	Generic Edit	5	2	Allow NULL?
23	WMASIP	Percent - As is	Numeric	Generic Edit	5	2	Allow NULL?
24	WMCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
25	WMSTPP	Operation Scrap Percent	Numeric	Generic Edit	5	2	Allow NULL?
26	WMLOVD	Leadtime Offset Days	Numeric	Generic Edit	6	0	Allow NULL?
27	WMCPIT	Component Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
28	WMCPIL	Component 2nd Item Number	String	Generic Edit	25	0	Allow NULL?
29	WMCPIA	Component 3rd Item Number	String	Generic Edit	25	0	Allow NULL?
30	WMCMCU	Component Branch	String	Generic Edit	12	0	Allow NULL?
31	WMDSC1	Description	String	Generic Edit	30	0	Allow NULL?
32	WMDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
33	WMLOCN	Location	String	Generic Edit	20	0	Allow NULL?
34	WMLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
35	WMAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
36	WMLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
37	WMSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
38	WMTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
39	WMDRQJ	Date - Requested	Date	Generic Edit	6	0
40	WMUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
41	WMTRQT	Quantity Available	Numeric	Generic Edit	15	2	Allow NULL?
42	WMSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
43	WMSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	2	Allow NULL?
44	WMCTS1	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
45	WMQNTA	Units - Quantity Commited	Numeric	Generic Edit	15	2	Allow NULL?
46	WMUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
47	WMEA	Amount - Estimated Cost	Numeric	Generic Edit	15	2	Allow NULL?
48	WMRTG	Route Sheet (N)	Character	Generic Edit	1	0	Allow NULL?
49	WMMTST	Material Status Code W.O.	String	UDC (31 MS)	2	0	Allow NULL?
50	WMDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
51	WMSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
52	WMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
53	WMOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
54	WMOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
55	WMSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
56	WMCMRV	Component Revision Level	String	Generic Edit	3	0	Allow NULL?
57	WMSTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
58	WMPARS	Number - Parent WO Number	String	Generic Edit	8	0	Allow NULL?
59	WMCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
60	WMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
61	WMURDT	User Reserved Date	Date	Generic Edit	6	0
62	WMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
63	WMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
64	WMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
65	WMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
66	WMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
67	WMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
68	WMUPMJ	Date - Updated	Date	Generic Edit	6	0
69	WMTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
70	WMUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
71	WMVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
72	WMPOC	Issue and Receipt	Character	UDC (43 IR)	1	0	Allow NULL?
73	WMCTS4	Amount - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
74	WMCTS7	Amount - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
75	WMCTS8	Units - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
76	WMGLD	G/L Date	Date	Generic Edit	6	0
77	WMSBFL	Parts List Substitute Flag	Character	Generic Edit	1	0	Allow NULL?
78	WMAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
79	WMSSTQ	Secondary Quantity Issued/Completed	Numeric	Generic Edit	15	0	Allow NULL?
80	WMUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
81	WMAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
82	WMPSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
83	WMDLEJ	Lot Effectivity Date	Date	Generic Edit	6	0
84	WMCOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
85	WMCHPP	Critical Hold Propagation	Character	Generic Edit	1	0	Allow NULL?
86	WMCPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
87	WMBSEQAN	Bubble Sequence Alpha Numeric	String	Generic Edit	5	0	Allow NULL?

TOP 812 | 31 | F3111 INDEXES

Number

Description

OrderNo OperSeqNo +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	BSEQ	Sorszám - Buborék sorszám	Ascending

CompItemNo CompBranch +A

Element	Alias	Description	Sequence
1	CPIT	Component Item Number - Short	Ascending
2	CMCU	Component Branch	Ascending
3	DRQJ	Date - Requested	Ascending

BusinessUnit CompItemNo +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CPIT	Component Item Number - Short	Ascending
3	COBY	Co-Products/By-Products/Intermediate	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending

OrderNo OperSeqNo +B

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	DRQJ	Date - Requested	Ascending
4	CMCU	Component Branch	Ascending
5	LOCN	Location	Ascending
6	LOTN	Lot/Serial Number	Ascending
7	CPIT	Component Item Number - Short	Ascending

OrderNumber CompItmNo +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	CPIT	Component Item Number - Short	Ascending
3	CMCU	Component Branch	Ascending
4	DRQJ	Date - Requested	Ascending

Co_ByProducts OrderNo +A

Element	Alias	Description	Sequence
1	COBY	Co-Products/By-Products/Intermediate	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	OPSQ	Sequence Number - Operations	Ascending

Co_ByProducts CompItem +A

Element	Alias	Description	Sequence
1	COBY	Co-Products/By-Products/Intermediate	Ascending
2	CPIT	Component Item Number - Short	Ascending
3	CMCU	Component Branch	Ascending
4	DRQJ	Date - Requested	Ascending

UniqueKeyID (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

CompItemNo CompBranch +B

Element	Alias	Description	Sequence
1	CPIT	Component Item Number - Short	Ascending
2	CMCU	Component Branch	Ascending
3	LOCN	Location	Ascending
4	LOTN	Lot/Serial Number	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending

OrderNo OperSeqNo +C

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	CPNB	Component Line Number BOM	Ascending

OrderNo OrderType +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	CPNB	Component Line Number BOM	Ascending

OrderNo RelatedOrder +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	RKCO	Company - Key (Related Order)	Ascending
3	RORN	Related PO/SO/WO Number	Ascending
4	RCTO	Related PO/SO/WO Order Type	Ascending
5	RLLN	Related PO/SO Line Number	Ascending
6	CPIT	Component Item Number - Short	Ascending

Co_ByProducts OrderNo ActIng +

Element	Alias	Description	Sequence
1	COBY	Co-Products/By-Products/Intermediate	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	AING	Active Ingredient Flag	Ascending
4	OPSQ	Sequence Number - Operations	Ascending

CompItemNo CompBranch +C

Element	Alias	Description	Sequence
1	CPIT	Component Item Number - Short	Ascending
2	CMCU	Component Branch	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	UORG	Units - Order/Transaction Quantity	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

87 COLUMNS | 14 INDEXES | 812 | 31 | F3111 TABLE

TOP 812 | 31 | F3111 COLUMNS

TOP 812 | 31 | F3111 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

87 COLUMNS | 14 INDEXES | 812 | 31 | F3111 TABLE

TOP812 | 31 | F3111 COLUMNS

TOP812 | 31 | F3111 INDEXES

TOP 812 | 31 | F3111 COLUMNS

TOP 812 | 31 | F3111 INDEXES