	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

27 columns | 910 | CAPID

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0049	Business Function Call Abstraction Register	14	CA	PID	Program ID	String	Generic Edit	10	0
TOP13C: Condition-Base Maintenance
2	F1310	Condition-Based Alerts	80	CA	PID	Program ID	String	Generic Edit	10	0
TOP15: Property Management
3	F15012B	Tenant E.P. Class Master	95	NS	CAPID	Cap Rule ID	String	Generic Edit	10	0
4	F1515	E.P. Cap Rules	1	CH	CAPID	Cap Rule ID	String	Generic Edit	10	0
5	F15151	Building E.P. Caps	1	CD	CAPID	Cap Rule ID	String	Generic Edit	10	0
6	F15152	Lease E.P. Caps	6	LC	CAPID	Cap Rule ID	String	Generic Edit	10	0
7	F151521	Lease E.P. Accounts Not Subject to Cap	4	LO	CAPID	Cap Rule ID	String	Generic Edit	10	0
8	F15153	Lease Cap History	5	LC	CAPID	Cap Rule ID	String	Generic Edit	10	0
9	F1530	Expense Participation Class Master	32	NG	CAPID	Cap Rule ID	String	Generic Edit	10	0
10	F15303	E.P. Class Expenses History	2	CH	CAPID	Cap Rule ID	String	Generic Edit	10	0
11	F1538B	EP Billing Register	120	NZ	CAPID	Cap Rule ID	String	Generic Edit	10	0
TOP15L: Adv Real Estate Forecasting
12	F15L38	AREF EP Billing Register	108	NZ	CAPID	Cap Rule ID	String	Generic Edit	10	0
TOP31B: Blend Management
13	F31B053	Consumable Assignments	21	CA	PID	Program ID	String	Generic Edit	10	0
14	F31B0760	EUR Conversion Assumptions	13	CA	PID	Program ID	String	Generic Edit	10	0
TOP40: Inventory/OP Base
15	F40241D	UNSPSC Code Alternate Description	6	CA	PID	Program ID	String	Generic Edit	10	0
16	F40333	Preference Profile - Carrier	33	CA	PID	Program ID	String	Generic Edit	10	0
TOP42: Sales Management
17	F42A011	Campaigns	40	CA	PID	Program ID	String	Generic Edit	10	0
TOP43C: Contracts
18	F43C05	Contract Action Dates	18	CA	PID	Program ID	String	Generic Edit	10	0
TOP48: Work Order Processing
19	F4808	Order Routing Approval Master	7	CA	PID	Program ID	String	Generic Edit	10	0
TOP58: Reserved for Clients
20	F74T100	Check Additional Table	11	CA	PID	Program ID	String	Generic Edit	10	0
TOP74R: CIS
21	F74R013	Cash Account Setup - RUS - 00	4	CA	PID	Program ID	String	Generic Edit	10	0
22	F74R9001	Correspondence Account Setup - RUS -09 - 74R	12	CA	PID	Program ID	String	Generic Edit	10	0
TOP75C: China - Reporting System Only
23	F75C007	China - Chart of Accounts Set Up	10	CA	PID	Program ID	String	Generic Edit	10	0
TOP80D: Plant Manager Dashboard
24	F80D253	AP Daily Counts and Amounts	8	CA	PID	Program ID	String	Generic Edit	10	0
TOP90CA: CRM Foundation
25	F90CA07A	Contact_Event Table	7	CA	PID	Program ID	String	Generic Edit	10	0
TOP90CG: CRM Case Management
26	F1755UR	F1755 - CRM User Reserved Tag File	33	CA	PID	Program ID	String	Generic Edit	10	0
27	F90CG503	Case Association Table	13	CA	PID	Program ID	String	Generic Edit	10	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

27 columns | 910 | CAPID