	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

186 columns | 812 | LOCN

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP12: Fixed Assets
1	F1217	Equipment Master Extension	54	WR	LOCN	Location	String	Generic Edit	20	0
2	F1217P	Equipment Master Extension Purge Table	54	WR	LOCN	Location	String	Generic Edit	20	0
3	F1217Z1	Unedited Equipment Tag Transactions	58	WR	LOCN	Location	String	Generic Edit	20	0
4	F1217Z2	Unedited Equipment Tag Transactions	58	WR	LOCN	Location	String	Generic Edit	20	0
TOP13: Plant/Equipment Management
5	F13017	Equipment Parts List	11	PL	LOCN	Location	String	Generic Edit	20	0
TOP17: Customer Service Management
6	F3111Z2	Warranty Claim/Supplier Recovery processing	46	WP	LOCN	Location	String	Generic Edit	20	0
7	F3112Z2	Warranty Claim/Supplier Recovery processing	97	WL	LOCN	Location	String	Generic Edit	20	0
8	F4801Z2	Warranty Claim/Supplier Recovery processing	35	WS	LOCN	Location	String	Generic Edit	20	0
TOP30: Product Data Management
9	F30006	Work Center Master File	4	IW	LOCN	Location	String	Generic Edit	20	0
10	F30006Z1	Work Center Transaction File	17	SZ	LOCN	Location	String	Generic Edit	20	0
11	F300211	Lean Multi Level Bill of Material Detail	61	ED	LOCN	Location	String	Generic Edit	20	0
12	F300311	Lean Multi Level Routing Detail File	41	EH	LOCN	Location	String	Generic Edit	20	0
13	F3003Z1	Routing Transactions File	57	SZ	LOCN	Location	String	Generic Edit	20	0
14	F3016	Kanban Master	9	KM	LOCN	Location	String	Generic Edit	20	0
TOP30A: Product Costing
15	F300261	Item Cost Component Detail	5	IE	LOCN	Location	String	Generic Edit	20	0
TOP31: Shop Floor Control
16	F3105	Work Order LSN	8	IS	LOCN	Location	String	Generic Edit	20	0
17	F3105S	Purge Work Order LSN	8	IS	LOCN	Location	String	Generic Edit	20	0
18	F3111	Work Order Parts List	33	WM	LOCN	Location	String	Generic Edit	20	0
19	F3111S	Purge - Shop Floor Parts List	33	WM	LOCN	Location	String	Generic Edit	20	0
20	F3111Z1	Outbound Work Order Parts List	46	SZ	LOCN	Location	String	Generic Edit	20	0
21	F3112	Work Order Routing	79	WL	LOCN	Location	String	Generic Edit	20	0
22	F3112S	Purge Shop Floor Control Routing Instructions	79	WL	LOCN	Location	String	Generic Edit	20	0
23	F3112ST	Purge Shop Floor Control Routing Instructions Tag Table	10	WL	LOCN	Location	String	Generic Edit	20	0
24	F3112T	Shop Floor Control Routing Instructions Tag Table	10	WL	LOCN	Location	String	Generic Edit	20	0
25	F3112Z1	Outbound Work Order Routings	97	SZ	LOCN	Location	String	Generic Edit	20	0
26	F4801S	Purge - Work Order Master file	16	WA	LOCN	Location	String	Generic Edit	20	0
27	F4801Z1	Outbound Work Order Header	35	SY	LOCN	Location	String	Generic Edit	20	0
TOP31B: Blend Management
28	F31B03	Barrel Master Table	11	BM	LOCN	Location	String	Generic Edit	20	0
29	F31B03E	Barrel Inquiry Work File	5	BE	LOCN	Location	String	Generic Edit	20	0
30	F31B053	Consumable Assignments	9	CA	LOCN	Location	String	Generic Edit	20	0
31	F31B07	EUR Master File	41	EU	LOCN	Location	String	Generic Edit	20	0
32	F31B08	Tank Master	13	TM	LOCN	Location	String	Generic Edit	20	0
33	F31B101	VBT Detail	8	VD	LOCN	Location	String	Generic Edit	20	0
34	F31B110	Mass Barrel Update	16	MB	LOCN	Location	String	Generic Edit	20	0
35	F31B66	Blend Transactions	56	BT	LOCN	Location	String	Generic Edit	20	0
36	F31B84	Operation Additives	12	OA	LOCN	Location	String	Generic Edit	20	0
37	F31B85	Weigh Tag Master	38	WT	LOCN	Location	String	Generic Edit	20	0
38	F31B85T	Weigh Tag Master Tag Table	6	WT	LOCN	Location	String	Generic Edit	20	0
39	F31B86	Inventory By Vessel WorkFile	8	IV	LOCN	Location	String	Generic Edit	20	0
40	F31B88	Inventory By Vessel Workfile	8	IV	LOCN	Location	String	Generic Edit	20	0
41	F31B98	Bottling Master	5	BM	LOCN	Location	String	Generic Edit	20	0
42	F31B99	Decant Detail	6	DD	LOCN	Location	String	Generic Edit	20	0
TOP32: Configuration Management
43	F3215	Configurator Component Table	17	CC	LOCN	Location	String	Generic Edit	20	0
44	F32159	Configurator Component History Table	17	CH	LOCN	Location	String	Generic Edit	20	0
45	F3294	Configured String History File	3	KZ	LOCN	Location	String	Generic Edit	20	0
46	F32943	Configured String History - OneWorld	3	KO	LOCN	Location	String	Generic Edit	20	0
TOP34: Requirements Planning
47	F43213	SRS Ship Dates	16	VP	LOCN	Location	String	Generic Edit	20	0
TOP37: Quality Management
48	F3703	Non-Conforming Material	5	QE	LOCN	Location	String	Generic Edit	20	0
49	F3711	Test Results	10	TR	LOCN	Location	String	Generic Edit	20	0
50	F3711Z1	Test Results Unedited Transaction Table	23	SZ	LOCN	Location	String	Generic Edit	20	0
51	F37900	Certificate of Analysis (COA) Extract	11	TR	LOCN	Location	String	Generic Edit	20	0
TOP38: Agreement Management
52	F38111	Agreements Transaction Ledger	9	DZ	LOCN	Location	String	Generic Edit	20	0
TOP40: Inventory/OP Base
53	F30026	Item Cost Component Add-Ons	5	IE	LOCN	Location	String	Generic Edit	20	0
54	F3003	Routing Master File	55	IR	LOCN	Location	String	Generic Edit	20	0
55	F3003T	Routing Tag File	9	IR	LOCN	Location	String	Generic Edit	20	0
56	F30UI006	Lot Tracking Work File	25	IL	LOCN	Location	String	Generic Edit	20	0
57	F40052	Return Material Authorization Defaults	7	RV	LOCN	Location	String	Generic Edit	20	0
58	F4011Z	Batch Receiver File - Order Details	52	SZ	LOCN	Location	String	Generic Edit	20	0
59	F4012ZW	WF - Destination Quantity	24	SP	LOCN	Location	String	Generic Edit	20	0
60	F40320	Preference Profile - Multi Shipping/Receiving Locations	15	LP	LOCN	Location	String	Generic Edit	20	0
61	F40320R	Preference Resolution Ledger - Multi ShiP/Rec Locations	16	LP	LOCN	Location	String	Generic Edit	20	0
62	F4100	Location Master	2	LM	LOCN	Location	String	Generic Edit	20	0
63	F4106	Item Base Price File	5	BP	LOCN	Location	String	Generic Edit	20	0
64	F41112	Item ASOF File	8	IN	LOCN	Location	String	Generic Edit	20	0
65	F4171	Critical Hold Management	3	I1	LOCN	Location	String	Generic Edit	20	0
66	F4211Z1	Sales Order Detail Unedited Transaction File	49	SZ	LOCN	Location	String	Generic Edit	20	0
67	F4220	Basic Serial Numbers	9	SW	LOCN	Location	String	Generic Edit	20	0
TOP41: Inventory Management
68	F4100T	Location Master Tag File	2	LM	LOCN	Location	String	Generic Edit	20	0
69	F4101A	Item File	86	IM	LOCN	Location	String	Generic Edit	20	0
70	F4101Z1	F4101 Item Master Unedited Transaction Table	184	SZ	LOCN	Location	String	Generic Edit	20	0
71	F41021	Item Location File	3	LI	LOCN	Location	String	Generic Edit	20	0
72	F410211	Project Commitment Detail Table	5	PC	LOCN	Location	String	Generic Edit	20	0
73	F41021A	Item Location File - Temporary Upgrade	3	LI	LOCN	Location	String	Generic Edit	20	0
74	F41021WF	F41021 Transaction Workfile	7	LW	LOCN	Location	String	Generic Edit	20	0
75	F41021Z1	Item Location Unedited Transaction File	16	SZ	LOCN	Location	String	Generic Edit	20	0
76	F41023	Item Location Definition Table	3	IL	LOCN	Location	String	Generic Edit	20	0
77	F4105	Item Cost File	5	CO	LOCN	Location	String	Generic Edit	20	0
78	F41051	Average Cost Work file	4	CH	LOCN	Location	String	Generic Edit	20	0
79	F4105Z1	Unedited Transaction Table - Item Cost	18	SZ	LOCN	Location	String	Generic Edit	20	0
80	F4111	Item Ledger File	6	IL	LOCN	Location	String	Generic Edit	20	0
81	F41113	Lot Ledger	8	I8	LOCN	Location	String	Generic Edit	20	0
82	F4141	Cycle Count Transaction File	7	PJ	LOCN	Location	String	Generic Edit	20	0
83	F4141Z1	F4141 Cycle Count Unedited Transaction Table	20	SZ	LOCN	Location	String	Generic Edit	20	0
84	F4160	Tag Inventory File	5	IT	LOCN	Location	String	Generic Edit	20	0
85	F41UI001	Inventory Transactions Detail File	17	IT	LOCN	Location	String	Generic Edit	20	0
86	F41UI002	Inventory Transactions Batch File	7	TI	LOCN	Location	String	Generic Edit	20	0
TOP41B: Bulk Stock Management
87	F41512	Gain/Loss Transactions File	13	PT	LOCN	Location	String	Generic Edit	20	0
TOP42: Sales Management
88	F4211	Sales Order Detail File	36	SD	LOCN	Location	String	Generic Edit	20	0
89	F42119	Sales Order History File	36	SD	LOCN	Location	String	Generic Edit	20	0
90	F42199	S.O. Detail Ledger File	36	SL	LOCN	Location	String	Generic Edit	20	0
91	F42UI11	SO Detail Cache File (MBF)	39	ZD	LOCN	Location	String	Generic Edit	20	0
92	F42UI12	Sales Order Detail Cache 2 (MBF)	72	ZD	LOCN	Location	String	Generic Edit	20	0
93	F42UI130	Commitment Work File	19	ZC	LOCN	Location	String	Generic Edit	20	0
94	F42UI521	Pick Slips Detail File	31	S9	LOCN	Location	String	Generic Edit	20	0
95	F42UI800	Sales Detail Work File - Sales Update	41	SD	LOCN	Location	String	Generic Edit	20	0
TOP42B: Sales Order Entry
96	F42420	Audit Log Transaction	23	AL	LOCN	Location	String	Generic Edit	20	0
TOP43: Procurement
97	F41291	Item Cost Components	6	IG	LOCN	Location	String	Generic Edit	20	0
98	F43080	Approvals Fields Constants	46	PD	LOCN	Location	String	Generic Edit	20	0
99	F43092	Purchase Order Receipt Routing File	22	PX	LOCN	Location	String	Generic Edit	20	0
100	F43092Z1	Receipt Routing Unedited Transaction Table	35	SZ	LOCN	Location	String	Generic Edit	20	0
101	F4311	Purchase Order Detail File	38	PD	LOCN	Location	String	Generic Edit	20	0
102	F4311Z	Purchase Order Generator File	42	PW	LOCN	Location	String	Generic Edit	20	0
103	F4311Z1	Purchase Order Detail Unedited Transaction Table	51	SZ	LOCN	Location	String	Generic Edit	20	0
104	F43121	Purchase Order Receiver File	18	PR	LOCN	Location	String	Generic Edit	20	0
105	F43121Z	Receiver workfile	23	PW	LOCN	Location	String	Generic Edit	20	0
106	F43121Z1	Receipts Unedited Transaction Table	35	SZ	LOCN	Location	String	Generic Edit	20	0
107	F4314Z	Voucher Match Selection File	117	PN	LOCN	Location	String	Generic Edit	20	0
108	F43199	P.O. Detail Ledger File - Flexible Version	38	OL	LOCN	Location	String	Generic Edit	20	0
TOP43Q: Strategic Sourcing
109	F43Q90	Sourcing Constants	7	SC	LOCN	Location	String	Generic Edit	20	0
110	F43Q92	Adhoc Item Definition	4	AI	LOCN	Location	String	Generic Edit	20	0
TOP45: Advanced Pricing
111	F4574	Key Reference Table	9	KR	LOCN	Location	String	Generic Edit	20	0
TOP46: Warehouse Management
112	F4142	Warehouse Count Transactions	5	CT	LOCN	Location	String	Generic Edit	20	0
113	F46012	Fixed Locations	5	IS	LOCN	Location	String	Generic Edit	20	0
114	F4602	Location Detail Information	3	IF	LOCN	Location	String	Generic Edit	20	0
115	F46021	Location Characteristics	3	LQ	LOCN	Location	String	Generic Edit	20	0
116	F46026	Allowed Containers by Location	2	AC	LOCN	Location	String	Generic Edit	20	0
117	F46027	Available Space Tiebreaker	4	AV	LOCN	Location	String	Generic Edit	20	0
118	F46029	Proximity Tiebreaker	4	LP	LOCN	Location	String	Generic Edit	20	0
119	F46051	Fixed Replenisment Zones	2	LY	LOCN	Location	String	Generic Edit	20	0
120	F46130	Putaway Reservations	12	R3	LOCN	Location	String	Generic Edit	20	0
121	F46130PU	Putaway Reservations - Purged	12	R3	LOCN	Location	String	Generic Edit	20	0
122	F46821	Random Locations	3	LX	LOCN	Location	String	Generic Edit	20	0
TOP46L: License Plating
123	F46L10	License Plate Master	5	LM	LOCN	Location	String	Generic Edit	20	0
124	F46L11	License Plate Item Detail	5	ID	LOCN	Location	String	Generic Edit	20	0
125	F46L12	License Plate Commitment	14	LC	LOCN	Location	String	Generic Edit	20	0
126	F46L30	Location Capacity	2	LC	LOCN	Location	String	Generic Edit	20	0
127	F46L42	License Plate Cycle and Tag Count	5	CC	LOCN	Location	String	Generic Edit	20	0
128	F46L99	License Plate History	6	LM	LOCN	Location	String	Generic Edit	20	0
129	F46LUI01	Assign/Remove Items To LP Work File	9	WF	LOCN	Location	String	Generic Edit	20	0
130	F46LUI03	Assign/Remove Child LP Work File	9	WF	LOCN	Location	String	Generic Edit	20	0
TOP47: Electronic Commerce
131	F47012	EDI Purchase Order Detail - Inbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
132	F47017	EDI Purchase Order Detail - Outbound	52	SZ	LOCN	Location	String	Generic Edit	20	0
133	F47022	EDI P.O. Acknowledgment Detail - Inbound	52	SZ	LOCN	Location	String	Generic Edit	20	0
134	F47027	EDI P.O. Acknowledgment Detail - Outbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
135	F47032	EDI Shipping Notice Detail - Inbound	51	SZ	LOCN	Location	String	Generic Edit	20	0
136	F47037	EDI Shipping Notice Detail - Outbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
137	F470371	EDI Shipping Notice Detail - Outbound	59	SZ	LOCN	Location	String	Generic Edit	20	0
138	F47042	EDI Invoice Detail - Inbound	33	SZ	LOCN	Location	String	Generic Edit	20	0
139	F47047	EDI Invoice Detail (Sales) - Outbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
140	F47072	EDI Receiving Advice Detail - Inbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
141	F47077	EDI Receiving Advice Detail - Outbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
142	F47092	EDI Request for Quote Detail - Inbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
143	F47097	EDI Request for Quote Detail - Outbound	52	SZ	LOCN	Location	String	Generic Edit	20	0
144	F47102	EDI Response to RFQ Detail - Inbound	52	SZ	LOCN	Location	String	Generic Edit	20	0
145	F47107	EDI Response to RFQ Detail - Outbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
146	F47122	EDI Product Activity Data Detail - Inbound	25	MJ	LOCN	Location	String	Generic Edit	20	0
147	F47127	EDI Product Activity Data Detail - Outbound	25	MJ	LOCN	Location	String	Generic Edit	20	0
148	F47132	EDI Purchase Order Change Detail - Inbound	54	SZ	LOCN	Location	String	Generic Edit	20	0
149	F47137	EDI Purchase Order Change Detail - Outbound	53	SZ	LOCN	Location	String	Generic Edit	20	0
150	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	54	SZ	LOCN	Location	String	Generic Edit	20	0
151	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	55	SZ	LOCN	Location	String	Generic Edit	20	0
152	F47157	EDI Shipping Schedule Detail - Outbound	55	SZ	LOCN	Location	String	Generic Edit	20	0
TOP48: Work Order Processing
153	F4801	Work Order Master File	16	WA	LOCN	Location	String	Generic Edit	20	0
154	F48UI001	X4801 Master Business Function Workfile	19	WA	LOCN	Location	String	Generic Edit	20	0
TOP49: Transportation Management
155	F4963	Load In-transit	16	TI	LOCN	Location	String	Generic Edit	20	0
156	F49631	Load In-transit Ledger	35	TO	LOCN	Location	String	Generic Edit	20	0
TOP55: Reserved for Clients
157	F74H1051	Invoicing Workfile - New	13	IW	LOCN	Location	String	Generic Edit	20	0
TOP75C: China - Reporting System Only
158	F75C4106	Chinese Free Goods VAT base price - F75C4106	4	IB	LOCN	Location	String	Generic Edit	20	0
TOP76A: Argentina
159	F76A393	Calculated costs detail - 76A	8	C3	LOCN	Location	String	Generic Edit	20	0
160	F76A394	Adjustments - 76A	8	C4	LOCN	Location	String	Generic Edit	20	0
TOP76B: Brazil - Reporting System Only
161	F7611B	Nota Fiscal Detail - Brazil	28	FD	LOCN	Location	String	Generic Edit	20	0
162	F761BA	AS Fiscal file book	32	FB	LOCN	Location	String	Generic Edit	20	0
163	F76412	Item Branch Regional Information - Brazil	3	IJ	LOCN	Location	String	Generic Edit	20	0
TOP76H: Chile
164	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	26	I1	LOCN	Location	String	Generic Edit	20	0
165	F76H6003	Indirect Costs Selection EPS F1642 - CHI - 41 - 76H	27	I2	LOCN	Location	String	Generic Edit	20	0
166	F76H6004	Item Cost Component WF - CHI - 41 - 76H	6	IC	LOCN	Location	String	Generic Edit	20	0
167	F76H6008	Manufactured Items - CHI - 41 - 76H	6	IP	LOCN	Location	String	Generic Edit	20	0
168	F76H6105	Item Actual Cost File - CHI - 41 - 76H	6	AC	LOCN	Location	String	Generic Edit	20	0
169	F76H611	Actual Item Ledger File - CHI - 41 - 76H	6	AL	LOCN	Location	String	Generic Edit	20	0
170	F76H6112	Actual Item ASOF File - CHI - 41 - 76H	8	AN	LOCN	Location	String	Generic Edit	20	0
171	F76H6205	Item Replacement Cost - CHI - 41	6	IR	LOCN	Location	String	Generic Edit	20	0
TOP76P: Peru
172	F76P393Z	Calculated Costs detail Z1 - PER - 41 - 76P	7	CZ	LOCN	Location	String	Generic Edit	20	0
TOP89: Conversion Programs
173	F43199A	Temp F43199 for ERP 9.0 Upgrade	38	OL	LOCN	Location	String	Generic Edit	20	0
TOPD3N: dcLINK (data collection) - DSI
174	FD3N1601	Pallet Tracking Table 1	4	PH	LOCN	Location	String	Generic Edit	20	0
175	FD3N161P	Pallet Tracking Table 4	7	PH	LOCN	Location	String	Generic Edit	20	0
176	FD3N4041	Pallet Tracking Table 6	5	CD	LOCN	Location	String	Generic Edit	20	0
TOPF30L: DFM Line Design
177	FF30L930	DFM Routings	55	LR	LOCN	Location	String	Generic Edit	20	0
TOPF31: Lean Transactions
178	FF31010	Production Master File	9	EH	LOCN	Location	String	Generic Edit	20	0
179	FF31011	TransactionID Master File	21	EH	LOCN	Location	String	Generic Edit	20	0
180	FF31011S	Purge - TransactionID Master File	21	ER	LOCN	Location	String	Generic Edit	20	0
181	FF31111	Lean Transaction Parts List	34	PL	LOCN	Location	String	Generic Edit	20	0
182	FF31111S	Purge - Lean Transaction Parts List	34	PR	LOCN	Location	String	Generic Edit	20	0
183	FF31112	Routing Transaction Table	61	EH	LOCN	Location	String	Generic Edit	20	0
184	FF31112S	Purge - Routing Transaction Table	61	ET	LOCN	Location	String	Generic Edit	20	0
TOPH91: Design Tools
185	F98TC01	Table Conversion UnNormalized	3	TC	LOCN	Location	String	Generic Edit	20	0
186	F98TC03	Table Conversion Normalized 2	3	TN	LOCN	Location	String	Generic Edit	20	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

186 columns | 812 | LOCN