	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

33 columns | 812 | PRAN8

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP01: Address Book
1	F01501	Enhanced Parent Child	3	PR	AN8	Address Number	Numeric	UDC	8	0
TOP17C: Call Management
2	F1755	Customer Call Master	208	ZA	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
TOP40: Inventory/OP Base
3	F4201Z1	Sales Order Header Unedited Transaction File	138	SY	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
TOP42: Sales Management
4	F4201	Sales Order Header File	126	SH	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
5	F42019	Sales Order Header History File	126	SH	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
6	F4211	Sales Order Detail File	247	SD	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
7	F42119	Sales Order History File	247	SD	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
8	F42199	S.O. Detail Ledger File	246	SL	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
9	F42UI01	SO Header Cache File (MBF)	165	ZH	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
10	F42UI11	SO Detail Cache File (MBF)	178	ZD	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
TOP42B: Sales Order Entry
11	F4211CZ1	Sales Order Detail Unedited Transaction File - CRM	14	CZ	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
12	F42420	Audit Log Transaction	107	AL	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
13	F47012T	EDI Purchase Order Detail Tag - Inbound	64	UZ	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
14	F47132T	EDI Purchase Order Change Detail Tag - Inbound	64	UZ	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
TOP43: Procurement
15	F43121	Purchase Order Receiver File	2	PR	AN8	Address Number	Numeric	UDC	8	0
TOP47: Electronic Commerce
16	F47011	EDI Purchase Order Header - Inbound	141	SY	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
17	F47131	EDI Purchase Order Change Header - Inbound	138	SY	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
TOP76B: Brazil - Reporting System Only
18	F76011P	Archive Address Book Brazilian Tag Table - 04	1	PR	AN8	Address Number	Numeric	UDC	8	0
19	F76B20	Account Payable and Receivable Table - IN68 - 03B	3	PR	AN8	Address Number	Numeric	UDC	8	0
20	F76B8602	IN86-Work Table for Suppliers and Customers - 04	5	PR	AN8	Address Number	Numeric	UDC	8	0
TOP89: Conversion Programs
21	F89CA050	Lookup Table for CRM and EOne Partner Ids	2	PR	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
TOP90CA: CRM Foundation
22	F90CA030	Profile Table	1	PR	AN8	Address Number	Numeric	UDC	8	0
23	F90CA050	Partner Table	1	PP	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
24	F90CA05A	Partner_Employee Table	1	PA	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
25	F90CA05B	Partner_Item Table	1	PB	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
26	F90CA070	Contact Table	6	CT	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
27	F90CA08C	Customer_Partner Table	2	UC	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
TOP90CB: CRM Sales Force Automation
28	F90CB01C	Lead_Partner Table	2	LP	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
29	F90CB020	Opportunity Table	6	OT	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
30	F90CB02G	Opportunity_Partner Table	1	OG	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
31	F90CB06B	Opportunity_For_Forecast Table	7	OF	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
32	F90CB06Z	Opportunity for Forecast WTF	8	ZF	PRAN8	Partner Address Number	Numeric	Generic Edit	8	0
TOPF31: Lean Transactions
33	FF31111S	Purge - Lean Transaction Parts List	36	PR	AN8	Address Number	Numeric	UDC	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

33 columns | 812 | PRAN8