	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

102 columns | 920 | HMCU

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	92	GL	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP05: Time Accounting and HRM Base
2	F050116W	Employee Master Integrations Work File	3	EM	HMCU	Business Unit - Home	String	Generic Edit	12	0
3	F051124	Director Text Setup File	2	Y4	HMCU	Business Unit - Home	String	Generic Edit	12	0
4	F051402	Search Constants	2	SC	HMCU	Business Unit - Home	String	Generic Edit	12	0
5	F054101	Employee Personal Profile Information History Table	9	EH	HMCU	Business Unit - Home	String	Generic Edit	12	0
6	F054101W	Employee Personal Profile Information Work Table	9	EP	HMCU	Business Unit - Home	String	Generic Edit	12	0
7	F06106	Employee Pay Instructions	103	YM	HMCU	Business Unit - Home	String	Generic Edit	12	0
8	F0618	Employee Transaction History	9	YT	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP05A: PeopleSoft HR & PR Foundation
9	F05844	Approval Hierarchy Table	2	AH	HMCU	Business Unit - Home	String	Generic Edit	12	0
10	F060116	Employee Master Information	23	YA	HMCU	Business Unit - Home	String	Generic Edit	12	0
11	F0601161	Point-In-Time Employee Master	25	PT	HMCU	Business Unit - Home	String	Generic Edit	12	0
12	F060116W	EE Master Request File	23	YA	HMCU	Business Unit - Home	String	Generic Edit	12	0
13	F060116Z	Unedited Quick Hire Transaction File	23	SZ	HMCU	Business Unit - Home	String	Generic Edit	12	0
14	F060119	Employee Jobs History File	2	YE	HMCU	Business Unit - Home	String	Generic Edit	12	0
15	F06345	Historical Payroll Register	7	JL	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP05T: Time Entry
16	F051123	Self Service Time Entry Layout Setup File	2	Y3	HMCU	Business Unit - Home	String	Generic Edit	12	0
17	F06116	Employee Transaction Detail File	9	YT	HMCU	Business Unit - Home	String	Generic Edit	12	0
18	F06116Z1	Employee Transactions - Batch File	26	VL	HMCU	Business Unit - Home	String	Generic Edit	12	0
19	F06116Z2	ESS Timecard History	26	VM	HMCU	Business Unit - Home	String	Generic Edit	12	0
20	F06278	Retro Timecard Detail File	12	YT	HMCU	Business Unit - Home	String	Generic Edit	12	0
21	F063951	Payroll Journal (Compressed) File	29	GL	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP06: Payroll (old) - Obsolete-do not reuse
22	F060118	Employee Jobs	2	YE	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP07: Payroll
23	F05290	WF - Payroll Journal (Detail)	29	JR	HMCU	Business Unit - Home	String	Generic Edit	12	0
24	F06156	Pay Check History Summary	28	YU	HMCU	Business Unit - Home	String	Generic Edit	12	0
25	F06270	Retro Processing Parameter	37	JP	HMCU	Business Unit - Home	String	Generic Edit	12	0
26	F063106	Deduction/Benefit Work File	5	Y7	HMCU	Business Unit - Home	String	Generic Edit	12	0
27	F06350I	WF - Paycheck (Interims)	37	Y4	HMCU	Business Unit - Home	String	Generic Edit	12	0
28	F06490	Payroll/Accounts Payable Ledger Detail	8	JR	HMCU	Business Unit - Home	String	Generic Edit	12	0
29	F0716701	Employee Assignment T/E Template Information	27	EA	HMCU	Business Unit - Home	String	Generic Edit	12	0
30	F0716709	Employee Assignment T/E Template Info History	27	EA	HMCU	Business Unit - Home	String	Generic Edit	12	0
31	F0717	ROE Summary History	37	JF	HMCU	Business Unit - Home	String	Generic Edit	12	0
32	F07235	Auto Deposit Bank Workfile	5	Y6	HMCU	Business Unit - Home	String	Generic Edit	12	0
33	F07236	Auto Deposit Tape File Setup	2	Y6	HMCU	Business Unit - Home	String	Generic Edit	12	0
34	F07236T	Auto Deposit Tape File Setup (Additional)	2	Y6	HMCU	Business Unit - Home	String	Generic Edit	12	0
35	F07350	Payment File	12	Y0	HMCU	Business Unit - Home	String	Generic Edit	12	0
36	F07355	Pre-Payroll Error File	25	Y5	HMCU	Business Unit - Home	String	Generic Edit	12	0
37	F07490	Payroll - Accounts Payable Detail (One World)	8	JR	HMCU	Business Unit - Home	String	Generic Edit	12	0
38	F07727	Canadian Pension Information	4	J7	HMCU	Business Unit - Home	String	Generic Edit	12	0
39	F07822	Company Federal Control Table	11	JI	HMCU	Business Unit - Home	String	Generic Edit	12	0
40	F07830	Employee Federal Control Table	61	Y0	HMCU	Business Unit - Home	String	Generic Edit	12	0
41	F07831	Employee State/Local Control Table	37	YB	HMCU	Business Unit - Home	String	Generic Edit	12	0
42	F07832	Employee Special Handling Control Table	23	YH	HMCU	Business Unit - Home	String	Generic Edit	12	0
43	F07850	Group Fund Setup	4	FG	HMCU	Business Unit - Home	String	Generic Edit	12	0
44	F07UI200	Timecard History Work File	12	TH	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP08: Human Resources
45	F081161	ACA Employee Eligibility	25	AD	HMCU	Business Unit - Home	String	Generic Edit	12	0
46	F0811619	ACA Employee Eligibility Archive	25	AD	HMCU	Business Unit - Home	String	Generic Edit	12	0
47	F082003	Grade/Step Progression Detail File	4	YW	HMCU	Business Unit - Home	String	Generic Edit	12	0
48	F083305	Mail Merge Header/Detail	21	MM	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP08AD: ADP Integration
49	F05137	ADP Employee Master Information	11	AD	HMCU	Business Unit - Home	String	Generic Edit	12	0
50	F051371	ADP Employee DBA Instructions	108	AD	HMCU	Business Unit - Home	String	Generic Edit	12	0
51	F051372	ADP Employee Job Master Information	5	AD	HMCU	Business Unit - Home	String	Generic Edit	12	0
52	F051373	ADP Employee Auto Deposit Instructions	5	AD	HMCU	Business Unit - Home	String	Generic Edit	12	0
53	F051374	ADP Employee Tax Withholding/Override Instructions	5	AD	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP08B: Benefits Administration
54	F0833WF	Benefit Statement Work file	18	WF	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP08H: Health and Safety
55	F08601	Injury/Illness Case Master	10	HL	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP08P: Position Control
56	F08005	Business Unit/ Job Id. X-Ref	1	JV	HMCU	Business Unit - Home	String	Generic Edit	12	0
57	F08101	Position Master	26	HP	HMCU	Business Unit - Home	String	Generic Edit	12	0
58	F081012	Position Accounts	2	HC	HMCU	Business Unit - Home	String	Generic Edit	12	0
59	F08101P	Purge - Position Master	26	HP	HMCU	Business Unit - Home	String	Generic Edit	12	0
60	F08111	Position Budget Detail	19	HQ	HMCU	Business Unit - Home	String	Generic Edit	12	0
61	F08111P	Purge - Position Budget Detail	19	HQ	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
62	F08102	Requisition Information	37	HN	HMCU	Business Unit - Home	String	Generic Edit	12	0
63	F08401	Applicant Master	43	HA	HMCU	Business Unit - Home	String	Generic Edit	12	0
64	F08401WF	Applicant Work File	44	XN	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP08U: PeopleSoft HR US
65	F08910	COBRA Qualified Beneficiary File	27	J1	HMCU	Business Unit - Home	String	Generic Edit	12	0
66	F08990	COBRA General Constants	2	HW	HMCU	Business Unit - Home	String	Generic Edit	12	0
67	F089901	COBRA General Constants Additional Information	2	CC	HMCU	Business Unit - Home	String	Generic Edit	12	0
68	F089902	COBRA General Constants - COBRA Notices Information	2	J2	HMCU	Business Unit - Home	String	Generic Edit	12	0
69	F08991	COBRA Qualifying Event Constant	5	HD	HMCU	Business Unit - Home	String	Generic Edit	12	0
70	F08992	Qualifying Event Rules Header	4	QE	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP08W: Wage and Salary
71	F08201	Salary Review Workfile	7	HR	HMCU	Business Unit - Home	String	Generic Edit	12	0
72	F08818	Increase Type Rules	3	YM	HMCU	Business Unit - Home	String	Generic Edit	12	0
73	F08830WF	Compensation Root Work Table	12	YN	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP09: General Accounting
74	F0911P	Purge - Account Ledger	92	GL	HMCU	Business Unit - Home	String	Generic Edit	12	0
75	F0911Z1	Journal Entry Transactions - Batch File	109	VN	HMCU	Business Unit - Home	String	Generic Edit	12	0
76	F0911Z4	F0911 Interoperability Table	114	SZ	HMCU	Business Unit - Home	String	Generic Edit	12	0
77	F0917	Bank Statement Detail	42	GD	HMCU	Business Unit - Home	String	Generic Edit	12	0
78	F09UI015	Indexed Computations Multi-Tiered Entries	92	GL	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP09E: Expense Reimbursment
79	F20111	Expense Report Header	35	EH	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP17C: Call Management
80	F1755	Case Master	99	ZA	HMCU	Business Unit - Home	String	Generic Edit	12	0
81	F1760	Time Entry	17	ZB	HMCU	Business Unit - Home	String	Generic Edit	12	0
82	F1797	S/WM Address Book Information	20	CS	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP18: Timecard Automation
83	F186602	Labor Rules Tag File	23	TF	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP37: Quality Management
84	F3711	Test Results	19	TR	HMCU	Business Unit - Home	String	Generic Edit	12	0
85	F3711Z1	Test Results Unedited Transaction Table	32	SZ	HMCU	Business Unit - Home	String	Generic Edit	12	0
86	F37900	Certificate of Analysis (COA) Extract	19	TR	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP42: Sales Management
87	F42800G	Sales Update G Batch Workfile	23	SG	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP48S: Service Billing
88	F48096	Billing Rate / Mark up Table	17	WQ	HMCU	Business Unit - Home	String	Generic Edit	12	0
89	F4812	Billing Detail Workfile	44	WD	HMCU	Business Unit - Home	String	Generic Edit	12	0
90	F4812H	Billing Workfile History	44	WD	HMCU	Business Unit - Home	String	Generic Edit	12	0
91	F4812HS	Billing Workfile History Purged Save	44	WD	HMCU	Business Unit - Home	String	Generic Edit	12	0
92	F48S0618	Payroll Reclassification Workfile	9	YT	HMCU	Business Unit - Home	String	Generic Edit	12	0
93	F48S910	Billing Detail Journal Workfile	50	W2	HMCU	Business Unit - Home	String	Generic Edit	12	0
94	F48S911	Summarized Journal Workfile	41	W3	HMCU	Business Unit - Home	String	Generic Edit	12	0
95	F48SUI01	Billing Detail Print Workfile	44	WD	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP52: Contract Billing
96	F5212	T and M, Unit Price and Lumpsum Cross Reference Accounts	19	G5	HMCU	Business Unit - Home	String	Generic Edit	12	0
97	F5280W	Contract Revenue Summary Work File	26	GY	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP52G: Proj & Gov Contract Accounting
98	F52G21	Contract Specific Labor Category Cross Reference	13	LR	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP54HS: Health & Safety Incident Mgt
99	F54HS02	Incident People	19	S2	HMCU	Business Unit - Home	String	Generic Edit	12	0
100	F54HS02M	Incident People Change History	22	I2	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP75A: Australia
101	F75A0301	Superannuation Payment	4	SA	HMCU	Business Unit - Home	String	Generic Edit	12	0
TOP77: Payroll (Canadian)
102	F77200	Canadian Employee Year-End Form Header - F77200	12	J5	HMCU	Business Unit - Home	String	Generic Edit	12	0

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

102 columns | 920 | HMCU