	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

48 columns | 812 | ADD2

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F004201	Prepayment Transaction Table	25	PT	ADD2	Address Line 2	String	Generic Edit	40	0
TOP01: Address Book
2	F0101Z2	Address Book - Interoperability	88	SZ	ADD2	Address Line 2	String	Generic Edit	40	0
3	F0116	Address by Date	5	AL	ADD2	Address Line 2	String	Generic Edit	40	0
4	F01161	Alternate Address	6	WL	ADD2	Address Line 2	String	Generic Edit	40	0
5	F01161Z1	Batch - Alternative Address	19	LB	ADD2	Address Line 2	String	Generic Edit	40	0
6	F0118	Postal Code Address	4	A7	ADD2	Address Line 2	String	Generic Edit	40	0
TOP05: Time Accounting and HRM Base
7	F054101	Employee Personal Profile Information History Table	15	EH	ADD2	Address Line 2	String	Generic Edit	40	0
8	F054101W	Employee Personal Profile Information Work Table	15	EP	ADD2	Address Line 2	String	Generic Edit	40	0
TOP05A: OW HR & PR Foundation
9	F05003	Verification of Employment Data	14	EV	ADD2	Address Line 2	String	Generic Edit	40	0
10	F060116Z	Unedited Quick Hire Transaction File	70	SZ	ADD2	Address Line 2	String	Generic Edit	40	0
TOP07: Payroll
11	F074001	New Hire Reporting Workfile - OneWorld Only	13	NH	ADD2	Address Line 2	String	Generic Edit	40	0
12	F07880	SUI Magnetic Media Workfile	9	YW	ADD2	Address Line 2	String	Generic Edit	40	0
13	F8907422	New Hire Detail File - Massachusetts (22)	14	MA	ADD2	Address Line 2	String	Generic Edit	40	0
14	F8907427	New Hire Detail File - Montana (27)	35	MT	ADD2	Address Line 2	String	Generic Edit	40	0
15	F8907428	New Hire Detail File - Nebraska(28)	11	NE	ADD2	Address Line 2	String	Generic Edit	40	0
16	F8907444	New Hire Detail File Transfer - Texas (44)	9	TX	ADD2	Address Line 2	String	Generic Edit	40	0
TOP08: Human Resources
17	F083305	Mail Merge Header/Detail	9	MM	ADD2	Address Line 2	String	Generic Edit	40	0
TOP08A: eRecruit
18	F08490	Recruitment Information	7	RI	ADD2	Address Line 2	String	Generic Edit	40	0
TOP08AD: ADP Integration
19	F05137	ADP Employee Master Information	54	AD	ADD2	Address Line 2	String	Generic Edit	40	0
TOP08B: Benefits Administration
20	F0833WF	Benefit Statement Work file	6	WF	ADD2	Address Line 2	String	Generic Edit	40	0
TOP13C: Condition-Base Maintenance
21	F1310	Condition-Based Alerts	48	CA	ADD2	Address Line 2	String	Generic Edit	40	0
22	F1310Z1	Unedited Condition-Based Alerts	62	CB	ADD2	Address Line 2	String	Generic Edit	40	0
TOP17C: Call Management
23	F17311	Installed Base Location Details	14	LD	ADD2	Address Line 2	String	Generic Edit	40	0
TOP31B: Blend Management
24	F31B01	Winery Master	5	WI	ADD2	Address Line 2	String	Generic Edit	40	0
TOP40: Inventory/OP Base
25	F4006	Order Address Information	7	OA	ADD2	Address Line 2	String	Generic Edit	40	0
26	F4006Z	Batch Order Receiver - Order Address Information	7	OY	ADD2	Address Line 2	String	Generic Edit	40	0
TOP47: Electronic Commerce
27	F47037	EDI Shipping Notice Detail - Outbound	206	SZ	ADD2	Address Line 2	String	Generic Edit	40	0
28	F470561	EDI Payment Order Bank N and A - Outbound	27	D2	ADD2	Address Line 2	String	Generic Edit	40	0
29	F470561W	EDI Payment Order Bank N and A - Work	27	D2	ADD2	Address Line 2	String	Generic Edit	40	0
30	F470562	EDI Payment Order Vendor N and A - Outbound	25	D4	ADD2	Address Line 2	String	Generic Edit	40	0
31	F470562W	EDI Payment Order Vendor N and A - Work	25	D4	ADD2	Address Line 2	String	Generic Edit	40	0
32	F470563	EDI Payment Order Payee N and A - Outbound	25	D5	ADD2	Address Line 2	String	Generic Edit	40	0
33	F470563W	EDI Payment Order Payee N and A - Work	25	D5	ADD2	Address Line 2	String	Generic Edit	40	0
34	F4706	EDI Order Address Information	17	ZA	ADD2	Address Line 2	String	Generic Edit	40	0
35	F47081	EDI Price Sales Catalog Header - Inbound	21	FV	ADD2	Address Line 2	String	Generic Edit	40	0
TOP49: Transportation Management
36	F49130	Shipment Document Workfile	19	BW	ADD2	Address Line 2	String	Generic Edit	40	0
37	F49140	SSCC Print Label Workfile	11	BW	ADD2	Address Line 2	String	Generic Edit	40	0
TOP74: EMEA Localization
38	F7430031	Legal Document Address (Print Info) - COMM - 03B	9	PI	ADD2	Address Line 2	String	Generic Edit	40	0
TOP74U: United Kingdom Localizations
39	F74U4052	Subcontractor Detail - CIS Monthly Return - UK - 04	6	SM	ADD2	Address Line 2	String	Generic Edit	40	0
TOP75A: Australia - Reporting System Only
40	F75A0010	Australian Employee Termination Details	58	A0	ADD2	Address Line 2	String	Generic Edit	40	0
41	F75A0220	Payment Summary Workfile	7	PS	ADD2	Address Line 2	String	Generic Edit	40	0
TOP76A: Argentina
42	F76A0209	Header and Footer Invoice/ShipmentNote History WF - ARG - 76A	18	HF	ADD2	Address Line 2	String	Generic Edit	40	0
43	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	18	HF	ADD2	Address Line 2	String	Generic Edit	40	0
44	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	27	C6	ADD2	Address Line 2	String	Generic Edit	40	0
45	F76AUI20	Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00	18	HF	ADD2	Address Line 2	String	Generic Edit	40	0
TOP76H: Chile
46	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	9	PI	ADD2	Address Line 2	String	Generic Edit	40	0
TOPH90: ONEWORLD TOOLS
47	F012504	Focus Registration	17	FO	ADD2	Address Line 2	String	Generic Edit	40	0
TOPH91: Design Tools
48	F9801NEW	Employee Information - New Version	5	AA	ADD2	Address Line 2	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

48 columns | 812 | ADD2