	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

51 columns | 920 | ADD4

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP01: Address Book
1	F0101Z2	Address Book - Interoperability	90	SZ	ADD4	Address Line 4	String	Generic Edit	40	0
2	F0116	Address by Date	7	AL	ADD4	Address Line 4	String	Generic Edit	40	0
3	F01161	Alternate Address	8	WL	ADD4	Address Line 4	String	Generic Edit	40	0
4	F01161DW	Customer Alternate Address Export	11	DW	ADD4	Address Line 4	String	Generic Edit	40	0
5	F01161Z1	Batch - Alternative Address	21	LB	ADD4	Address Line 4	String	Generic Edit	40	0
6	F0118	Postal Code Address	6	A7	ADD4	Address Line 4	String	Generic Edit	40	0
TOP05: Time Accounting and HRM Base
7	F054101	Employee Personal Profile Information History Table	17	EH	ADD4	Address Line 4	String	Generic Edit	40	0
8	F054101W	Employee Personal Profile Information Work Table	17	EP	ADD4	Address Line 4	String	Generic Edit	40	0
TOP05A: PeopleSoft HR & PR Foundation
9	F060116Z	Unedited Quick Hire Transaction File	72	SZ	ADD4	Address Line 4	String	Generic Edit	40	0
TOP07: Payroll
10	F074001	New Hire Reporting Workfile - OneWorld Only	30	NH	ADD4	Address Line 4	String	Generic Edit	40	0
11	F07880	SUI Magnetic Media Workfile	28	YW	ADD4	Address Line 4	String	Generic Edit	40	0
12	F8907427	New Hire Detail File - Montana (27)	8	MT	ADD4	Address Line 4	String	Generic Edit	40	0
13	F8907444	New Hire Detail File Transfer - Texas (44)	24	TX	ADD4	Address Line 4	String	Generic Edit	40	0
TOP08: Human Resources
14	F083305	Mail Merge Header/Detail	11	MM	ADD4	Address Line 4	String	Generic Edit	40	0
TOP08AD: ADP Integration
15	F05137	ADP Employee Master Information	56	AD	ADD4	Address Line 4	String	Generic Edit	40	0
TOP08B: Benefits Administration
16	F0833WF	Benefit Statement Work file	8	WF	ADD4	Address Line 4	String	Generic Edit	40	0
TOP13C: Condition-Base Maintenance
17	F1310	Condition-Based Alerts	50	CA	ADD4	Address Line 4	String	Generic Edit	40	0
18	F1310Z1	Unedited Condition-Based Alerts	64	CB	ADD4	Address Line 4	String	Generic Edit	40	0
TOP17C: Call Management
19	F17311	Equipment Master Location Details	16	LD	ADD4	Address Line 4	String	Generic Edit	40	0
TOP40: Inventory/OP Base
20	F4006	Order Address Information	9	OA	ADD4	Address Line 4	String	Generic Edit	40	0
21	F4006Z	Batch Order Receiver - Order Address Information	9	OY	ADD4	Address Line 4	String	Generic Edit	40	0
TOP47: Electronic Commerce
22	F47037	EDI Shipping Notice Detail - Outbound	208	SZ	ADD4	Address Line 4	String	Generic Edit	40	0
23	F470561	EDI Payment Order Bank N & A - Outbound	29	D2	ADD4	Address Line 4	String	Generic Edit	40	0
24	F470561W	EDI Payment Order Bank N & A - Work	29	D2	ADD4	Address Line 4	String	Generic Edit	40	0
25	F470562	EDI Payment Order Vendor N & A - Outbound	27	D4	ADD4	Address Line 4	String	Generic Edit	40	0
26	F470562W	EDI Payment Order Vendor N & A - Work	27	D4	ADD4	Address Line 4	String	Generic Edit	40	0
27	F470563	EDI Payment Order Payee N & A - Outbound	27	D5	ADD4	Address Line 4	String	Generic Edit	40	0
28	F470563W	EDI Payment Order Payee N & A - Work	27	D5	ADD4	Address Line 4	String	Generic Edit	40	0
29	F4706	EDI Order Address Information	19	ZA	ADD4	Address Line 4	String	Generic Edit	40	0
30	F47081	EDI Price Sales Catalog Header - Inbound	23	FV	ADD4	Address Line 4	String	Generic Edit	40	0
TOP49: Transportation Management
31	F49130	Shipment Document Workfile	21	BW	ADD4	Address Line 4	String	Generic Edit	40	0
32	F49140	SSCC Print Label Workfile	13	BW	ADD4	Address Line 4	String	Generic Edit	40	0
33	F49T50	Order Release Location Staging	16	LO	ADD4	Address Line 4	String	Generic Edit	40	0
34	F49T80	Locations Staging Table	12	LC	ADD4	Address Line 4	String	Generic Edit	40	0
TOP54HS: Health & Safety Incident Mgt
35	F54HS01	Incident Master	33	S1	ADD4	Address Line 4	String	Generic Edit	40	0
36	F54HS01M	Incident Master Change History	36	I1	ADD4	Address Line 4	String	Generic Edit	40	0
TOP74: EMEA Localization
37	F74101	Additional Address Book & Vat Id Info via VIES - EU - 01	6	VV	ADD4	Address Line 4	String	Generic Edit	40	0
38	F74101W	Additional Address Book & Vat Id Info Work File - EU - 01	6	VW	ADD4	Address Line 4	String	Generic Edit	40	0
39	F7430031	Legal Document Address (Print Info) - COMM - 03B	11	PI	ADD4	Address Line 4	String	Generic Edit	40	0
TOP74U: United Kingdom Localizations
40	F74U4052	Subcontractor Detail - CIS Monthly Return - UK - 04	8	SM	ADD4	Address Line 4	String	Generic Edit	40	0
41	F74UUI52	Subcontractor Detail - XML WF CIS Monthly Return - UK - 04	8	SM	ADD4	Address Line 4	String	Generic Edit	40	0
TOP75A: Australia
42	F75A0220	Payment Summary Workfile	9	PS	ADD4	Address Line 4	String	Generic Edit	40	0
TOP75I: India
43	F75I100Q	TDS Form 26Q - WorkFile (Quarterly)	19	EF	ADD4	Address Line 4	String	Generic Edit	40	0
44	F75I100W	TDS Form 26 - WorkFile	19	EF	ADD4	Address Line 4	String	Generic Edit	40	0
45	F75I210	Tax Registration Details - IND - 00	5	CS	ADD4	Address Line 4	String	Generic Edit	40	0
TOP76A: Argentina
46	F76A0209	Header & Footer Invoice/ShipmentNote History WF - ARG - 76A	20	HF	ADD4	Address Line 4	String	Generic Edit	40	0
47	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	20	HF	ADD4	Address Line 4	String	Generic Edit	40	0
48	F76AUI20	Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A	20	HF	ADD4	Address Line 4	String	Generic Edit	40	0
TOP76H: Chile
49	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	11	PI	ADD4	Address Line 4	String	Generic Edit	40	0
TOP79A: Greenhouse Gas Accounting
50	F79A75	GHG Organization Name	7	GO	ADD4	Address Line 4	String	Generic Edit	40	0
TOPH90: EnterpriseOne TOOLS
51	F012504	Focus Registration	19	FO	ADD4	Address Line 4	String	Generic Edit	40	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

51 columns | 920 | ADD4