	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

45 columns | 920 | SSN

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F0626	Wage Attachment Control File	9	JG	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP05A: PeopleSoft HR & PR Foundation
2	F060116	Employee Master Information	3	YA	SSN	Employee Tax ID	String	Generic Edit	20	0
3	F0601161	Point-In-Time Employee Master	5	PT	SSN	Employee Tax ID	String	Generic Edit	20	0
4	F060116W	EE Master Request File	3	YA	SSN	Employee Tax ID	String	Generic Edit	20	0
5	F060116Z	Unedited Quick Hire Transaction File	19	SZ	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP05T: Time Entry
6	F06278	Retro Timecard Detail File	3	YT	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP07: Payroll
7	F055011W	Auto Deposit Instructions Work File	2	AD	SSN	Employee Tax ID	String	Generic Edit	20	0
8	F06136	Tax History	2	YZ	SSN	Employee Tax ID	String	Generic Edit	20	0
9	F06136A	Tax Summary (Additional)	10	YZ	SSN	Employee Tax ID	String	Generic Edit	20	0
10	F06136B	Tax Summary (PA ACT 32)	12	YZ	SSN	Employee Tax ID	String	Generic Edit	20	0
11	F063106	Deduction/Benefit Work File	25	Y7	SSN	Employee Tax ID	String	Generic Edit	20	0
12	F065016	Automatic Bank Deposit Master	2	YG	SSN	Employee Tax ID	String	Generic Edit	20	0
13	F07100	CCQ WORKFILE	2	F7	SSN	Employee Tax ID	String	Generic Edit	20	0
14	F07107	Employee Wage Attachment Rules	4	JW	SSN	Employee Tax ID	String	Generic Edit	20	0
15	F074001	New Hire Reporting Workfile - OneWorld Only	7	NH	SSN	Employee Tax ID	String	Generic Edit	20	0
16	F077011	Tax History Integrity (Temp)	6	Y$	SSN	Employee Tax ID	String	Generic Edit	20	0
17	F077011A	Tax History Integrity Additional (Temp)	6	Y$	SSN	Employee Tax ID	String	Generic Edit	20	0
18	F077011B	Tax Integrity (PA Act32)	6	Y3	SSN	Employee Tax ID	String	Generic Edit	20	0
19	F077021	Transaction History Integrity(Temp)	6	Y$	SSN	Employee Tax ID	String	Generic Edit	20	0
20	F07727	Canadian Pension Information	6	J7	SSN	Employee Tax ID	String	Generic Edit	20	0
21	F07830	Employee Federal Control Table	14	Y0	SSN	Employee Tax ID	String	Generic Edit	20	0
22	F07831	Employee State/Local Control Table	17	YB	SSN	Employee Tax ID	String	Generic Edit	20	0
23	F07832	Employee Special Handling Control Table	18	YH	SSN	Employee Tax ID	String	Generic Edit	20	0
24	F078510	ADP Quarterly Integrity Report	10	VR	SSN	Employee Tax ID	String	Generic Edit	20	0
25	F07880	SUI Magnetic Media Workfile	22	YW	SSN	Employee Tax ID	String	Generic Edit	20	0
26	F07991	Deduction, Benefit, Accrual History Conversion Data	1	YX	SSN	Employee Tax ID	String	Generic Edit	20	0
27	F07992	Payroll Tax History Conversion Data	1	YQ	SSN	Employee Tax ID	String	Generic Edit	20	0
28	F8907422	New Hire Detail File - Massachusetts (22)	12	MA	SSN	Employee Tax ID	String	Generic Edit	20	0
29	F8907427	New Hire Detail File - Montana (27)	30	MT	SSN	Employee Tax ID	String	Generic Edit	20	0
30	F8907444	New Hire Detail File Transfer - Texas (44)	4	TX	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP08: Human Resources
31	F083305	Mail Merge Header/Detail	17	MM	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP08AD: ADP Integration
32	F05137	ADP Employee Master Information	13	AD	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP08B: Benefits Administration
33	F0833WF	Benefit Statement Work file	14	WF	SSN	Employee Tax ID	String	Generic Edit	20	0
34	F08901	Participant file	3	HU	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
35	F08401	Applicant Master	4	HA	SSN	Employee Tax ID	String	Generic Edit	20	0
36	F08401WF	Applicant Work File	5	XN	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP08U: PeopleSoft HR US
37	F08360	Nondiscrimination Groups	6	HE	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP08W: Wage and Salary
38	F08201	Salary Review Workfile	3	HR	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP75A: Australia
39	F75A0006	Australian Employee Tax Overrides	2	ZE	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP75Z: New Zealand
40	F75Z0005	New Zealand Employee Tax Overrides	2	ZD	SSN	Employee Tax ID	String	Generic Edit	20	0
TOP77: Payroll (Canadian)
41	F06176	Unemployment Insurance History File	23	YS	SSN	Employee Tax ID	String	Generic Edit	20	0
42	F0713	Tax History	2	YZ	SSN	Employee Tax ID	String	Generic Edit	20	0
43	F0713SAV	Backup Copy of F0713 For Tax Ledger Repost	2	YZ	SSN	Employee Tax ID	String	Generic Edit	20	0
44	F77200	Canadian Employee Year-End Form Header - F77200	10	J5	SSN	Employee Tax ID	String	Generic Edit	20	0
45	F77201T	Negative Amount Print	9	NA	SSN	Employee Tax ID	String	Generic Edit	20	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

45 columns | 920 | SSN