	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

148 COLUMNS | 2 INDEXES | 812 | 17 | F4801Z2 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
17: Customer Service Management
1	812	F4801Z2	WS	148	2	Warranty Claim/Supplier Recovery processing	Transaction Files	17: Customer Service Management	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 WSEDUS, WSEDBT, WSEDTN, WSEDLN, WSEDCT, WSTYTN, WSEDFT, WSEDDT, WSDRIN, WSEDDL, WSEDSP, WSPNID, WSTNAC, WSDCTO, WSRCD, WSDGL, WSLOTS, WSEXPR, WSLOT1, WSLOT2, WSDOCO, WSSFXO, WSRCTO, WSRORN, WSLNID, WSPTWO, WSPARS, WSTYPS, WSPRTS, WSDL01, WSSTCM, WSCO, WSMCU, WSMMCU, WSLOCN, WSAISL, WSBIN, WSSRST, WSDCG, WSSUB, WSAN8, WSANO, WSANSA, WSANPA, WSANP, WSDPL, WSANT, WSNAN8, WSTRDJ, WSSTRT, WSDRQJ, WSSTRX, WSDAP, WSDAT, WSPPDT, WSWR01, WSWR02, WSWR03, WSWR04, WSWR05, WSWR06, WSWR07, WSWR08, WSWR09, WSWR10, WSVR01, WSVR02, WSAMTO, WSSETC, WSBRT, WSPAYT, WSAMTC, WSHRSO, WSHRSC, WSAMTA, WSHRSA, WSITM, WSAITM, WSLITM, WSNUMB, WSAPID, WSUORG, WSSOBK, WSSOCN, WSSOQS, WSQTYT, WSUOM, WSSHNO, WSPBTM, WSTBM, WSTRT, WSSHTY, WSPEC, WSPPFG, WSBM, WSRTG, WSSPRT, WSUNCD, WSINDC, WSRESC, WSMOH, WSTDT, WSPOU, WSPC, WSLTLV, WSLTCM, WSCTS1, WSLOTN, WSLOTP, WSLOTG, WSRAT1, WSRAT2, WSDCT, WSSBLI, WSRKCO, WSBREV, WSRREV, WSDRWC, WSRTCH, WSPNRQ, WSREAS, WSPHSE, WSXDSP, WSBOMC, WSAAID, WSNTST, WSXRTO, WSESDN, WSACDN, WSSAID, WSMPOS, WSAPRT, WSAMLC, WSAMMC, WSAMOT, WSLBAM, WSMTAM, WSURCD, WSURDT, WSURAT, WSURAB, WSURRF, WSTORG, WSUSER, WSPID, WSJOBN, WSUPMJ, WSTDAY FROM F4801Z2

