	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

20 columns | 920 | DIVC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F05430	ESS User Defined Text	2	UT	DIVC	Benefit Group	String	Generic Edit	6	0
TOP05A: PeopleSoft HR & PR Foundation
2	F060116	Employee Master Information	147	YA	DIVC	Benefit Group	String	Generic Edit	6	0
3	F0601161	Point-In-Time Employee Master	149	PT	DIVC	Benefit Group	String	Generic Edit	6	0
4	F060116W	EE Master Request File	147	YA	DIVC	Benefit Group	String	Generic Edit	6	0
5	F060116Z	Unedited Quick Hire Transaction File	67	SZ	DIVC	Benefit Group	String	Generic Edit	6	0
TOP08: Human Resources
6	F081161	ACA Employee Eligibility	29	AD	DIVC	Benefit Group	String	Generic Edit	6	0
7	F0811619	ACA Employee Eligibility Archive	29	AD	DIVC	Benefit Group	String	Generic Edit	6	0
8	F08350C	Categories by Benefit Group Tag File	1	BX	DIVC	Benefit Group	String	Generic Edit	6	0
9	F085540	Benefits Enrollment Plan/Option URL Address	4	PU	DIVC	Benefit Group	String	Generic Edit	6	0
TOP08B: Benefits Administration
10	F08350	Categories within Benefit Groups	1	BK	DIVC	Benefit Group	String	Generic Edit	6	0
11	F08350B	Benefit Categories by Benefit Group Tag Table	1	I8	DIVC	Benefit Group	String	Generic Edit	6	0
12	F08351	Plans within Benefit Categories	1	BU	DIVC	Benefit Group	String	Generic Edit	6	0
13	F08351B	Plans within Categories Tag Table	1	PC	DIVC	Benefit Group	String	Generic Edit	6	0
14	F08380WF	Batch Enrollment Work File	11	BE	DIVC	Benefit Group	String	Generic Edit	6	0
15	F08500	Enrollment Event Setup	1	ES	DIVC	Benefit Group	String	Generic Edit	6	0
16	F085574	Maximum Insurance Coverage Increase Amounts	2	MI	DIVC	Benefit Group	String	Generic Edit	6	0
TOP08P: Position Control
17	F08001	Job information	12	JM	DIVC	Benefit Group	String	Generic Edit	6	0
18	F08005	Business Unit/ Job Id. X-Ref	4	JV	DIVC	Benefit Group	String	Generic Edit	6	0
TOP08U: PeopleSoft HR US
19	F08910	COBRA Qualified Beneficiary File	35	J1	DIVC	Benefit Group	String	Generic Edit	6	0
TOP08W: Wage and Salary
20	F08830WF	Compensation Root Work Table	75	YN	DIVC	Benefit Group	String	Generic Edit	6	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

20 columns | 920 | DIVC