	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

127 COLUMNS | 6 INDEXES | 920 | 48 | F4801T TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
48: Work Order Processing
1	920	F4801T	WA	127	6	Work Order Master Tag 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 WADOCO, WALINE, WAMWDH, WASCSP, WASHFT, WASRCN, WALEDG, WACTS4, WACTS7, WACTS8, WAAID, WAALSE, WAASID, WAATST, WABSEQ, WACHPR, WACRCD, WACRCE, WACRCF, WAD5J, WAD6J, WADRAW, WADUAL, WAMPCE, WAMPRC, WAOBJ, WAOTAM, WAPRJM, WAPRRP, WASHPP, WASQOR, WASRKF, WASRNK, WASSOQ, WATRAF, WAUOM2, WAWR11, WAWR12, WAWR13, WAWR14, WAWR15, WAWR16, WAWR17, WAWR18, WAWR19, WAWR20, WAJBCD, WAVFWO, WAPMTN, WAISSUE, WAPRODM, WAWHO2, WAAR1, WAPHN1, WATMCO, WAMTHPR, WAENTCK, WARYIN, WARSTM, WACTR, WAREGION, WATXA1, WAEXR1, WALNGP, WAGLCCV, WAGLCNC, WACOVGR, WAASN4, WAASN2, WASEST, WASEET, WADSAVNAME, WATIMEZONES, WAPRODF, WACSLPRT, WAMCUCSL, WARLOT, WAFAILCD, WAFAILDT, WAFAILTM, WAREPDT, WAREPTM, WAVEND, WAAN8AS, WAAN8SRM, WASRYN, WAENTCKS, WACURBALM1, WACURBALM2, WACURBALM3, WACRDC, WACRRM, WACRR, WAVMRS31, WAVMRS32, WASEQN, WAPLMR, WAPLLB, WAPLOS, WABGTC, WATOEM, WATOPL, WAPLSA, WAPLSU, WAESSA, WAESSU, WAACSA, WAACSU, WAOACM, WARACM, WAHPLF, WAVMRS33, WASCALL, WAISNO, WARMTHD, WADOC, WADCT, WAKCO, WACOCH, WALNID, WACRTU, WAXEVT, WAMCULT, WAWSCHF, WADFMDP, WAPMPN, WAPNS FROM F4801T

