	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

36 columns | 920 | PH1

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00094	CTI Properties	3	T1	PH1	Phone Number	String	Generic Edit	20	0
TOP01: Address Book
2	F0101Z2	Address Book - Interoperability	97	SZ	PH1	Phone Number	String	Generic Edit	20	0
3	F0115	Address Book - Phone Numbers	7	WP	PH1	Phone Number	String	Generic Edit	20	0
4	F0115Z1	Phones - Interoperability	21	PI	PH1	Phone Number	String	Generic Edit	20	0
TOP05A: PeopleSoft HR & PR Foundation
5	F05003	Verification of Employment Data	9	EV	PH1	Phone Number	String	Generic Edit	20	0
6	F060116Z	Unedited Quick Hire Transaction File	78	SZ	PH1	Phone Number	String	Generic Edit	20	0
TOP07: Payroll
7	F074001	New Hire Reporting Workfile - OneWorld Only	41	NH	PH1	Phone Number	String	Generic Edit	20	0
8	F8907427	New Hire Detail File - Montana (27)	17	MT	PH1	Phone Number	String	Generic Edit	20	0
9	F8907428	New Hire Detail File - Nebraska(28)	17	NE	PH1	Phone Number	String	Generic Edit	20	0
TOP08: Human Resources
10	F054115	Employee Phone Number History Table	5	HP	PH1	Phone Number	String	Generic Edit	20	0
11	F054115W	Employee Phone Number Work Table	5	PN	PH1	Phone Number	String	Generic Edit	20	0
TOP08AD: ADP Integration
12	F05137	ADP Employee Master Information	48	AD	PH1	Phone Number	String	Generic Edit	20	0
TOP17C: Call Management
13	F1755	Case Master	25	ZA	PH1	Phone Number	String	Generic Edit	20	0
14	F1797	S/WM Address Book Information	17	CS	PH1	Phone Number	String	Generic Edit	20	0
TOP47: Electronic Commerce
15	F470561	EDI Payment Order Bank N & A - Outbound	20	D2	PH1	Phone Number	String	Generic Edit	20	0
16	F470561W	EDI Payment Order Bank N & A - Work	22	D2	PH1	Phone Number	String	Generic Edit	20	0
17	F470562	EDI Payment Order Vendor N & A - Outbound	20	D4	PH1	Phone Number	String	Generic Edit	20	0
18	F470562W	EDI Payment Order Vendor N & A - Work	20	D4	PH1	Phone Number	String	Generic Edit	20	0
19	F470563	EDI Payment Order Payee N & A - Outbound	20	D5	PH1	Phone Number	String	Generic Edit	20	0
20	F470563W	EDI Payment Order Payee N & A - Work	20	D5	PH1	Phone Number	String	Generic Edit	20	0
TOP54HS: Health & Safety Incident Mgt
21	F54HS02	Incident People	48	S2	PH1	Phone Number	String	Generic Edit	20	0
22	F54HS02M	Incident People Change History	51	I2	PH1	Phone Number	String	Generic Edit	20	0
23	F54HS04	Incident Agencies	7	S5	PH1	Phone Number	String	Generic Edit	20	0
24	F54HS04M	Incident Agencies Change History	10	I5	PH1	Phone Number	String	Generic Edit	20	0
TOP70: Multi-National Products
25	F703037	Legal Document Contact Information - COMM - 03B	13	CI	PH1	Phone Number	String	Generic Edit	20	0
TOP74: EMEA Localization
26	F7430031	Legal Document Address (Print Info) - COMM - 03B	18	PI	PH1	Phone Number	String	Generic Edit	20	0
TOP74S: Spain
27	F74S90	Model 349 - Record Type 0 - Spain - 03B	27	Q0	PH1	Phone Number	String	Generic Edit	20	0
TOP75A: Australia
28	F75A0301	Superannuation Payment	8	SA	PH1	Phone Number	String	Generic Edit	20	0
29	F75A9096	Australian/New Zealand company constants	5	ZC	PH1	Phone Number	String	Generic Edit	20	0
TOP75C: China
30	F75C001	Chinese GUI cross reference file	27	CR	PH1	Phone Number	String	Generic Edit	20	0
TOP75T: Taiwan
31	F75T001	GUI/VAT Declaration Site - 75T	17	DS	PH1	Phone Number	String	Generic Edit	20	0
TOP76H: Chile
32	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	18	PI	PH1	Phone Number	String	Generic Edit	20	0
TOPH90: EnterpriseOne TOOLS
33	F012504	Focus Registration	13	FO	PH1	Phone Number	String	Generic Edit	20	0
34	F1761	Electronic Help JDE Request Log	17	ZA	PH1	Phone Number	String	Generic Edit	20	0
TOPH91: Design Tools
35	F9801NEW	Employee Information - New Version	9	AA	PH1	Phone Number	String	Generic Edit	20	0
36	F9801OLD	Employee Information - Old Version	8	AA	PH1	Phone Number	String	Generic Edit	20	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

36 columns | 920 | PH1