	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	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

15 columns | 812 | CUAN8

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

JDE TABLES