	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

47 columns | 812 | DTEY

	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	4	J@	DTEY	Date - YR	Numeric	Generic Edit	2	0
2	F06145	Calendar Month DBA Summary History File	5	YH	DTEY	Date - YR	Numeric	Generic Edit	2	0
3	F0627	Workers Compensation Summary History	8	JH	DTEY	Date - YR	Numeric	Generic Edit	2	0
4	F06915	Holiday Table	1	JH	DTEY	Date - YR	Numeric	Generic Edit	2	0
5	F06920	Savings Bond General Constant	2	YQ	DTEY	Date - YR	Numeric	Generic Edit	2	0
TOP05T: Time Entry
6	F0623	Piecework History File	9	JL	DTEY	Date - YR	Numeric	Generic Edit	2	0
7	F069151	Holiday Codes	1	JG	DTEY	Date - YR	Numeric	Generic Edit	2	0
TOP06: Payroll (old) - Obsolete-do not reuse
8	F06146	Employee Transaction History Summary	5	YN	DTEY	Date - YR	Numeric	Generic Edit	2	0
9	F06210	Payroll Cycle Parameters	4	YD	DTEY	Date - YR	Numeric	Generic Edit	2	0
TOP07: Payroll
10	F06136	Tax History	9	YZ	DTEY	Date - YR	Numeric	Generic Edit	2	0
11	F06136A	Tax Summary (Additional)	5	YZ	DTEY	Date - YR	Numeric	Generic Edit	2	0
12	F06148	Tax Area Transaction History	4	Y@	DTEY	Date - YR	Numeric	Generic Edit	2	0
13	F06720	W-2/1099 Processing Control	2	JE	DTEY	Date - YR	Numeric	Generic Edit	2	0
14	F069066	Pay Cycle Constant	2	JD	DTEY	Date - YR	Numeric	Generic Edit	2	0
15	F0701734	Prior Head Tax from a Previous Employer	2	Y3	DTEY	Date - YR	Numeric	Generic Edit	2	0
16	F0701740	Quantum Control Tax	2	YQ	DTEY	Date - YR	Numeric	Generic Edit	2	0
17	F0701741	Canadian Deduction	2	YD	DTEY	Date - YR	Numeric	Generic Edit	2	0
18	F0705	DBA Period Control File	4	J@	DTEY	Date - YR	Numeric	Generic Edit	2	0
19	F07172	ROE Max/Min	1	YD	DTEY	Date - YR	Numeric	Generic Edit	2	0
20	F07210	Pay Cycle Parameters File	31	YD	DTEY	Date - YR	Numeric	Generic Edit	2	0
21	F077011	Tax History Integrity (Temp)	1	Y$	DTEY	Date - YR	Numeric	Generic Edit	2	0
22	F077021	Transaction History Integrity(Temp)	1	Y$	DTEY	Date - YR	Numeric	Generic Edit	2	0
23	F07800	Year-End Employee Table	2	JE	DTEY	Date - YR	Numeric	Generic Edit	2	0
24	F07810	Year-End Control Table	2	JE	DTEY	Date - YR	Numeric	Generic Edit	2	0
25	F07811	Negative Amount Workfile	2	JE	DTEY	Date - YR	Numeric	Generic Edit	2	0
26	F07815	Special Handling Codes Setup	2	YF	DTEY	Date - YR	Numeric	Generic Edit	2	0
27	F07821	Company Form Count Table	1	JG	DTEY	Date - YR	Numeric	Generic Edit	2	0
28	F07822	Company Federal Control Table	2	JI	DTEY	Date - YR	Numeric	Generic Edit	2	0
29	F07823	Year-End Report Table	2	YF	DTEY	Date - YR	Numeric	Generic Edit	2	0
30	F07824	Company State/Local Control Table	2	JD	DTEY	Date - YR	Numeric	Generic Edit	2	0
31	F07825	Company Special Handling Control Table	2	JA	DTEY	Date - YR	Numeric	Generic Edit	2	0
32	F07826	Additional Parameters	2	JB	DTEY	Date - YR	Numeric	Generic Edit	2	0
33	F07830	Employee Federal Control Table	2	Y0	DTEY	Date - YR	Numeric	Generic Edit	2	0
34	F07831	Employee State/Local Control Table	2	YB	DTEY	Date - YR	Numeric	Generic Edit	2	0
35	F07832	Employee Special Handling Control Table	2	YH	DTEY	Date - YR	Numeric	Generic Edit	2	0
36	F07835	W-2 Magnetic Media Workfile	2	JE	DTEY	Date - YR	Numeric	Generic Edit	2	0
37	F07836	1099 Magnetic Media Workfile	2	JE	DTEY	Date - YR	Numeric	Generic Edit	2	0
38	F078601	Table for storing W2 Mag Media Information	4	RF	DTEY	Date - YR	Numeric	Generic Edit	2	0
39	F078602	State Mag Media Table	4	RS	DTEY	Date - YR	Numeric	Generic Edit	2	0
40	F078603	1099 Mag Media	3	R9	DTEY	Date - YR	Numeric	Generic Edit	2	0
41	F07869	W-2 MMREF State Build	4	RM	DTEY	Date - YR	Numeric	Generic Edit	2	0
42	F07880	SUI Magnetic Media Workfile	4	YW	DTEY	Date - YR	Numeric	Generic Edit	2	0
TOP13: Plant/Equipment Management
43	F1303	Billing Exception Days	6	FJ	DTEY	Date - YR	Numeric	Generic Edit	2	0
TOP40: Inventory/OP Base
44	F49085	Scheduled Invoice Date	2	ID	DTEY	Date - YR	Numeric	Generic Edit	2	0
TOP75A: Australia - Reporting System Only
45	F75A0140	Australian Group Certificates	3	ZG	DTEY	Date - YR	Numeric	Generic Edit	2	0
TOP77: Payroll (Canadian)
46	F0713	Tax History	9	YZ	DTEY	Date - YR	Numeric	Generic Edit	2	0
47	F0713SAV	Backup Copy of F0713 For Tax Ledger Repost	9	YZ	DTEY	Date - YR	Numeric	Generic Edit	2	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

47 columns | 812 | DTEY