	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

128 COLUMNS | 32 INDEXES | 920 | 48 | F4801 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
48: Work Order Processing
1	920	F4801	WA	128	32	Work Order Master File	Master Files	48: Work Order Processing	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 WADCTO, WADOCO, WASFXO, WARCTO, WARORN, WALNID, WAPTWO, WAPARS, WATYPS, WAPRTS, WADL01, WASTCM, WACO, WAMCU, WAMMCU, WALOCN, WAAISL, WABIN, WASRST, WADCG, WASUB, WAAN8, WAANO, WAANSA, WAANPA, WAANP, WADPL, WAANT, WANAN8, WATRDJ, WASTRT, WADRQJ, WASTRX, WADAP, WADAT, WAPPDT, WAWR01, WAWR02, WAWR03, WAWR04, WAWR05, WAWR06, WAWR07, WAWR08, WAWR09, WAWR10, WAVR01, WAVR02, WAAMTO, WASETC, WABRT, WAPAYT, WAAMTC, WAHRSO, WAHRSC, WAAMTA, WAHRSA, WAITM, WAAITM, WALITM, WANUMB, WAAPID, WAUORG, WASOBK, WASOCN, WASOQS, WAQTYT, WAUOM, WASHNO, WAPBTM, WATBM, WATRT, WASHTY, WAPEC, WAPPFG, WABM, WARTG, WASPRT, WAUNCD, WAINDC, WARESC, WAMOH, WATDT, WAPOU, WAPC, WALTLV, WALTCM, WACTS1, WALOTN, WALOTP, WALOTG, WARAT1, WARAT2, WADCT, WASBLI, WARKCO, WABREV, WARREV, WADRWC, WARTCH, WAPNRQ, WAREAS, WAPHSE, WAXDSP, WABOMC, WAURCD, WAURDT, WAURAT, WAURAB, WAURRF, WAUSER, WAPID, WAJOBN, WAUPMJ, WATDAY, WAAAID, WANTST, WAXRTO, WAESDN, WAACDN, WASAID, WAMPOS, WAAPRT, WAAMLC, WAAMMC, WAAMOT, WALBAM, WAMTAM FROM F4801

