	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

16 columns | 920 | CUAN8

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP04: Accounts Payable
1	F046141	T5018 Tax Workfile	3	CU	AN8	Address Number	Numeric	Generic Edit	8	0
TOP05: Time Accounting and HRM Base
2	F05100Z1	Resource Competencies Unedited Transactions File	9	CU	AN8	Address Number	Numeric	Generic Edit	8	0
3	F05107	Competency Update Approval Routing	4	CU	AN8	Address Number	Numeric	Generic Edit	8	0
TOP40: Inventory/OP Base
4	F40071	Customer Preference Groups	1	CU	AN8	Address Number	Numeric	Generic Edit	8	0
TOP90CA: CRM Foundation
5	F90CA080	Customer Table	1	UU	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
6	F90CA086	Flat Customer Related Address Table	1	CR	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
7	F90CA08A	Customer_Employee Table	1	UA	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
8	F90CA08C	Customer_Partner Table	1	UC	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
9	F90CA08E	Customer_Profile Table	3	UE	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
TOP90CB: CRM Sales Force Automation
10	F90CB020	Opportunity Table	8	OT	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
11	F90CB02E	Opportunity_Employee Table	39	OE	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
12	F90CB02I	Opportunity_Item Table	3	OI	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
13	F90CB05C	Sales_Cycle_Notification_Ledger Table	8	NL	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
14	F90CB06B	Opportunity_For_Forecast Table	9	OF	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
15	F90CB06C	Opportunity_Item_For_Forecast Table	4	OH	CUAN8	Customer Address Number	Numeric	Generic Edit	8	0
16	F90CB06Z	Opportunity for Forecast WTF	10	ZF	CUAN8	Customer Address Number	Numeric	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

16 columns | 920 | CUAN8