	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 | 2 INDEXES | 920 | 41F | FCW67 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41F: Apparel Management
1	920	FCW67	WM	87	2	Style Work Order Parts List	Files	41F: Apparel 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 WMJOBS, WMC9LANC, WMC9LVL0, WMC9LVL1, WMC9LVL2, WMC9LVL3, WMC9LVL4, 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, WMPBTM, 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, WMC9UORG, WMC9TRQT, WMC9SOCN, WMC9SOBK, WMC9QNTA, WMC9ITM, WMMMCU, WMC9LOCN, WMC9LOTN, WMLNID, WMC9LVNM FROM FCW67

TOP 920 | 41F | FCW67 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WMJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
2	WMC9LANC	Master Work Order	Numeric	Generic Edit	8	0	Allow NULL?
3	WMC9LVL0	Level 0	String	Generic Edit	25	0	Allow NULL?
4	WMC9LVL1	Level 1	String	Generic Edit	6	0	Allow NULL?
5	WMC9LVL2	Level 2	String	Generic Edit	6	0	Allow NULL?
6	WMC9LVL3	Level 3	String	Generic Edit	6	0	Allow NULL?
7	WMC9LVL4	Level 4	String	Generic Edit	6	0	Allow NULL?
8	WMDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
9	WMSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
10	WMTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
11	WMFORQ	Fixed or Variable Quantity	Character	UDC (H40 FO)	1	0	Allow NULL?
12	WMITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
13	WMCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
14	WMCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
15	WMCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
16	WMFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
17	WMTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
18	WMFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
19	WMTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
20	WMRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
21	WMRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
22	WMRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
23	WMRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
24	WMOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
25	WMBSEQ	Sequence - Bubble Sequence	Numeric	Generic Edit	5	0	Allow NULL?
26	WMRSCP	Resource Percent	Numeric	Generic Edit	5	2	Allow NULL?
27	WMSCRP	Percent - Percent of Scrap	Numeric	Generic Edit	5	2	Allow NULL?
28	WMREWP	Percent - Rework	Numeric	Generic Edit	5	2	Allow NULL?
29	WMASIP	Percent - As is	Numeric	Generic Edit	5	2	Allow NULL?
30	WMCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
31	WMSTPP	Operation Scrap Percent	Numeric	Generic Edit	5	2	Allow NULL?
32	WMLOVD	Leadtime Offset Days	Numeric	Generic Edit	6	0	Allow NULL?
33	WMCPIT	Component Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
34	WMCPIL	Component 2nd Item Number	String	Generic Edit	25	0	Allow NULL?
35	WMCPIA	Component 3rd Item Number	String	Generic Edit	25	0	Allow NULL?
36	WMCMCU	Component Branch	String	Generic Edit	12	0	Allow NULL?
37	WMDSC1	Description	String	Generic Edit	30	0	Allow NULL?
38	WMDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
39	WMLOCN	Location	String	Generic Edit	20	0	Allow NULL?
40	WMLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
41	WMAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
42	WMLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
43	WMSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
44	WMTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
45	WMDRQJ	Date - Requested	Date	Generic Edit	6	0
46	WMPBTM	Time - Beginning (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
47	WMUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
48	WMTRQT	Quantity Available	Numeric	Generic Edit	15	0	Allow NULL?
49	WMSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
50	WMSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
51	WMCTS1	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
52	WMQNTA	Units - Quantity Commited	Numeric	Generic Edit	15	0	Allow NULL?
53	WMUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
54	WMEA	Amount - Estimated Cost	Numeric	Generic Edit	15	2	Allow NULL?
55	WMRTG	Route Sheet (N)	Character	Generic Edit	1	0	Allow NULL?
56	WMMTST	Material Status Code W.O.	String	UDC (31 MS)	2	0	Allow NULL?
57	WMDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
58	WMSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
59	WMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
60	WMOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
61	WMOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
62	WMSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
63	WMCMRV	Component Revision Level	String	Generic Edit	3	0	Allow NULL?
64	WMSTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
65	WMPARS	Number - Parent WO Number	String	Generic Edit	8	0	Allow NULL?
66	WMCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
67	WMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
68	WMURDT	User Reserved Date	Date	Generic Edit	6	0
69	WMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
70	WMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
71	WMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
72	WMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
73	WMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
74	WMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
75	WMUPMJ	Date - Updated	Date	Generic Edit	6	0
76	WMTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
77	WMC9UORG	Units - Order/Transaction QuantityOrigin	Numeric	Generic Edit	15	0	Allow NULL?
78	WMC9TRQT	Quantity AvailableOriginal	Numeric	Generic Edit	15	0	Allow NULL?
79	WMC9SOCN	Units - Quantity Canceled/Original	Numeric	Generic Edit	15	0	Allow NULL?
80	WMC9SOBK	Units - Qty Backordered/HeldOriginal	Numeric	Generic Edit	15	0	Allow NULL?
81	WMC9QNTA	Units - Quantity Commited Original	Numeric	Generic Edit	15	0	Allow NULL?
82	WMC9ITM	Short Item Number	Numeric	Generic Edit	8	0	Allow NULL?
83	WMMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
84	WMC9LOCN	Location	String	Generic Edit	20	0	Allow NULL?
85	WMC9LOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
86	WMLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
87	WMC9LVNM	Level Name	String	Generic Edit	50	0	Allow NULL?

TOP 920 | 41F | FCW67 INDEXES

Number

Description

Jobnumber (Unique)

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	C9LANC	Master Work Order	Ascending
3	CPIT	Component Item Number - Short	Ascending
4	MMCU	Branch	Ascending
5	LOCN	Location	Ascending
6	LOTN	Lot/Serial Number	Ascending
7	QNTA	Units - Quantity Commited	Ascending
8	CPNT	Component Line Number	Ascending

Job+Ligne (Primary/Unique)

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	CPNT	Component Line 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

87 COLUMNS | 2 INDEXES | 920 | 41F | FCW67 TABLE

TOP 920 | 41F | FCW67 COLUMNS

TOP 920 | 41F | FCW67 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 | 2 INDEXES | 920 | 41F | FCW67 TABLE

TOP920 | 41F | FCW67 COLUMNS

TOP920 | 41F | FCW67 INDEXES

TOP 920 | 41F | FCW67 COLUMNS

TOP 920 | 41F | FCW67 INDEXES