	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

137 columns | 812 | EFTB

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F1501	Tenant/Lease Master	33	NE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP01: Address Book
2	F0101	Address Book Master	22	AB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
3	F0101Z2	Address Book - Interoperability	35	SZ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
4	F0116	Address by Date	2	AL	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
5	F01161	Alternate Address	3	WL	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	F069216	Workers Compensation Insurance Rates	3	YB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
16	F069226	Unemployment Insurance Rates	12	YH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
17	F06923	Valid Job Type/ Step Constant	19	YH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
18	F06925	Employee/Vendor Cross Reference	8	YG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
19	F06931	Wage Attachment File	5	J3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
20	F069311	Wage Attachment Additional Exemptions	4	J3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
21	F069312	Wage Attachment Exemptions File	2	J3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
22	F06933	Step Progression Parameters	3	J@	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
23	F06936	Retro Pay Types Rate	8	JA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP05A: OW HR & PR Foundation
24	F069056	Establishment Constant File	8	YO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP05T: Time Entry
25	F06918	PF - Piece Rate File	6	JN	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
26	F069246	Shift Differential Table	4	Y3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP06: Payroll (old) - Obsolete-do not reuse
27	F060146	Employees Pay Rate File	8	JI	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
28	F06210	Payroll Cycle Parameters	9	YD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP07: Payroll
29	F06053	Interim Check Parameters File	22	YW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
30	F0701732	Additional Tax Overrides	5	AO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
31	F07210	Pay Cycle Parameters File	33	YD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
32	F0729	Employee DBA Override Instructions	34	Y9	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08: Human Resources
33	F0800601	Organizational Business Unit/Job Cross-Reference	4	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
34	F0800603	Job Group Competencies	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
35	F0800604	Organizational Business Unit Competencies	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
36	F0800605	Job Type/Step Competencies	4	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
37	F0800606	Competency Options - Overrides	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
38	F0800607	Organizational Competencies	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
39	F0800608	Date Effective Organizational Structure	2	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
40	F0800610	Competencies in Structure and Job	5	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
41	F0800611	Job Competency Default - Overrides	3	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
42	F0800612	User Defined Job Competency Description Reference	4	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
43	F08006WF	Job Competency Default Overrides Work File	9	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
44	F08JDWF1	Job Description Changes Integration Work File	2	JC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
45	F08JDWF2	Job Description History Integration Work File	14	JH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08AD: ADP Integration
46	F051375	ADP Payroll DBA Transaction Constants	68	AD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
47	F05138	ADP - Pay Cycle Review Control	4	PC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08B: Benefits Administration
48	F06024	Beneficiary/Co-owner File	11	YJ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
49	F083203	Plan Master Rates	5	BG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08P: Position Control
50	F08001	Job information	68	JM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
51	F06018	Date Parameter Extension	5	YF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
52	F08102	Requisition Information	21	HN	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08U: OW HR US
53	F08360	Nondiscrimination Groups	22	HE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
54	F08920	COBRA Coverage	29	JS	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
55	F08990	COBRA General Constants	3	HW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
56	F089901	COBRA General Constants Additional Information	3	CC	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
57	F089902	COBRA General Constants - COBRA Notices Information	4	J2	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
58	F08991	COBRA Qualifying Event Constant	7	HD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
59	F08992	Qualifying Event Rules Header	6	QE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP08W: Wage and Salary
60	F08290	Pay/Salary Formula File	3	HG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP09E: Expense Reimbursment
61	F09E110	Audit Selection Rules	7	AS	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP12: Fixed Assets
62	F12002	Default Accounting Constants	24	FD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
63	F12003	Default Depreciation Constants	21	FF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
64	F1201	Asset Master File	64	FA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
65	F1201P	Asset Master Purge Table	64	FA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
66	F1201Z1	Unedited Asset Master Transactions	75	FA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
67	F1204	Location Tracking Table	16	FM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
68	F1204P	Location Tracking Purge Table	16	FM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
69	F1212	Parent History	3	FY	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
70	F1212P	Parent History Purge Table	3	FY	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
71	F12841	Revaluation Index	1	RI	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
72	F12851	Depreciation Rules	8	LU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
73	F12851D	Demo Depreciation Rules	8	LU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
74	F12852	Annual Depreciation Rules	6	LV	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
75	F12852D	Demo Annual Depreciation Rules	6	LV	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
76	F1301	Equipment Rates	4	FG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
77	F1301P	Equipment Rates Purge Table	4	FG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP13: Plant/Equipment Management
78	F1307	Status History File	3	F1	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
79	F1307P	Status History Purge Table	3	F1	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP15: Property Management
80	F15012	Tenant E.P. Class Master	20	NS	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
81	F15012B	Tenant E.P. Class Master	21	NS	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
82	F15013B	Sales Overage Master File	7	NO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
83	F15014	Product Scales Master	6	NP	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
84	F15014B	Product Scales Master	8	NP	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
85	F15015	Minimum rent/recoveries Master	4	NQ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
86	F15015B	Min/Max Rents And Recoveries Master	6	NQ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
87	F15016	Tenant Escalation Master	36	NU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
88	F15016B	Tenant Escalation Master	37	NU	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
89	F1501B	Lease Master Header File	25	NE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
90	F1502	Recurring Billings Master	9	NF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
91	F1502B	Recurring Billings Master	9	NF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
92	F1502WAB	Rent Increase Amounts	7	NF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
93	F1502WB	Estimated EP Recurring Billing Work File (OneWorld)	11	N4	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
94	F1503	Log Standards Master	12	NB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
95	F1505	Management Fee Master	6	ND	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
96	F1505B	Management Fee Master	8	ND	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
97	F15110B	Expense Participation Class Account	4	OB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
98	F1513	FASB 13 Lease Control File	11	O3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
99	F1513B	FASB 13 Lease Control File	11	O3	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
100	F1514	Area Master	12	NW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
101	F1514W	Area Work File	1	NW	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
102	F1521	Log Detail Master	11	NB	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
103	F1525	A/R Fee Interest	24	N0	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
104	F1525B	A/R Fee and Interest	25	NM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
105	F1530	Expense Participation Class Master	10	NG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
106	F1531	Expense Participation Class Adjustment	4	OM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
107	F1533	Tenant Class Account Exclusions	6	NM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
108	F1533B	Tenant Account Exclusions	7	NM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
109	F1548	Escalation Billing Register	47	N1	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
110	F1548B	Escalation Billing Register	48	N1	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
111	F1565	Security Deposit Master	7	JF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
112	F1570	Legal Clauses	8	ND	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
113	F15703	Legal Clause Amounts	8	NI	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
114	F159071	Market/Potential/Renewal Rent Master	8	NY	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP15L: Adv Real Estate Forecasting
115	F15L101	AREF Unit Master	28	UM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
116	F15L109	AREF Budget Results	25	BR	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP17: Customer Service Management
117	F1791	Entitlement Dates	7	EM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP17C: Call Management
118	F1731	Installed Base Location History	12	LQ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
119	F1755	Customer Call Master	118	ZA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
120	F1757	Task Master	15	ZA	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP48S: Service Billing
121	F48096	Billing Rate / Mark up Table	3	WQ	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
122	F48127	Tax Derivation Information	4	WO	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
123	F4860	Component Table Master	3	AF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
124	F4861	Component Table Detail	2	AF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
125	F4862	Component Cross Reference	3	AF	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
126	F48S80	Segment Definition	2	SD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
127	F48S81	Burden Computation Method	2	CM	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
128	F48S82	Burden Base Rules	3	BR	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
129	F48S83	Pool Definition	2	PD	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
130	F48S84	Pool Grouping Codes	2	PG	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
131	F48S85	Burden Rates	2	RT	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
132	F48S95	Billing AAI Information	4	WV	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP55: Reserved for Clients
133	F74U0142	ACM - Application / Certificate Status History	6	DH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP74H: Hungary
134	F74H1010	Effective EU Tax Identifiers	2	AE	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP74U: United Kingdom Localizations
135	F74U0118	Payment Voucher Status History	6	VH	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOP75Z: New Zealand - Reporting System Only
136	F75Z0008	New Zealand Special Rates	3	Z8	EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
TOPH90: ONEWORLD TOOLS
137	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

137 columns | 812 | EFTB