	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	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

52 columns | 920 | EFT

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00092	Supplemental Data	11	T3	EFT	Date - Effective	Date	Generic Edit	6	0
2	F00093	Flash Messages	4	FM	EFT	Date - Effective	Date	Generic Edit	6	0
3	F00692	Cost Center Supplemental Data Codes	4	M2	EFT	Date - Effective	Date	Generic Edit	6	0
4	F00693	Cost Center Supplemental Data Text	4	M3	EFT	Date - Effective	Date	Generic Edit	6	0
5	F0087	Conversion Constants File for Euro	4	EU	EFT	Date - Effective	Date	Generic Edit	6	0
TOP01: Address Book
6	F01092	Supplemental Database - Code	6	A2	EFT	Date - Effective	Date	Generic Edit	6	0
7	F01093	Supplemental Database - Narrative	5	A3	EFT	Date - Effective	Date	Generic Edit	6	0
TOP05: Time Accounting and HRM Base
8	F05122	Action Plan	4	AP	EFT	Date - Effective	Date	Generic Edit	6	0
TOP08: Human Resources
9	F0800609	Gap Analysis Snapshot	3	YI	EFT	Date - Effective	Date	Generic Edit	6	0
10	F08092	Human Resources General Description-User Def Codes	7	JZ	EFT	Date - Effective	Date	Generic Edit	6	0
11	F08093	Human Resources General Description - Narration	7	JY	EFT	Date - Effective	Date	Generic Edit	6	0
12	F08336B	Dep/Ben X-Reference Tag Table	5	E2	EFT	Date - Effective	Date	Generic Edit	6	0
13	F08338	Primary Care Physician Table	4	E7	EFT	Date - Effective	Date	Generic Edit	6	0
14	F08338B	Primary Care Physician Tag Table	4	PT	EFT	Date - Effective	Date	Generic Edit	6	0
15	F085520	Available Plans and Plan Options by Employee History Table	10	PH	EFT	Date - Effective	Date	Generic Edit	6	0
16	F085520W	Available Plans and Plan Options by Employee Work Table	22	AP	EFT	Date - Effective	Date	Generic Edit	6	0
17	F085530W	Employee Current/Pending Elections Work Table	8	CP	EFT	Date - Effective	Date	Generic Edit	6	0
18	F085536	Dependent/Beneficiary X-Reference History Table	9	DH	EFT	Date - Effective	Date	Generic Edit	6	0
19	F085536W	Dependent/Beneficiary X-Reference Work Table	9	DB	EFT	Date - Effective	Date	Generic Edit	6	0
20	F085537W	Current Dep/Ben X-Reference Work Table	8	XB	EFT	Date - Effective	Date	Generic Edit	6	0
21	F08JDWF2	Job Description History Integration Work File	26	JH	EFT	Date - Effective	Date	Generic Edit	6	0
TOP08B: Benefits Administration
22	F08320	Benefits Plan Master	5	BA	EFT	Date - Effective	Date	Generic Edit	6	0
23	F08320WF	Available Plans and Plan Options by Employee Work Table	20	BV	EFT	Date - Effective	Date	Generic Edit	6	0
24	F08330	Employee Enrollment	3	BG	EFT	Date - Effective	Date	Generic Edit	6	0
25	F08330B	Employee Enrollment Tag File	4	BT	EFT	Date - Effective	Date	Generic Edit	6	0
26	F08330C	Employee Enrollment Tag Table C	4	PC	EFT	Date - Effective	Date	Generic Edit	6	0
27	F08330WF	Employee Current/Pending Elections Work Table	8	BR	EFT	Date - Effective	Date	Generic Edit	6	0
28	F08336	Dep/Ben to Employee Plan X-Reference	9	BJ	EFT	Date - Effective	Date	Generic Edit	6	0
29	F08336WF	Dependent/Beneficiary X-Ref Work Table	9	BD	EFT	Date - Effective	Date	Generic Edit	6	0
30	F08346	401(K) Elections	3	B4	EFT	Date - Effective	Date	Generic Edit	6	0
31	F08351	Plans within Benefit Categories	5	BU	EFT	Date - Effective	Date	Generic Edit	6	0
32	F08351B	Plans within Categories Tag Table	5	PC	EFT	Date - Effective	Date	Generic Edit	6	0
33	F08380WF	Batch Enrollment Work File	7	BE	EFT	Date - Effective	Date	Generic Edit	6	0
34	F08500	Enrollment Event Setup	3	ES	EFT	Date - Effective	Date	Generic Edit	6	0
35	F08511	Employee Pension Activity Detail	4	HJ	EFT	Date - Effective	Date	Generic Edit	6	0
TOP08H: Health and Safety
36	F086401	Injury/Illness Report Header Information	4	RH	EFT	Date - Effective	Date	Generic Edit	6	0
TOP08W: Wage and Salary
37	F08818	Increase Type Rules	4	YM	EFT	Date - Effective	Date	Generic Edit	6	0
38	F08820	Increase Guideline Master Table	2	YT	EFT	Date - Effective	Date	Generic Edit	6	0
39	F08821	Increase Guideline Range Table	2	YD	EFT	Date - Effective	Date	Generic Edit	6	0
TOP11: Multi Currency
40	F0015	Currency Exchange Rates	5	CX	EFT	Date - Effective	Date	Generic Edit	6	0
41	F0015Z1	External Currency Exchange Rates	27	ZE	EFT	Date - Effective	Date	Generic Edit	6	0
42	F1113	Currency Restatement Rates File	4	C1	EFT	Date - Effective	Date	Generic Edit	6	0
TOP12: Fixed Assets
43	F12092	Fixed Assets Supplemental Data Codes Type	4	F3	EFT	Date - Effective	Date	Generic Edit	6	0
TOP41: Inventory Management
44	F41092	Item Supplemental Data Base User Defined Codes	6	T2	EFT	Date - Effective	Date	Generic Edit	6	0
TOP41F: Apparel Management
45	FCW38	Price List Exchange Rate	3	TR	EFT	Date - Effective	Date	Generic Edit	6	0
46	FCW84	Exchange Rate for Outsource Operations	2	TR	EFT	Date - Effective	Date	Generic Edit	6	0
TOP74P: Poland
47	F74P0001	Exchange Table Number - POL - 11	1	ET	EFT	Date - Effective	Date	Generic Edit	6	0
TOP75T: Taiwan
48	F75T1113	Taiwan Exchange Rate Update	4	TR	EFT	Date - Effective	Date	Generic Edit	6	0
TOP76A: Argentina
49	F76A0209	Header & Footer Invoice/ShipmentNote History WF - ARG - 76A	77	HF	EFT	Date - Effective	Date	Generic Edit	6	0
50	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	77	HF	EFT	Date - Effective	Date	Generic Edit	6	0
51	F76AUI20	Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A	77	HF	EFT	Date - Effective	Date	Generic Edit	6	0
TOP89: Conversion Programs
52	F00151	Needed for upgrade for XE and below	6	T1	EFT	Date - Effective	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

52 columns | 920 | EFT