	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 | 7 INDEXES | 920 | 31 | F3112 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
31: Shop Floor Control
1	920	F3112	WL	110	7	Work Order Routing	Transaction Files	31: Shop Floor Control	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 WLDOCO, WLDCTO, WLSFXO, WLTRT, WLKIT, WLKITL, WLKITA, WLMMCU, WLLINE, WLMCU, WLALD, WLDSC1, WLOPSQ, WLOPSC, WLOPST, WLINPE, WLTIMB, WLLAMC, WLBFPF, WLPPRF, WLJBCD, WLAN8, WLCRTR, WLSLTR, WLTRDJ, WLDRQJ, WLSTRT, WLSTRX, WLRSFT, WLSSFT, WLCSFT, WLLTPC, WLPOVR, WLOPYP, WLCPYP, WLNXOP, WLSETC, WLMOVD, WLQUED, WLRUNM, WLRUNL, WLSETL, WLMACA, WLLABA, WLSETA, WLOPSR, WLUORG, WLSOCN, WLSOQS, WLQMTO, WLPWRT, WLUOM, WLCTS2, WLCTS3, WLCTS4, WLCTS5, WLCTS6, WLAPID, WLSHNO, WLOMCU, WLOBJ, WLSUB, WLVEND, WLRKCO, WLRORN, WLRCTO, WLRLLN, WLDCT, WLURCD, WLURDT, WLURAT, WLURRF, WLURAB, WLUSER, WLPID, WLJOBN, WLUPMJ, WLTDAY, WLLOCN, WLRUC, WLCAPU, WLWMCU, WLCMHR, WLCLHR, WLCSHR, WLCOST, WLACTB, WLNUMB, WLCTS7, WLCTS8, WLCTS9, WLLABP, WLMACR, WLSETR, WLAPSC, WLSEST, WLSEET, WLTMCO, WLD2J, WLSTTI, WLCMPE, WLCMPC, WLCPLVLFR, WLCPLVLTO, WLCMRQ, WLANSA, WLANPA, WLANP, WLWSCHF, WLTRAF FROM F3112

