	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

90 tables920 | 08

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

90 tables920 | 08