	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

97 tables910 | 05

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05: Time Accounting and HRM Base
1	910	F05005	GF	21	1	Generic UBE File	Files	05: Time Accounting and HRM Base
2	910	F050116W	EM	27	2	Employee Master Integrations Work File	Files	05: Time Accounting and HRM Base
3	910	F050611	UR	11	2	URL Definitions	Files	05: Time Accounting and HRM Base
4	910	F050612	UR	9	3	Media Object URL Intersection	Files	05: Time Accounting and HRM Base
5	910	F05100	CM	11	2	Resource Competency	Master Files	05: Time Accounting and HRM Base	Business Data
6	910	F05100Z1	CU	28	2	Resource Competencies Unedited Transactions File	Files	05: Time Accounting and HRM Base
7	910	F05101	CY	14	2	Course Master	Master Files	05: Time Accounting and HRM Base	Business Data
8	910	F05102	SM	22	6	Goal Master	Master Files	05: Time Accounting and HRM Base	Business Data
9	910	F05103	AM	9	1	Scale Master	Master Files	05: Time Accounting and HRM Base	Business Data
10	910	F05104	CM	11	1	Competency Master	Master Files	05: Time Accounting and HRM Base	Business Data
11	910	F05105	GS	15	3	Goal Suggestions	Files	05: Time Accounting and HRM Base	Business Data
12	910	F05106	CU	9	1	Competency Update Events	Files	05: Time Accounting and HRM Base	Business Data
13	910	F05107	CU	9	1	Competency Update Approval Routing	Files	05: Time Accounting and HRM Base	Business Data
14	910	F05107A	CU	10	1	Competency Update Approval Routing Tag File	Files	05: Time Accounting and HRM Base
15	910	F05108	UT	15	1	Unconfirmed Training Additional	Files	08: Human Resources
16	910	F05111	CT	18	3	Training/Development	Transaction Files	05: Time Accounting and HRM Base	Business Data
17	910	F05112	ST	13	1	Skills/Resources	Transaction Files	05: Time Accounting and HRM Base	Business Data
18	910	F051124	Y4	9	1	Director Text Setup File	Files	05T: Time Entry	Business Data
19	910	F05113	AT	13	1	Accomplishments	Transaction Files	05: Time Accounting and HRM Base	Business Data
20	910	F05114	CT	19	1	Certifications	Transaction Files	05: Time Accounting and HRM Base	Business Data
21	910	F05115	ET	14	3	Education	Transaction Files	05: Time Accounting and HRM Base	Business Data
22	910	F05116	LT	11	1	Languages	Transaction Files	05: Time Accounting and HRM Base	Business Data
23	910	F05117	GL	11	2	Goal Action Plan	Transaction Files	05: Time Accounting and HRM Base	Business Data
24	910	F051171	GL	20	5	Goal Actions	Files	05: Time Accounting and HRM Base	Business Data
25	910	F05118	AC	9	1	Aggregate Competencies	Transaction Files	05: Time Accounting and HRM Base	Business Data
26	910	F05119	CL	9	1	Competency Levels	Transaction Files	05: Time Accounting and HRM Base	Business Data
27	910	F05120	MM	15	1	Competency History	History Files	05: Time Accounting and HRM Base	Business Data
28	910	F05121	CR	9	2	Competency/Course	Transaction Files	05: Time Accounting and HRM Base	Business Data
29	910	F05122	AP	10	2	Action Plan	Secondary Master Files	05: Time Accounting and HRM Base	Business Data
30	910	F051400	SF	9	1	Searchable Competency Fields	Files	05: Time Accounting and HRM Base
31	910	F051402	SC	8	1	Search Constants	Files	05: Time Accounting and HRM Base
32	910	F051413	SI	7	1	Competency Search Importance	Files	05: Time Accounting and HRM Base
33	910	F051421	WI	8	2	Word Index	Files	05: Time Accounting and HRM Base
34	910	F051422	CW	9	1	Competency Words	Files	05: Time Accounting and HRM Base
35	910	F051423	LW	10	1	Level Words	Files	05: Time Accounting and HRM Base
36	910	F051424	CD	10	1	Competency Detail UDC Words	Files	05: Time Accounting and HRM Base
37	910	F051425	CD	10	1	Competency Detail Words	Files	05: Time Accounting and HRM Base
38	910	F051427	IW	6	1	Ignore Words	Files	05: Time Accounting and HRM Base
39	910	F051428	RW	7	1	Related Words	Files	05: Time Accounting and HRM Base
40	910	F051429	AC	9	1	Acronym	Files	05: Time Accounting and HRM Base
41	910	F05152WF	WF	8	1	Results Work File	Files	05: Time Accounting and HRM Base
42	910	F05153WF	WF	9	1	Results Work File Competency Detail	Files	05: Time Accounting and HRM Base
43	910	F05154WF	WF	10	1	Results Work File Competency Words Detail	Files	05: Time Accounting and HRM Base
44	910	F05400	PF	27	4	Self-Service Process Flow Settings	Files	05: Time Accounting and HRM Base
45	910	F054101	EH	51	1	Employee Personal Profile Information History Table	Files	05: Time Accounting and HRM Base
46	910	F054101W	EP	52	5	Employee Personal Profile Information Work Table	Files	05: Time Accounting and HRM Base
47	910	F054111	CH	25	1	Employee Emergency Contact History Table	Files	05: Time Accounting and HRM Base
48	910	F054111W	EC	26	4	Employee Emergency Contact Work Table	Files	05: Time Accounting and HRM Base
49	910	F05420	WA	15	2	Workflow Approval Table	Files	05: Time Accounting and HRM Base
50	910	F05430	UT	12	1	ESS User Defined Text	Files	05: Time Accounting and HRM Base
51	910	F06005	JE	30	1	Batch Processing Parameters	Work Files	07: Payroll	Business Data
52	910	F0605	J@	27	1	D/B/A Period Control File	Balance Files	05: Time Accounting and HRM Base	Business Data
53	910	F0607	JI	26	1	Wage Attachment Ledger File	Transaction Files	05: Time Accounting and HRM Base	Business Data
54	910	F0609	Y$	41	9	Deduction/Benefit/Accrual Ledger File	Transaction Files	05: Time Accounting and HRM Base	Business Data
55	910	F06106	YM	105	8	Employee Pay Instructions	Secondary Master Files	05: Time Accounting and HRM Base	Business Data
56	910	F06107	J$	49	1	Employee Wage Attachment Rules	Secondary Master Files	05: Time Accounting and HRM Base	Business Data
57	910	F061071	J$	23	1	Employee Wage Attachment Fee File	Secondary Master Files	07: Payroll	Business Data
58	910	F06145	YH	54	3	Calendar Month DBA Summary History File	History Files	07: Payroll	Business Data
59	910	F06149	Y7	14	1	Fiscal and Anniversary Rollover Work File	Balance Files	05: Time Accounting and HRM Base	Business Data
60	910	F0618	YT	149	27	Employee Transaction History	History Files	05: Time Accounting and HRM Base	Business Data
61	910	F0619	Y$	33	9	Benefit/Accrual Detail File	History Files	05: Time Accounting and HRM Base	Business Data
62	910	F0625	JB	19	5	Change Code History File	History Files	05: Time Accounting and HRM Base	Business Data
63	910	F06251	JB	10	4	Step Progression Rate History File	Transaction Files	07: Payroll	Business Data
64	910	F0626	JG	24	4	Wage Attachment Control File	Transaction Files	05: Time Accounting and HRM Base	Business Data
65	910	F0627	JH	100	1	Workers Compensation Summary History	History Files	05: Time Accounting and HRM Base	Business Data
66	910	F069016	YP	21	3	Payroll Tax Area Profile	Constants Files	07: Payroll	Business Data
67	910	F069016T	YP	9	1	Payroll Tax Area Profile - Tag File	Constants Files	07: Payroll
68	910	F069027	Y2	10	1	Table Code Unit-of-Measure Window	Constants Files	05: Time Accounting and HRM Base	Business Data
69	910	F069036	YX	7	2	Payroll Transaction Cross Reference	Constants Files	05: Time Accounting and HRM Base	Business Data
70	910	F069086	YI	10	4	Payroll Corporate Tax Identification	Constants Files	05: Time Accounting and HRM Base	Business Data
71	910	F069106	Y1	53	4	Union Benefits Master	Constants Files	05: Time Accounting and HRM Base	Business Data
72	910	F069116	YC	135	9	Payroll Transaction Constants	Constants Files	07: Payroll	Business Data
73	910	F069116T	YC	47	1	Payroll Transaction Constants - Tag File	Constants Files	07: Payroll
74	910	F069117	YB	3	1	Tax Authority Tax Exemption File	Constants Files	05: Time Accounting and HRM Base	Business Data
75	910	F069126	YL	40	3	Union Rates File	Constants Files	05: Time Accounting and HRM Base	Business Data
76	910	F0691261	YL	25	1	Additional Union Rates	Files	05: Time Accounting and HRM Base
77	910	F06915	JH	16	5	Holiday Table	Constants Files	05: Time Accounting and HRM Base	Business Data
78	910	F069162	JH	5	1	Job Type/ Item Cross Reference File	Constants Files	05: Time Accounting and HRM Base	Business Data
79	910	F06919	YB	4	1	Denomination Table File	Constants Files	05: Time Accounting and HRM Base	Business Data
80	910	F06920	YQ	22	1	Savings Bond General Constant	Extra Features Files	05: Time Accounting and HRM Base	Business Data
81	910	F069216	YB	19	4	Workers Compensation Insurance Rates	Constants Files	05: Time Accounting and HRM Base	Business Data
82	910	F069226	YH	14	2	Unemployment Insurance Rates	Constants Files	05: Time Accounting and HRM Base
83	910	F06923	YH	36	2	Valid Job Type/ Step Constant	Constants Files	05: Time Accounting and HRM Base	Business Data
84	910	F06925	YG	9	1	Employee/Vendor Cross Reference	Extra Features Files	05: Time Accounting and HRM Base	Business Data
85	910	F06926	Y#	4	1	Tax Area/ Vendor Cross Reference	Extra Features Files	05: Time Accounting and HRM Base	Business Data
86	910	F06927	J5	3	1	Payee Voucher Rules	Extra Features Files	07: Payroll	Business Data
87	910	F06931	J3	10	1	Wage Attachment File	Constants Files	07: Payroll	Business Data
88	910	F069311	J3	6	1	Wage Attachment Additional Exemptions	Constants Files	07: Payroll	Business Data
89	910	F069312	J3	9	1	Wage Attachment Exemptions File	Constants Files	07: Payroll	Business Data
90	910	F06933	J@	20	2	Step Progression Parameters	Constants Files	07: Payroll	Business Data
91	910	F06936	JA	19	7	Retro Pay Types Rate	Constants Files	07: Payroll	Business Data
92	910	F06972	YR	6	3	Retro Pay Type Table	Constants Files	07: Payroll	Business Data
93	910	F0709	Y$	59	15	Deduction/Benefit/Accrual Ledger File	Transaction Files	07: Payroll	Business Data
94	910	F07300	YB	11	2	Employee Lockout Code File	Regular Work Files	05: Time Accounting and HRM Base	Business Data
95	910	F073111	AA	8	2	Pay Type to Activity Type Association	Files	05: Time Accounting and HRM Base
96	910	F07315	GS	10	3	Employee Group Schedules Director	Files	05: Time Accounting and HRM Base
97	910	F086011	CO	16	1	Establishment Information	Files	05: Time Accounting and HRM Base

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

97 tables910 | 05