	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

49 columns | 920 | PLAN

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F06106	Employee Pay Instructions	97	YM	PLAN	Plan ID	String	Generic Edit	8	0
TOP08: Human Resources
2	F08320C	Plan Master Tag File	1	PX	PLAN	Plan ID	String	Generic Edit	8	0
3	F08336B	Dep/Ben X-Reference Tag Table	3	E2	PLAN	Plan ID	String	Generic Edit	8	0
4	F08338	Primary Care Physician Table	2	E7	PLAN	Plan ID	String	Generic Edit	8	0
5	F08338B	Primary Care Physician Tag Table	2	PT	PLAN	Plan ID	String	Generic Edit	8	0
6	F085500	Allowed Dependent Relations Per Plan	1	AD	PLAN	Plan ID	String	Generic Edit	8	0
7	F085520	Available Plans and Plan Options by Employee History Table	6	PH	PLAN	Plan ID	String	Generic Edit	8	0
8	F085520W	Available Plans and Plan Options by Employee Work Table	6	AP	PLAN	Plan ID	String	Generic Edit	8	0
9	F085530W	Employee Current/Pending Elections Work Table	5	CP	PLAN	Plan ID	String	Generic Edit	8	0
10	F085536	Dependent/Beneficiary X-Reference History Table	7	DH	PLAN	Plan ID	String	Generic Edit	8	0
11	F085536W	Dependent/Beneficiary X-Reference Work Table	7	DB	PLAN	Plan ID	String	Generic Edit	8	0
12	F085537W	Current Dep/Ben X-Reference Work Table	6	XB	PLAN	Plan ID	String	Generic Edit	8	0
13	F085540	Benefits Enrollment Plan/Option URL Address	1	PU	PLAN	Plan ID	String	Generic Edit	8	0
TOP08AD: ADP Integration
14	F051371	ADP Employee DBA Instructions	102	AD	PLAN	Plan ID	String	Generic Edit	8	0
TOP08B: Benefits Administration
15	F08320	Benefits Plan Master	1	BA	PLAN	Plan ID	String	Generic Edit	8	0
16	F083201	Plan Master Text	1	B1	PLAN	Plan ID	String	Generic Edit	8	0
17	F083202	Plan Additional Options	1	B5	PLAN	Plan ID	String	Generic Edit	8	0
18	F083202B	Plan Additional Option Tag Table	1	MD	PLAN	Plan ID	String	Generic Edit	8	0
19	F083203	Plan Master Rates	1	BG	PLAN	Plan ID	String	Generic Edit	8	0
20	F08320B	Plan/Plan Option Tag Table	1	PP	PLAN	Plan ID	String	Generic Edit	8	0
21	F08320D	Plan Master Tag Table	1	PD	PLAN	Plan ID	String	Generic Edit	8	0
22	F08320WF	Available Plans and Plan Options by Employee Work Table	6	BV	PLAN	Plan ID	String	Generic Edit	8	0
23	F08320X	Plan Name Conversion	1	PX	PLAN	Plan ID	String	Generic Edit	8	0
24	F08330	Employee Enrollment	2	BG	PLAN	Plan ID	String	Generic Edit	8	0
25	F08330B	Employee Enrollment Tag File	2	BT	PLAN	Plan ID	String	Generic Edit	8	0
26	F08330C	Employee Enrollment Tag Table C	2	PC	PLAN	Plan ID	String	Generic Edit	8	0
27	F08330WF	Employee Current/Pending Elections Work Table	5	BR	PLAN	Plan ID	String	Generic Edit	8	0
28	F08336	Dep/Ben to Employee Plan X-Reference	2	BJ	PLAN	Plan ID	String	Generic Edit	8	0
29	F08336WF	Dependent/Beneficiary X-Ref Work Table	7	BD	PLAN	Plan ID	String	Generic Edit	8	0
30	F08345	401(k) Elections Setup	1	B3	PLAN	Plan ID	String	Generic Edit	8	0
31	F08346	401(K) Elections	2	B4	PLAN	Plan ID	String	Generic Edit	8	0
32	F08351	Plans within Benefit Categories	3	BU	PLAN	Plan ID	String	Generic Edit	8	0
33	F08351B	Plans within Categories Tag Table	4	PC	PLAN	Plan ID	String	Generic Edit	8	0
34	F08370	Reimbursement Spending Acct - Balance File	3	B7	PLAN	Plan ID	String	Generic Edit	8	0
35	F08371	Reimbursement Spending Account Claims File	3	B6	PLAN	Plan ID	String	Generic Edit	8	0
36	F08372	FSA - Pay Instruction File	2	BM	PLAN	Plan ID	String	Generic Edit	8	0
37	F08380WF	Batch Enrollment Work File	5	BE	PLAN	Plan ID	String	Generic Edit	8	0
38	F08381WF	Recalculate Plan Option Costs	4	RC	PLAN	Plan ID	String	Generic Edit	8	0
39	F08392	Batch Enrollment Parameters	1	BF	PLAN	Plan ID	String	Generic Edit	8	0
40	F08501	Employee Pension Activity Master	2	HH	PLAN	Plan ID	String	Generic Edit	8	0
41	F08502	Pension Plan Activity Balance	2	HI	PLAN	Plan ID	String	Generic Edit	8	0
42	F08511	Employee Pension Activity Detail	2	HJ	PLAN	Plan ID	String	Generic Edit	8	0
43	F085201	Pension Plan Calculation Rules	1	HK	PLAN	Plan ID	String	Generic Edit	8	0
44	F085574	Maximum Insurance Coverage Increase Amounts	4	MI	PLAN	Plan ID	String	Generic Edit	8	0
TOP08U: PeopleSoft HR US
45	F08361	Plan Control Group - NDT	1	NA	PLAN	Plan ID	String	Generic Edit	8	0
46	F08362	NDT - Tests Associated with Plan	1	NB	PLAN	Plan ID	String	Generic Edit	8	0
47	F083675	NDT - Prior Year Testing Method Selection Criteria	4	PF	PLAN	Plan ID	String	Generic Edit	8	0
48	F08369	Plan Control Group Test History	1	NC	PLAN	Plan ID	String	Generic Edit	8	0
49	F08920	COBRA Coverage	5	JS	PLAN	Plan ID	String	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

49 columns | 920 | PLAN