	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

147 columns | 920 | DRQJ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F5301	Change Request Master Table	20	DI	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP05A: PeopleSoft HR & PR Foundation
2	F05003	Verification of Employment Data	2	EV	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP05U: E1 HR & PR Foundation US
3	F053030	IRS Form W-4, Employee's Withholding Certificate	2	EW	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP17: Customer Service Management
4	F3111Z2	Warranty Claim/Supplier Recovery processing	52	WP	DRQJ	Date - Requested	Date	Generic Edit	6	0
5	F3112Z2	Warranty Claim/Supplier Recovery processing	39	WL	DRQJ	Date - Requested	Date	Generic Edit	6	0
6	F4801Z2	Warranty Claim/Supplier Recovery processing	51	WS	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP17C: Call Management
7	F1755	Case Master	125	ZA	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP30: Product Data Management
8	F3019	Kanban Replenishment Capacity	3	KR	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP31: Shop Floor Control
9	F3111	Work Order Parts List	39	WM	DRQJ	Date - Requested	Date	Generic Edit	6	0
10	F3111S	Purge - Shop Floor Parts List	39	WM	DRQJ	Date - Requested	Date	Generic Edit	6	0
11	F3111Z1	Outbound Work Order Parts List	52	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
12	F3112	Work Order Routing	26	WL	DRQJ	Date - Requested	Date	Generic Edit	6	0
13	F3112S	Purge Shop Floor Control Routing Instructions	26	WL	DRQJ	Date - Requested	Date	Generic Edit	6	0
14	F3112Z1	Outbound Work Order Routings	39	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
15	F3115	Net Change Transaction table	8	NC	DRQJ	Date - Requested	Date	Generic Edit	6	0
16	F3118	Shortage Maintenance Master File	5	WN	DRQJ	Date - Requested	Date	Generic Edit	6	0
17	F31UI006	Line Scheduling Workbench - Work File	32	LS	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP31P: Engineer To Order
18	F31P11	Project Quote Detail	35	QP	DRQJ	Date - Requested	Date	Generic Edit	6	0
19	F31PUI01	Scheduling Error Report	3	SE	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP33: Capacity Planning
20	F3311	Capacity Message File	9	CN	DRQJ	Date - Requested	Date	Generic Edit	6	0
21	F3312	Capacity Pegging	5	CW	DRQJ	Date - Requested	Date	Generic Edit	6	0
22	F33UI001	Shop Floor Control Routing Instructions	10	WL	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP34: Requirements Planning
23	F3411	MPS/MRP/DRP Message File	16	MM	DRQJ	Date - Requested	Date	Generic Edit	6	0
24	F3412	MPS/MRP/DRP Lower Level Requirements File	3	MW	DRQJ	Date - Requested	Date	Generic Edit	6	0
25	F3460	Forecast File	5	MF	DRQJ	Date - Requested	Date	Generic Edit	6	0
26	F34A70	Last Outbound Work Order Table	3	OW	DRQJ	Date - Requested	Date	Generic Edit	6	0
27	F34UI005	MRP Orders/Requirements User Index-Process Item	5	F5	DRQJ	Date - Requested	Date	Generic Edit	6	0
28	F34UI006	MRP Co/By Product Net Quantity User Index	4	W6	DRQJ	Date - Requested	Date	Generic Edit	6	0
29	F4321	Supplier Schedule Master File	18	PB	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP34X: In-Memory Planning Advisor
30	F34X200W	Planning Details Supply/Demand Work Table	23	SD	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP36: Forecasting
31	F3400	Forecast Summary File	16	SG	DRQJ	Date - Requested	Date	Generic Edit	6	0
32	F3460Z1	Forecast Unedited Transactions	18	FT	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP37: Quality Management
33	F37900	Certificate of Analysis (COA) Extract	78	TR	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP40: Inventory/OP Base
34	F4001Z	Batch Receiver File - Order Headings	39	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
35	F40051	Return Material Authorization	35	RD	DRQJ	Date - Requested	Date	Generic Edit	6	0
36	F4011Z	Batch Receiver File - Order Details	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
37	F4012ZW	WF - Destination Quantity	18	SP	DRQJ	Date - Requested	Date	Generic Edit	6	0
38	F4013Z	Kit Components Batch File	11	KS	DRQJ	Date - Requested	Date	Generic Edit	6	0
39	F40300R	Preference Resolution History - Master	7	PM	DRQJ	Date - Requested	Date	Generic Edit	6	0
40	F4201Z1	Sales Order Header Unedited Transaction File	29	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
41	F4209	Held Orders	14	HO	DRQJ	Date - Requested	Date	Generic Edit	6	0
42	F4211DT	Sales Order Detail Date Tracking File	20	DT	DRQJ	Date - Requested	Date	Generic Edit	6	0
43	F4211Z1	Sales Order Detail Unedited Transaction File	34	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
44	F4215	Shipment Header	28	XH	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP40S: Supply Chain Self Service
45	F4947SW	Self-Service Shipment Tracking Work File	7	SW	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP41F: Apparel Management
46	FCW20	Matrix Work File	114	WX	DRQJ	Date - Requested	Date	Generic Edit	6	0
47	FCW44	Proposal Order Details	8	FP	DRQJ	Date - Requested	Date	Generic Edit	6	0
48	FCW64	WO Receipts Matrix Entry Work File	177	WX	DRQJ	Date - Requested	Date	Generic Edit	6	0
49	FCW65	Work Order Header for Style Items	33	OF	DRQJ	Date - Requested	Date	Generic Edit	6	0
50	FCW67	Style Work Order Parts List	45	WM	DRQJ	Date - Requested	Date	Generic Edit	6	0
51	FCW68	Style Work Order Routings	27	WL	DRQJ	Date - Requested	Date	Generic Edit	6	0
52	FCW96	Material Analysis	10	WO	DRQJ	Date - Requested	Date	Generic Edit	6	0
53	FCW97	Grouping Messages	9	GM	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP42: Sales Management
54	F4201	Sales Order Header File	16	SH	DRQJ	Date - Requested	Date	Generic Edit	6	0
55	F42019	Sales Order Header History File	16	SH	DRQJ	Date - Requested	Date	Generic Edit	6	0
56	F4211	Sales Order Detail File	21	SD	DRQJ	Date - Requested	Date	Generic Edit	6	0
57	F42119	Sales Order History File	21	SD	DRQJ	Date - Requested	Date	Generic Edit	6	0
58	F42199	S.O. Detail Ledger File	21	SL	DRQJ	Date - Requested	Date	Generic Edit	6	0
59	F42565	Invoice Print File	30	IW	DRQJ	Date - Requested	Date	Generic Edit	6	0
60	F42UI01	SO Header Cache File (MBF)	21	ZH	DRQJ	Date - Requested	Date	Generic Edit	6	0
61	F42UI11	SO Detail Cache File (MBF)	25	ZD	DRQJ	Date - Requested	Date	Generic Edit	6	0
62	F42UI11C	Customer Self Service Shopping Cart Workfile	11	SC	DRQJ	Date - Requested	Date	Generic Edit	6	0
63	F42UI520	Pick Slips Header File	23	S8	DRQJ	Date - Requested	Date	Generic Edit	6	0
64	F42UI521	Pick Slips Detail File	19	S9	DRQJ	Date - Requested	Date	Generic Edit	6	0
65	F42UI800	Sales Detail Work File - Sales Update	107	SD	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP42B: Sales Order Entry
66	F42420	Audit Log Transaction	25	AL	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP42W: Fulfilment Management
67	F427UI01	Release Fulfillment Work File	27	RF	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP43: Procurement
68	F4301	Purchase Order Header	14	PH	DRQJ	Date - Requested	Date	Generic Edit	6	0
69	F4301Z	PO Header Work File	18	PA	DRQJ	Date - Requested	Date	Generic Edit	6	0
70	F4301Z1	Purchase Order Header Unedited Transaction Table	27	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
71	F43080	Approvals Fields Constants	8	PD	DRQJ	Date - Requested	Date	Generic Edit	6	0
72	F43092Z1	Receipt Routing Unedited Transaction Table	48	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
73	F4311	Purchase Order Detail File	21	PD	DRQJ	Date - Requested	Date	Generic Edit	6	0
74	F4311Z	Purchase Order Generator File	25	PW	DRQJ	Date - Requested	Date	Generic Edit	6	0
75	F4311Z1	Purchase Order Detail Unedited Transaction Table	34	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
76	F43121	Purchase Order Receiver File	28	PR	DRQJ	Date - Requested	Date	Generic Edit	6	0
77	F43121Z	Receiver workfile	77	PW	DRQJ	Date - Requested	Date	Generic Edit	6	0
78	F43121Z1	Receipts Unedited Transaction Table	45	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
79	F4314Z	Voucher Match Selection File	127	PN	DRQJ	Date - Requested	Date	Generic Edit	6	0
80	F43199	P.O. Detail Ledger File - Flexible Version	21	OL	DRQJ	Date - Requested	Date	Generic Edit	6	0
81	F43632Z	Open Purchase Order by Item Work File	18	OI	DRQJ	Date - Requested	Date	Generic Edit	6	0
82	F43UI50D	PO Print Detail Work File	20	PW	DRQJ	Date - Requested	Date	Generic Edit	6	0
83	F43UI50H	PO Print Header Work File	26	PA	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP43E: Requisition Self Service
84	F43E11	Requisition Detail	11	RD	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP43Q: Strategic Sourcing
85	F43Q11	Event Detail	32	ED	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP44H: Homebuilder Management
86	F44H601	Bid Header	22	BH	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP46: Warehouse Management
87	F4600	Warehouse Requests	69	R1	DRQJ	Date - Requested	Date	Generic Edit	6	0
88	F4600PU	Warehouse Requests - Purged	67	R1	DRQJ	Date - Requested	Date	Generic Edit	6	0
89	F4611	Warehouse Suggestions	92	R2	DRQJ	Date - Requested	Date	Generic Edit	6	0
90	F4611PU	Warehouse Suggestions - Purged	91	R2	DRQJ	Date - Requested	Date	Generic Edit	6	0
91	F4611Z1	Unedited Suggestion Table	103	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
92	F46130	Putaway Reservations	14	R3	DRQJ	Date - Requested	Date	Generic Edit	6	0
93	F46130PU	Putaway Reservations - Purged	14	R3	DRQJ	Date - Requested	Date	Generic Edit	6	0
94	F4942Z1	Work File for F4942	24	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP46L: License Plating
95	F46LUI01	Assign/Remove Items To LP Work File	38	WF	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP47: Electronic Commerce
96	F47011	EDI Purchase Order Header - Inbound	34	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
97	F47012	EDI Purchase Order Detail - Inbound	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
98	F47016	EDI Purchase Order Header - Outbound	29	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
99	F47017	EDI Purchase Order Detail - Outbound	34	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
100	F47021	EDI P.O. Acknowledgment Header - Inbound	29	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
101	F47022	EDI P.O. Acknowledgment Detail - Inbound	34	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
102	F47026	EDI P.O. Acknowledgment Header - Outbound	31	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
103	F47027	EDI P.O. Acknowledgment Detail - Outbound	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
104	F47031	EDI Shipping Notice Header - Inbound	30	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
105	F47032	EDI Shipping Notice Detail - Inbound	37	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
106	F47037	EDI Shipping Notice Detail - Outbound	36	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
107	F470371	EDI Shipping Notice Detail - Outbound	36	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
108	F47046	EDI Invoice Header (Sales) - Outbound	31	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
109	F47047	EDI Invoice Detail (Sales) - Outbound	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
110	F47062	EDI Planning Schedule Detail - Inbound	26	MY	DRQJ	Date - Requested	Date	Generic Edit	6	0
111	F47067	EDI Planning Schedule Detail - Outbound	26	MY	DRQJ	Date - Requested	Date	Generic Edit	6	0
112	F47071	EDI Receiving Advice Header - Inbound	30	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
113	F47072	EDI Receiving Advice Detail - Inbound	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
114	F47076	EDI Receiving Advice Header - Outbound	30	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
115	F47077	EDI Receiving Advice Detail - Outbound	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
116	F47091	EDI Request for Quote Header - Inbound	34	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
117	F47092	EDI Request for Quote Detail - Inbound	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
118	F47096	EDI Request for Quote Header - Outbound	29	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
119	F47097	EDI Request for Quote Detail - Outbound	34	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
120	F47101	EDI Response to RFQ Header - Inbound	29	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
121	F47102	EDI Response to RFQ Detail - Inbound	34	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
122	F47106	EDI Response to RFQ Header - Outbound	31	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
123	F47107	EDI Response to RFQ Detail - Outbound	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
124	F47131	EDI Purchase Order Change Header - Inbound	31	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
125	F47132	EDI Purchase Order Change Detail - Inbound	36	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
126	F47136	EDI Purchase Order Change Header - Outbound	29	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
127	F47137	EDI Purchase Order Change Detail - Outbound	35	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
128	F47141	EDI P.O. Change Acknowledgment Header - Inbound	30	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
129	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	36	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
130	F47146	EDI P.O. Change Acknowledgment Header - Outbound	32	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
131	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	37	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
132	F47156	EDI Shipping Schedule Header - Outbound	31	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
133	F47157	EDI Shipping Schedule Detail - Outbound	36	SZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP48: Work Order Processing
134	F4801	Work Order Master File	32	WA	DRQJ	Date - Requested	Date	Generic Edit	6	0
135	F4801S	Purge - Work Order Master file	32	WA	DRQJ	Date - Requested	Date	Generic Edit	6	0
136	F4801Z1	Outbound Work Order Header	51	SY	DRQJ	Date - Requested	Date	Generic Edit	6	0
137	F48710	Work Order Mass Update Template Table	19	WT	DRQJ	Date - Requested	Date	Generic Edit	6	0
138	F48UI001	X4801 Master Business Function Workfile	34	WA	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP53: Change Management
139	F5301B	Change Request Master Table	19	DI	DRQJ	Date - Requested	Date	Generic Edit	6	0
140	F5301BZ1	Change Request Master Table Workfile	23	DI	DRQJ	Date - Requested	Date	Generic Edit	6	0
141	F5314	Planned Change Order Master Table	6	D2	DRQJ	Date - Requested	Date	Generic Edit	6	0
142	F5315	Change Order Master Table	6	D3	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP54R: Rental Management
143	F54R12	Purchase Order Receiver Rentals File	15	RR	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP75T: Taiwan
144	F75T42W	Work file with union of F4211 and F42119	10	SW	DRQJ	Date - Requested	Date	Generic Edit	6	0
TOP89: Conversion Programs
145	F3294	Needed for upgrade from Xe and below	15	KZ	DRQJ	Date - Requested	Date	Generic Edit	6	0
146	F32943	Needed for upgrade from Xe and below	16	KO	DRQJ	Date - Requested	Date	Generic Edit	6	0
147	F43199A	Temp F43199 for ERP 9.0 Upgrade	21	OL	DRQJ	Date - Requested	Date	Generic Edit	6	0

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

147 columns | 920 | DRQJ