TOP 920 | 48 | F4801T COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	WALINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
3	WAMWDH	Month/Week/Day/Shift	Character	UDC (31 RP)	1	0	Allow NULL?
4	WASCSP	Schedule Spread	Numeric	Generic Edit	2	0	Allow NULL?
5	WASHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
6	WASRCN	Serialized components	Character	UDC (31 SC)	1	0	Allow NULL?
7	WALEDG	Cost Method	String	UDC (40 CM)	2	0	Allow NULL?
8	WACTS4	Amount - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
9	WACTS7	Amount - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
10	WACTS8	Units - Unaccounted Scrap	Numeric	Generic Edit	15	0	Allow NULL?
11	WAAID	Account ID	String	Generic Edit	8	0	Allow NULL?
12	WAALSE	Alert Sensitive Task	Character	Generic Edit	1	0	Allow NULL?
13	WAASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
14	WAATST	Date - Actual Start (Julian)	Date	Generic Edit	6	0
15	WABSEQ	Sequence - Bubble Sequence	Numeric	Generic Edit	5	0	Allow NULL?
16	WACHPR	Charge Cost to Project Account	Character	Generic Edit	1	0	Allow NULL?
17	WACRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
18	WACRCE	Currency Code - Source	String	Generic Edit	3	0	Allow NULL?
19	WACRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
20	WAD5J	Date - Other 5	Date	Generic Edit	6	0
21	WAD6J	Date - Other 6	Date	Generic Edit	6	0
22	WADRAW	Drawing Number	String	Generic Edit	20	0	Allow NULL?
23	WADUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
24	WAMPCE	Production Costs Exist	Character	UDC (00 ZO)	1	0	Allow NULL?
25	WAMPRC	Changes to Parts And Routings Allowed	Character	UDC (00 ZO)	1	0	Allow NULL?
26	WAOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
27	WAOTAM	Amount - Actual Other	Numeric	Generic Edit	15	2	Allow NULL?
28	WAPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
29	WAPRRP	Direct Project Relationship	Character	Generic Edit	1	0	Allow NULL?
30	WASHPP	Ship This Phase	Character	UDC (00 ZO)	1	0	Allow NULL?
31	WASQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
32	WASRKF	Shrink Factor Method	Character	UDC (H40 SR)	1	0	Allow NULL?
33	WASRNK	Shrink Factor	Numeric	Generic Edit	15	2	Allow NULL?
34	WASSOQ	Secondary Quantity Completed	Numeric	Generic Edit	15	0	Allow NULL?
35	WATRAF	Resources Assigned	Character	UDC (00 ZO)	1	0	Allow NULL?
36	WAUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
37	WAWR11	Categories - Work Order 11	String	UDC (00 X1)	3	0	Allow NULL?
38	WAWR12	Categories - Work Order 12	String	UDC (00 X2)	3	0	Allow NULL?
39	WAWR13	Categories - Work Order 13	String	UDC (00 X3)	3	0	Allow NULL?
40	WAWR14	Categories - Work Order 14	String	UDC (00 X4)	3	0	Allow NULL?
41	WAWR15	Categories - Work Order 15	String	UDC (00 X5)	3	0	Allow NULL?
42	WAWR16	Categories - Work Order 16	String	UDC (00 X6)	3	0	Allow NULL?
43	WAWR17	Categories - Work Order 17	String	UDC (00 X7)	3	0	Allow NULL?
44	WAWR18	Categories - Work Order 18	String	UDC (00 X8)	3	0	Allow NULL?
45	WAWR19	Categories - Work Order 19	String	UDC (00 X9)	3	0	Allow NULL?
46	WAWR20	Categories - Work Order 20	String	UDC (00 X0)	3	0	Allow NULL?
47	WAJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
48	WAVFWO	Firm Work Order	Character	Generic Edit	1	0	Allow NULL?
49	WAPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
50	WAISSUE	Problem Description	String	Generic Edit	80	0	Allow NULL?
51	WAPRODM	Product Model	String	UDC (17 PM)	8	0	Allow NULL?
52	WAWHO2	Contact Name 2	String	Generic Edit	40	0	Allow NULL?
53	WAAR1	Phone Prefix	String	Generic Edit	6	0	Allow NULL?
54	WAPHN1	Phone Number	String	Generic Edit	20	0	Allow NULL?
55	WATMCO	Time - Completed	Numeric	Generic Edit	6	0	Allow NULL?
56	WAMTHPR	Method of Pricing	Character	UDC (17 MP)	1	0	Allow NULL?
57	WAENTCK	Entitlement Check	String	UDC (17 ER)	3	0	Allow NULL?
58	WARYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
59	WARSTM	Time - Guaranteed Response	Numeric	Generic Edit	5	2	Allow NULL?
60	WACTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
61	WAREGION	Geographic Region Code	String	UDC (17 GR)	3	0	Allow NULL?
62	WATXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
63	WAEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
64	WALNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
65	WAGLCCV	Category - G/L Covered	String	UDC (41 9)	4	0	Allow NULL?
66	WAGLCNC	Category - G/L Non-Covered	String	UDC (41 9)	4	0	Allow NULL?
67	WACOVGR	Coverage Group	String	UDC (17 CG)	8	0	Allow NULL?
68	WAASN4	Price and Adjustment Schedule-Four	String	UDC (40 AS)	8	0	Allow NULL?
69	WAASN2	Price and Adjustment Schedule-Service	String	UDC (40 AS)	8	0	Allow NULL?
70	WASEST	Time - Scheduled Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
71	WASEET	Time - Scheduled End (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
72	WADSAVNAME	Daylight Savings Rule Name	String	UDC	10	0	Allow NULL?
73	WATIMEZONES	Time Zone List	String	UDC (H91 TZ)	2	0	Allow NULL?
74	WAPRODF	Product Family	String	UDC (17 PA)	8	0	Allow NULL?
75	WACSLPRT	Causal Part	Numeric	Generic Edit	8	0	Allow NULL?
76	WAMCUCSL	Causal Part Business Unit	String	Generic Edit	12	0	Allow NULL?
77	WARLOT	Supplier Lot Number	String	Generic Edit	30	0	Allow NULL?
78	WAFAILCD	Defect Code	String	UDC (17 DC)	8	0	Allow NULL?
79	WAFAILDT	Failure Date	Date	Generic Edit	6	0
80	WAFAILTM	Failure Time	Numeric	Generic Edit	6	0	Allow NULL?
81	WAREPDT	Repair Date	Date	Generic Edit	6	0
82	WAREPTM	Repair Time	Numeric	Generic Edit	6	0	Allow NULL?
83	WAVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
84	WAAN8AS	Assessor Number	Numeric	Generic Edit	8	0	Allow NULL?
85	WAAN8SRM	Supplier Recovery Manager Number	Numeric	Generic Edit	8	0	Allow NULL?
86	WASRYN	Eligible Supplier Recovery	Character	UDC (17 SR)	1	0	Allow NULL?
87	WAENTCKS	Entitlement Check Supplier	String	Generic Edit	3	0	Allow NULL?
88	WACURBALM1	Current Balance of Meter 1	Numeric	Generic Edit	15	0	Allow NULL?
89	WACURBALM2	Current Balance of Meter 2	Numeric	Generic Edit	15	0	Allow NULL?
90	WACURBALM3	Current Balance of Meter 3	Numeric	Generic Edit	15	0	Allow NULL?
91	WACRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
92	WACRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
93	WACRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
94	WAVMRS31	Component Code - System	String	UDC (17 C6)	2	0	Allow NULL?
95	WAVMRS32	Component Code - Assembly	String	UDC (17 C7)	8	0	Allow NULL?
96	WASEQN	Sequence Number	Numeric	Generic Edit	7	0	Allow NULL?
97	WAPLMR	Planned Material	Numeric	Generic Edit	15	2	Allow NULL?
98	WAPLLB	Planned Labor	Numeric	Generic Edit	15	2	Allow NULL?
99	WAPLOS	Planned Other	Numeric	Generic Edit	15	2	Allow NULL?
100	WABGTC	Budgeted Cost	Numeric	Generic Edit	15	2	Allow NULL?
101	WATOEM	Total Estimated	Numeric	Generic Edit	15	2	Allow NULL?
102	WATOPL	Total Planned	Numeric	Generic Edit	15	2	Allow NULL?
103	WAPLSA	Planned Special Amount	Numeric	Generic Edit	15	2	Allow NULL?
104	WAPLSU	Planned Special Units	Numeric	Generic Edit	15	2	Allow NULL?
105	WAESSA	Estimated Special Amount	Numeric	Generic Edit	15	2	Allow NULL?
106	WAESSU	Estimated Special Units	Numeric	Generic Edit	15	2	Allow NULL?
107	WAACSA	Actual Special Amount	Numeric	Generic Edit	15	2	Allow NULL?
108	WAACSU	Actual Special Units	Numeric	Generic Edit	15	2	Allow NULL?
109	WAOACM	Amount Committed - Original	Numeric	Generic Edit	15	2	Allow NULL?
110	WARACM	Amount Committed - Remaining	Numeric	Generic Edit	15	2	Allow NULL?
111	WAHPLF	Held Parts List Flag	Character	Generic Edit	1	0	Allow NULL?
112	WAVMRS33	Component Code - Part	String	UDC (17 C8)	10	0	Allow NULL?
113	WASCALL	Call Backs	Character	UDC (17 CB)	1	0	Allow NULL?
114	WAISNO	Issue Number	Numeric	Generic Edit	8	0	Allow NULL?
115	WARMTHD	Reimbursement Method	Character	Generic Edit	1	0	Allow NULL?
116	WADOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
117	WADCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
118	WAKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
119	WACOCH	Contract Change Number	String	Generic Edit	3	0	Allow NULL?
120	WALNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
121	WACRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
122	WAXEVT	External Event Flag	Character	Generic Edit	1	0	Allow NULL?
123	WAMCULT	Lead Craft	String	Generic Edit	12	0	Allow NULL?
124	WAWSCHF	Maintenance Schedule Flag	Character	UDC (13 WS)	1	0	Allow NULL?
125	WADFMDP	DFM Daily Plan	Character	Generic Edit	1	0	Allow NULL?
126	WAPMPN	Production Number	String	Generic Edit	30	0	Allow NULL?
127	WAPNS	Production Number Short	Numeric	Generic Edit	10	0	Allow NULL?

TOP 920 | 48 | F4801T INDEXES

Number

Description

Order Number (Primary/Unique)

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

DOCO PRJM

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	PRJM	Project Number	Ascending

PRJM SEQN

Element	Alias	Description	Sequence
1	PRJM	Project Number	Ascending
2	SEQN	Sequence Number	Ascending

Product Model

Element	Alias	Description	Sequence
1	PRODM	Product Model	Ascending

Defect Code

Element	Alias	Description	Sequence
1	FAILCD	Defect Code	Ascending

PMPN PNS

Element	Alias	Description	Sequence
1	PMPN	Production Number	Ascending
2	PNS	Production Number Short	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

127 COLUMNS | 6 INDEXES | 920 | 48 | F4801T TABLE

TOP 920 | 48 | F4801T COLUMNS

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

127 COLUMNS | 6 INDEXES | 920 | 48 | F4801T TABLE

TOP920 | 48 | F4801T COLUMNS

TOP920 | 48 | F4801T INDEXES

TOP 920 | 48 | F4801T COLUMNS

TOP 920 | 48 | F4801T INDEXES