	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

160 COLUMNS | 2 INDEXES | 920 | 17 | F3111Z2 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
17: Customer Service Management
1	920	F3111Z2	WP	160	2	Warranty Claim/Supplier Recovery processing	Batch Input 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 WPEDUS, WPEDBT, WPEDTN, WPEDLN, WPEDCT, WPTYTN, WPEDFT, WPEDDT, WPDRIN, WPEDDL, WPEDSP, WPPNID, WPTNAC, WPDOCO, WPDCTO, WPSFXO, WPTBM, WPFORQ, WPITC, WPCOBY, WPCOTY, WPCPNT, WPFRMP, WPTHRP, WPFRGD, WPTHGD, WPRKCO, WPRORN, WPRCTO, WPRLLN, WPOPSQ, WPBSEQ, WPRSCP, WPSCRP, WPREWP, WPASIP, WPCPYP, WPSTPP, WPLOVD, WPCPIT, WPCPIL, WPCPIA, WPCMCU, WPDSC1, WPDSC2, WPLOCN, WPLOTN, WPAN8, WPLNTY, WPSERN, WPTRDJ, WPDRQJ, WPUORG, WPTRQT, WPSOCN, WPSOBK, WPCTS1, WPQNTA, WPUM, WPEA, WPRTG, WPMTST, WPDCT, WPSHNO, WPMCU, WPOMCU, WPOBJ, WPSUB, WPCMRV, WPSTRX, WPPARS, WPCOMM, WPUKID, WPURCD, WPURDT, WPURAT, WPURAB, WPURRF, WPTORG, WPPOC, WPVEND, WPCTS4, WPCTS7, WPCTS8, WPUSER, WPPID, WPJOBN, WPUPMJ, WPTDAY, WPGLD, WPSBFL, WPAING, WPSSTQ, WPUOM2, WPAPSC, WPPSN, WPDLEJ, WPCOST, WPCHPP, WPCPNB, WPBSEQAN, WPESUNC, WPESUNB, WPESUNP, WPEPAAP, WPAMTO, WPEBILL, WPACUNC, WPACUNB, WPACUNP, WPAMTA, WPTOTB, WPPAAP, WPCLAMT, WPPAYAB, WPBILL, WPDTPAY, WPDTBIL, WPGLCNC, WPGLCCV, WPENTCK, WPVR02, WPASN4, WPASN2, WPPCOVR, WPMTHPR, WPSAID, WPPRODF, WPPRODM, WPCOVGR, WPPMTHP, WPPYPRT, WPCRDC, WPBCRCD, WPBCRR, WPBCRRM, WPFESUNB, WPFEBILL, WPFACUNB, WPFTOTB, WPPCRCD, WPPCRR, WPPCRRM, WPFESUNP, WPFEPAAP, WPFACUNP, WPFPAAP, WPFAILCD, WPRETPOL, WPDTSUB, WPTMSUB, WPCSLPRT, WPMCUCSL, WPSRVEND, WPRLOT, WPTAX1, WPUKIDP, WPVMRS31, WPVMRS32, WPVMRS33 FROM F3111Z2

