	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

55 columns | 920 | CKCN

	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	13	JI	CKCN	Check Control Number	Numeric	Generic Edit	8	0
2	F0609	Deduction/Benefit/Accrual Ledger File	2	Y$	CKCN	Check Control Number	Numeric	Generic Edit	8	0
3	F0618	Employee Transaction History	5	YT	CKCN	Check Control Number	Numeric	Generic Edit	8	0
4	F0619	Benefit/Accrual Detail File	2	Y$	CKCN	Check Control Number	Numeric	Generic Edit	8	0
5	F069160	Employee DBA Override Instructions Group Limits	2	Y9	CKCN	Check Control Number	Numeric	Generic Edit	8	0
6	F0709	Deduction/Benefit/Accrual Ledger File	2	Y$	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP05A: PeopleSoft HR & PR Foundation
7	F06345	Historical Payroll Register	3	JL	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP05T: Time Entry
8	F06116	Employee Transaction Detail File	5	YT	CKCN	Check Control Number	Numeric	Generic Edit	8	0
9	F06116Z1	Employee Transactions - Batch File	22	VL	CKCN	Check Control Number	Numeric	Generic Edit	8	0
10	F06116Z2	ESS Timecard History	22	VM	CKCN	Check Control Number	Numeric	Generic Edit	8	0
11	F06278	Retro Timecard Detail File	8	YT	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP07: Payroll
12	F06053	Interim Check Parameters File	13	YW	CKCN	Check Control Number	Numeric	Generic Edit	8	0
13	F06156	Pay Check History Summary	4	YU	CKCN	Check Control Number	Numeric	Generic Edit	8	0
14	F06166	Pay Check History Tax Ledger	3	YV	CKCN	Check Control Number	Numeric	Generic Edit	8	0
15	F06166A	Tax Ledger (Additional)	2	YV	CKCN	Check Control Number	Numeric	Generic Edit	8	0
16	F06166B	Tax Ledger (PA ACT 32)	2	YV	CKCN	Check Control Number	Numeric	Generic Edit	8	0
17	F06350I	WF - Paycheck (Interims)	5	Y4	CKCN	Check Control Number	Numeric	Generic Edit	8	0
18	F0701740	Quantum Control Tax	6	YQ	CKCN	Check Control Number	Numeric	Generic Edit	8	0
19	F0701741	Canadian Deduction	6	YD	CKCN	Check Control Number	Numeric	Generic Edit	8	0
20	F0705	DBA Period Control File	10	J@	CKCN	Check Control Number	Numeric	Generic Edit	8	0
21	F07149	Accrual Fiscal/Anniversary History Work File	20	Y8	CKCN	Check Control Number	Numeric	Generic Edit	8	0
22	F07186	Stub Information History Table	1	Y8	CKCN	Check Control Number	Numeric	Generic Edit	8	0
23	F071861	Stub Detail Piece Rate History File	1	Y8	CKCN	Check Control Number	Numeric	Generic Edit	8	0
24	F0719	DBA Transaction Detail History	2	Y$	CKCN	Check Control Number	Numeric	Generic Edit	8	0
25	F0728	Employee Paid Workers Compensation Transactions	4	YW	CKCN	Check Control Number	Numeric	Generic Edit	8	0
26	F0729	Employee DBA Override Instructions	2	Y9	CKCN	Check Control Number	Numeric	Generic Edit	8	0
27	F07350	Payment File	2	Y0	CKCN	Check Control Number	Numeric	Generic Edit	8	0
28	F07351	Payment Distribution File	1	Y1	CKCN	Check Control Number	Numeric	Generic Edit	8	0
29	F07351T	Payment Distribution File (Additional)	1	Y1	CKCN	Check Control Number	Numeric	Generic Edit	8	0
30	F07352	Stub Information File	1	Y2	CKCN	Check Control Number	Numeric	Generic Edit	8	0
31	F073521	Stub Detail Piece Rate File	1	Y2	CKCN	Check Control Number	Numeric	Generic Edit	8	0
32	F07353	Tax Detail File	2	Y3	CKCN	Check Control Number	Numeric	Generic Edit	8	0
33	F07355	Pre-Payroll Error File	26	Y5	CKCN	Check Control Number	Numeric	Generic Edit	8	0
34	F079430	Prevailing Wage Transaction Detail	4	PW	CKCN	Check Control Number	Numeric	Generic Edit	8	0
35	F079435	Prevailing Wage Fringe Detail	10	PF	CKCN	Check Control Number	Numeric	Generic Edit	8	0
36	F079440	Prevailing Wage Transaction History	4	PW	CKCN	Check Control Number	Numeric	Generic Edit	8	0
37	F079445	Prevailing Wage Fringe History	10	PH	CKCN	Check Control Number	Numeric	Generic Edit	8	0
38	F07UI200	Timecard History Work File	8	TH	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP08B: Benefits Administration
39	F08371	Reimbursement Spending Account Claims File	18	B6	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP08U: PeopleSoft HR US
40	F08360	Nondiscrimination Groups	24	HE	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP18: Timecard Automation
41	F186602	Labor Rules Tag File	19	TF	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP48S: Service Billing
42	F48S0618	Payroll Reclassification Workfile	5	YT	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP75A: Australia
43	F75A0005	Coinage Details Work File	2	A5	CKCN	Check Control Number	Numeric	Generic Edit	8	0
44	F75A0301	Superannuation Payment	5	SA	CKCN	Check Control Number	Numeric	Generic Edit	8	0
45	F75A0500	AU Bonus and Back Pay Tax Workfile	1	BP	CKCN	Check Control Number	Numeric	Generic Edit	8	0
46	F75A0501	AU Bonus and Back Pay Tax History	2	TH	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP75Z: New Zealand
47	F75Z0002	New Zealand Ledger Detail	2	Z2	CKCN	Check Control Number	Numeric	Generic Edit	8	0
48	F75Z0009	New Zealand Tax Detail Work File	2	TX	CKCN	Check Control Number	Numeric	Generic Edit	8	0
49	F75Z0010	New Zealand Tax Detail Tag Table	2	TD	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP77: Payroll (Canadian)
50	F06176	Unemployment Insurance History File	3	YS	CKCN	Check Control Number	Numeric	Generic Edit	8	0
51	F0716	Pay Check History Tax Ledger - Canadian DB	3	YV	CKCN	Check Control Number	Numeric	Generic Edit	8	0
52	F07183	Commission History Detail File	2	ZB	CKCN	Check Control Number	Numeric	Generic Edit	8	0
53	F77703	Payroll History Audit Report - Worktable	11	AR	CKCN	Check Control Number	Numeric	Generic Edit	8	0
TOP89: Conversion Programs
54	F07186T	Piece Rate History File	1	Y8	CKCN	Check Control Number	Numeric	Generic Edit	8	0
55	F07352T	Piece Rate Stub Detail Tag File	1	Y2	CKCN	Check Control Number	Numeric	Generic Edit	8	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

55 columns | 920 | CKCN