	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

132 columns | 812 | EFTE

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00092	Supplemental Data	15	T3	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
2	F00692	Cost Center Supplemental Data Codes	5	M2	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
3	F1501	Tenant/Lease Master	34	NE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP01: Address Book
4	F01092	Suplemental Data Base - Code	7	A2	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP03B: Enhanced Accounts Receivable
5	F03B27	A/R Delinquency Policy Detail - Fees	4	RM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP05: Time Accounting and HRM Base
6	F06005	Batch Processing Parameters	10	JE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
7	F069116	Payroll Transaction Constants	67	YC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
8	F069126	Union Rates File	4	YL	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
9	F069216	Workers Compensation Insurance Rates	4	YB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
10	F069226	Unemployment Insurance Rates	13	YH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
11	F06923	Valid Job Type/ Step Constant	20	YH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
12	F06925	Employee/Vendor Cross Reference	9	YG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
13	F06931	Wage Attachment File	6	J3	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
14	F069311	Wage Attachment Additional Exemptions	5	J3	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
15	F069312	Wage Attachment Exemptions File	3	J3	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
16	F06933	Step Progression Parameters	4	J@	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
17	F06936	Retro Pay Types Rate	9	JA	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP05A: OW HR & PR Foundation
18	F069056	Establishment Constant File	9	YO	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP05T: Time Entry
19	F051126	Managers Delegates Setup File	4	Y6	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
20	F06022	Employee Piecerate File	21	JA	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
21	F06918	PF - Piece Rate File	7	JN	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
22	F069246	Shift Differential Table	5	Y3	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP06: Payroll (old) - Obsolete-do not reuse
23	F060146	Employees Pay Rate File	9	JI	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
24	F06210	Payroll Cycle Parameters	10	YD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP07: Payroll
25	F06053	Interim Check Parameters File	23	YW	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
26	F0701732	Additional Tax Overrides	6	AO	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
27	F07210	Pay Cycle Parameters File	34	YD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
28	F0729	Employee DBA Override Instructions	35	Y9	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08: Human Resources
29	F0800601	Organizational Business Unit/Job Cross-Reference	5	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
30	F0800603	Job Group Competencies	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
31	F0800604	Organizational Business Unit Competencies	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
32	F0800605	Job Type/Step Competencies	5	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
33	F0800606	Competency Options - Overrides	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
34	F0800607	Organizational Competencies	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
35	F0800608	Date Effective Organizational Structure	3	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
36	F0800610	Competencies in Structure and Job	6	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
37	F0800611	Job Competency Default - Overrides	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
38	F0800612	User Defined Job Competency Description Reference	5	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
39	F08006WF	Job Competency Default Overrides Work File	10	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
40	F08092	Human Resources General Description-User Def Codes	8	JZ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
41	F08338	Primary Care Physician Table	5	E7	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
42	F085520	Available Plans and Plan Options by Employee History Table	11	PH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
43	F085520W	Available Plans and Plan Options by Employee Work Table	23	AP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
44	F085530W	Employee Current/Pending Elections Work Table	9	CP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
45	F085536	Dependent/Beneficiary X-Reference History Table	10	DH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
46	F085536W	Dependent/Beneficiary X-Reference Work Table	10	DB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
47	F085537W	Current Dep/Ben X-Reference Work Table	9	XB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
48	F08750	Managers Delegates	4	MD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
49	F08JDWF1	Job Description Changes Integration Work File	3	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
50	F08JDWF2	Job Description History Integration Work File	15	JH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08AD: ADP Integration
51	F051375	ADP Payroll DBA Transaction Constants	69	AD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
52	F05138	ADP - Pay Cycle Review Control	5	PC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08B: Benefits Administration
53	F06024	Beneficiary/Co-owner File	10	YJ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
54	F08320	Benefits Plan Master	6	BA	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
55	F083203	Plan Master Rates	6	BG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
56	F08320WF	Available Plans and Plan Options by Employee Work Table	23	BV	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
57	F08330	Employee Enrollment	4	BG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
58	F08336	Dep/Ben to Employee Plan X-Reference	10	BJ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
59	F08336WF	Dependent/Beneficiary X-Ref Work Table	11	BD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
60	F08346	401(K) Elections	5	B4	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
61	F08351	Plans within Benefit Categories	6	BU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
62	F08380WF	Batch Enrollment Work File	8	BE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
63	F08500	Enrollment Event Setup	4	ES	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
64	F08511	Employee Pension Activity Detail	5	HJ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08H: Health and Safety
65	F086401	Injury/Illness Report Header Information	5	RH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08P: Position Control
66	F08001	Job information	69	JM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
67	F06018	Date Parameter Extension	6	YF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08U: OW HR US
68	F08360	Nondiscrimination Groups	23	HE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
69	F08920	COBRA Coverage	30	JS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
70	F08990	COBRA General Constants	4	HW	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
71	F089901	COBRA General Constants Additional Information	4	CC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
72	F089902	COBRA General Constants - COBRA Notices Information	5	J2	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
73	F08991	COBRA Qualifying Event Constant	6	HD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
74	F08992	Qualifying Event Rules Header	7	QE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08W: Wage and Salary
75	F08818	Increase Type Rules	5	YM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
76	F08820	Increase Guideline Master Table	3	YT	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
77	F08821	Increase Guideline Range Table	4	YD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP12: Fixed Assets
78	F12002	Default Accounting Constants	25	FD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
79	F12003	Default Depreciation Constants	22	FF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
80	F12092	Fixed Assets Supplemental Data Codes Type	5	F3	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
81	F1212	Parent History	4	FY	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
82	F1212P	Parent History Purge Table	4	FY	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
83	F12851	Depreciation Rules	9	LU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
84	F12851D	Demo Depreciation Rules	9	LU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
85	F1301	Equipment Rates	5	FG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
86	F1301P	Equipment Rates Purge Table	5	FG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP13: Plant/Equipment Management
87	F1307	Status History File	7	F1	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
88	F1307P	Status History Purge Table	7	F1	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP15: Property Management
89	F15012	Tenant E.P. Class Master	21	NS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
90	F15012B	Tenant E.P. Class Master	22	NS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
91	F15013B	Sales Overage Master File	6	NO	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
92	F15014	Product Scales Master	7	NP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
93	F15014B	Product Scales Master	18	NP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
94	F15015	Minimum rent/recoveries Master	5	NQ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
95	F15015B	Min/Max Rents And Recoveries Master	14	NQ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
96	F15016	Tenant Escalation Master	37	NU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
97	F15016B	Tenant Escalation Master	38	NU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
98	F1501B	Lease Master Header File	27	NE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
99	F1502	Recurring Billings Master	10	NF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
100	F1502B	Recurring Billings Master	10	NF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
101	F1502WAB	Rent Increase Amounts	8	NF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
102	F1502WB	Estimated EP Recurring Billing Work File (OneWorld)	12	N4	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
103	F1505	Management Fee Master	7	ND	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
104	F1505B	Management Fee Master	9	ND	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
105	F15110B	Expense Participation Class Account	5	OB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
106	F1514	Area Master	13	NW	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
107	F1514W	Area Work File	2	NW	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
108	F1525	A/R Fee Interest	25	N0	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
109	F1525B	A/R Fee and Interest	26	NM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
110	F1530	Expense Participation Class Master	11	NG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
111	F1531	Expense Participation Class Adjustment	5	OM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
112	F1533	Tenant Class Account Exclusions	7	NM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
113	F1533B	Tenant Account Exclusions	8	NM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
114	F1565	Security Deposit Master	8	JF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
115	F1570	Legal Clauses	9	ND	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
116	F15703	Legal Clause Amounts	9	NI	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
117	F159071	Market/Potential/Renewal Rent Master	9	NY	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP15L: Adv Real Estate Forecasting
118	F15L101	AREF Unit Master	29	UM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
119	F15L109	AREF Budget Results	26	BR	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP39: Advanced Stock Valuation
120	F3908	Item Pool Valuation Cost Master	5	CS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP41: Inventory Management
121	F41092	Item Supplemental Data Base User Defined Codes	7	T2	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP48S: Service Billing
122	F48096	Billing Rate / Mark up Table	4	WQ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
123	F48127	Tax Derivation Information	5	WO	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
124	F4860	Component Table Master	4	AF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
125	F48S83	Pool Definition	3	PD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
126	F48S95	Billing AAI Information	5	WV	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP55: Reserved for Clients
127	F74U0142	ACM - Application / Certificate Status History	11	DH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP74U: United Kingdom Localizations
128	F74U0118	Payment Voucher Status History	10	VH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP75Z: New Zealand - Reporting System Only
129	F75Z0008	New Zealand Special Rates	4	Z8	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP76A: Argentina
130	F76A396	Item Valuation Cost Master - 76A	5	CS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP76B: Brazil - Reporting System Only
131	F76B61	Packing and Raw Material Table - IN68 - 30	9	IE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP76P: Peru
132	F76P503	Regional Constants by Asset Number - PER - 12 - 76P	2	RC	EFTE	Date - Ending 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

132 columns | 812 | EFTE