	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

169 tables920 | 07

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F05290	JR	70	2	WF - Payroll Journal (Detail)	Extra Features Files	07: Payroll	Business Data
2	920	F055011W	AD	69	8	Auto Deposit Instructions Work File	Files	07: Payroll
3	920	F06053	YW	36	2	Interim Check Parameters File	Master Files	07: Payroll	Business Data
4	920	F06136	YZ	74	13	Tax History	History Files	07: Payroll	Business Data
5	920	F06136A	YZ	68	1	Tax Summary (Additional)	Files	07: Payroll
6	920	F06136B	YZ	74	1	Tax Summary (PA ACT 32)	Files	07: Payroll
7	920	F06147	YD	17	3	Fiscal and Anniversary Year History	History Files	07: Payroll	Business Data
8	920	F06148	Y@	13	6	Tax Area Transaction History	History Files	07: Payroll
9	920	F06156	YU	45	11	Pay Check History Summary	History Files	07: Payroll	Business Data
10	920	F06166	YV	19	7	Pay Check History Tax Ledger	History Files	07: Payroll	Business Data
11	920	F06166A	YV	27	1	Tax Ledger (Additional)	Files	07: Payroll
12	920	F06166B	YV	31	1	Tax Ledger (PA ACT 32)	Files	07: Payroll
13	920	F06209	Y@	64	1	Execution Control Parameters	Constants Files	07: Payroll	Business Data
14	920	F06270	JP	83	1	Retro Processing Parameter	Extra Features Files	07: Payroll	Business Data
15	920	F06271	JQ	4	1	Retro Processing Selection	Extra Features Files	07: Payroll	Business Data
16	920	F063106	Y7	29	2	Deduction/Benefit Work File	Work Files	07: Payroll	Business Data
17	920	F06350I	Y4	53	2	WF - Paycheck (Interims)	Regular Work Files	07: Payroll	Business Data
18	920	F06490	JR	23	3	Payroll/Accounts Payable Ledger Detail	Extra Features Files	07: Payroll	Business Data
19	920	F06491	J6	20	1	Payroll/Accounts Payable Ledger Detail	Extra Features Files	07: Payroll	Business Data
20	920	F06492	JC	10	2	Payroll - Accounts Payable Control	Extra Features Files	07: Payroll	Business Data
21	920	F065016	YG	28	1	Automatic Bank Deposit Master	Master Files	07: Payroll	Business Data
22	920	F065016T	YG	24	1	Automatic Bank Deposit Master (Additional)	Files	07: Payroll
23	920	F06560	Y8	6	1	Bank Reconciliation - Issue File	Batch Input Files	07: Payroll	Business Data
24	920	F06561	Y9	6	1	Bank Reconciliation - Paid File	Batch Input Files	07: Payroll	Business Data
25	920	F06720	JE	220	1	W-2/1099 Processing Control	Extra Features Files	07: Payroll	Business Data
26	920	F068500	YZ	12	1	941 - Federal Tax History	Extra Features Files	07: Payroll	Business Data
27	920	F06900	Y$	15	1	Payroll Fiscal Patterns	Constants Files	07: Payroll	Business Data
28	920	F069025	TR	4	1	Calculation Table Rules	Files	07: Payroll
29	920	F069026	Y2	23	3	Payroll Generic Tables	Constants Files	07: Payroll	Business Data
30	920	F0690361	RO	9	1	Employee Rollover Table Overrides	Files	07: Payroll
31	920	F069066	JD	24	7	Pay Cycle Constant	Constants Files	07: Payroll	Business Data
32	920	F069076	YF	7	2	Insured Pay Code	Constants Files	07: Payroll	Business Data
33	920	F069171	YP	24	1	Payroll Payment/ Reporting Terms	Constants Files	07: Payroll	Business Data
34	920	F0701730	VS	9	2	Populate Vertex Filing Status	Files	07: Payroll
35	920	F0701731	YC	13	1	Compensation Overrides	Files	07: Payroll
36	920	F0701732	AO	26	1	Additional Tax Overrides	Files	07: Payroll
37	920	F0701733	YC	29	1	Additional Calc Methods	Files	07: Payroll
38	920	F0701734	Y3	21	1	Prior Head Tax from a Previous Employer	Files	07: Payroll
39	920	F0701735	YC	16	1	Pretax Deduction Overrides	Files	07: Payroll
40	920	F0701740	YQ	16	2	Quantum Control Tax	Files	07: Payroll
41	920	F0701741	YD	16	2	Canadian Deduction	Files	07: Payroll
42	920	F0705	J@	16	3	DBA Period Control File	Transaction Files	07: Payroll	Business Data
43	920	F07100	F7	17	2	CCQ WORKFILE	Work Files	07: Payroll	Business Data
44	920	F07107	JW	61	2	Employee Wage Attachment Rules	Master Files	07: Payroll	Business Data
45	920	F071072	JX	9	1	Employee Level Multi Child Support Overrides	Constants Files	07: Payroll	Business Data
46	920	F071073	J3	12	1	Employee Level Multi Wage Attachment Rules	Files	07: Payroll
47	920	F071074	WE	14	1	Wage Attachment Exemption Rules	Files	07: Payroll
48	920	F071075	JW	23	2	Wage Attachment Child Support EFT Detail	Files	07: Payroll
49	920	F07149	Y8	20	3	Accrual Fiscal/Anniversary History Work File	Files	07: Payroll	Business Data
50	920	F0716701	EA	97	1	Employee Assignment T/E Template Information	Files	07: Payroll	Business Data
51	920	F0716702	EA	21	2	Employee Assignment Rates	Files	07: Payroll	Business Data
52	920	F0716703	EA	14	2	Employee Assignment Job Description	Files	07: Payroll	Business Data
53	920	F0716704	EA	7	1	Employee Assignment Default Pay Type	Files	07: Payroll	Business Data
54	920	F0716709	EA	97	1	Employee Assignment T/E Template Info History	Files	07: Payroll	Business Data
55	920	F0717	JF	53	8	ROE Summary History	History Files	07: Payroll	Business Data
56	920	F07171	JP	4	2	ROE Summary History Comments	History Files	07: Payroll	Business Data
57	920	F07172	YD	5	1	ROE Max/Min	Constants Files	07: Payroll	Business Data
58	920	F07186	Y8	22	1	Stub Information History Table	Work Files	07: Payroll	Business Data
59	920	F071861	Y8	20	1	Stub Detail Piece Rate History File	Files	07: Payroll	Business Data
60	920	F0719	Y$	59	2	DBA Transaction Detail History	History Files	07: Payroll	Business Data
61	920	F07209	Y@	41	1	Execution Control Parameters	Constants Files	07: Payroll	Business Data
62	920	F07210	YD	99	3	Pay Cycle Parameters File	Work Files	07: Payroll	Business Data
63	920	F07212	Y2	8	1	Paystub Retro Pay State Setup	Files	07: Payroll
64	920	F07235	Y6	7	2	Auto Deposit Bank Workfile	Files	07: Payroll	Business Data
65	920	F07236	Y6	14	1	Auto Deposit Tape File Setup	Files	07: Payroll	Business Data
66	920	F07236T	Y6	23	1	Auto Deposit Tape File Setup (Additional)	Files	07: Payroll
67	920	F0724	YS	24	1	Burden Distribution File	History Files	07: Payroll	Business Data
68	920	F07241	YS	24	2	Burden Distribution File	History Files	07: Payroll	Business Data
69	920	F0728	YW	13	2	Employee Paid Workers Compensation Transactions	Files	07: Payroll
70	920	F0729	Y9	93	2	Employee DBA Override Instructions	Files	07: Payroll	Business Data
71	920	F07350	Y0	52	5	Payment File	Work Files	07: Payroll	Business Data
72	920	F07351	Y1	27	2	Payment Distribution File	Work Files	07: Payroll	Business Data
73	920	F07351T	Y1	24	1	Payment Distribution File (Additional)	Files	07: Payroll
74	920	F07352	Y2	22	1	Stub Information File	Work Files	07: Payroll	Business Data
75	920	F073521	Y2	20	1	Stub Detail Piece Rate File	Files	07: Payroll	Business Data
76	920	F07353	Y3	32	3	Tax Detail File	Work Files	07: Payroll	Business Data
77	920	F07354	Y4	10	1	Report Setup File	Constants Files	07: Payroll	Business Data
78	920	F07355	Y5	36	2	Pre-Payroll Error File	Work Files	07: Payroll	Business Data
79	920	F07390	RO	14	1	Year-End Rollover Workfile	Files	07: Payroll
80	920	F073911	Y8	17	1	Leave Rollover Balance Report Work File	Work Files	07: Payroll	Business Data
81	920	F07400	NH	8	1	New Hire Detail File - Common Format	Work Files	07S: Payroll SUI	Business Data
82	920	F074001	NH	115	1	New Hire Reporting Workfile - OneWorld Only	Work Files	07S: Payroll SUI	Business Data
83	920	F074001R	NH	15	1	New Hire Report Setup - OneWorld Only	Constants Files	07S: Payroll SUI	Business Data
84	920	F074001W	NH	15	1	SUI/New Hire Client loader for F074001R	Install Files	07S: Payroll SUI	Business Data
85	920	F07415	NH	8	1	New Hire Detail File - Indiana	Work Files	07: Payroll	Business Data
86	920	F07436	NH	8	1	New Hire Detail File - Ohio	Master Files	07S: Payroll SUI	Business Data
87	920	F07439	NH	8	1	New Hire Detail File - Pennsylvania	Master Files	07S: Payroll SUI	Business Data
88	920	F07440	NH	8	1	New Hire Detail File - Rhode Island	Work Files	07: Payroll	Business Data
89	920	F07490	JR	24	4	Payroll - Accounts Payable Detail (One World)	Extra Features Files	07: Payroll	Business Data
90	920	F07491	J6	23	2	Payroll - Accounts Payable Summary File	Extra Features Files	07: Payroll	Business Data
91	920	F07492	JC	11	3	Payroll - Accounts Payable Control File	Extra Features Files	07: Payroll	Business Data
92	920	F07500	GC	9	1	Geocoder Report Setup	Files	07: Payroll	Business Data
93	920	F075611	Y9	1	1	Bank File of Cleared Checks - Flat File OneWorld Only	Work Files	07: Payroll	Business Data
94	920	F07600	LC	21	1	Leave Administration Control	Files	07: Payroll	Business Data
95	920	F07601	LS	15	3	Leave Type Setup	Files	07: Payroll	Business Data
96	920	F07602	LR	15	1	Leave Verification Rules	Files	07: Payroll
97	920	F07603	FV	28	1	FMLA Leave Substitution Rules	Files	07: Payroll
98	920	F07620	LV	25	5	Leave Transactions	Files	07: Payroll	Business Data
99	920	F07621	L1	26	1	Employee Medical Leave Information	Files	07: Payroll	Business Data
100	920	F07622	L2	15	1	Employee Leave - Medical Opinions	Files	07: Payroll	Business Data
101	920	F07623	L3	21	1	Employee FMLA Request Header	Files	07: Payroll	Business Data
102	920	F07624	L4	25	1	Employee Medical Leave Change Information	Files	07: Payroll	Business Data
103	920	F07630	LM	11	1	Leave Messaging and Audit	Files	07: Payroll
104	920	F077011	Y$	12	1	Tax History Integrity (Temp)	Regular Work Files	07: Payroll	Business Data
105	920	F077011A	Y$	14	1	Tax History Integrity Additional (Temp)	Regular Work Files	07: Payroll	Business Data
106	920	F077011B	Y3	15	1	Tax Integrity (PA Act32)	Files	07: Payroll
107	920	F077021	Y$	15	1	Transaction History Integrity(Temp)	Regular Work Files	07: Payroll	Business Data
108	920	F07727	J7	28	3	Canadian Pension Information	History Files	07: Payroll	Business Data
109	920	F07800	JE	9	2	Year-End Employee Table	Extra Features Files	07Y: US Payroll Year End
110	920	F07810	JE	52	1	Year-End Control Table	Extra Features Files	07Y: US Payroll Year End
111	920	F07811	JE	12	1	Negative Amount Workfile	Extra Features Files	07Y: US Payroll Year End
112	920	F07815	YF	9	1	Special Handling Codes Setup	Extra Features Files	07Y: US Payroll Year End
113	920	F07821	JG	16	3	Company Form Count Table	Extra Features Files	07Y: US Payroll Year End	Business Data
114	920	F07822	JI	51	2	Company Federal Control Table	Extra Features Files	07Y: US Payroll Year End
115	920	F07823	YF	14	2	Year-End Report Table	Extra Features Files	07Y: US Payroll Year End
116	920	F07824	JD	25	3	Company State/Local Control Table	Extra Features Files	07Y: US Payroll Year End
117	920	F07825	JA	49	3	Company Special Handling Control Table	Extra Features Files	07Y: US Payroll Year End
118	920	F07826	JB	9	2	Additional Parameters	Extra Features Files	07Y: US Payroll Year End
119	920	F07830	Y0	90	11	Employee Federal Control Table	Extra Features Files	07Y: US Payroll Year End	Business Data
120	920	F078303	YF	8	1	Arizona SUI magnetic media table (03)	Regular Work Files	07S: Payroll SUI	Business Data
121	920	F078305	YW	8	1	California SUI Magnetic Media Table (05)	Work Files	07S: Payroll SUI	Business Data
122	920	F078306	YF	8	1	Colorado SUI magnetic media table (06)	Regular Work Files	07S: Payroll SUI	Business Data
123	920	F07831	YB	53	14	Employee State/Local Control Table	Extra Features Files	07Y: US Payroll Year End	Business Data
124	920	F078310	YF	8	1	Florida SUI magnetic media table (10)	Regular Work Files	07S: Payroll SUI	Business Data
125	920	F078311	YF	8	1	Georgia SUI magnetic media table (11)	Regular Work Files	07S: Payroll SUI	Business Data
126	920	F078312	YF	8	1	Hawaii SUI magnetic media table (12)	Extra Features Files	07S: Payroll SUI	Business Data
127	920	F07832	YH	66	11	Employee Special Handling Control Table	Extra Features Files	07Y: US Payroll Year End	Business Data
128	920	F078329	YF	8	1	Nevada SUI Magnetic Media Table (29)	Regular Work Files	07S: Payroll SUI	Business Data
129	920	F078344	YW	8	1	Texas SUI Magnetic Media Table(44)	Work Files	07S: Payroll SUI	Business Data
130	920	F078345	YF	8	1	Utah SUI magnetic media table (45)	Regular Work Files	07S: Payroll SUI	Business Data
131	920	F078348	YW	8	1	Washington SUI Magnetic Media Table (48)	Work Files	07S: Payroll SUI	Business Data
132	920	F07835	JE	4	1	W-2 Magnetic Media Workfile	Extra Features Files	07Y: US Payroll Year End
133	920	F07836	JE	4	1	1099 Magnetic Media Workfile	Extra Features Files	07Y: US Payroll Year End
134	920	F07845	FZ	15	1	Fund Master	Files	07: Payroll
135	920	F07850	FG	16	1	Group Fund Setup	Files	07: Payroll
136	920	F078504	VA	26	1	Vertex Geo Code to ADP Code	Files	07: Payroll	Business Data
137	920	F078505	YA	2	1	ADP PDBA Quarterly Table Setup	Files	07: Payroll	Business Data
138	920	F078506	YJ	2	1	ADP Company Code to JDE Company Code	Files	07: Payroll	Business Data
139	920	F078507	YE	21	1	ADP Employee Additional Information	Files	07: Payroll	Business Data
140	920	F078510	VR	134	2	ADP Quarterly Integrity Report	Files	07: Payroll
141	920	F07855	AF	30	1	Employee Fund Allocation	Files	07: Payroll
142	920	F07860	ST	7	1	Superannuation Date Tracking	Files	07: Payroll
143	920	F078601	RF	4	1	Table for storing W2 Mag Media Information	Extra Features Files	07Y: US Payroll Year End
144	920	F078602	RS	5	1	State Mag Media Table	Extra Features Files	07Y: US Payroll Year End
145	920	F078603	R9	4	1	1099 Mag Media	Transaction Files	07Y: US Payroll Year End
146	920	F078651	RM	4	1	W2 EFW2 Electronic Filing Build	Extra Features Files	07Y: US Payroll Year End
147	920	F078652	RF	4	1	W-2C EFW2C Electronic Filing Build	Extra Features Files	07Y: US Payroll Year End
148	920	F07869	RM	4	1	W-2 EFW2 Electronic Filing State Build	Extra Features Files	07Y: US Payroll Year End
149	920	F07880	YW	91	2	SUI Magnetic Media Workfile	Work Files	07S: Payroll SUI	Business Data
150	920	F07881	YF	8	1	SUI Magnetic Media Flat File - Generic	Work Files	07S: Payroll SUI	Business Data
151	920	F07885	YW	28	3	SUI Payments for Quarterly Reporting	Work Files	07S: Payroll SUI
152	920	F07900	NC	20	1	Non Calendar Tax Fiscal Date Patterns	Constants Files	07: Payroll	Business Data
153	920	F07901	Y5	49	2	Pre-Payroll DBA Calculation Control Table	Constants Files	07: Payroll	Business Data
154	920	F079320	WX	35	1	Wage Attachment Exemptions by Pay Frequency	Files	07: Payroll
155	920	F07940	YY	13	1	Set Vertex Tax Table	Constants Files	07: Payroll	Business Data
156	920	F079420	PD	22	1	Prevailing Wage DBAs	Files	07: Payroll
157	920	F079425	PR	24	1	Prevailing Wage DBA Range	Files	07: Payroll
158	920	F079430	PW	40	2	Prevailing Wage Transaction Detail	Files	07: Payroll
159	920	F079435	PF	28	2	Prevailing Wage Fringe Detail	Files	07: Payroll
160	920	F079440	PW	39	2	Prevailing Wage Transaction History	Files	07: Payroll
161	920	F079445	PH	27	2	Prevailing Wage Fringe History	Files	07: Payroll
162	920	F07991	YX	11	1	Deduction, Benefit, Accrual History Conversion Data	Batch Input Files	07: Payroll	Business Data
163	920	F07992	YQ	11	1	Payroll Tax History Conversion Data	Batch Input Files	07: Payroll	Business Data
164	920	F07UI200	TH	101	6	Timecard History Work File	Work Files	07: Payroll	Business Data
165	920	F186206	LG	3	2	Leave Group List	Files	07: Payroll
166	920	F8907422	MA	18	1	New Hire Detail File - Massachusetts (22)	Master Files	07S: Payroll SUI	Business Data
167	920	F8907427	MT	56	1	New Hire Detail File - Montana (27)	Master Files	07S: Payroll SUI	Business Data
168	920	F8907428	NE	18	1	New Hire Detail File - Nebraska(28)	Master Files	07S: Payroll SUI	Business Data
169	920	F8907444	TX	45	1	New Hire Detail File Transfer - Texas (44)	Master Files	07S: Payroll SUI	Business Data

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

169 tables920 | 07