	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

76 tables812 | 08

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

76 tables812 | 08