TOP 920 | 31 | F3112 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WLDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	WLDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	WLSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
4	WLTRT	Type of Routing	String	UDC (40 TR)	3	0	Allow NULL?
5	WLKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
6	WLKITL	Kit - 2nd Item Number	String	Generic Edit	25	0	Allow NULL?
7	WLKITA	3rd Item Number - Kit	String	Generic Edit	25	0	Allow NULL?
8	WLMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
9	WLLINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
10	WLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
11	WLALD	Auto Load Description	String	UDC (30 AL)	4	0	Allow NULL?
12	WLDSC1	Description	String	Generic Edit	30	0	Allow NULL?
13	WLOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
14	WLOPSC	Type Operation Code	String	UDC (30 OT)	2	0	Allow NULL?
15	WLOPST	Operation Status Code W.O.	String	UDC (31 OS)	2	0	Allow NULL?
16	WLINPE	Inspection Code	String	Generic Edit	2	0	Allow NULL?
17	WLTIMB	Time Basis Code	Character	UDC (30 TB)	1	0	Allow NULL?
18	WLLAMC	Labor or Machine	Character	UDC (H40 LA)	1	0	Allow NULL?
19	WLBFPF	Pay Point Code	Character	UDC (30 BF)	1	0	Allow NULL?
20	WLPPRF	Pay Point Status	Character	UDC (31 PP)	1	0	Allow NULL?
21	WLJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
22	WLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
23	WLCRTR	Critical Ratio	Numeric	Generic Edit	7	4	Allow NULL?
24	WLSLTR	Slack Time Ratio	Numeric	Generic Edit	7	4	Allow NULL?
25	WLTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
26	WLDRQJ	Date - Requested	Date	Generic Edit	6	0
27	WLSTRT	Date - Start (Julian)	Date	Generic Edit	6	0
28	WLSTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
29	WLRSFT	Shift Code - Requested	Character	UDC	1	0	Allow NULL?
30	WLSSFT	Shift Code - Start	Character	UDC	1	0	Allow NULL?
31	WLCSFT	Shift Code - Completed	Character	UDC	1	0	Allow NULL?
32	WLLTPC	Percent - Leadtime Overlap	Numeric	Generic Edit	5	2	Allow NULL?
33	WLPOVR	Percent - Overlap	Numeric	Generic Edit	5	2	Allow NULL?
34	WLOPYP	Percent - Operational Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
35	WLCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
36	WLNXOP	Sequence Number - Next Operation	Numeric	Generic Edit	5	2	Allow NULL?
37	WLSETC	Crew Size	Numeric	Generic Edit	5	1	Allow NULL?
38	WLMOVD	Move Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
39	WLQUED	Queue Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
40	WLRUNM	Run Machine - Standard	Numeric	Generic Edit	15	2	Allow NULL?
41	WLRUNL	Run Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
42	WLSETL	Setup Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
43	WLMACA	Run Machine - Actual	Numeric	Generic Edit	15	2	Allow NULL?
44	WLLABA	Run Labor - Actual	Numeric	Generic Edit	15	2	Allow NULL?
45	WLSETA	Hours - Setup Labor Hours - Actual	Numeric	Generic Edit	15	2	Allow NULL?
46	WLOPSR	Factor - Operation Shrinkage Factor	Numeric	Generic Edit	15	4	Allow NULL?
47	WLUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
48	WLSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
49	WLSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
50	WLQMTO	Units - Quantity at Operation	Numeric	Generic Edit	15	0	Allow NULL?
51	WLPWRT	Rate - Piecework	Numeric	Generic Edit	15	3	Allow NULL?
52	WLUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
53	WLCTS2	Hours - Unaccounted Setup Labor	Numeric	Generic Edit	15	2	Allow NULL?
54	WLCTS3	Hours - Unaccounted Machine Hours	Numeric	Generic Edit	15	2	Allow NULL?
55	WLCTS4	Amount - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
56	WLCTS5	Amount - Unaccounted Setup Labor	Numeric	Generic Edit	15	2	Allow NULL?
57	WLCTS6	Amount - Unaccounted Machine	Numeric	Generic Edit	15	2	Allow NULL?
58	WLAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
59	WLSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
60	WLOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
61	WLOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
62	WLSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
63	WLVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
64	WLRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
65	WLRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
66	WLRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
67	WLRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
68	WLDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
69	WLURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
70	WLURDT	User Reserved Date	Date	Generic Edit	6	0
71	WLURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
72	WLURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
73	WLURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
74	WLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
75	WLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
76	WLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
77	WLUPMJ	Date - Updated	Date	Generic Edit	6	0
78	WLTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
79	WLLOCN	Location	String	Generic Edit	20	0	Allow NULL?
80	WLRUC	Resource units consumed	Numeric	Generic Edit	15	2	Allow NULL?
81	WLCAPU	Capacity Unit of measure	String	UDC (00 UM)	2	0	Allow NULL?
82	WLWMCU	Workcenter Branch	String	Generic Edit	12	0	Allow NULL?
83	WLCMHR	Run Machine - Current	Numeric	Generic Edit	15	2	Allow NULL?
84	WLCLHR	Run Labor - Current	Numeric	Generic Edit	15	2	Allow NULL?
85	WLCSHR	Setup Labor - Current	Numeric	Generic Edit	15	2	Allow NULL?
86	WLCOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
87	WLACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
88	WLNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
89	WLCTS7	Amount - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
90	WLCTS8	Units - Unaccounted Scrap	Numeric	Generic Edit	15	0	Allow NULL?
91	WLCTS9	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
92	WLLABP	Run Labor - Rate	Numeric	Generic Edit	15	2	Allow NULL?
93	WLMACR	Run Machine - Rate	Numeric	Generic Edit	15	2	Allow NULL?
94	WLSETR	Setup Labor - Rate	Numeric	Generic Edit	15	2	Allow NULL?
95	WLAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
96	WLSEST	Time - Scheduled Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
97	WLSEET	Time - Scheduled End (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
98	WLTMCO	Time - Completed	Numeric	Generic Edit	6	0	Allow NULL?
99	WLD2J	Date - Actual Start	Date	Generic Edit	6	0
100	WLSTTI	Time - Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
101	WLCMPE	Competency Type	String	UDC (05 CY)	3	0	Allow NULL?
102	WLCMPC	Competency Code	String	Generic Edit	10	0	Allow NULL?
103	WLCPLVLFR	Competency Level From	Numeric	Generic Edit	6	3	Allow NULL?
104	WLCPLVLTO	Competency Level To	Numeric	Generic Edit	6	3	Allow NULL?
105	WLCMRQ	Rule Match Flag	Character	Generic Edit	1	0	Allow NULL?
106	WLANSA	Address Number - Manager	Numeric	Generic Edit	8	0	Allow NULL?
107	WLANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
108	WLANP	Address Number - Assigned To	Numeric	Generic Edit	8	0	Allow NULL?
109	WLWSCHF	Maintenance Schedule Flag	Character	UDC (13 WS)	1	0	Allow NULL?
110	WLTRAF	Resources Assigned	Character	UDC (00 ZO)	1	0	Allow NULL?

TOP 920 | 31 | F3112 INDEXES

Number

Description

OrderNo OperationSeqNo +A (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	OPSC	Type Operation Code	Ascending
4	MCU	Business Unit	Ascending

BusinessUnit StartDate +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	STRT	Date - Start (Julian)	Ascending
3	OPSQ	Sequence Number - Operations	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending

BusinessUnit RequestedDate

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	DRQJ	Date - Requested	Ascending

Branch BusinessUnit +A

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	MCU	Business Unit	Ascending
3	WMCU	Workcenter Branch	Ascending
4	OPSC	Type Operation Code	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending

AddressNo StartDate +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	STRT	Date - Start (Julian)	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	OPSQ	Sequence Number - Operations	Ascending

Branch ParentItemNo +A

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	KIT	Parent (short) Item Number	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	OPSQ	Sequence Number - Operations	Ascending

OrderNo OperSeqNo +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	OPSC	Type Operation Code	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 | 7 INDEXES | 920 | 31 | F3112 TABLE

TOP 920 | 31 | F3112 COLUMNS

TOP 920 | 31 | F3112 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 | 7 INDEXES | 920 | 31 | F3112 TABLE

TOP920 | 31 | F3112 COLUMNS

TOP920 | 31 | F3112 INDEXES

TOP 920 | 31 | F3112 COLUMNS

TOP 920 | 31 | F3112 INDEXES