	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

104 tables920 | 05

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

104 tables920 | 05