	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

103 columns | 920 | 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	F0006DZ1	Business Unit Alternate Description Z file	18	SZ	DL02	Description 02	String	Generic Edit	30	0
4	F0006S	Date Effective Business Unit Master	14	MC	DL02	Description 02	String	Generic Edit	30	0
5	F0006Z1	Cost Center Unedited Transaction Table	25	SZ	DL02	Description 02	String	Generic Edit	30	0
6	F0006Z2	Business Unit Master Z File	25	SZ	DL02	Description 02	String	Generic Edit	30	0
7	F0012	Automatic Accounting Instructions Master	7	KG	DL02	Description 02	String	Generic Edit	30	0
8	F0012D	AAI Alternate Description Master	5	LJ	DL02	Description 02	String	Generic Edit	30	0
9	F00191	Generic Message/Rates	5	CE	DL02	Description 02	String	Generic Edit	30	0
TOP05: Time Accounting and HRM Base
10	F05005	Generic UBE File	6	GF	DL02	Description 02	String	Generic Edit	30	0
11	F054101	Employee Personal Profile Information History Table	49	EH	DL02	Description 02	String	Generic Edit	30	0
12	F054101W	Employee Personal Profile Information Work Table	50	EP	DL02	Description 02	String	Generic Edit	30	0
TOP05A: PeopleSoft HR & PR Foundation
13	F060116W	EE Master Request File	226	YA	DL02	Description 02	String	Generic Edit	30	0
14	F08096	HR Generic Table Headings	4	H$	DL02	Description 02	String	Generic Edit	30	0
TOP06: Payroll (old) - Obsolete-do not reuse
15	F06210	Payroll Cycle Parameters	56	YD	DL02	Description 02	String	Generic Edit	30	0
TOP07: Payroll
16	F069026	Payroll Generic Tables	14	Y2	DL02	Description 02	String	Generic Edit	30	0
17	F07186	Stub Information History Table	13	Y8	DL02	Description 02	String	Generic Edit	30	0
18	F07352	Stub Information File	13	Y2	DL02	Description 02	String	Generic Edit	30	0
19	F07355	Pre-Payroll Error File	7	Y5	DL02	Description 02	String	Generic Edit	30	0
20	F074001	New Hire Reporting Workfile - OneWorld Only	83	NH	DL02	Description 02	String	Generic Edit	30	0
21	F074001R	New Hire Report Setup - OneWorld Only	7	NH	DL02	Description 02	String	Generic Edit	30	0
22	F074001W	SUI/New Hire Client loader for F074001R	7	NH	DL02	Description 02	String	Generic Edit	30	0
23	F078504	Vertex Geo Code to ADP Code	5	VA	DL02	Description 02	String	Generic Edit	30	0
24	F8907422	New Hire Detail File - Massachusetts (22)	18	MA	DL02	Description 02	String	Generic Edit	30	0
25	F8907427	New Hire Detail File - Montana (27)	14	MT	DL02	Description 02	String	Generic Edit	30	0
26	F8907444	New Hire Detail File Transfer - Texas (44)	16	TX	DL02	Description 02	String	Generic Edit	30	0
TOP08: Human Resources
27	F083305	Mail Merge Header/Detail	27	MM	DL02	Description 02	String	Generic Edit	30	0
28	F08391	User Program Parameters	17	B0	DL02	Description 02	String	Generic Edit	30	0
29	F085520	Available Plans and Plan Options by Employee History Table	9	PH	DL02	Description 02	String	Generic Edit	30	0
TOP08B: Benefits Administration
30	F08320D	Plan Master Tag Table	14	PD	DL02	Description 02	String	Generic Edit	30	0
31	F08380WF	Batch Enrollment Work File	13	BE	DL02	Description 02	String	Generic Edit	30	0
32	F08593	Retirement Rule Definition	4	H7	DL02	Description 02	String	Generic Edit	30	0
TOP08P: Position Control
33	F08101	Position Master	5	HP	DL02	Description 02	String	Generic Edit	30	0
34	F08101P	Purge - Position Master	5	HP	DL02	Description 02	String	Generic Edit	30	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
35	F08102	Requisition Information	26	HN	DL02	Description 02	String	Generic Edit	30	0
TOP08W: Wage and Salary
36	F08830WF	Compensation Root Work Table	31	YN	DL02	Description 02	String	Generic Edit	30	0
TOP09: General Accounting
37	F09UI009	Trial Balance Generic Work File - OneWorld ONLY	8	GB	DL02	Description 02	String	Generic Edit	30	0
TOP10: Financial Reporting
38	F10471	Elimination Rules (OW)	19	ER	DL02	Description 02	String	Generic Edit	30	0
TOP12: Fixed Assets
39	F1201	Asset Master File	14	FA	DL02	Description 02	String	Generic Edit	30	0
40	F1201D	Asset Master - Alternate Description	4	LJ	DL02	Description 02	String	Generic Edit	30	0
41	F1201P	Asset Master Purge Table	14	FA	DL02	Description 02	String	Generic Edit	30	0
42	F1201Z1	Unedited Asset Master Transactions	27	FA	DL02	Description 02	String	Generic Edit	30	0
43	F12911ER	Post G/L to FA Exceptions Work File	13	GL	DL02	Description 02	String	Generic Edit	30	0
TOP13: Plant/Equipment Management
44	F3111IGS	WO Parts for IGS Integration	7	IG	DL02	Description 02	String	Generic Edit	30	0
TOP15: Real Estate Management
45	F15012	Tenant E.P. Class Master	7	NS	DL02	Description 02	String	Generic Edit	30	0
46	F15012B	Tenant E.P. Class Master	7	NS	DL02	Description 02	String	Generic Edit	30	0
47	F1507	Unit Master	6	NH	DL02	Description 02	String	Generic Edit	30	0
48	F1507D	Unit Master - Alternate Description	5	NH	DL02	Description 02	String	Generic Edit	30	0
TOP16: Profit Management (EPS)
49	F1610	Cost Calculation Definitions	4	CD	DL02	Description 02	String	Generic Edit	30	0
TOP17: Customer Service Management
50	F1720	Contract Header	14	CH	DL02	Description 02	String	Generic Edit	30	0
TOP31P: Engineer To Order
51	F31P10	Project Quote Header	8	PQ	DL02	Description 02	String	Generic Edit	30	0
TOP34: Requirements Planning
52	F34UI003	MPS Time Series User Index	1	M8	DL02	Description 02	String	Generic Edit	30	0
TOP34A: Advanced Planning & Scheduling
53	F34A30	Order Status Definition Table	5	N0	DL02	Description 02	String	Generic Edit	30	0
TOP38: Agreement Management
54	F38010	Agreement Master	4	DN	DL02	Description 02	String	Generic Edit	30	0
TOP40: Inventory/OP Base
55	F4090	Distribution/Manufacturing - AAI Record Type	3	MK	DL02	Description 02	String	Generic Edit	30	0
TOP42I: Outbound Inventory Management
56	F42I06	Outbound Inventory Agreement Master Change History	5	OH	DL02	Description 02	String	Generic Edit	30	0
TOP43: Procurement
57	F43092Z1	Receipt Routing Unedited Transaction Table	53	SZ	DL02	Description 02	String	Generic Edit	30	0
TOP44H: Homebuilder Management
58	F4451	Lot Proceed Detail (World)	13	JF	DL02	Description 02	String	Generic Edit	30	0
59	F4453	Lot Master (World)	13	JB	DL02	Description 02	String	Generic Edit	30	0
60	F4461	Option Master (World)	18	JN	DL02	Description 02	String	Generic Edit	30	0
61	F44H301	Plan Master	13	PM	DL02	Description 02	String	Generic Edit	30	0
62	F44H401	Option Master	8	OC	DL02	Description 02	String	Generic Edit	30	0
63	F44H4011	Option by Community	9	OC	DL02	Description 02	String	Generic Edit	30	0
64	F44H401W	Option Master Work File	9	OW	DL02	Description 02	String	Generic Edit	30	0
TOP52: Contract Billing
65	F5201	Contract Master	8	G4	DL02	Description 02	String	Generic Edit	30	0
TOP52G: Proj & Gov Contract Accounting
66	F52G01M	Advanced Contracts Modifications	13	CM	DL02	Description 02	String	Generic Edit	30	0
TOP53: Change Management
67	F53005	Job Specific UDC's Master Table	5	D1	DL02	Description 02	String	Generic Edit	30	0
68	F5302	F5302 World Specs	8	DK	DL02	Description 02	String	Generic Edit	30	0
TOP74: EMEA Localization
69	F74092	IVA Balances History - Italy	6	HB	DL02	Description 02	String	Generic Edit	30	0
TOP75C: China
70	F75C002	Electronic Accounting Book	18	EA	DL02	Description 02	String	Generic Edit	30	0
71	F75C007	China - Chart of Accounts Set Up	15	CA	DL02	Description 02	String	Generic Edit	30	0
72	F75C010W	AP & AR XML Workfile - China -75C	27	AA	DL02	Description 02	String	Generic Edit	30	0
73	F75CUI04	China CNAO V2 Fixed Asset XML Work File - CHINA	4	WF	DL02	Description 02	String	Generic Edit	30	0
74	F75CUI3	Financial Reporting Work FIle	22	CW	DL02	Description 02	String	Generic Edit	30	0
TOP75I: India
75	F75I2213	Setoff Temp Table	10	TT	DL02	Description 02	String	Generic Edit	30	0
76	F75I396B	ER-6	9	SE	DL02	Description 02	String	Generic Edit	30	0
77	F75I396T	ER-6 Temp	9	SE	DL02	Description 02	String	Generic Edit	30	0
78	F75I406	State / Branch Plant Cross Reference	5	SB	DL02	Description 02	String	Generic Edit	30	0
79	F75I407	Item Category Relationship	7	IC	DL02	Description 02	String	Generic Edit	30	0
TOP76A: Argentina
80	F76A0209	Header & Footer Invoice/ShipmentNote History WF - ARG - 76A	51	HF	DL02	Description 02	String	Generic Edit	30	0
81	F76A020P	Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A	51	HF	DL02	Description 02	String	Generic Edit	30	0
82	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	28	DL	DL02	Description 02	String	Generic Edit	30	0
83	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	28	DL	DL02	Description 02	String	Generic Edit	30	0
84	F76A22	Credit Invoice Detail - F76A22 - ARG - 03B - 76A	14	ID	DL02	Description 02	String	Generic Edit	30	0
85	F76A22P	Credit Invoice Detail Purge - ARG - 03B - 76A	14	ID	DL02	Description 02	String	Generic Edit	30	0
86	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	33	C6	DL02	Description 02	String	Generic Edit	30	0
87	F76AUI20	Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A	51	HF	DL02	Description 02	String	Generic Edit	30	0
88	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A	28	DL	DL02	Description 02	String	Generic Edit	30	0
89	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	23	WF	DL02	Description 02	String	Generic Edit	30	0
TOP76B: Brazil
90	F76B0401	Tax Code - 04	4	CT	DL02	Description 02	String	Generic Edit	30	0
91	F76B054	Messages Information - SPED Fiscal Brazilian WF - BRA - 76B	8	WM	DL02	Description 02	String	Generic Edit	30	0
92	F76B0806	Messages information - SPED Fiscal Brazilian Workfile	6	MI	DL02	Description 02	String	Generic Edit	30	0
93	F76B8200	IN86-Work Table for Fixed Assets - 12	5	FA	DL02	Description 02	String	Generic Edit	30	0
TOP89: Conversion Programs
94	F75I101A	TDS Ceritificate Master Tabel Extension	19	QB	DL02	Description 02	String	Generic Edit	30	0
TOPH91: Design Tools
95	F00085A	Daylight Savings Rules	25	DS	DL02	Description 02	String	Generic Edit	30	0
96	F9801NEW	Employee Information - New Version	11	AA	DL02	Description 02	String	Generic Edit	30	0
97	F9801OLD	Employee Information - Old Version	10	AA	DL02	Description 02	String	Generic Edit	30	0
98	F98TMPL	Templates	4	TT	DL02	Description 02	String	Generic Edit	30	0
TOPH92: Interactive Engine/OL
99	F98231H	OMW Transfer Activity Rule Director - Header	5	TR	DL02	Description 02	String	Generic Edit	30	0
TOPH95: Object and Environment Tech
100	F0005	User Defined Code Values	5	DR	DL02	Description 02	String	Generic Edit	30	0
101	F0005D	User Defined Codes - Alternate Language Descriptions	6	DR	DL02	Description 02	String	Generic Edit	30	0
TOPH96U: Upgrade
102	F964725	Special Instructions UDC Description	6	SI	DL02	Description 02	String	Generic Edit	30	0
103	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

103 columns | 920 | DL02