	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

22 columns | 920 | RTAM

	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	10	JI	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
2	F0609	Deduction/Benefit/Accrual Ledger File	10	Y$	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
3	F06106	Employee Pay Instructions	33	YM	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
4	F0619	Benefit/Accrual Detail File	10	Y$	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
5	F069106	Union Benefits Master	15	Y1	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
6	F069116	Payroll Transaction Constants	17	YC	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
7	F06931	Wage Attachment File	9	J3	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
8	F06936	Retro Pay Types Rate	11	JA	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
9	F0709	Deduction/Benefit/Accrual Ledger File	12	Y$	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
TOP07: Payroll
10	F06136B	Tax Summary (PA ACT 32)	11	YZ	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
11	F06166B	Tax Ledger (PA ACT 32)	17	YV	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
12	F063106	Deduction/Benefit Work File	20	Y7	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
13	F069171	Payroll Payment/ Reporting Terms	20	YP	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
14	F0705	DBA Period Control File	11	J@	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
15	F071072	Employee Level Multi Child Support Overrides	2	JX	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
16	F071073	Employee Level Multi Wage Attachment Rules	4	J3	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
17	F0719	DBA Transaction Detail History	12	Y$	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
18	F0729	Employee DBA Override Instructions	21	Y9	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
19	F07353	Tax Detail File	20	Y3	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
TOP08AD: ADP Integration
20	F051371	ADP Employee DBA Instructions	38	AD	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
21	F051375	ADP Payroll DBA Transaction Constants	19	AD	RTAM	Amount or Rate	Numeric	Generic Edit	9	4
TOP08B: Benefits Administration
22	F083203	Plan Master Rates	7	BG	RTAM	Amount or Rate	Numeric	Generic Edit	9	4

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

22 columns | 920 | RTAM