TOP 812 | 17 | F4801Z2 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WSEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	WSEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	WSEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	WSEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	WSEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	WSTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	WSEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	WSEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	WSDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	WSEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	WSEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	WSPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	WSTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	WSDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	WSRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
16	WSDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
17	WSLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
18	WSEXPR	Date - Expired	Date	Generic Edit	6	0
19	WSLOT1	Memo Lot 1	String	Generic Edit	30	0	Allow NULL?
20	WSLOT2	Memo Lot 2	String	Generic Edit	30	0	Allow NULL?
21	WSDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
22	WSSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
23	WSRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
24	WSRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
25	WSLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
26	WSPTWO	Peg to Work Order	Numeric	Generic Edit	8	0	Allow NULL?
27	WSPARS	Number - Parent WO Number	String	Generic Edit	8	0	Allow NULL?
28	WSTYPS	Type - W.O.	Character	UDC (00 TY)	1	0	Allow NULL?
29	WSPRTS	Priority - W.O.	Character	UDC (00 PR)	1	0	Allow NULL?
30	WSDL01	Description	String	Generic Edit	30	0	Allow NULL?
31	WSSTCM	Status - Comment	String	Generic Edit	30	0	Allow NULL?
32	WSCO	Company	String	Generic Edit	5	0	Allow NULL?
33	WSMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
34	WSMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
35	WSLOCN	Location	String	Generic Edit	20	0	Allow NULL?
36	WSAISL	Aisle	String	Generic Edit	8	0	Allow NULL?
37	WSBIN	Bin	String	Generic Edit	8	0	Allow NULL?
38	WSSRST	Status Code W.O.	String	UDC (00 SS)	2	0	Allow NULL?
39	WSDCG	Date - Status Changed	Date	Generic Edit	6	0
40	WSSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
41	WSAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
42	WSANO	Address Number - Originator	Numeric	Generic Edit	8	0	Allow NULL?
43	WSANSA	Address Number - Manager	Numeric	Generic Edit	8	0	Allow NULL?
44	WSANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
45	WSANP	Address Number - Assigned To	Numeric	Generic Edit	8	0	Allow NULL?
46	WSDPL	Date - W.O. Planned Completed	Date	Generic Edit	6	0
47	WSANT	Address Number - Inspector	Numeric	Generic Edit	8	0	Allow NULL?
48	WSNAN8	Next Address Number	Numeric	Generic Edit	8	0	Allow NULL?
49	WSTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
50	WSSTRT	Date - Start (Julian)	Date	Generic Edit	6	0
51	WSDRQJ	Date - Requested	Date	Generic Edit	6	0
52	WSSTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
53	WSDAP	Date - Assigned to	Date	Generic Edit	6	0
54	WSDAT	Date - Assigned to Inspector	Date	Generic Edit	6	0
55	WSPPDT	Date - Paper Printed Date	Date	Generic Edit	6	0
56	WSWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
57	WSWR02	Categories - Work Order 02	String	UDC (00 W2)	3	0	Allow NULL?
58	WSWR03	Categories - Work Order 03	String	UDC (00 W3)	3	0	Allow NULL?
59	WSWR04	Categories - Work Order 04	String	UDC (00 W4)	3	0	Allow NULL?
60	WSWR05	Categories - Work Order 05	String	UDC (00 W5)	3	0	Allow NULL?
61	WSWR06	EnterpriseOne Consulting - Status	String	UDC (00 W6)	3	0	Allow NULL?
62	WSWR07	EnterpriseOne Consulting - Service Type	String	UDC (00 W7)	3	0	Allow NULL?
63	WSWR08	EnterpriseOne Consulting - Skill Type	String	UDC (00 W8)	3	0	Allow NULL?
64	WSWR09	E1 Consulting - Experience Level	String	UDC (00 W9)	3	0	Allow NULL?
65	WSWR10	Categories - Work Order 10	String	UDC (00 W0)	3	0	Allow NULL?
66	WSVR01	Reference	String	Generic Edit	25	0	Allow NULL?
67	WSVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
68	WSAMTO	Amount - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
69	WSSETC	Crew Size	Numeric	Generic Edit	5	1	Allow NULL?
70	WSBRT	Revenue Rate Markup Override	Numeric	Generic Edit	15	2	Allow NULL?
71	WSPAYT	Pay/Deduction/Benefit Type	String	Generic Edit	5	0	Allow NULL?
72	WSAMTC	Amount - Change to Original Dollars	Numeric	Generic Edit	15	2	Allow NULL?
73	WSHRSO	Hours - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
74	WSHRSC	Hours - Change to Original Hours	Numeric	Generic Edit	15	2	Allow NULL?
75	WSAMTA	Amount - Actual	Numeric	Generic Edit	15	2	Allow NULL?
76	WSHRSA	Hours - Actual	Numeric	Generic Edit	15	2	Allow NULL?
77	WSITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
78	WSAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
79	WSLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
80	WSNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
81	WSAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
82	WSUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
83	WSSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	2	Allow NULL?
84	WSSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
85	WSSOQS	Quantity Shipped	Numeric	Generic Edit	15	2	Allow NULL?
86	WSQTYT	Units - Shipped to Date	Numeric	Generic Edit	15	2	Allow NULL?
87	WSUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
88	WSSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
89	WSPBTM	Time - Beginning (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
90	WSTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
91	WSTRT	Type of Routing	String	UDC (40 TR)	3	0	Allow NULL?
92	WSSHTY	WO Pick List Printed	Character	UDC (H00 SH)	1	0	Allow NULL?
93	WSPEC	Posting Edit	Character	UDC (H00 PE)	1	0	Allow NULL?
94	WSPPFG	Variance Flag	Character	UDC (H00 PP)	1	0	Allow NULL?
95	WSBM	Bill of Material (N)	Character	Generic Edit	1	0	Allow NULL?
96	WSRTG	Route Sheet (N)	Character	Generic Edit	1	0	Allow NULL?
97	WSSPRT	Work Order Flash Message	Character	UDC (00 WM)	1	0	Allow NULL?
98	WSUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
99	WSINDC	Indented Code	Character	Generic Edit	1	0	Allow NULL?
100	WSRESC	Resequence Code	Numeric	Generic Edit	5	2	Allow NULL?
101	WSMOH	Amount - Miles or Hours (units)	Numeric	Generic Edit	15	2	Allow NULL?
102	WSTDT	Date - Scheduled Tickler	Date	Generic Edit	6	0
103	WSPOU	Amount - Memo Budget Changes	Numeric	Generic Edit	15	2	Allow NULL?
104	WSPC	Percent Complete	Numeric	Generic Edit	5	0	Allow NULL?
105	WSLTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
106	WSLTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
107	WSCTS1	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
108	WSLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
109	WSLOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
110	WSLOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
111	WSRAT1	Ratio _ Critical Ratio Priority 1	Numeric	Generic Edit	5	2	Allow NULL?
112	WSRAT2	Ratio - Critical Ratio Priority 2	Numeric	Generic Edit	5	2	Allow NULL?
113	WSDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
114	WSSBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
115	WSRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
116	WSBREV	Bill Revision Level	String	Generic Edit	3	0	Allow NULL?
117	WSRREV	Routing Revision Level	String	Generic Edit	3	0	Allow NULL?
118	WSDRWC	Drawing Change	Character	Generic Edit	1	0	Allow NULL?
119	WSRTCH	Routing Change	Character	Generic Edit	1	0	Allow NULL?
120	WSPNRQ	New Part Number	Character	Generic Edit	1	0	Allow NULL?
121	WSREAS	Reason for ECO	String	UDC (40 CR)	2	0	Allow NULL?
122	WSPHSE	Phase In	String	UDC (40 PH)	3	0	Allow NULL?
123	WSXDSP	Existing Disposition	String	UDC (40 ED)	3	0	Allow NULL?
124	WSBOMC	BOM Change	Character	Generic Edit	1	0	Allow NULL?
125	WSAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
126	WSNTST	Next Status - W.O.	String	UDC (00 SS)	2	0	Allow NULL?
127	WSXRTO	Criticality - Work Order	Numeric	Generic Edit	4	0	Allow NULL?
128	WSESDN	Estimated Downtime Hours	Numeric	Generic Edit	5	2	Allow NULL?
129	WSACDN	Actual Downtime Hours	Numeric	Generic Edit	5	2	Allow NULL?
130	WSSAID	Service Address Number	Numeric	Generic Edit	8	0	Allow NULL?
131	WSMPOS	Meter Position	Numeric	Generic Edit	3	0	Allow NULL?
132	WSAPRT	Approval Type	String	UDC (48 AP)	3	0	Allow NULL?
133	WSAMLC	Amount - Estimated Labor	Numeric	Generic Edit	15	2	Allow NULL?
134	WSAMMC	Amount - Estimated Material	Numeric	Generic Edit	15	2	Allow NULL?
135	WSAMOT	Amount - Estimated Other	Numeric	Generic Edit	15	2	Allow NULL?
136	WSLBAM	Amount - Actual Labor	Numeric	Generic Edit	15	2	Allow NULL?
137	WSMTAM	Amount - Actual Material	Numeric	Generic Edit	15	2	Allow NULL?
138	WSURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
139	WSURDT	User Reserved Date	Date	Generic Edit	6	0
140	WSURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
141	WSURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
142	WSURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
143	WSTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
144	WSUSER	User ID	String	Generic Edit	10	0	Allow NULL?
145	WSPID	Program ID	String	Generic Edit	10	0	Allow NULL?
146	WSJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
147	WSUPMJ	Date - Updated	Date	Generic Edit	6	0
148	WSTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 812 | 17 | F4801Z2 INDEXES

Number

Description

UserID Batch Transaction +A (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

OrderNo Line Transaction +B

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	EDLN	EDI - Line Number	Ascending
3	TYTN	Type - Transaction	Ascending
4	TNAC	Transaction Action	Ascending
5	DRIN	Direction Indicator	Ascending
6	EDDL	EDI - Detail Lines Processed	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

148 COLUMNS | 2 INDEXES | 812 | 17 | F4801Z2 TABLE

TOP 812 | 17 | F4801Z2 COLUMNS

TOP 812 | 17 | F4801Z2 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

148 COLUMNS | 2 INDEXES | 812 | 17 | F4801Z2 TABLE

TOP812 | 17 | F4801Z2 COLUMNS

TOP812 | 17 | F4801Z2 INDEXES

TOP 812 | 17 | F4801Z2 COLUMNS

TOP 812 | 17 | F4801Z2 INDEXES