	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

65 columns | 920 | VEND

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP12: Fixed Assets
1	F1217	Equipment Master Extension	19	WR	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
2	F1217P	Equipment Master Extension Purge Table	19	WR	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
3	F1217Z1	Unedited Equipment Tag Transactions	32	WR	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
4	F1217Z2	Unedited Equipment Tag Transactions	32	WR	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP13: Plant/Equipment Management
5	F13017	Equipment Parts List	12	PL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
6	F3111IGS	WO Parts for IGS Integration	10	IG	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP17: Customer Service Management
7	F1775	Claim Temporary Table	6	TC	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
8	F3111Z2	Warranty Claim/Supplier Recovery processing	81	WP	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
9	F3112Z2	Warranty Claim/Supplier Recovery processing	75	WL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
10	F31171	Parts List - Extension	15	WS	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
11	F31171S	Purge Parts List - Extension	15	WS	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
12	F4801TZ2	Warranty Claim/Supplier Recovery processing	96	WQ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP30: Product Data Management
13	F300311	Lean Multi-Level Routing Detail File	33	EH	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
14	F3003Z1	Routing Transactions File	50	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP31: Shop Floor Control
15	F3111	Work Order Parts List	71	WM	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
16	F3111S	Purge - Shop Floor Parts List	71	WM	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
17	F3111ST	Purge - Shop Floor Parts List Tag Table - Needed for upgrade	3	WM	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
18	F3111T	Shop Floor Control Parts List Tag Table - Needed for upgrade	3	WM	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
19	F3111Z1	Outbound Work Order Parts List	81	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
20	F3112	Work Order Routing	63	WL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
21	F3112S	Purge Shop Floor Control Routing Instructions	63	WL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
22	F3112Z1	Outbound Work Order Routings	75	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP34: Requirements Planning
23	F3411	MPS/MRP/DRP Message File	15	MM	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP34X: In-Memory Planning Advisor
24	F34X101W	Item Summary Work Table	10	IS	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP40: Inventory/OP Base
25	F3003	Routing Master File	37	IR	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
26	F40052	Return Material Authorization Defaults	5	RV	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
27	F4011Z	Batch Receiver File - Order Details	136	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
28	F4015	Order Templates	10	OT	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
29	F40UI002	Supplier History Rebuild -workfile	10	UT	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
30	F4108	Lot Master	8	IO	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
31	F4211Z1	Sales Order Detail Unedited Transaction File	130	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
32	F4220	Basic Serial Numbers	21	SW	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP41: Inventory Management
33	F4101A	Item File	73	IM	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
34	F4101Z1	F4101 Item Master Unedited Transaction Table	155	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
35	F4102	Item Branch File	28	IB	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
36	F41023	Item Location Definition Table	7	IL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP41F: Apparel Management
37	FCW10	Item Branch Work File	9	WB	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
38	FCW22	Lot Master Work File	8	WL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
39	FCW68	Style Work Order Routings	67	WL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
40	FCW93	Copy to Outsource Operations for Style Items	8	ST	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP42: Sales Management
41	F4211	Sales Order Detail File	117	SD	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
42	F42119	Sales Order History File	117	SD	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
43	F42199	S.O. Detail Ledger File	117	SL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
44	F42UI11	SO Detail Cache File (MBF)	86	ZD	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
45	F42UI130	Commitment Work File	35	ZC	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
46	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	86	UZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP42B: Sales Order Entry
47	F42420	Audit Log Transaction	42	AL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP43: Procurement
48	F43121Z	Receiver workfile	37	PW	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP45: Advanced Pricing
49	F4576Z1	Ship and Debit Claims Unedited Transaction Table	152	Z1	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP47: Electronic Commerce
50	F47012	EDI Purchase Order Detail - Inbound	137	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
51	F47027	EDI P.O. Acknowledgment Detail - Outbound	137	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
52	F47047	EDI Invoice Detail (Sales) - Outbound	137	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
53	F47092	EDI Request for Quote Detail - Inbound	137	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
54	F47107	EDI Response to RFQ Detail - Outbound	137	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
55	F47132	EDI Purchase Order Change Detail - Inbound	138	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
56	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	139	SZ	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOP48: Work Order Processing
57	F4801ST	Purge - Work Order Master Tag File	83	WA	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
58	F4801T	Work Order Master Tag File	83	WA	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
59	F4817	Service Order Extension	48	SR	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
TOPF31: Lean Transactions
60	FF31111	Lean Transaction Parts List	53	PL	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
61	FF31111S	Purge - Lean Transaction Parts List	53	PR	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
62	FF31112	Routing Transaction Table	33	EH	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
63	FF31112S	Purge - Routing Transaction Table	33	ET	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
64	FF31113	Lean Transaction Labor Detail	33	LD	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0
65	FF31113S	Purge - Lean Transaction Labor Detail	33	LR	VEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	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

65 columns | 920 | VEND