	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

84 tables910 | 08

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
08: Human Resources
1	910	F05401	DT	10	1	Self-Service Process Flow Director Text	Files	08: Human Resources
2	910	F05402	SA	9	1	Self-Service Step/ApplicationCross-Reference	Files	08: Human Resources
3	910	F05403	PR	10	1	Self-Service Script Position Rules	Files	08: Human Resources
4	910	F05410	ES	13	1	Employee E-Signature	Files	08: Human Resources
5	910	F054115	HP	15	1	Employee Phone Number History Table	Files	08: Human Resources
6	910	F054115W	PN	16	3	Employee Phone Number Work Table	Files	08: Human Resources
7	910	F0800601	JC	11	5	Organizational Business Unit/Job Cross-Reference	Master Files	08: Human Resources	Business Data
8	910	F0800602	JC	18	1	Job Competency Master	Master Files	08: Human Resources	Business Data
9	910	F0800603	JC	12	5	Job Group Competencies	Master Files	08: Human Resources	Business Data
10	910	F0800604	JC	12	5	Organizational Business Unit Competencies	Master Files	08: Human Resources	Business Data
11	910	F0800605	JC	13	5	Job Type/Step Competencies	Master Files	08: Human Resources	Business Data
12	910	F0800606	JC	20	7	Competency Options - Overrides	Master Files	08: Human Resources	Business Data
13	910	F0800607	JC	11	5	Organizational Competencies	Master Files	08: Human Resources	Business Data
14	910	F0800608	JC	9	1	Date Effective Organizational Structure	Master Files	08: Human Resources	Business Data
15	910	F0800609	YI	39	4	Gap Analysis Snapshot	Master Files	08: Human Resources	Business Data
16	910	F0800610	JC	15	6	Competencies in Structure and Job	Master Files	08: Human Resources	Business Data
17	910	F0800611	JC	11	4	Job Competency Default - Overrides	Master Files	08: Human Resources	Business Data
18	910	F0800612	JC	17	1	User Defined Job Competency Description Reference	Master Files	08: Human Resources	Business Data
19	910	F08006WF	JC	20	5	Job Competency Default Overrides Work File	Master Files	08: Human Resources	Business Data
20	910	F080434A	VT	104	1	Veteran Employment Reporting	Files	08: Human Resources	Business Data
21	910	F080434B	VE	134	2	Veterans Employment Reporting (VETS 100A)	Files	08: Human Resources
22	910	F080700	XR	12	1	Fusion XREF Table	Files	08: Human Resources
23	910	F080701	LU	19	1	Fusion Lookup Map	Files	08: Human Resources
24	910	F080702	EM	27	1	Fusion Entity Map	Files	08: Human Resources
25	910	F080703	LT	11	1	Fusion Lookup Table	Files	08: Human Resources
26	910	F080704	FE	12	1	Fusion Business Objects Extracted Table	Files	08: Human Resources
27	910	F080705	FT	10	1	HR2HR Transaction Details	Files	08: Human Resources
28	910	F080706	FC	15	2	Fusion Configuration Details	Files	08: Human Resources
29	910	F08090	JX	31	1	HRM Supplemental Data Types	Constants Files	08: Human Resources	Business Data
30	910	F08092	JZ	17	4	Human Resources General Description-User Def Codes	Transaction Files	08: Human Resources	Business Data
31	910	F08093	JY	12	2	Human Resources General Description - Narration	Transaction Files	08: Human Resources	Business Data
32	910	F082002	YV	18	1	Grade/Step Progression Header File	Regular Work Files	08: Human Resources	Business Data
33	910	F082003	YW	29	1	Grade/Step Progression Detail File	Regular Work Files	08: Human Resources	Business Data
34	910	F08320C	PX	11	1	Plan Master Tag File	Files	08: Human Resources
35	910	F083301	BS	7	1	Benefit Statement	Files	08: Human Resources	Business Data
36	910	F083302	HT	7	1	Benefit Statement Heading Codes Type	Files	08: Human Resources	Business Data
37	910	F083303	CR	10	1	Benefit Statement Cross Reference Detail	Files	08: Human Resources	Business Data
38	910	F083304	AH	8	1	Associate Benefit Statement Heading	Files	08: Human Resources	Business Data
39	910	F083305	MM	36	1	Mail Merge Header/Detail	Files	08: Human Resources	Business Data
40	910	F08336B	E2	12	1	Dep/Ben X-Reference Tag Table	Master Files	08: Human Resources	Business Data
41	910	F08338	E7	16	1	Primary Care Physician Table	Master Files	08: Human Resources
42	910	F08338B	PT	11	2	Primary Care Physician Tag Table	Files	08: Human Resources
43	910	F08350C	BX	11	1	Categories by Benefit Group Tag File	Files	08: Human Resources
44	910	F08391	B0	28	1	User Program Parameters	Extra Features Files	08: Human Resources	Business Data
45	910	F085500	AD	8	1	Allowed Dependent Relations Per Plan	Files	08: Human Resources
46	910	F085510	ER	9	1	Benefit Categories by Enrollment Events	Files	08: Human Resources
47	910	F085515	WP	11	1	Workflow Process File	Files	08: Human Resources
48	910	F085520	PH	29	1	Available Plans and Plan Options by Employee History Table	Files	08: Human Resources
49	910	F085520W	AP	53	5	Available Plans and Plan Options by Employee Work Table	Files	08: Human Resources
50	910	F085528	ES	9	1	ESS History Table Cross Reference	Files	08: Human Resources
51	910	F085530W	CP	30	3	Employee Current/Pending Elections Work Table	Files	08: Human Resources
52	910	F085536	DH	28	2	Dependent/Beneficiary X-Reference History Table	Files	08: Human Resources
53	910	F085536W	DB	29	5	Dependent/Beneficiary X-Reference Work Table	Files	08: Human Resources
54	910	F085537W	XB	21	3	Current Dep/Ben X-Reference Work Table	Files	08: Human Resources
55	910	F085540	PU	14	1	Benefits Enrollment Plan/Option URL Address	Files	08: Human Resources
56	910	F085550	IO	14	2	Employee Self-Service Personal Information Options	Files	08: Human Resources
57	910	F085560	NP	3	1	Number of Participants by Employee	Files	08: Human Resources
58	910	F08710	ES	23	5	Employee Setup Master	Master Files	08: Human Resources	Business Data
59	910	F087101	DT	4	2	Default Setup Tasks	Master Files	08: Human Resources	Business Data
60	910	F087102	TL	14	3	Setup Task List	Master Files	08: Human Resources	Business Data
61	910	F087103	TD	26	3	Setup Task Details	Master Files	08: Human Resources	Business Data
62	910	F08711	ET	17	4	Employee Setup Tasks	Master Files	08: Human Resources	Business Data
63	910	F08713P	PI	8	1	Organization Chart Public Information Flags	Files	08: Human Resources
64	910	F08720	SC	13	4	Employee Status Change	Transaction Files	08: Human Resources	Business Data
65	910	F08721	SD	10	1	Employee Status Change Details	Transaction Files	08: Human Resources	Business Data
66	910	F08730	SS	9	1	Employee Status Change Setup	Transaction Files	08: Human Resources	Business Data
67	910	F08731	SL	8	1	Employee Status Change Setup Detail	Transaction Files	08: Human Resources	Business Data
68	910	F08740	MR	14	3	Managers Self Service Reports	Transaction Files	08: Human Resources	Business Data
69	910	F08750	MD	11	1	Managers Delegates	Transaction Files	08: Human Resources	Business Data
70	910	F08771	XG	13	1	CBPA System Company Constants	Master Files	08: Human Resources	Business Data
71	910	F087711	XJ	49	4	CBPA Appraisal Header	Files	08: Human Resources	Business Data
72	910	F087711A	XJ	11	4	CBPA Appraisal Header Tag Table	Files	08: Human Resources	Business Data
73	910	F087711B	XK	15	1	Performance Appraisal Header Template Keys	Files	08: Human Resources	Business Data
74	910	F087715	XM	18	3	CBPA Diary Table	Files	08: Human Resources	Business Data
75	910	F08771A	XG	7	1	CBPA System Company Constants Tag Table	Master Files	08: Human Resources	Business Data
76	910	F08772	XH	13	1	CBPA System Business Unit Overrides	Files	08: Human Resources	Business Data
77	910	F087721	XP	12	1	CBPA Appraisal Creation Work File	Files	08: Human Resources	Business Data
78	910	F08772A	XH	7	1	CBPA System Business Unit Overrides Tag Table	Files	08: Human Resources	Business Data
79	910	F08773	XL	15	1	CBPA System Appraisal Type Overrides	Files	08: Human Resources	Business Data
80	910	F08773A	XL	9	1	CBPA System Appraisal Type Overrides Tag Table	Files	08: Human Resources	Business Data
81	910	F08776	XO	11	2	CBPA Appraisal Templates	Files	08: Human Resources	Business Data
82	910	F089921	DT	11	2	Rules Detail	Files	08: Human Resources	Business Data
83	910	F08JDWF1	JC	19	1	Job Description Changes Integration Work File	Files	08: Human Resources
84	910	F08JDWF2	JH	26	3	Job Description History Integration Work File	Files	08: Human Resources

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

84 tables910 | 08