	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

73 columns | 920 | ADD1

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F004201	Prepayment Transaction Table	24	PT	ADD1	Address Line 1	String	Generic Edit	40	0
TOP01: Address Book
2	F0101Z2	Address Book - Interoperability	87	SZ	ADD1	Address Line 1	String	Generic Edit	40	0
3	F0116	Address by Date	4	AL	ADD1	Address Line 1	String	Generic Edit	40	0
4	F01161	Alternate Address	5	WL	ADD1	Address Line 1	String	Generic Edit	40	0
5	F01161DW	Customer Alternate Address Export	8	DW	ADD1	Address Line 1	String	Generic Edit	40	0
6	F01161Z1	Batch - Alternative Address	18	LB	ADD1	Address Line 1	String	Generic Edit	40	0
7	F0118	Postal Code Address	3	A7	ADD1	Address Line 1	String	Generic Edit	40	0
TOP05: Time Accounting and HRM Base
8	F054101	Employee Personal Profile Information History Table	14	EH	ADD1	Address Line 1	String	Generic Edit	40	0
9	F054101W	Employee Personal Profile Information Work Table	14	EP	ADD1	Address Line 1	String	Generic Edit	40	0
10	F054111	Employee Emergency Contact History Table	8	CH	ADD1	Address Line 1	String	Generic Edit	40	0
11	F054111W	Employee Emergency Contact Work Table	8	EC	ADD1	Address Line 1	String	Generic Edit	40	0
TOP05A: PeopleSoft HR & PR Foundation
12	F05003	Verification of Employment Data	13	EV	ADD1	Address Line 1	String	Generic Edit	40	0
13	F060116Z	Unedited Quick Hire Transaction File	69	SZ	ADD1	Address Line 1	String	Generic Edit	40	0
TOP07: Payroll
14	F074001	New Hire Reporting Workfile - OneWorld Only	12	NH	ADD1	Address Line 1	String	Generic Edit	40	0
15	F07880	SUI Magnetic Media Workfile	8	YW	ADD1	Address Line 1	String	Generic Edit	40	0
16	F8907422	New Hire Detail File - Massachusetts (22)	5	MA	ADD1	Address Line 1	String	Generic Edit	40	0
17	F8907427	New Hire Detail File - Montana (27)	34	MT	ADD1	Address Line 1	String	Generic Edit	40	0
18	F8907428	New Hire Detail File - Nebraska(28)	10	NE	ADD1	Address Line 1	String	Generic Edit	40	0
19	F8907444	New Hire Detail File Transfer - Texas (44)	8	TX	ADD1	Address Line 1	String	Generic Edit	40	0
TOP08: Human Resources
20	F083305	Mail Merge Header/Detail	8	MM	ADD1	Address Line 1	String	Generic Edit	40	0
TOP08AD: ADP Integration
21	F05137	ADP Employee Master Information	53	AD	ADD1	Address Line 1	String	Generic Edit	40	0
TOP08B: Benefits Administration
22	F0833WF	Benefit Statement Work file	5	WF	ADD1	Address Line 1	String	Generic Edit	40	0
TOP08U: PeopleSoft HR US
23	F08995	COBRA Notification History	6	H2	ADD1	Address Line 1	String	Generic Edit	40	0
TOP13C: Condition-Base Maintenance
24	F1310	Condition-Based Alerts	47	CA	ADD1	Address Line 1	String	Generic Edit	40	0
25	F1310Z1	Unedited Condition-Based Alerts	61	CB	ADD1	Address Line 1	String	Generic Edit	40	0
TOP17C: Call Management
26	F17311	Equipment Master Location Details	13	LD	ADD1	Address Line 1	String	Generic Edit	40	0
TOP31B: Blend Management
27	F31B01	Winery Master	4	WI	ADD1	Address Line 1	String	Generic Edit	40	0
TOP40: Inventory/OP Base
28	F4006	Order Address Information	6	OA	ADD1	Address Line 1	String	Generic Edit	40	0
29	F4006Z	Batch Order Receiver - Order Address Information	6	OY	ADD1	Address Line 1	String	Generic Edit	40	0
TOP44H: Homebuilder Management
30	F4453	Lot Master (World)	8	JB	ADD1	Address Line 1	String	Generic Edit	40	0
TOP47: Electronic Commerce
31	F47037	EDI Shipping Notice Detail - Outbound	205	SZ	ADD1	Address Line 1	String	Generic Edit	40	0
32	F470561	EDI Payment Order Bank N & A - Outbound	26	D2	ADD1	Address Line 1	String	Generic Edit	40	0
33	F470561W	EDI Payment Order Bank N & A - Work	26	D2	ADD1	Address Line 1	String	Generic Edit	40	0
34	F470562	EDI Payment Order Vendor N & A - Outbound	24	D4	ADD1	Address Line 1	String	Generic Edit	40	0
35	F470562W	EDI Payment Order Vendor N & A - Work	24	D4	ADD1	Address Line 1	String	Generic Edit	40	0
36	F470563	EDI Payment Order Payee N & A - Outbound	24	D5	ADD1	Address Line 1	String	Generic Edit	40	0
37	F470563W	EDI Payment Order Payee N & A - Work	24	D5	ADD1	Address Line 1	String	Generic Edit	40	0
38	F4706	EDI Order Address Information	16	ZA	ADD1	Address Line 1	String	Generic Edit	40	0
39	F47081	EDI Price Sales Catalog Header - Inbound	20	FV	ADD1	Address Line 1	String	Generic Edit	40	0
TOP49: Transportation Management
40	F49130	Shipment Document Workfile	18	BW	ADD1	Address Line 1	String	Generic Edit	40	0
41	F49140	SSCC Print Label Workfile	10	BW	ADD1	Address Line 1	String	Generic Edit	40	0
42	F49T50	Order Release Location Staging	10	LO	ADD1	Address Line 1	String	Generic Edit	40	0
43	F49T80	Locations Staging Table	9	LC	ADD1	Address Line 1	String	Generic Edit	40	0
TOP54HS: Health & Safety Incident Mgt
44	F54HS01	Incident Master	30	S1	ADD1	Address Line 1	String	Generic Edit	40	0
45	F54HS01M	Incident Master Change History	33	I1	ADD1	Address Line 1	String	Generic Edit	40	0
46	F54HS02	Incident People	40	S2	ADD1	Address Line 1	String	Generic Edit	40	0
47	F54HS02M	Incident People Change History	43	I2	ADD1	Address Line 1	String	Generic Edit	40	0
TOP74: EMEA Localization
48	F74101	Additional Address Book & Vat Id Info via VIES - EU - 01	3	VV	ADD1	Address Line 1	String	Generic Edit	40	0
49	F74101W	Additional Address Book & Vat Id Info Work File - EU - 01	3	VW	ADD1	Address Line 1	String	Generic Edit	40	0
50	F7430031	Legal Document Address (Print Info) - COMM - 03B	8	PI	ADD1	Address Line 1	String	Generic Edit	40	0
TOP74B: Begium Localization
51	F7403B11	Belgium - Work File Yearly Vat Declaration Data	3	QA	ADD1	Address Line 1	String	Generic Edit	40	0
52	F74B200	Yearly/Quarterly VAT Listing - Belgium	3	VT	ADD1	Address Line 1	String	Generic Edit	40	0
TOP74U: United Kingdom Localizations
53	F74U4052	Subcontractor Detail - CIS Monthly Return - UK - 04	5	SM	ADD1	Address Line 1	String	Generic Edit	40	0
54	F74UUI52	Subcontractor Detail - XML WF CIS Monthly Return - UK - 04	5	SM	ADD1	Address Line 1	String	Generic Edit	40	0
TOP75A: Australia
55	F75A0010	Australian Employee Termination Details	57	A0	ADD1	Address Line 1	String	Generic Edit	40	0
56	F75A0220	Payment Summary Workfile	6	PS	ADD1	Address Line 1	String	Generic Edit	40	0
TOP75C: China
57	F75C001	Chinese GUI cross reference file	28	CR	ADD1	Address Line 1	String	Generic Edit	40	0
TOP75I: India
58	F75I100Q	TDS Form 26Q - WorkFile (Quarterly)	16	EF	ADD1	Address Line 1	String	Generic Edit	40	0
59	F75I100W	TDS Form 26 - WorkFile	16	EF	ADD1	Address Line 1	String	Generic Edit	40	0
60	F75I210	Tax Registration Details - IND - 00	2	CS	ADD1	Address Line 1	String	Generic Edit	40	0
61	F75I303	Excise - ARE1 Bond Master-IND-75I	10	Q2	ADD1	Address Line 1	String	Generic Edit	40	0
62	F75I305	Excise - General Surety Bond	10	Q3	ADD1	Address Line 1	String	Generic Edit	40	0
TOP76A: Argentina
63	F76A0209	Header & Footer Invoice/ShipmentNote History WF - ARG - 76A	17	HF	ADD1	Address Line 1	String	Generic Edit	40	0
64	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	17	HF	ADD1	Address Line 1	String	Generic Edit	40	0
65	F76A8002	SICORE RG738 Withholding Entity - ARG - 04 - 76A	3	V3	ADD1	Address Line 1	String	Generic Edit	40	0
66	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	26	C6	ADD1	Address Line 1	String	Generic Edit	40	0
67	F76AUI20	Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A	17	HF	ADD1	Address Line 1	String	Generic Edit	40	0
TOP76C: Colombia
68	F76C571	DIAN File Type 1 - COL - 04	12	R1	ADD1	Address Line 1	String	Generic Edit	40	0
TOP76H: Chile
69	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	8	PI	ADD1	Address Line 1	String	Generic Edit	40	0
TOP79A: Greenhouse Gas Accounting
70	F79A75	GHG Organization Name	4	GO	ADD1	Address Line 1	String	Generic Edit	40	0
TOPH90: EnterpriseOne TOOLS
71	F012504	Focus Registration	16	FO	ADD1	Address Line 1	String	Generic Edit	40	0
TOPH91: Design Tools
72	F9801NEW	Employee Information - New Version	4	AA	ADD1	Address Line 1	String	Generic Edit	40	0
73	F9801OLD	Employee Information - Old Version	4	AA	ADD1	Address Line 1	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

73 columns | 920 | ADD1