	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

160 columns | 920 | EFTB

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP01: Address Book
1	F0101	Address Book Master	22	AB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
2	F0101Z2	Address Book - Interoperability	35	SZ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
3	F0116	Address by Date	2	AL	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
4	F01161	Alternate Address	3	WL	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
5	F01161DW	Customer Alternate Address Export	4	DW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
6	F01161Z1	Batch - Alternative Address	16	LB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP03: Accounts Receivable
7	F03012A	Date Effective Category Codes	3	A2	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP03B: Enhanced Accounts Receivable
8	F03B27	A/R Delinquency Policy Detail - Fees	3	RM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP05: Time Accounting and HRM Base
9	F06005	Batch Processing Parameters	9	JE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
10	F0625	Change Code History File	12	JB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
11	F06251	Step Progression Rate History File	6	JB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
12	F0627	Workers Compensation Summary History	7	JH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
13	F069116	Payroll Transaction Constants	66	YC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
14	F069126	Union Rates File	3	YL	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
15	F0691261	Additional Union Rates	3	YL	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
16	F069216	Workers Compensation Insurance Rates	3	YB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
17	F069226	Unemployment Insurance Rates	12	YH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
18	F06923	Valid Job Type/ Step Constant	19	YH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
19	F06925	Employee/Vendor Cross Reference	8	YG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
20	F06931	Wage Attachment File	5	J3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
21	F069311	Wage Attachment Additional Exemptions	4	J3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
22	F069312	Wage Attachment Exemptions File	2	J3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
23	F06933	Step Progression Parameters	3	J@	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
24	F06936	Retro Pay Types Rate	8	JA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP05A: PeopleSoft HR & PR Foundation
25	F069056	Establishment Constant File	8	YO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP05T: Time Entry
26	F05601	Component Pay Instructions	3	CP	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
27	F06918	PF - Piece Rate File	6	JN	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
28	F069246	Shift Differential Table	4	Y3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP06: Payroll (old) - Obsolete-do not reuse
29	F060146	Employees Pay Rate File	8	JI	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
30	F06210	Payroll Cycle Parameters	9	YD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP07: Payroll
31	F06053	Interim Check Parameters File	22	YW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
32	F0701732	Additional Tax Overrides	5	AO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
33	F07210	Pay Cycle Parameters File	33	YD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
34	F0729	Employee DBA Override Instructions	34	Y9	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
35	F079320	Wage Attachment Exemptions by Pay Frequency	3	WX	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08: Human Resources
36	F0800601	Organizational Business Unit/Job Cross-Reference	4	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
37	F0800603	Job Group Competencies	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
38	F0800604	Organizational Business Unit Competencies	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
39	F0800605	Job Type/Step Competencies	4	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
40	F0800606	Competency Options - Overrides	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
41	F0800607	Organizational Competencies	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
42	F0800608	Date Effective Organizational Structure	2	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
43	F0800610	Competencies in Structure and Job	5	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
44	F0800611	Job Competency Default - Overrides	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
45	F0800612	User Defined Job Competency Description Reference	4	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
46	F08006WF	Job Competency Default Overrides Work File	9	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
47	F08JDWF1	Job Description Changes Integration Work File	2	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
48	F08JDWF2	Job Description History Integration Work File	14	JH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08AD: ADP Integration
49	F051375	ADP Payroll DBA Transaction Constants	68	AD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
50	F05138	ADP - Pay Cycle Review Control	4	PC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08B: Benefits Administration
51	F06024	Beneficiary/Co-owner File	11	YJ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
52	F083203	Plan Master Rates	5	BG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08P: Position Control
53	F08001	Job information	68	JM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
54	F06018	Date Parameter Extension	5	YF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
55	F08102	Requisition Information	21	HN	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08U: PeopleSoft HR US
56	F08360	Nondiscrimination Groups	22	HE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
57	F08920	COBRA Coverage	29	JS	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
58	F08990	COBRA General Constants	3	HW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
59	F089901	COBRA General Constants Additional Information	3	CC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
60	F089902	COBRA General Constants - COBRA Notices Information	4	J2	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
61	F08991	COBRA Qualifying Event Constant	7	HD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
62	F08992	Qualifying Event Rules Header	6	QE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08W: Wage and Salary
63	F08290	Pay/Salary Formula File	3	HG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP09: General Accounting
64	F48S80	Segment Definition	2	SD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
65	F48S81	Burden Computation Method	2	CM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
66	F48S82	Burden Base Rules	3	BR	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
67	F48S83	Pool Definition	2	PD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
68	F48S84	Pool Grouping Codes	2	PG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
69	F48S85	Burden Rates	2	RT	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
70	F52G32W	Pool Grouping Selection Workfile	3	PG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP09E: Expense Reimbursment
71	F09E110	Audit Selection Rules	7	AS	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP12: Fixed Assets
72	F12002	Default Accounting Constants	24	FD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
73	F12003	Default Depreciation Constants	21	FF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
74	F1201	Asset Master File	64	FA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
75	F1201P	Asset Master Purge Table	64	FA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
76	F1201Z1	Unedited Asset Master Transactions	75	FA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
77	F1204	Location Tracking Table	16	FM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
78	F1204P	Location Tracking Purge Table	16	FM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
79	F1212	Parent History	3	FY	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
80	F1212P	Parent History Purge Table	3	FY	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
81	F12841	Revaluation Index	1	RI	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
82	F12851	Depreciation Rules	8	LU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
83	F12851D	Demo Depreciation Rules	8	LU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
84	F12852	Annual Depreciation Rules	6	LV	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
85	F12852D	Demo Annual Depreciation Rules	6	LV	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
86	F1301	Equipment Rates	4	FG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
87	F1301P	Equipment Rates Purge Table	4	FG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP13: Plant/Equipment Management
88	F1307	Status History File	3	F1	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
89	F1307P	Status History Purge Table	3	F1	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP15: Real Estate Management
90	F1501	Tenant/Lease Master	33	NE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
91	F15012	Tenant E.P. Class Master	20	NS	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
92	F15012B	Tenant E.P. Class Master	22	NS	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
93	F15013B	Sales Overage Master File	7	NO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
94	F15014	Product Scales Master	6	NP	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
95	F15014B	Product Scales Master	8	NP	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
96	F15015	Minimum rent/recoveries Master	4	NQ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
97	F15015B	Min/Max Rents And Recoveries Master	6	NQ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
98	F15016	Tenant Escalation Master	36	NU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
99	F15016B	Tenant Escalation Master	37	NU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
100	F1501B	Lease Master Header	25	NE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
101	F1502	Recurring Billings Master	9	NF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
102	F1502B	Recurring Billings Master	9	NF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
103	F1502WAB	Rent Increase Amounts	7	NF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
104	F1502WB	Estimated EP Recurring Billings	11	N4	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
105	F1503	Log Standards Master	12	NB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
106	F1505	Management Fee Master	6	ND	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
107	F1505B	Management Fee Master	8	ND	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
108	F15110B	Expense Participation Class Account	4	OB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
109	F1513	FASB 13 Lease Control File	11	O3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
110	F1513B	FASB 13 Lease Control	11	O3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
111	F1514	Area Master	12	NW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
112	F1514W	Area Work File	1	NW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
113	F1521	Log Detail Master	11	NB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
114	F1525	A/R Fee Interest	24	N0	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
115	F1525B	Fees and Interest	25	NM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
116	F1530	Expense Participation Class Master	10	NG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
117	F15301	E.P. Class Account Overrides	5	AO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
118	F1531	Expense Participation Class Adjustment	4	OM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
119	F1533	Tenant Class Account Exclusions	6	NM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
120	F1533B	Tenant Account Exclusions	7	NM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
121	F1538B1	Occupancy Gross Up Audit	37	GU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
122	F1539E	EP Billing Account Exclusions Audit	9	AU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
123	F1539FC	EP Billing Adj Factor EP Class Audit	8	AU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
124	F1539FL	EP Billing Adj Factor Lease Audit	8	AU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
125	F1548	Escalation Billing Register	47	N1	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
126	F1548B	Escalation Billing Register	48	N1	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
127	F1565	Security Deposit Master	7	JF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
128	F1570	Legal Clauses	8	ND	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
129	F15703	Legal Clause Amounts	8	NI	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
130	F159071	Market/Potential/Renewal Rent Master	8	NY	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP15L: Adv Real Estate Forecasting
131	F15L101	AREF Unit Master	28	UM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
132	F15L109	AREF Budget Results	25	BR	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
133	F15L401	AREF Share Factor Denominator Audit	46	SF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
134	F15L402	AREF Tenant Exclusion Rule Audit	7	SG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
135	F15L403	AREF Gross Up Processing Audit	27	SH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP17: Customer Service Management
136	F1791	Entitlement Dates	7	EM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP17C: Call Management
137	F1731	Equipment Master Location History	12	LQ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
138	F1755	Case Master	118	ZA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
139	F1757	Task Master	15	ZA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP43: Procurement
140	F74U0142	ACM - Application / Certificate Status History	6	DH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP48S: Service Billing
141	F48096	Billing Rate / Mark up Table	3	WQ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
142	F48127	Tax Derivation Information	4	WO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
143	F4860	Component Table Master	3	AF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
144	F4861	Component Table Detail	2	AF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
145	F4862	Component Cross Reference	3	AF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
146	F48S95	Billing AAI Information	4	WV	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP51X: In-Memory Project Management
147	F51X30	Project Advisor Results Header	101	PB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP52G: Proj & Gov Contract Accounting
148	F52G21	Contract Specific Labor Category Cross Reference	7	LR	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP74H: Hungary
149	F74H1010	Effective EU Tax Identifiers - HUN - 00	2	AE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP74U: United Kingdom Localizations
150	F74U0118	Payment Voucher Status History - 04	6	VH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP75A: Australia
151	F75A0500	AU Bonus and Back Pay Tax Workfile	7	BP	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
152	F75A0501	AU Bonus and Back Pay Tax History	7	TH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP75Z: New Zealand
153	F75Z0008	New Zealand Special Rates	3	Z8	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP76B: Brazil
154	F76B040	ePIS COFINS Job Header - BRA - 76B	5	PH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
155	F76B0510	Electronic Reporting Process Header - BR -	4	PH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
156	F76B0740	Ato Cotepe Process - BR - 00	5	PH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
157	F76B839	FCONT Jobs Periodicity - 76B	3	JP	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
158	F76B940	SPED Jobs -BR - 09	13	SJ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
159	F76B944	SPED Job Batches - BR - 09	4	SB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOPH90: EnterpriseOne TOOLS
160	F1761	Electronic Help JDE Request Log	8	ZA	EFTB	Date - Beginning 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

160 columns | 920 | EFTB