TOP 920 | 17 | F3111Z2 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WPEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	WPEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	WPEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	WPEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	WPEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	WPTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	WPEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	WPEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	WPDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	WPEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	WPEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	WPPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	WPTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	WPDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
15	WPDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
16	WPSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
17	WPTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
18	WPFORQ	Fixed or Variable Quantity	Character	UDC (H40 FO)	1	0	Allow NULL?
19	WPITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
20	WPCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
21	WPCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
22	WPCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
23	WPFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
24	WPTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
25	WPFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
26	WPTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
27	WPRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
28	WPRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
29	WPRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
30	WPRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
31	WPOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
32	WPBSEQ	Sequence - Bubble Sequence	Numeric	Generic Edit	5	0	Allow NULL?
33	WPRSCP	Resource Percent	Numeric	Generic Edit	5	2	Allow NULL?
34	WPSCRP	Percent - Percent of Scrap	Numeric	Generic Edit	5	2	Allow NULL?
35	WPREWP	Percent - Rework	Numeric	Generic Edit	5	2	Allow NULL?
36	WPASIP	Percent - As is	Numeric	Generic Edit	5	2	Allow NULL?
37	WPCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
38	WPSTPP	Operation Scrap Percent	Numeric	Generic Edit	5	2	Allow NULL?
39	WPLOVD	Leadtime Offset Days	Numeric	Generic Edit	6	0	Allow NULL?
40	WPCPIT	Component Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
41	WPCPIL	Component 2nd Item Number	String	Generic Edit	25	0	Allow NULL?
42	WPCPIA	Component 3rd Item Number	String	Generic Edit	25	0	Allow NULL?
43	WPCMCU	Component Branch	String	Generic Edit	12	0	Allow NULL?
44	WPDSC1	Description	String	Generic Edit	30	0	Allow NULL?
45	WPDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
46	WPLOCN	Location	String	Generic Edit	20	0	Allow NULL?
47	WPLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
48	WPAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
49	WPLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
50	WPSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
51	WPTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
52	WPDRQJ	Date - Requested	Date	Generic Edit	6	0
53	WPUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
54	WPTRQT	Quantity Available	Numeric	Generic Edit	15	0	Allow NULL?
55	WPSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
56	WPSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
57	WPCTS1	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
58	WPQNTA	Units - Quantity Commited	Numeric	Generic Edit	15	0	Allow NULL?
59	WPUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
60	WPEA	Amount - Estimated Cost	Numeric	Generic Edit	15	2	Allow NULL?
61	WPRTG	Route Sheet (N)	Character	Generic Edit	1	0	Allow NULL?
62	WPMTST	Material Status Code W.O.	String	UDC (31 MS)	2	0	Allow NULL?
63	WPDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
64	WPSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
65	WPMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
66	WPOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
67	WPOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
68	WPSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
69	WPCMRV	Component Revision Level	String	Generic Edit	3	0	Allow NULL?
70	WPSTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
71	WPPARS	Number - Parent WO Number	String	Generic Edit	8	0	Allow NULL?
72	WPCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
73	WPUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
74	WPURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
75	WPURDT	User Reserved Date	Date	Generic Edit	6	0
76	WPURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
77	WPURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
78	WPURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
79	WPTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
80	WPPOC	Issue and Receipt	Character	UDC (43 IR)	1	0	Allow NULL?
81	WPVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
82	WPCTS4	Amount - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
83	WPCTS7	Amount - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
84	WPCTS8	Units - Unaccounted Scrap	Numeric	Generic Edit	15	0	Allow NULL?
85	WPUSER	User ID	String	Generic Edit	10	0	Allow NULL?
86	WPPID	Program ID	String	Generic Edit	10	0	Allow NULL?
87	WPJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
88	WPUPMJ	Date - Updated	Date	Generic Edit	6	0
89	WPTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
90	WPGLD	G/L Date	Date	Generic Edit	6	0
91	WPSBFL	Parts List Substitute Flag	Character	Generic Edit	1	0	Allow NULL?
92	WPAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
93	WPSSTQ	Secondary Quantity Issued/Completed	Numeric	Generic Edit	15	0	Allow NULL?
94	WPUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
95	WPAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
96	WPPSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
97	WPDLEJ	Lot Effectivity Date	Date	Generic Edit	6	0
98	WPCOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
99	WPCHPP	Critical Hold Propagation	Character	Generic Edit	1	0	Allow NULL?
100	WPCPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
101	WPBSEQAN	Bubble Sequence Alpha Numeric	String	Generic Edit	5	0	Allow NULL?
102	WPESUNC	Estimated Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
103	WPESUNB	Estimated Unit Billable	Numeric	Generic Edit	15	4	Allow NULL?
104	WPESUNP	Estimated Unit Payable	Numeric	Generic Edit	15	4	Allow NULL?
105	WPEPAAP	Estimated Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
106	WPAMTO	Amount - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
107	WPEBILL	Estimated Amount	Numeric	Generic Edit	15	2	Allow NULL?
108	WPACUNC	Actual Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
109	WPACUNB	Actual Unit Billable	Numeric	Generic Edit	15	4	Allow NULL?
110	WPACUNP	Actual Unit Payable	Numeric	Generic Edit	15	4	Allow NULL?
111	WPAMTA	Amount - Actual	Numeric	Generic Edit	15	2	Allow NULL?
112	WPTOTB	Total Billed	Numeric	Generic Edit	15	2	Allow NULL?
113	WPPAAP	Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
114	WPCLAMT	Claim Amount	Numeric	Generic Edit	15	2	Allow NULL?
115	WPPAYAB	Payable (Y/N)	Character	UDC (17 YN)	1	0	Allow NULL?
116	WPBILL	Billable (Y/N)	Character	UDC (H00 BI)	1	0	Allow NULL?
117	WPDTPAY	Date - Paid	Date	Generic Edit	6	0
118	WPDTBIL	Date - Billed	Date	Generic Edit	6	0
119	WPGLCNC	Category - G/L Non-Covered	String	UDC (41 9)	4	0	Allow NULL?
120	WPGLCCV	Category - G/L Covered	String	UDC (41 9)	4	0	Allow NULL?
121	WPENTCK	Entitlement Check	String	UDC (17 ER)	3	0	Allow NULL?
122	WPVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
123	WPASN4	Price and Adjustment Schedule-Four	String	UDC (40 AS)	8	0	Allow NULL?
124	WPASN2	Price and Adjustment Schedule-Service	String	UDC (40 AS)	8	0	Allow NULL?
125	WPPCOVR	Percent Covered	Numeric	Generic Edit	5	2	Allow NULL?
126	WPMTHPR	Method of Pricing	Character	UDC (17 MP)	1	0	Allow NULL?
127	WPSAID	Service Address Number	Numeric	Generic Edit	8	0	Allow NULL?
128	WPPRODF	Product Family	String	UDC (17 PA)	8	0	Allow NULL?
129	WPPRODM	Product Model	String	UDC (17 PM)	8	0	Allow NULL?
130	WPCOVGR	Coverage Group	String	UDC (17 CG)	8	0	Allow NULL?
131	WPPMTHP	Pay Pricing Method	Character	UDC (17 MP)	1	0	Allow NULL?
132	WPPYPRT	Pay Service Provider for Parts	Character	UDC (17 YN)	1	0	Allow NULL?
133	WPCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
134	WPBCRCD	Billable Currency	String	Generic Edit	3	0	Allow NULL?
135	WPBCRR	Billable Exchange Rate	Numeric	Generic Edit	15	0	Allow NULL?
136	WPBCRRM	Billable Currency Mode	Character	UDC (H00 CY)	1	0	Allow NULL?
137	WPFESUNB	Foreign Estimated Billable Unit Rate	Numeric	Generic Edit	15	4	Allow NULL?
138	WPFEBILL	Foreign Estimated Billable Amount	Numeric	Generic Edit	15	2	Allow NULL?
139	WPFACUNB	Foreign Actual Billable Unit Rate	Numeric	Generic Edit	15	4	Allow NULL?
140	WPFTOTB	Foreign Actual Billable Amount	Numeric	Generic Edit	15	2	Allow NULL?
141	WPPCRCD	Payable Currency	String	Generic Edit	3	0	Allow NULL?
142	WPPCRR	Payable Exchange Rate	Numeric	Generic Edit	15	0	Allow NULL?
143	WPPCRRM	Payable Currency Mode	Character	UDC (H00 CY)	1	0	Allow NULL?
144	WPFESUNP	Foreign Estimated Payable Unit Rate	Numeric	Generic Edit	15	4	Allow NULL?
145	WPFEPAAP	Foreign Estimated Payable Amount	Numeric	Generic Edit	15	2	Allow NULL?
146	WPFACUNP	Foreign Actual Payable Unit Rate	Numeric	Generic Edit	15	4	Allow NULL?
147	WPFPAAP	Foreign Actual Payable Amount	Numeric	Generic Edit	15	2	Allow NULL?
148	WPFAILCD	Defect Code	String	UDC (17 DC)	8	0	Allow NULL?
149	WPRETPOL	Return Policy	Character	UDC (17 RT)	1	0	Allow NULL?
150	WPDTSUB	Date Submitted	Date	Generic Edit	6	0
151	WPTMSUB	Time Submitted	Numeric	Generic Edit	6	0	Allow NULL?
152	WPCSLPRT	Causal Part	Numeric	Generic Edit	8	0	Allow NULL?
153	WPMCUCSL	Causal Part Business Unit	String	Generic Edit	12	0	Allow NULL?
154	WPSRVEND	Supplier Recovery Vendor Number	Numeric	Generic Edit	8	0	Allow NULL?
155	WPRLOT	Supplier Lot Number	String	Generic Edit	30	0	Allow NULL?
156	WPTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
157	WPUKIDP	Unique Key Pricing	Numeric	Generic Edit	15	0	Allow NULL?
158	WPVMRS31	Component Code - System	String	UDC (17 C6)	2	0	Allow NULL?
159	WPVMRS32	Component Code - Assembly	String	UDC (17 C7)	8	0	Allow NULL?
160	WPVMRS33	Component Code - Part	String	UDC (17 C8)	10	0	Allow NULL?

TOP 920 | 17 | F3111Z2 INDEXES

Number

Description

User ID 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
5	UKID	Unique Key ID (Internal)	Ascending

User ID Batch Transaction +B

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
5	OPSQ	Sequence Number - Operations	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

160 COLUMNS | 2 INDEXES | 920 | 17 | F3111Z2 TABLE

TOP 920 | 17 | F3111Z2 COLUMNS

TOP 920 | 17 | F3111Z2 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

160 COLUMNS | 2 INDEXES | 920 | 17 | F3111Z2 TABLE

TOP920 | 17 | F3111Z2 COLUMNS

TOP920 | 17 | F3111Z2 INDEXES

TOP 920 | 17 | F3111Z2 COLUMNS

TOP 920 | 17 | F3111Z2 INDEXES