	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

29 columns | 920 | AOPT

	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	98	YM	AOPT	Plan Additional Option	String	Generic Edit	3	0
TOP08: Human Resources
2	F08320C	Plan Master Tag File	2	PX	AOPT	Plan Additional Option	String	Generic Edit	3	0
3	F08336B	Dep/Ben X-Reference Tag Table	4	E2	AOPT	Plan Additional Option	String	Generic Edit	3	0
4	F08338	Primary Care Physician Table	3	E7	AOPT	Plan Additional Option	String	Generic Edit	3	0
5	F08338B	Primary Care Physician Tag Table	3	PT	AOPT	Plan Additional Option	String	Generic Edit	3	0
6	F085500	Allowed Dependent Relations Per Plan	2	AD	AOPT	Plan Additional Option	String	Generic Edit	3	0
7	F085520	Available Plans and Plan Options by Employee History Table	8	PH	AOPT	Plan Additional Option	String	Generic Edit	3	0
8	F085520W	Available Plans and Plan Options by Employee Work Table	8	AP	AOPT	Plan Additional Option	String	Generic Edit	3	0
9	F085530W	Employee Current/Pending Elections Work Table	6	CP	AOPT	Plan Additional Option	String	Generic Edit	3	0
10	F085536	Dependent/Beneficiary X-Reference History Table	8	DH	AOPT	Plan Additional Option	String	Generic Edit	3	0
11	F085536W	Dependent/Beneficiary X-Reference Work Table	8	DB	AOPT	Plan Additional Option	String	Generic Edit	3	0
12	F085537W	Current Dep/Ben X-Reference Work Table	7	XB	AOPT	Plan Additional Option	String	Generic Edit	3	0
13	F085540	Benefits Enrollment Plan/Option URL Address	2	PU	AOPT	Plan Additional Option	String	Generic Edit	3	0
TOP08AD: ADP Integration
14	F051371	ADP Employee DBA Instructions	103	AD	AOPT	Plan Additional Option	String	Generic Edit	3	0
TOP08B: Benefits Administration
15	F083202	Plan Additional Options	2	B5	AOPT	Plan Additional Option	String	Generic Edit	3	0
16	F083202B	Plan Additional Option Tag Table	2	MD	AOPT	Plan Additional Option	String	Generic Edit	3	0
17	F083203	Plan Master Rates	2	BG	AOPT	Plan Additional Option	String	Generic Edit	3	0
18	F08320B	Plan/Plan Option Tag Table	2	PP	AOPT	Plan Additional Option	String	Generic Edit	3	0
19	F08320D	Plan Master Tag Table	2	PD	AOPT	Plan Additional Option	String	Generic Edit	3	0
20	F08320WF	Available Plans and Plan Options by Employee Work Table	7	BV	AOPT	Plan Additional Option	String	Generic Edit	3	0
21	F08330	Employee Enrollment	10	BG	AOPT	Plan Additional Option	String	Generic Edit	3	0
22	F08330B	Employee Enrollment Tag File	3	BT	AOPT	Plan Additional Option	String	Generic Edit	3	0
23	F08330C	Employee Enrollment Tag Table C	3	PC	AOPT	Plan Additional Option	String	Generic Edit	3	0
24	F08330WF	Employee Current/Pending Elections Work Table	6	BR	AOPT	Plan Additional Option	String	Generic Edit	3	0
25	F08336	Dep/Ben to Employee Plan X-Reference	3	BJ	AOPT	Plan Additional Option	String	Generic Edit	3	0
26	F08336WF	Dependent/Beneficiary X-Ref Work Table	8	BD	AOPT	Plan Additional Option	String	Generic Edit	3	0
27	F08381WF	Recalculate Plan Option Costs	5	RC	AOPT	Plan Additional Option	String	Generic Edit	3	0
28	F085574	Maximum Insurance Coverage Increase Amounts	5	MI	AOPT	Plan Additional Option	String	Generic Edit	3	0
TOP08U: PeopleSoft HR US
29	F08920	COBRA Coverage	6	JS	AOPT	Plan Additional Option	String	Generic Edit	3	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

29 columns | 920 | AOPT