	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

92 tables812 | 05

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

92 tables812 | 05