	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

65 columns | 812 | ADDZ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP01: Address Book
1	F0101Z2	Address Book - Interoperability	91	SZ	ADDZ	Postal Code	String	Generic Edit	12	0
2	F0116	Address by Date	8	AL	ADDZ	Postal Code	String	Generic Edit	12	0
3	F01161	Alternate Address	9	WL	ADDZ	Postal Code	String	Generic Edit	12	0
4	F01161Z1	Batch - Alternative Address	22	LB	ADDZ	Postal Code	String	Generic Edit	12	0
5	F0117	Postal Code Transactions	1	A8	ADDZ	Postal Code	String	Generic Edit	12	0
6	F0118	Postal Code Address	2	A7	ADDZ	Postal Code	String	Generic Edit	12	0
TOP05: Time Accounting and HRM Base
7	F054101	Employee Personal Profile Information History Table	20	EH	ADDZ	Postal Code	String	Generic Edit	12	0
8	F054101W	Employee Personal Profile Information Work Table	20	EP	ADDZ	Postal Code	String	Generic Edit	12	0
9	F054111	Employee Emergency Contact History Table	11	CH	ADDZ	Postal Code	String	Generic Edit	12	0
10	F054111W	Employee Emergency Contact Work Table	11	EC	ADDZ	Postal Code	String	Generic Edit	12	0
TOP05A: OW HR & PR Foundation
11	F05003	Verification of Employment Data	17	EV	ADDZ	Postal Code	String	Generic Edit	12	0
12	F060116Z	Unedited Quick Hire Transaction File	75	SZ	ADDZ	Postal Code	String	Generic Edit	12	0
TOP07: Payroll
13	F074001	New Hire Reporting Workfile - OneWorld Only	17	NH	ADDZ	Postal Code	String	Generic Edit	12	0
14	F07830	Employee Federal Control Table	62	Y0	ADDZ	Postal Code	String	Generic Edit	12	0
15	F07831	Employee State/Local Control Table	38	YB	ADDZ	Postal Code	String	Generic Edit	12	0
16	F07832	Employee Special Handling Control Table	24	YH	ADDZ	Postal Code	String	Generic Edit	12	0
17	F07880	SUI Magnetic Media Workfile	13	YW	ADDZ	Postal Code	String	Generic Edit	12	0
18	F8907422	New Hire Detail File - Massachusetts (22)	8	MA	ADDZ	Postal Code	String	Generic Edit	12	0
19	F8907427	New Hire Detail File - Montana (27)	38	MT	ADDZ	Postal Code	String	Generic Edit	12	0
20	F8907428	New Hire Detail File - Nebraska(28)	15	NE	ADDZ	Postal Code	String	Generic Edit	12	0
21	F8907444	New Hire Detail File Transfer - Texas (44)	13	TX	ADDZ	Postal Code	String	Generic Edit	12	0
TOP08: Human Resources
22	F083305	Mail Merge Header/Detail	14	MM	ADDZ	Postal Code	String	Generic Edit	12	0
TOP08A: eRecruit
23	F08490	Recruitment Information	14	RI	ADDZ	Postal Code	String	Generic Edit	12	0
TOP08AD: ADP Integration
24	F05137	ADP Employee Master Information	59	AD	ADDZ	Postal Code	String	Generic Edit	12	0
TOP08B: Benefits Administration
25	F0833WF	Benefit Statement Work file	11	WF	ADDZ	Postal Code	String	Generic Edit	12	0
TOP13C: Condition-Base Maintenance
26	F1310	Condition-Based Alerts	53	CA	ADDZ	Postal Code	String	Generic Edit	12	0
27	F1310Z1	Unedited Condition-Based Alerts	67	CB	ADDZ	Postal Code	String	Generic Edit	12	0
TOP15: Property Management
28	F1507	Unit Master File	20	NH	ADDZ	Postal Code	String	Generic Edit	12	0
TOP17C: Call Management
29	F17311	Installed Base Location Details	20	LD	ADDZ	Postal Code	String	Generic Edit	12	0
TOP31B: Blend Management
30	F31B01	Winery Master	8	WI	ADDZ	Postal Code	String	Generic Edit	12	0
TOP40: Inventory/OP Base
31	F4006	Order Address Information	10	OA	ADDZ	Postal Code	String	Generic Edit	12	0
32	F4006Z	Batch Order Receiver - Order Address Information	10	OY	ADDZ	Postal Code	String	Generic Edit	12	0
33	F4215	Shipment Header	37	XH	ADDZ	Postal Code	String	Generic Edit	12	0
TOP44H: Homebuilder Management
34	F44H201	Lot Master	6	LM	ADDZ	Postal Code	String	Generic Edit	12	0
35	F44H201H	Lot Master History	7	LM	ADDZ	Postal Code	String	Generic Edit	12	0
36	F44H201Z	HB Lot Master Unedited Transaction File	19	SZ	ADDZ	Postal Code	String	Generic Edit	12	0
37	F44H501H	Lot Sales History	172	LS	ADDZ	Postal Code	String	Generic Edit	12	0
TOP47: Electronic Commerce
38	F47037	EDI Shipping Notice Detail - Outbound	213	SZ	ADDZ	Postal Code	String	Generic Edit	12	0
39	F470561	EDI Payment Order Bank N and A - Outbound	31	D2	ADDZ	Postal Code	String	Generic Edit	12	0
40	F470561W	EDI Payment Order Bank N and A - Work	31	D2	ADDZ	Postal Code	String	Generic Edit	12	0
41	F470562	EDI Payment Order Vendor N and A - Outbound	31	D4	ADDZ	Postal Code	String	Generic Edit	12	0
42	F470562W	EDI Payment Order Vendor N and A - Work	31	D4	ADDZ	Postal Code	String	Generic Edit	12	0
43	F470563	EDI Payment Order Payee N and A - Outbound	31	D5	ADDZ	Postal Code	String	Generic Edit	12	0
44	F470563W	EDI Payment Order Payee N and A - Work	31	D5	ADDZ	Postal Code	String	Generic Edit	12	0
45	F4706	EDI Order Address Information	20	ZA	ADDZ	Postal Code	String	Generic Edit	12	0
46	F47081	EDI Price Sales Catalog Header - Inbound	27	FV	ADDZ	Postal Code	String	Generic Edit	12	0
TOP49: Transportation Management
47	F4950	Routing Entries	11	RT	ADDZ	Postal Code	String	Generic Edit	12	0
48	F4960	Load Header	11	TM	ADDZ	Postal Code	String	Generic Edit	12	0
49	F4981	Freight Audit History	56	FH	ADDZ	Postal Code	String	Generic Edit	12	0
TOP74: EMEA Localization
50	F7430031	Legal Document Address (Print Info) - COMM - 03B	15	PI	ADDZ	Postal Code	String	Generic Edit	12	0
TOP74B: Begium Localization
51	F7403B11	Belgium - Work File Yearly Vat Declaration Data	4	QA	ADDZ	Postal Code	String	Generic Edit	12	0
52	F74B200	Yearly/Quarterly VAT Listing - Belgium	4	VT	ADDZ	Postal Code	String	Generic Edit	12	0
TOP75A: Australia - Reporting System Only
53	F75A0010	Australian Employee Termination Details	61	A0	ADDZ	Postal Code	String	Generic Edit	12	0
54	F75A0220	Payment Summary Workfile	12	PS	ADDZ	Postal Code	String	Generic Edit	12	0
TOP76A: Argentina
55	F76A0209	Header and Footer Invoice/ShipmentNote History WF - ARG - 76A	94	HF	ADDZ	Postal Code	String	Generic Edit	12	0
56	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	94	HF	ADDZ	Postal Code	String	Generic Edit	12	0
57	F76A8002	SICORE RG738 Withholding Entity	6	V3	ADDZ	Postal Code	String	Generic Edit	12	0
58	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	28	C6	ADDZ	Postal Code	String	Generic Edit	12	0
59	F76AUI20	Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00	94	HF	ADDZ	Postal Code	String	Generic Edit	12	0
TOP76B: Brazil - Reporting System Only
60	F76101B	Nota Fiscal - Header (Fiscal Books) - 42	26	QX	ADDZ	Postal Code	String	Generic Edit	12	0
61	F76B70	Physical and Legal Person Table - IN68 - 42	15	FJ	ADDZ	Postal Code	String	Generic Edit	12	0
62	F76B8601	IN86-Work Table for Individuals and Legal Entities - 04	12	FJ	ADDZ	Postal Code	String	Generic Edit	12	0
TOP76H: Chile
63	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	15	PI	ADDZ	Postal Code	String	Generic Edit	12	0
TOP90CA: CRM Foundation
64	F90CA14D	Territory Zip Code Table	2	TD	ADDZ	Postal Code	String	Generic Edit	12	0
65	F90CA14E	Territory City Table	4	TE	ADDZ	Postal Code	String	Generic Edit	12	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

65 columns | 812 | ADDZ