	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

157 columns | 920 | 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
TOP01: Address Book
3	F01092	Supplemental Database - Code	7	A2	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP03B: Enhanced Accounts Receivable
4	F03B27	A/R Delinquency Policy Detail - Fees	4	RM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP05: Time Accounting and HRM Base
5	F06005	Batch Processing Parameters	10	JE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
6	F069116	Payroll Transaction Constants	67	YC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
7	F069126	Union Rates File	4	YL	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
8	F0691261	Additional Union Rates	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: PeopleSoft 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	F05601	Component Pay Instructions	4	CP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
21	F06022	Employee Piecerate File	21	JA	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
22	F06918	PF - Piece Rate File	7	JN	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
23	F069246	Shift Differential Table	5	Y3	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP06: Payroll (old) - Obsolete-do not reuse
24	F060146	Employees Pay Rate File	9	JI	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
25	F06210	Payroll Cycle Parameters	10	YD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP07: Payroll
26	F06053	Interim Check Parameters File	23	YW	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
27	F0701732	Additional Tax Overrides	6	AO	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
28	F07210	Pay Cycle Parameters File	34	YD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
29	F0729	Employee DBA Override Instructions	35	Y9	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
30	F079320	Wage Attachment Exemptions by Pay Frequency	4	WX	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08: Human Resources
31	F0800601	Organizational Business Unit/Job Cross-Reference	5	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
32	F0800603	Job Group Competencies	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
33	F0800604	Organizational Business Unit Competencies	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
34	F0800605	Job Type/Step Competencies	5	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
35	F0800606	Competency Options - Overrides	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
36	F0800607	Organizational Competencies	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
37	F0800608	Date Effective Organizational Structure	3	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
38	F0800610	Competencies in Structure and Job	6	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
39	F0800611	Job Competency Default - Overrides	4	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
40	F0800612	User Defined Job Competency Description Reference	5	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
41	F08006WF	Job Competency Default Overrides Work File	10	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
42	F08092	Human Resources General Description-User Def Codes	8	JZ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
43	F08338	Primary Care Physician Table	5	E7	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
44	F085520	Available Plans and Plan Options by Employee History Table	11	PH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
45	F085520W	Available Plans and Plan Options by Employee Work Table	23	AP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
46	F085530W	Employee Current/Pending Elections Work Table	9	CP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
47	F085536	Dependent/Beneficiary X-Reference History Table	10	DH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
48	F085536W	Dependent/Beneficiary X-Reference Work Table	10	DB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
49	F085537W	Current Dep/Ben X-Reference Work Table	9	XB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
50	F08750	Managers Delegates	4	MD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
51	F08JDWF1	Job Description Changes Integration Work File	3	JC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
52	F08JDWF2	Job Description History Integration Work File	15	JH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08AD: ADP Integration
53	F051375	ADP Payroll DBA Transaction Constants	69	AD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
54	F05138	ADP - Pay Cycle Review Control	5	PC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08B: Benefits Administration
55	F06024	Beneficiary/Co-owner File	10	YJ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
56	F08320	Benefits Plan Master	6	BA	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
57	F083203	Plan Master Rates	6	BG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
58	F08320WF	Available Plans and Plan Options by Employee Work Table	23	BV	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
59	F08330	Employee Enrollment	4	BG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
60	F08336	Dep/Ben to Employee Plan X-Reference	10	BJ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
61	F08336WF	Dependent/Beneficiary X-Ref Work Table	11	BD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
62	F08346	401(K) Elections	5	B4	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
63	F08351	Plans within Benefit Categories	6	BU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
64	F08380WF	Batch Enrollment Work File	8	BE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
65	F08500	Enrollment Event Setup	4	ES	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
66	F08511	Employee Pension Activity Detail	5	HJ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08H: Health and Safety
67	F086401	Injury/Illness Report Header Information	5	RH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08P: Position Control
68	F08001	Job information	69	JM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
69	F06018	Date Parameter Extension	6	YF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08U: PeopleSoft HR US
70	F08360	Nondiscrimination Groups	23	HE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
71	F08920	COBRA Coverage	30	JS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
72	F08990	COBRA General Constants	4	HW	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
73	F089901	COBRA General Constants Additional Information	4	CC	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
74	F089902	COBRA General Constants - COBRA Notices Information	5	J2	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
75	F08991	COBRA Qualifying Event Constant	6	HD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
76	F08992	Qualifying Event Rules Header	7	QE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP08W: Wage and Salary
77	F08818	Increase Type Rules	5	YM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
78	F08820	Increase Guideline Master Table	3	YT	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
79	F08821	Increase Guideline Range Table	4	YD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP09: General Accounting
80	F48S83	Pool Definition	3	PD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
81	F48S84	Pool Grouping Codes	11	PG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
82	F52G32W	Pool Grouping Selection Workfile	4	PG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP12: Fixed Assets
83	F12002	Default Accounting Constants	25	FD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
84	F12003	Default Depreciation Constants	22	FF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
85	F12092	Fixed Assets Supplemental Data Codes Type	5	F3	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
86	F1212	Parent History	4	FY	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
87	F1212P	Parent History Purge Table	4	FY	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
88	F12851	Depreciation Rules	9	LU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
89	F12851D	Demo Depreciation Rules	9	LU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
90	F1301	Equipment Rates	5	FG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
91	F1301P	Equipment Rates Purge Table	5	FG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP13: Plant/Equipment Management
92	F1307	Status History File	7	F1	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
93	F1307P	Status History Purge Table	7	F1	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP15: Real Estate Management
94	F1501	Tenant/Lease Master	34	NE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
95	F15012	Tenant E.P. Class Master	21	NS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
96	F15012B	Tenant E.P. Class Master	23	NS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
97	F15013B	Sales Overage Master File	6	NO	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
98	F15014	Product Scales Master	7	NP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
99	F15014B	Product Scales Master	18	NP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
100	F15015	Minimum rent/recoveries Master	5	NQ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
101	F15015B	Min/Max Rents And Recoveries Master	14	NQ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
102	F15016	Tenant Escalation Master	37	NU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
103	F15016B	Tenant Escalation Master	38	NU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
104	F1501B	Lease Master Header	27	NE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
105	F1502	Recurring Billings Master	10	NF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
106	F1502B	Recurring Billings Master	10	NF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
107	F1502WAB	Rent Increase Amounts	8	NF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
108	F1502WB	Estimated EP Recurring Billings	12	N4	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
109	F1505	Management Fee Master	7	ND	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
110	F1505B	Management Fee Master	9	ND	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
111	F15110B	Expense Participation Class Account	5	OB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
112	F1514	Area Master	13	NW	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
113	F1514W	Area Work File	2	NW	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
114	F1525	A/R Fee Interest	25	N0	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
115	F1525B	Fees and Interest	26	NM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
116	F1530	Expense Participation Class Master	11	NG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
117	F15301	E.P. Class Account Overrides	6	AO	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
118	F1531	Expense Participation Class Adjustment	5	OM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
119	F1533	Tenant Class Account Exclusions	7	NM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
120	F1533B	Tenant Account Exclusions	8	NM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
121	F1538B1	Occupancy Gross Up Audit	38	GU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
122	F1539E	EP Billing Account Exclusions Audit	10	AU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
123	F1539FC	EP Billing Adj Factor EP Class Audit	9	AU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
124	F1539FL	EP Billing Adj Factor Lease Audit	9	AU	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
125	F1565	Security Deposit Master	8	JF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
126	F1570	Legal Clauses	9	ND	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
127	F15703	Legal Clause Amounts	9	NI	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
128	F159071	Market/Potential/Renewal Rent Master	9	NY	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP15L: Adv Real Estate Forecasting
129	F15L101	AREF Unit Master	29	UM	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
130	F15L109	AREF Budget Results	26	BR	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
131	F15L401	AREF Share Factor Denominator Audit	47	SF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
132	F15L402	AREF Tenant Exclusion Rule Audit	8	SG	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
133	F15L403	AREF Gross Up Processing Audit	28	SH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP39: Advanced Stock Valuation
134	F3908	Item Pool Valuation Cost Master	5	CS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP41: Inventory Management
135	F41092	Item Supplemental Data Base User Defined Codes	7	T2	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP43: Procurement
136	F74U0142	ACM - Application / Certificate Status History	11	DH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP48S: Service Billing
137	F48096	Billing Rate / Mark up Table	4	WQ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
138	F48127	Tax Derivation Information	5	WO	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
139	F4860	Component Table Master	4	AF	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
140	F48S95	Billing AAI Information	5	WV	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP51X: In-Memory Project Management
141	F51X30	Project Advisor Results Header	102	PB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP52G: Proj & Gov Contract Accounting
142	F52G21	Contract Specific Labor Category Cross Reference	8	LR	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP74U: United Kingdom Localizations
143	F74U0118	Payment Voucher Status History - 04	10	VH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
144	F74U4314	SPC - Purchase Order Retention - UK - 43	6	SD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
145	F74U4318	SPC - Purchase Order Line Retention - UK - 43	7	SD	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP75A: Australia
146	F75A0500	AU Bonus and Back Pay Tax Workfile	8	BP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
147	F75A0501	AU Bonus and Back Pay Tax History	8	TH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP75Z: New Zealand
148	F75Z0008	New Zealand Special Rates	4	Z8	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP76A: Argentina
149	F76A396	Item Valuation Cost Master - 76A	5	CS	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP76B: Brazil
150	F76B040	ePIS COFINS Job Header - BRA - 76B	6	PH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
151	F76B0510	Electronic Reporting Process Header - BR -	5	PH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
152	F76B0740	Ato Cotepe Process - BR - 00	6	PH	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
153	F76B61	Packing and Raw Material Table - IN68 - 30	9	IE	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
154	F76B839	FCONT Jobs Periodicity - 76B	4	JP	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
155	F76B940	SPED Jobs -BR - 09	14	SJ	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
156	F76B944	SPED Job Batches - BR - 09	5	SB	EFTE	Date - Ending Effective	Date	Generic Edit	6	0
TOP76P: Peru
157	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

157 columns | 920 | EFTE