	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

81 columns | 920 | TARA

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F0607	Wage Attachment Ledger File	25	JI	TARA	Tax Area (Work)	String	Generic Edit	10	0
2	F06106	Employee Pay Instructions	18	YM	TARA	Tax Area (Work)	String	Generic Edit	10	0
3	F06107	Employee Wage Attachment Rules	11	J$	TARA	Tax Area (Work)	String	Generic Edit	10	0
4	F0626	Wage Attachment Control File	12	JG	TARA	Tax Area (Work)	String	Generic Edit	10	0
5	F0627	Workers Compensation Summary History	2	JH	TARA	Tax Area (Work)	String	Generic Edit	10	0
6	F069016	Payroll Tax Area Profile	1	YP	TARA	Tax Area (Work)	String	Generic Edit	10	0
7	F069016T	Payroll Tax Area Profile - Tag File	1	YP	TARA	Tax Area (Work)	String	Generic Edit	10	0
8	F069086	Payroll Corporate Tax Identification	2	YI	TARA	Tax Area (Work)	String	Generic Edit	10	0
9	F069116	Payroll Transaction Constants	90	YC	TARA	Tax Area (Work)	String	Generic Edit	10	0
10	F069117	Tax Authority Tax Exemption File	3	YB	TARA	Tax Area (Work)	String	Generic Edit	10	0
11	F069216	Workers Compensation Insurance Rates	2	YB	TARA	Tax Area (Work)	String	Generic Edit	10	0
12	F069226	Unemployment Insurance Rates	2	YH	TARA	Tax Area (Work)	String	Generic Edit	10	0
13	F06926	Tax Area/ Vendor Cross Reference	1	Y#	TARA	Tax Area (Work)	String	Generic Edit	10	0
14	F06931	Wage Attachment File	3	J3	TARA	Tax Area (Work)	String	Generic Edit	10	0
15	F069312	Wage Attachment Exemptions File	1	J3	TARA	Tax Area (Work)	String	Generic Edit	10	0
TOP05A: PeopleSoft HR & PR Foundation
16	F060116	Employee Master Information	14	YA	TARA	Tax Area (Work)	String	Generic Edit	10	0
17	F0601161	Point-In-Time Employee Master	16	PT	TARA	Tax Area (Work)	String	Generic Edit	10	0
18	F060116W	EE Master Request File	14	YA	TARA	Tax Area (Work)	String	Generic Edit	10	0
19	F060116Z	Unedited Quick Hire Transaction File	36	SZ	TARA	Tax Area (Work)	String	Generic Edit	10	0
20	F06345	Historical Payroll Register	29	JL	TARA	Tax Area (Work)	String	Generic Edit	10	0
TOP05T: Time Entry
21	F069136	Tip Disbursement	20	JE	TARA	Tax Area (Work)	String	Generic Edit	10	0
TOP07: Payroll
22	F06136	Tax History	3	YZ	TARA	Tax Area (Work)	String	Generic Edit	10	0
23	F06136A	Tax Summary (Additional)	3	YZ	TARA	Tax Area (Work)	String	Generic Edit	10	0
24	F06136B	Tax Summary (PA ACT 32)	3	YZ	TARA	Tax Area (Work)	String	Generic Edit	10	0
25	F06148	Tax Area Transaction History	2	Y@	TARA	Tax Area (Work)	String	Generic Edit	10	0
26	F06166	Pay Check History Tax Ledger	4	YV	TARA	Tax Area (Work)	String	Generic Edit	10	0
27	F06166A	Tax Ledger (Additional)	4	YV	TARA	Tax Area (Work)	String	Generic Edit	10	0
28	F06166B	Tax Ledger (PA ACT 32)	4	YV	TARA	Tax Area (Work)	String	Generic Edit	10	0
29	F06270	Retro Processing Parameter	54	JP	TARA	Tax Area (Work)	String	Generic Edit	10	0
30	F06350I	WF - Paycheck (Interims)	30	Y4	TARA	Tax Area (Work)	String	Generic Edit	10	0
31	F06490	Payroll/Accounts Payable Ledger Detail	12	JR	TARA	Tax Area (Work)	String	Generic Edit	10	0
32	F068500	941 - Federal Tax History	4	YZ	TARA	Tax Area (Work)	String	Generic Edit	10	0
33	F0701730	Populate Vertex Filing Status	2	VS	TARA	Tax Area (Work)	String	Generic Edit	10	0
34	F0701731	Compensation Overrides	1	YC	TARA	Tax Area (Work)	String	Generic Edit	10	0
35	F0701732	Additional Tax Overrides	2	AO	TARA	Tax Area (Work)	String	Generic Edit	10	0
36	F0701734	Prior Head Tax from a Previous Employer	3	Y3	TARA	Tax Area (Work)	String	Generic Edit	10	0
37	F0701735	Pretax Deduction Overrides	1	YC	TARA	Tax Area (Work)	String	Generic Edit	10	0
38	F07107	Employee Wage Attachment Rules	14	JW	TARA	Tax Area (Work)	String	Generic Edit	10	0
39	F0716701	Employee Assignment T/E Template Information	29	EA	TARA	Tax Area (Work)	String	Generic Edit	10	0
40	F0716709	Employee Assignment T/E Template Info History	29	EA	TARA	Tax Area (Work)	String	Generic Edit	10	0
41	F0717	ROE Summary History	43	JF	TARA	Tax Area (Work)	String	Generic Edit	10	0
42	F07186	Stub Information History Table	12	Y8	TARA	Tax Area (Work)	String	Generic Edit	10	0
43	F0729	Employee DBA Override Instructions	63	Y9	TARA	Tax Area (Work)	String	Generic Edit	10	0
44	F07352	Stub Information File	12	Y2	TARA	Tax Area (Work)	String	Generic Edit	10	0
45	F07353	Tax Detail File	3	Y3	TARA	Tax Area (Work)	String	Generic Edit	10	0
46	F074001	New Hire Reporting Workfile - OneWorld Only	4	NH	TARA	Tax Area (Work)	String	Generic Edit	10	0
47	F07490	Payroll - Accounts Payable Detail (One World)	11	JR	TARA	Tax Area (Work)	String	Generic Edit	10	0
48	F07500	Geocoder Report Setup	2	GC	TARA	Tax Area (Work)	String	Generic Edit	10	0
49	F077011	Tax History Integrity (Temp)	8	Y$	TARA	Tax Area (Work)	String	Generic Edit	10	0
50	F077011A	Tax History Integrity Additional (Temp)	8	Y$	TARA	Tax Area (Work)	String	Generic Edit	10	0
51	F077011B	Tax Integrity (PA Act32)	8	Y3	TARA	Tax Area (Work)	String	Generic Edit	10	0
52	F07727	Canadian Pension Information	7	J7	TARA	Tax Area (Work)	String	Generic Edit	10	0
53	F07811	Negative Amount Workfile	6	JE	TARA	Tax Area (Work)	String	Generic Edit	10	0
54	F078504	Vertex Geo Code to ADP Code	1	VA	TARA	Tax Area (Work)	String	Generic Edit	10	0
55	F078510	ADP Quarterly Integrity Report	6	VR	TARA	Tax Area (Work)	String	Generic Edit	10	0
56	F07880	SUI Magnetic Media Workfile	3	YW	TARA	Tax Area (Work)	String	Generic Edit	10	0
57	F07885	SUI Payments for Quarterly Reporting	2	YW	TARA	Tax Area (Work)	String	Generic Edit	10	0
58	F079320	Wage Attachment Exemptions by Pay Frequency	1	WX	TARA	Tax Area (Work)	String	Generic Edit	10	0
59	F07992	Payroll Tax History Conversion Data	5	YQ	TARA	Tax Area (Work)	String	Generic Edit	10	0
TOP08: Human Resources
60	F081161	ACA Employee Eligibility	32	AD	TARA	Tax Area (Work)	String	Generic Edit	10	0
61	F0811619	ACA Employee Eligibility Archive	32	AD	TARA	Tax Area (Work)	String	Generic Edit	10	0
62	F083303	Benefit Statement Cross Reference Detail	5	CR	TARA	Tax Area (Work)	String	Generic Edit	10	0
TOP08AD: ADP Integration
63	F05137	ADP Employee Master Information	35	AD	TARA	Tax Area (Work)	String	Generic Edit	10	0
64	F051371	ADP Employee DBA Instructions	23	AD	TARA	Tax Area (Work)	String	Generic Edit	10	0
65	F051375	ADP Payroll DBA Transaction Constants	92	AD	TARA	Tax Area (Work)	String	Generic Edit	10	0
TOP75A: Australia
66	F75A0003	Australia/New Zealand tax calculation rules	20	ZR	TARA	Tax Area (Work)	String	Generic Edit	10	0
67	F75A0500	AU Bonus and Back Pay Tax Workfile	5	BP	TARA	Tax Area (Work)	String	Generic Edit	10	0
68	F75A0501	AU Bonus and Back Pay Tax History	5	TH	TARA	Tax Area (Work)	String	Generic Edit	10	0
TOP75Z: New Zealand
69	F75Z0009	New Zealand Tax Detail Work File	3	TX	TARA	Tax Area (Work)	String	Generic Edit	10	0
70	F75Z0010	New Zealand Tax Detail Tag Table	3	TD	TARA	Tax Area (Work)	String	Generic Edit	10	0
TOP77: Payroll (Canadian)
71	F06176	Unemployment Insurance History File	11	YS	TARA	Tax Area (Work)	String	Generic Edit	10	0
72	F0713	Tax History	3	YZ	TARA	Tax Area (Work)	String	Generic Edit	10	0
73	F0713SAV	Backup Copy of F0713 For Tax Ledger Repost	3	YZ	TARA	Tax Area (Work)	String	Generic Edit	10	0
74	F0716	Pay Check History Tax Ledger - Canadian DB	4	YV	TARA	Tax Area (Work)	String	Generic Edit	10	0
75	F77200	Canadian Employee Year-End Form Header - F77200	8	J5	TARA	Tax Area (Work)	String	Generic Edit	10	0
76	F77200A	Canadian Employee Year-End Form Header (Additional)	7	J5	TARA	Tax Area (Work)	String	Generic Edit	10	0
77	F77201T	Negative Amount Print	7	NA	TARA	Tax Area (Work)	String	Generic Edit	10	0
78	F77210	Canadian Employee Year-End Form Detail - F72210	8	J6	TARA	Tax Area (Work)	String	Generic Edit	10	0
79	F77220	Employee Special Handling Detail - F77220	8	J3	TARA	Tax Area (Work)	String	Generic Edit	10	0
80	F77230	Employee Pension Maintenance - F77230	4	J8	TARA	Tax Area (Work)	String	Generic Edit	10	0
81	F77703	Payroll History Audit Report - Worktable	9	AR	TARA	Tax Area (Work)	String	Generic Edit	10	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

81 columns | 920 | TARA