	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

31 columns | 920 | PHRW

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F0609	Deduction/Benefit/Accrual Ledger File	15	Y$	PHRW	Hours Worked	Numeric	Generic Edit	9	2
2	F06106	Employee Pay Instructions	22	YM	PHRW	Hours Worked	Numeric	Generic Edit	9	2
3	F0618	Employee Transaction History	22	YT	PHRW	Hours Worked	Numeric	Generic Edit	9	2
4	F0619	Benefit/Accrual Detail File	15	Y$	PHRW	Hours Worked	Numeric	Generic Edit	9	2
5	F0625	Change Code History File	19	JB	PHRW	Hours Worked	Numeric	Generic Edit	9	2
6	F0709	Deduction/Benefit/Accrual Ledger File	18	Y$	PHRW	Hours Worked	Numeric	Generic Edit	9	2
TOP05T: Time Entry
7	F06116	Employee Transaction Detail File	22	YT	PHRW	Hours Worked	Numeric	Generic Edit	9	2
8	F06116Z1	Employee Transactions - Batch File	39	VL	PHRW	Hours Worked	Numeric	Generic Edit	9	2
9	F06116Z2	ESS Timecard History	39	VM	PHRW	Hours Worked	Numeric	Generic Edit	9	2
10	F0624	Burden Distribution File	15	J#	PHRW	Hours Worked	Numeric	Generic Edit	9	2
11	F06241	Burden Distribution File	15	J#	PHRW	Hours Worked	Numeric	Generic Edit	9	2
12	F06278	Retro Timecard Detail File	25	YT	PHRW	Hours Worked	Numeric	Generic Edit	9	2
13	F06290	Payroll Accounting Journal Work File	11	YR	PHRW	Hours Worked	Numeric	Generic Edit	9	2
14	F069136	Tip Disbursement	29	JE	PHRW	Hours Worked	Numeric	Generic Edit	9	2
15	F069151	Holiday Codes	4	JG	PHRW	Hours Worked	Numeric	Generic Edit	9	2
TOP07: Payroll
16	F06270	Retro Processing Parameter	11	JP	PHRW	Hours Worked	Numeric	Generic Edit	9	2
17	F06350I	WF - Paycheck (Interims)	20	Y4	PHRW	Hours Worked	Numeric	Generic Edit	9	2
18	F0701734	Prior Head Tax from a Previous Employer	7	Y3	PHRW	Hours Worked	Numeric	Generic Edit	9	2
19	F07172	ROE Max/Min	5	YD	PHRW	Hours Worked	Numeric	Generic Edit	9	2
20	F0719	DBA Transaction Detail History	18	Y$	PHRW	Hours Worked	Numeric	Generic Edit	9	2
21	F0724	Burden Distribution File	18	YS	PHRW	Hours Worked	Numeric	Generic Edit	9	2
22	F07241	Burden Distribution File	18	YS	PHRW	Hours Worked	Numeric	Generic Edit	9	2
23	F0728	Employee Paid Workers Compensation Transactions	8	YW	PHRW	Hours Worked	Numeric	Generic Edit	9	2
24	F07350	Payment File	25	Y0	PHRW	Hours Worked	Numeric	Generic Edit	9	2
25	F07355	Pre-Payroll Error File	12	Y5	PHRW	Hours Worked	Numeric	Generic Edit	9	2
26	F07UI200	Timecard History Work File	25	TH	PHRW	Hours Worked	Numeric	Generic Edit	9	2
TOP08AD: ADP Integration
27	F051371	ADP Employee DBA Instructions	27	AD	PHRW	Hours Worked	Numeric	Generic Edit	9	2
TOP17C: Call Management
28	F1760	Time Entry	14	ZB	PHRW	Hours Worked	Numeric	Generic Edit	9	2
TOP48S: Service Billing
29	F48S0618	Payroll Reclassification Workfile	22	YT	PHRW	Hours Worked	Numeric	Generic Edit	9	2
TOP75Z: New Zealand
30	F75Z0006	Leave Taken A.G.E. Work File	5	Z6	PHRW	Hours Worked	Numeric	Generic Edit	9	2
TOP77: Payroll (Canadian)
31	F06176	Unemployment Insurance History File	7	YS	PHRW	Hours Worked	Numeric	Generic Edit	9	2

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

31 columns | 920 | PHRW