TOP 920 | 48 | F4801 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WADCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
2	WADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	WASFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
4	WARCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
5	WARORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
6	WALNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
7	WAPTWO	Peg to Work Order	Numeric	Generic Edit	8	0	Allow NULL?
8	WAPARS	Number - Parent WO Number	String	Generic Edit	8	0	Allow NULL?
9	WATYPS	Type - W.O.	Character	UDC (00 TY)	1	0	Allow NULL?
10	WAPRTS	Priority - W.O.	Character	UDC (00 PR)	1	0	Allow NULL?
11	WADL01	Description	String	Generic Edit	30	0	Allow NULL?
12	WASTCM	Status - Comment	String	Generic Edit	30	0	Allow NULL?
13	WACO	Company	String	Generic Edit	5	0	Allow NULL?
14	WAMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
15	WAMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
16	WALOCN	Location	String	Generic Edit	20	0	Allow NULL?
17	WAAISL	Aisle	String	Generic Edit	8	0	Allow NULL?
18	WABIN	Bin	String	Generic Edit	8	0	Allow NULL?
19	WASRST	Status Code W.O.	String	UDC (00 SS)	2	0	Allow NULL?
20	WADCG	Date - Status Changed	Date	Generic Edit	6	0
21	WASUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
22	WAAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
23	WAANO	Address Number - Originator	Numeric	Generic Edit	8	0	Allow NULL?
24	WAANSA	Address Number - Manager	Numeric	Generic Edit	8	0	Allow NULL?
25	WAANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
26	WAANP	Address Number - Assigned To	Numeric	Generic Edit	8	0	Allow NULL?
27	WADPL	Date - W.O. Planned Completed	Date	Generic Edit	6	0
28	WAANT	Address Number - Inspector	Numeric	Generic Edit	8	0	Allow NULL?
29	WANAN8	Next Address Number	Numeric	Generic Edit	8	0	Allow NULL?
30	WATRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
31	WASTRT	Date - Start (Julian)	Date	Generic Edit	6	0
32	WADRQJ	Date - Requested	Date	Generic Edit	6	0
33	WASTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
34	WADAP	Date - Assigned to	Date	Generic Edit	6	0
35	WADAT	Date - Assigned to Inspector	Date	Generic Edit	6	0
36	WAPPDT	Date - Paper Printed Date	Date	Generic Edit	6	0
37	WAWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
38	WAWR02	Categories - Work Order 02	String	UDC (00 W2)	3	0	Allow NULL?
39	WAWR03	Categories - Work Order 03	String	UDC (00 W3)	3	0	Allow NULL?
40	WAWR04	Categories - Work Order 04	String	UDC (00 W4)	3	0	Allow NULL?
41	WAWR05	Categories - Work Order 05	String	UDC (00 W5)	3	0	Allow NULL?
42	WAWR06	EnterpriseOne Consulting - Status	String	UDC (00 W6)	3	0	Allow NULL?
43	WAWR07	EnterpriseOne Consulting - Service Type	String	UDC (00 W7)	3	0	Allow NULL?
44	WAWR08	EnterpriseOne Consulting - Skill Type	String	UDC (00 W8)	3	0	Allow NULL?
45	WAWR09	E1 Consulting - Experience Level	String	UDC (00 W9)	3	0	Allow NULL?
46	WAWR10	Categories - Work Order 10	String	UDC (00 W0)	3	0	Allow NULL?
47	WAVR01	Reference	String	Generic Edit	25	0	Allow NULL?
48	WAVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
49	WAAMTO	Amount - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
50	WASETC	Crew Size	Numeric	Generic Edit	5	1	Allow NULL?
51	WABRT	Revenue Rate Markup Override	Numeric	Generic Edit	15	2	Allow NULL?
52	WAPAYT	Pay/Deduction/Benefit Type	String	Generic Edit	5	0	Allow NULL?
53	WAAMTC	Amount - Change to Original Dollars	Numeric	Generic Edit	15	2	Allow NULL?
54	WAHRSO	Hours - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
55	WAHRSC	Hours - Change to Original Hours	Numeric	Generic Edit	15	2	Allow NULL?
56	WAAMTA	Amount - Actual	Numeric	Generic Edit	15	2	Allow NULL?
57	WAHRSA	Hours - Actual	Numeric	Generic Edit	15	2	Allow NULL?
58	WAITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
59	WAAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
60	WALITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
61	WANUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
62	WAAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
63	WAUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
64	WASOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
65	WASOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
66	WASOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
67	WAQTYT	Units - Shipped to Date	Numeric	Generic Edit	15	0	Allow NULL?
68	WAUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
69	WASHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
70	WAPBTM	Time - Beginning (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
71	WATBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
72	WATRT	Type of Routing	String	UDC (40 TR)	3	0	Allow NULL?
73	WASHTY	WO Pick List Printed	Character	UDC (H00 SH)	1	0	Allow NULL?
74	WAPEC	Posting Edit	Character	UDC (H00 PE)	1	0	Allow NULL?
75	WAPPFG	Variance Flag	Character	UDC (H00 PP)	1	0	Allow NULL?
76	WABM	Bill of Material (N)	Character	Generic Edit	1	0	Allow NULL?
77	WARTG	Route Sheet (N)	Character	Generic Edit	1	0	Allow NULL?
78	WASPRT	Work Order Flash Message	Character	UDC (00 WM)	1	0	Allow NULL?
79	WAUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
80	WAINDC	Indented Code	Character	Generic Edit	1	0	Allow NULL?
81	WARESC	Resequence Code	Numeric	Generic Edit	5	2	Allow NULL?
82	WAMOH	Amount - Miles or Hours (units)	Numeric	Generic Edit	15	2	Allow NULL?
83	WATDT	Date - Scheduled Tickler	Date	Generic Edit	6	0
84	WAPOU	Amount - Memo Budget Changes	Numeric	Generic Edit	15	2	Allow NULL?
85	WAPC	Percent Complete	Numeric	Generic Edit	5	0	Allow NULL?
86	WALTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
87	WALTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
88	WACTS1	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
89	WALOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
90	WALOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
91	WALOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
92	WARAT1	Ratio _ Critical Ratio Priority 1	Numeric	Generic Edit	5	2	Allow NULL?
93	WARAT2	Ratio - Critical Ratio Priority 2	Numeric	Generic Edit	5	2	Allow NULL?
94	WADCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
95	WASBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
96	WARKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
97	WABREV	Bill Revision Level	String	Generic Edit	3	0	Allow NULL?
98	WARREV	Routing Revision Level	String	Generic Edit	3	0	Allow NULL?
99	WADRWC	Drawing Change	Character	Generic Edit	1	0	Allow NULL?
100	WARTCH	Routing Change	Character	Generic Edit	1	0	Allow NULL?
101	WAPNRQ	New Part Number	Character	Generic Edit	1	0	Allow NULL?
102	WAREAS	Reason for ECO	String	UDC (40 CR)	2	0	Allow NULL?
103	WAPHSE	Phase In	String	UDC (40 PH)	3	0	Allow NULL?
104	WAXDSP	Existing Disposition	String	UDC (40 ED)	3	0	Allow NULL?
105	WABOMC	BOM Change	Character	Generic Edit	1	0	Allow NULL?
106	WAURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
107	WAURDT	User Reserved Date	Date	Generic Edit	6	0
108	WAURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
109	WAURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
110	WAURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
111	WAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
112	WAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
113	WAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
114	WAUPMJ	Date - Updated	Date	Generic Edit	6	0
115	WATDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
116	WAAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
117	WANTST	Next Status - W.O.	String	UDC (00 SS)	2	0	Allow NULL?
118	WAXRTO	Criticality - Work Order	Numeric	Generic Edit	4	0	Allow NULL?
119	WAESDN	Estimated Downtime Hours	Numeric	Generic Edit	5	2	Allow NULL?
120	WAACDN	Actual Downtime Hours	Numeric	Generic Edit	5	2	Allow NULL?
121	WASAID	Service Address Number	Numeric	Generic Edit	8	0	Allow NULL?
122	WAMPOS	Meter Position	Numeric	Generic Edit	3	0	Allow NULL?
123	WAAPRT	Approval Type	String	UDC (48 AP)	3	0	Allow NULL?
124	WAAMLC	Amount - Estimated Labor	Numeric	Generic Edit	15	2	Allow NULL?
125	WAAMMC	Amount - Estimated Material	Numeric	Generic Edit	15	2	Allow NULL?
126	WAAMOT	Amount - Estimated Other	Numeric	Generic Edit	15	2	Allow NULL?
127	WALBAM	Amount - Actual Labor	Numeric	Generic Edit	15	2	Allow NULL?
128	WAMTAM	Amount - Actual Material	Numeric	Generic Edit	15	2	Allow NULL?

TOP 920 | 48 | F4801 INDEXES

Number

Description

Document Number (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending

ParentWO Category01 +G

Element	Alias	Description	Sequence
1	PARS	Number - Parent WO Number	Ascending
2	WR01	Categories - Work Order 01	Ascending
3	WR02	Categories - Work Order 02	Ascending
4	WR03	Categories - Work Order 03	Ascending
5	TYPS	Type - W.O.	Ascending
6	PRTS	Priority - W.O.	Ascending
7	DOCO	Document (Order No Invoice etc.)	Ascending

Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

Item Branch

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MMCU	Branch	Ascending
3	DRQJ	Date - Requested	Ascending

Order Number Type

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending

address number phase +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	WR01	Categories - Work Order 01	Ascending
3	DPL	Date - W.O. Planned Completed	Ascending

reference status +d

Element	Alias	Description	Sequence
1	VR01	Reference	Ascending
2	SRST	Status Code W.O.	Ascending
3	DPL	Date - W.O. Planned Completed	Ascending

originator status +d

Element	Alias	Description	Sequence
1	ANO	Address Number - Originator	Ascending
2	SRST	Status Code W.O.	Ascending
3	DPL	Date - W.O. Planned Completed	Ascending

business unit phase +d

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	WR01	Categories - Work Order 01	Ascending
3	DPL	Date - W.O. Planned Completed	Ascending

supervisor status +d

Element	Alias	Description	Sequence
1	ANPA	Supervisor	Ascending
2	SRST	Status Code W.O.	Ascending
3	DPL	Date - W.O. Planned Completed	Ascending

manager status +d

Element	Alias	Description	Sequence
1	ANSA	Address Number - Manager	Ascending
2	SRST	Status Code W.O.	Ascending
3	DPL	Date - W.O. Planned Completed	Ascending

order date order number

Element	Alias	Description	Sequence
1	TRDJ	Date - Order/Transaction	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending

completed date order number

Element	Alias	Description	Sequence
1	STRX	Date - Completion (Julian)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending

start date order number

Element	Alias	Description	Sequence
1	STRT	Date - Start (Julian)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending

item number categorywo +c

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	Ascending
2	WR01	Categories - Work Order 01	Ascending
3	WR02	Categories - Work Order 02	Ascending
4	WR03	Categories - Work Order 03	Ascending
5	TYPS	Type - W.O.	Ascending
6	PRTS	Priority - W.O.	Ascending
7	DOCO	Document (Order No Invoice etc.)	Ascending

WO Category Code W1

Element	Alias	Description	Sequence
1	WR01	Categories - Work Order 01	Ascending

WO Category Code W2

Element	Alias	Description	Sequence
1	WR02	Categories - Work Order 02	Ascending

WO Category Code W3

Element	Alias	Description	Sequence
1	WR03	Categories - Work Order 03	Ascending

WO Category Code W4

Element	Alias	Description	Sequence
1	WR04	Categories - Work Order 04	Ascending

WO Category Code W5

Element	Alias	Description	Sequence
1	WR05	Categories - Work Order 05	Ascending

WO Category Code W6

Element	Alias	Description	Sequence
1	WR06	EnterpriseOne Consulting - Status	Ascending

WO Category Code W7

Element	Alias	Description	Sequence
1	WR07	EnterpriseOne Consulting - Service Type	Ascending

WO Category Code W8

Element	Alias	Description	Sequence
1	WR08	EnterpriseOne Consulting - Skill Type	Ascending

WO Category Code W9

Element	Alias	Description	Sequence
1	WR09	E1 Consulting - Experience Level	Ascending

WO Category Code W0

Element	Alias	Description	Sequence
1	WR10	Categories - Work Order 10	Ascending

Document No. Sts Code +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	SRST	Status Code W.O.	Ascending
3	STRX	Date - Completion (Julian)	Ascending

Asset Status +

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	Ascending
2	SRST	Status Code W.O.	Ascending
3	TRDJ	Date - Order/Transaction	Ascending

Inventory Status +

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	SRST	Status Code W.O.	Ascending
3	TRDJ	Date - Order/Transaction	Ascending

Address Status +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	SRST	Status Code W.O.	Ascending
3	TRDJ	Date - Order/Transaction	Ascending

Work Order Status +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	SRST	Status Code W.O.	Ascending
3	TRDJ	Date - Order/Transaction	Ascending

Related Order No Ty Co

Element	Alias	Description	Sequence
1	RORN	Related PO/SO/WO Number	Ascending
2	RCTO	Related PO/SO/WO Order Type	Ascending
3	RKCO	Company - Key (Related Order)	Ascending

PegToWo Doco

Element	Alias	Description	Sequence
1	PTWO	Peg to Work Order	Ascending
2	DOCO	Document (Order No Invoice etc.)	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

128 COLUMNS | 32 INDEXES | 920 | 48 | F4801 TABLE

TOP 920 | 48 | F4801 COLUMNS

TOP 920 | 48 | F4801 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

128 COLUMNS | 32 INDEXES | 920 | 48 | F4801 TABLE

TOP920 | 48 | F4801 COLUMNS

TOP920 | 48 | F4801 INDEXES

TOP 920 | 48 | F4801 COLUMNS

TOP 920 | 48 | F4801 INDEXES