	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

73 columns | 920 | TAXX

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F0605	D/B/A Period Control File	6	J@	TAXX	Tax Identification Number	String	Generic Edit	20	0
2	F06145	Calendar Month DBA Summary History File	8	YH	TAXX	Tax Identification Number	String	Generic Edit	20	0
3	F06149	Fiscal and Anniversary Rollover Work File	4	Y7	TAXX	Tax Identification Number	String	Generic Edit	20	0
4	F0618	Employee Transaction History	122	YT	TAXX	Tax Identification Number	String	Generic Edit	20	0
5	F0627	Workers Compensation Summary History	10	JH	TAXX	Tax Identification Number	String	Generic Edit	20	0
6	F069086	Payroll Corporate Tax Identification	4	YI	TAXX	Tax Identification Number	String	Generic Edit	20	0
7	F0709	Deduction/Benefit/Accrual Ledger File	15	Y$	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP05T: Time Entry
8	F06116	Employee Transaction Detail File	175	YT	TAXX	Tax Identification Number	String	Generic Edit	20	0
9	F0623	Piecework History File	11	JL	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP06: Payroll (old) - Obsolete-do not reuse
10	F06146	Employee Transaction History Summary	8	YN	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP07: Payroll
11	F06136	Tax History	10	YZ	TAXX	Tax Identification Number	String	Generic Edit	20	0
12	F06136A	Tax Summary (Additional)	6	YZ	TAXX	Tax Identification Number	String	Generic Edit	20	0
13	F06136B	Tax Summary (PA ACT 32)	6	YZ	TAXX	Tax Identification Number	String	Generic Edit	20	0
14	F06147	Fiscal and Anniversary Year History	4	YD	TAXX	Tax Identification Number	String	Generic Edit	20	0
15	F06148	Tax Area Transaction History	5	Y@	TAXX	Tax Identification Number	String	Generic Edit	20	0
16	F06156	Pay Check History Summary	32	YU	TAXX	Tax Identification Number	String	Generic Edit	20	0
17	F06166	Pay Check History Tax Ledger	19	YV	TAXX	Tax Identification Number	String	Generic Edit	20	0
18	F06166A	Tax Ledger (Additional)	20	YV	TAXX	Tax Identification Number	String	Generic Edit	20	0
19	F06166B	Tax Ledger (PA ACT 32)	13	YV	TAXX	Tax Identification Number	String	Generic Edit	20	0
20	F06720	W-2/1099 Processing Control	7	JE	TAXX	Tax Identification Number	String	Generic Edit	20	0
21	F068500	941 - Federal Tax History	12	YZ	TAXX	Tax Identification Number	String	Generic Edit	20	0
22	F0701734	Prior Head Tax from a Previous Employer	9	Y3	TAXX	Tax Identification Number	String	Generic Edit	20	0
23	F0701740	Quantum Control Tax	3	YQ	TAXX	Tax Identification Number	String	Generic Edit	20	0
24	F0701741	Canadian Deduction	3	YD	TAXX	Tax Identification Number	String	Generic Edit	20	0
25	F0705	DBA Period Control File	7	J@	TAXX	Tax Identification Number	String	Generic Edit	20	0
26	F07149	Accrual Fiscal/Anniversary History Work File	4	Y8	TAXX	Tax Identification Number	String	Generic Edit	20	0
27	F0719	DBA Transaction Detail History	15	Y$	TAXX	Tax Identification Number	String	Generic Edit	20	0
28	F07350	Payment File	11	Y0	TAXX	Tax Identification Number	String	Generic Edit	20	0
29	F07353	Tax Detail File	23	Y3	TAXX	Tax Identification Number	String	Generic Edit	20	0
30	F074001	New Hire Reporting Workfile - OneWorld Only	26	NH	TAXX	Tax Identification Number	String	Generic Edit	20	0
31	F077011	Tax History Integrity (Temp)	10	Y$	TAXX	Tax Identification Number	String	Generic Edit	20	0
32	F077011A	Tax History Integrity Additional (Temp)	10	Y$	TAXX	Tax Identification Number	String	Generic Edit	20	0
33	F077011B	Tax Integrity (PA Act32)	10	Y3	TAXX	Tax Identification Number	String	Generic Edit	20	0
34	F077021	Transaction History Integrity(Temp)	9	Y$	TAXX	Tax Identification Number	String	Generic Edit	20	0
35	F07727	Canadian Pension Information	8	J7	TAXX	Tax Identification Number	String	Generic Edit	20	0
36	F07821	Company Form Count Table	6	JG	TAXX	Tax Identification Number	String	Generic Edit	20	0
37	F07822	Company Federal Control Table	4	JI	TAXX	Tax Identification Number	String	Generic Edit	20	0
38	F07824	Company State/Local Control Table	4	JD	TAXX	Tax Identification Number	String	Generic Edit	20	0
39	F07825	Company Special Handling Control Table	4	JA	TAXX	Tax Identification Number	String	Generic Edit	20	0
40	F07830	Employee Federal Control Table	3	Y0	TAXX	Tax Identification Number	String	Generic Edit	20	0
41	F07831	Employee State/Local Control Table	3	YB	TAXX	Tax Identification Number	String	Generic Edit	20	0
42	F07832	Employee Special Handling Control Table	3	YH	TAXX	Tax Identification Number	String	Generic Edit	20	0
43	F078510	ADP Quarterly Integrity Report	9	VR	TAXX	Tax Identification Number	String	Generic Edit	20	0
44	F07880	SUI Magnetic Media Workfile	6	YW	TAXX	Tax Identification Number	String	Generic Edit	20	0
45	F07885	SUI Payments for Quarterly Reporting	9	YW	TAXX	Tax Identification Number	String	Generic Edit	20	0
46	F8907422	New Hire Detail File - Massachusetts (22)	3	MA	TAXX	Tax Identification Number	String	Generic Edit	20	0
47	F8907427	New Hire Detail File - Montana (27)	6	MT	TAXX	Tax Identification Number	String	Generic Edit	20	0
48	F8907428	New Hire Detail File - Nebraska(28)	5	NE	TAXX	Tax Identification Number	String	Generic Edit	20	0
49	F8907444	New Hire Detail File Transfer - Texas (44)	21	TX	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP08U: PeopleSoft HR US
50	F08360	Nondiscrimination Groups	5	HE	TAXX	Tax Identification Number	String	Generic Edit	20	0
51	F08368	NDT - Nondiscrimination Totals	4	DB	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP18: Timecard Automation
52	F186602	Labor Rules Tag File	181	TF	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP48S: Service Billing
53	F48S0618	Payroll Reclassification Workfile	122	YT	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP75A: Australia
54	F75A0500	AU Bonus and Back Pay Tax Workfile	11	BP	TAXX	Tax Identification Number	String	Generic Edit	20	0
55	F75A0501	AU Bonus and Back Pay Tax History	11	TH	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP76A: Argentina
56	F76A0209	Header & Footer Invoice/ShipmentNote History WF - ARG - 76A	28	HF	TAXX	Tax Identification Number	String	Generic Edit	20	0
57	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	28	HF	TAXX	Tax Identification Number	String	Generic Edit	20	0
58	F76A0440	Check details RG 1547 - ARG - 04 - 76A	3	CD	TAXX	Tax Identification Number	String	Generic Edit	20	0
59	F76AUI20	Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A	28	HF	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP76H: Chile
60	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	32	PI	TAXX	Tax Identification Number	String	Generic Edit	20	0
TOP77: Payroll (Canadian)
61	F06176	Unemployment Insurance History File	25	YS	TAXX	Tax Identification Number	String	Generic Edit	20	0
62	F0713	Tax History	10	YZ	TAXX	Tax Identification Number	String	Generic Edit	20	0
63	F0713SAV	Backup Copy of F0713 For Tax Ledger Repost	10	YZ	TAXX	Tax Identification Number	String	Generic Edit	20	0
64	F0716	Pay Check History Tax Ledger - Canadian DB	19	YV	TAXX	Tax Identification Number	String	Generic Edit	20	0
65	F77110	Canadian Year-End Sequential Number Setup	4	J9	TAXX	Tax Identification Number	String	Generic Edit	20	0
66	F77173	ROE Summary History Work File	10	JF	TAXX	Tax Identification Number	String	Generic Edit	20	0
67	F77200	Canadian Employee Year-End Form Header - F77200	9	J5	TAXX	Tax Identification Number	String	Generic Edit	20	0
68	F77200A	Canadian Employee Year-End Form Header (Additional)	8	J5	TAXX	Tax Identification Number	String	Generic Edit	20	0
69	F77201T	Negative Amount Print	8	NA	TAXX	Tax Identification Number	String	Generic Edit	20	0
70	F77210	Canadian Employee Year-End Form Detail - F72210	7	J6	TAXX	Tax Identification Number	String	Generic Edit	20	0
71	F77220	Employee Special Handling Detail - F77220	7	J3	TAXX	Tax Identification Number	String	Generic Edit	20	0
72	F77230	Employee Pension Maintenance - F77230	3	J8	TAXX	Tax Identification Number	String	Generic Edit	20	0
73	F77703	Payroll History Audit Report - Worktable	3	AR	TAXX	Tax Identification Number	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

73 columns | 920 | TAXX