	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

89 columns | 812 | DL02

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006	Business Unit Master	12	MC	DL02	Description 02	String	Generic Edit	30	0
2	F0006D	Business Unit Alternate Description Master	4	LJ	DL02	Description 02	String	Generic Edit	30	0
3	F0006S	Date Effective Business Unit Master	14	MC	DL02	Description 02	String	Generic Edit	30	0
4	F0006Z1	Cost Center Unedited Transaction Table	25	SZ	DL02	Description 02	String	Generic Edit	30	0
5	F0012	Automatic Accounting Instructions Master	7	KG	DL02	Description 02	String	Generic Edit	30	0
6	F0012D	AAI Alternate Description Master	5	LJ	DL02	Description 02	String	Generic Edit	30	0
7	F00191	Generic Message/Rates	5	CE	DL02	Description 02	String	Generic Edit	30	0
TOP05: Time Accounting and HRM Base
8	F05005	Generic UBE File	6	GF	DL02	Description 02	String	Generic Edit	30	0
9	F054101	Employee Personal Profile Information History Table	49	EH	DL02	Description 02	String	Generic Edit	30	0
10	F054101W	Employee Personal Profile Information Work Table	50	EP	DL02	Description 02	String	Generic Edit	30	0
TOP05A: OW HR & PR Foundation
11	F060116W	EE Master Request File	226	YA	DL02	Description 02	String	Generic Edit	30	0
12	F08096	HR Generic Table Headings	4	H$	DL02	Description 02	String	Generic Edit	30	0
TOP06: Payroll (old) - Obsolete-do not reuse
13	F06210	Payroll Cycle Parameters	56	YD	DL02	Description 02	String	Generic Edit	30	0
TOP07: Payroll
14	F069026	Payroll Generic Tables	14	Y2	DL02	Description 02	String	Generic Edit	30	0
15	F07186	Stub Information History Table	13	Y8	DL02	Description 02	String	Generic Edit	30	0
16	F07352	Stub Information File	13	Y2	DL02	Description 02	String	Generic Edit	30	0
17	F07355	Pre-Payroll Error File	7	Y5	DL02	Description 02	String	Generic Edit	30	0
18	F074001	New Hire Reporting Workfile - OneWorld Only	83	NH	DL02	Description 02	String	Generic Edit	30	0
19	F074001R	New Hire Report Setup - OneWorld Only	7	NH	DL02	Description 02	String	Generic Edit	30	0
20	F078504	Vertex Geo Code to ADP Code	4	VA	DL02	Description 02	String	Generic Edit	30	0
21	F8907422	New Hire Detail File - Massachusetts (22)	18	MA	DL02	Description 02	String	Generic Edit	30	0
22	F8907427	New Hire Detail File - Montana (27)	14	MT	DL02	Description 02	String	Generic Edit	30	0
23	F8907444	New Hire Detail File Transfer - Texas (44)	16	TX	DL02	Description 02	String	Generic Edit	30	0
TOP08: Human Resources
24	F083305	Mail Merge Header/Detail	27	MM	DL02	Description 02	String	Generic Edit	30	0
25	F08391	User Program Parameters	17	B0	DL02	Description 02	String	Generic Edit	30	0
26	F085520	Available Plans and Plan Options by Employee History Table	9	PH	DL02	Description 02	String	Generic Edit	30	0
TOP08A: eRecruit
27	F08471	Job Posting Competencies	9	PC	DL02	Description 02	String	Generic Edit	30	0
TOP08B: Benefits Administration
28	F08320D	Plan Master Tag Table	14	PD	DL02	Description 02	String	Generic Edit	30	0
29	F08380WF	Batch Enrollment Work File	13	BE	DL02	Description 02	String	Generic Edit	30	0
30	F08593	Retirement Rule Definition	4	H7	DL02	Description 02	String	Generic Edit	30	0
TOP08P: Position Control
31	F08101	Position Master	5	HP	DL02	Description 02	String	Generic Edit	30	0
32	F08101P	Purge - Position Master	5	HP	DL02	Description 02	String	Generic Edit	30	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
33	F08102	Requisition Information	26	HN	DL02	Description 02	String	Generic Edit	30	0
TOP08W: Wage and Salary
34	F08830WF	Compensation Root Work Table	31	YN	DL02	Description 02	String	Generic Edit	30	0
TOP09: General Accounting
35	F09UI009	Trial Balance Generic Work File - OneWorld ONLY	8	GB	DL02	Description 02	String	Generic Edit	30	0
TOP10: Financial Reporting
36	F10471	Elimination Rules (OW)	19	ER	DL02	Description 02	String	Generic Edit	30	0
TOP12: Fixed Assets
37	F1201	Asset Master File	14	FA	DL02	Description 02	String	Generic Edit	30	0
38	F1201D	Asset Master - Alternate Description	4	LJ	DL02	Description 02	String	Generic Edit	30	0
39	F1201P	Asset Master Purge Table	14	FA	DL02	Description 02	String	Generic Edit	30	0
40	F1201Z1	Unedited Asset Master Transactions	27	FA	DL02	Description 02	String	Generic Edit	30	0
41	F12911ER	Post G/L to FA Exceptions Work File	13	GL	DL02	Description 02	String	Generic Edit	30	0
TOP13: Plant/Equipment Management
42	F3111IGS	WO Parts for IGS Integration	7	IG	DL02	Description 02	String	Generic Edit	30	0
TOP15: Property Management
43	F15012	Tenant E.P. Class Master	7	NS	DL02	Description 02	String	Generic Edit	30	0
44	F15012B	Tenant E.P. Class Master	7	NS	DL02	Description 02	String	Generic Edit	30	0
45	F1507	Unit Master File	6	NH	DL02	Description 02	String	Generic Edit	30	0
46	F1507D	Unit Master - Alternate Description	5	NH	DL02	Description 02	String	Generic Edit	30	0
TOP16: Profit Management (EPS)
47	F1610	Cost Calculation Definitions	4	CD	DL02	Description 02	String	Generic Edit	30	0
TOP17: Customer Service Management
48	F1720	Contract Header	14	CH	DL02	Description 02	String	Generic Edit	30	0
TOP31P: Engineer To Order
49	F31P10	Project Quote Header	8	PQ	DL02	Description 02	String	Generic Edit	30	0
TOP34: Requirements Planning
50	F34UI003	MPS Time Series User Index	1	M8	DL02	Description 02	String	Generic Edit	30	0
TOP34A: Advanced Planning & Scheduling
51	F34A30	Order Status Definition Table	5	N0	DL02	Description 02	String	Generic Edit	30	0
TOP38: Agreement Management
52	F38010	Agreement Master	4	DN	DL02	Description 02	String	Generic Edit	30	0
TOP40: Inventory/OP Base
53	F4090	Distribution/Manufacturing - AAI Record Type	3	MK	DL02	Description 02	String	Generic Edit	30	0
TOP43: Procurement
54	F43092Z1	Receipt Routing Unedited Transaction Table	53	SZ	DL02	Description 02	String	Generic Edit	30	0
TOP44H: Homebuilder Management
55	F4451	Lot Proceed Detail (World)	13	JF	DL02	Description 02	String	Generic Edit	30	0
56	F4453	Lot Master (World)	13	JB	DL02	Description 02	String	Generic Edit	30	0
57	F4461	Option Master (World)	18	JN	DL02	Description 02	String	Generic Edit	30	0
58	F44H301	Plan Master	13	PM	DL02	Description 02	String	Generic Edit	30	0
59	F44H401	Option Master	8	OC	DL02	Description 02	String	Generic Edit	30	0
60	F44H4011	Option by Community	9	OC	DL02	Description 02	String	Generic Edit	30	0
61	F44H401W	Option Master Work File	9	OW	DL02	Description 02	String	Generic Edit	30	0
TOP52: Contract Billing
62	F5201	Contract Master File	8	G4	DL02	Description 02	String	Generic Edit	30	0
TOP53: Change Management
63	F53005	Job Specific UDC's Master Table	5	D1	DL02	Description 02	String	Generic Edit	30	0
64	F5302	F5302 World Specs	8	DK	DL02	Description 02	String	Generic Edit	30	0
TOP55: Reserved for Clients
65	F74H1050	Invoicing Workfile Header - New	17	IH	DL02	Description 02	String	Generic Edit	30	0
66	F74H1056	Invoicing Additional References	4	AR	DL02	Description 02	String	Generic Edit	30	0
TOP74: EMEA Localization
67	F74092	IVA Balances History - Italy	6	HB	DL02	Description 02	String	Generic Edit	30	0
TOP76A: Argentina
68	F76A0209	Header and Footer Invoice/ShipmentNote History WF - ARG - 76A	51	HF	DL02	Description 02	String	Generic Edit	30	0
69	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	51	HF	DL02	Description 02	String	Generic Edit	30	0
70	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	28	DL	DL02	Description 02	String	Generic Edit	30	0
71	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	28	DL	DL02	Description 02	String	Generic Edit	30	0
72	F76A22	Credit Invoice Detail - F76A22 - ARG - 03B - 76A	14	ID	DL02	Description 02	String	Generic Edit	30	0
73	F76A22P	Credit Invoice Detail Purge - ARG - 03B - 76A	14	ID	DL02	Description 02	String	Generic Edit	30	0
74	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	33	C6	DL02	Description 02	String	Generic Edit	30	0
75	F76AUI20	Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00	51	HF	DL02	Description 02	String	Generic Edit	30	0
76	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	28	DL	DL02	Description 02	String	Generic Edit	30	0
77	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	23	WF	DL02	Description 02	String	Generic Edit	30	0
TOP76B: Brazil - Reporting System Only
78	F76B0401	Tax Code - 04	4	CT	DL02	Description 02	String	Generic Edit	30	0
79	F76B8200	IN86-Work Table for Fixed Assets - 12	5	FA	DL02	Description 02	String	Generic Edit	30	0
TOP89: Conversion Programs
80	F074001W	SUI/New Hire Client loader for F074001R	7	NH	DL02	Description 02	String	Generic Edit	30	0
TOPH91: Design Tools
81	F00085A	Daylight Savings Rules	25	DS	DL02	Description 02	String	Generic Edit	30	0
82	F9801NEW	Employee Information - New Version	11	AA	DL02	Description 02	String	Generic Edit	30	0
83	F9801OLD	Employee Information - Old Version	10	AA	DL02	Description 02	String	Generic Edit	30	0
84	F98TMPL	Templates	4	TT	DL02	Description 02	String	Generic Edit	30	0
TOPH92: Interactive Engine/OL
85	F98231H	OMW Transfer Activity Rule Director - Header	5	TR	DL02	Description 02	String	Generic Edit	30	0
TOPH95: Tech Resources/Applications
86	F0005	User Defined Codes	5	DR	DL02	Description 02	String	Generic Edit	30	0
87	F0005D	User Defined Codes - Alternate Language Descriptions	6	DR	DL02	Description 02	String	Generic Edit	30	0
TOPH96U: Upgrade
88	F964725	Special Instructions UDC Description	6	SI	DL02	Description 02	String	Generic Edit	30	0
89	F96710	Impact Analysis Results	16	RA	DL02	Description 02	String	Generic Edit	30	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

89 columns | 812 | DL02