	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

162 columns | 920 | OBNM

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00022	Unique Key File - Next Available Unique Key	1	UK	OBNM	Object Name	String	Generic Edit	10	0
2	F00023	Distributed Next Number Table	8	DN	OBNM	Object Name	String	Generic Edit	10	0
3	F00094	CTI Properties	4	T1	OBNM	Object Name	String	Generic Edit	10	0
4	F00095	Business Object Reservation	1	A1	OBNM	Object Name	String	Generic Edit	10	0
5	F00096	Default Media Object Category by Table	1	M0	OBNM	Object Name	String	Generic Edit	10	0
6	F00098	Enable Distributed Next Numner	7	ED	OBNM	Object Name	String	Generic Edit	10	0
7	F0039M	Generated Document Media Object History	1	GH	OBNM	Object Name	String	Generic Edit	10	0
8	F0046	Processing Log	8	PL	OBNM	Object Name	String	Generic Edit	10	0
9	F0047	Data Export Control	4	DE	OBNM	Object Name	String	Generic Edit	10	0
10	F007021W	Transactions to Batch Headers Work Table	3	TB	OBNM	Object Name	String	Generic Edit	10	0
11	F01RS11W	PCFGTV Detail Public Data	17	TD	OBNM	Object Name	String	Generic Edit	10	0
12	F01RS13W	PCFGTV By Role Public Data	11	TA	OBNM	Object Name	String	Generic Edit	10	0
13	F80D306	Action Definition	2	HD	OBNM	Object Name	String	Generic Edit	10	0
TOP05: Time Accounting and HRM Base
14	F05005	Generic UBE File	3	GF	OBNM	Object Name	String	Generic Edit	10	0
15	F05400	Self-Service Process Flow Settings	9	PF	OBNM	Object Name	String	Generic Edit	10	0
16	F05430	ESS User Defined Text	6	UT	OBNM	Object Name	String	Generic Edit	10	0
TOP05A: PeopleSoft HR & PR Foundation
17	F980014D	Mail Merge Runtime Web Data	2	MD	OBNM	Object Name	String	Generic Edit	10	0
TOP08: Human Resources
18	F05402	Self-Service Step/ApplicationCross-Reference	2	SA	OBNM	Object Name	String	Generic Edit	10	0
19	F083301	Benefit Statement	3	BS	OBNM	Object Name	String	Generic Edit	10	0
20	F083305	Mail Merge Header/Detail	4	MM	OBNM	Object Name	String	Generic Edit	10	0
21	F085528	ESS History Table Cross Reference	3	ES	OBNM	Object Name	String	Generic Edit	10	0
22	F087103	Setup Task Details	15	TD	OBNM	Object Name	String	Generic Edit	10	0
23	F08730	Employee Status Change Setup	8	SS	OBNM	Object Name	String	Generic Edit	10	0
24	F08740	Manager's Self Service Reports	5	MR	OBNM	Object Name	String	Generic Edit	10	0
TOP08B: Benefits Administration
25	F0833WF	Benefit Statement Work file	2	WF	OBNM	Object Name	String	Generic Edit	10	0
TOP08U: PeopleSoft HR US
26	F089902	COBRA General Constants - COBRA Notices Information	7	J2	OBNM	Object Name	String	Generic Edit	10	0
TOP09: General Accounting
27	F09305	OVFS Row Definition Grouping Elements Table	2	GR	OBNM	Object Name	String	Generic Edit	10	0
TOP40G: Grower Management
28	F40G50	Maturity Calc Program Name Setup	4	MC	OBNM	Object Name	String	Generic Edit	10	0
TOP42B: Sales Order Entry
29	F4211SW	Sales Order Detail Summary Work File	7	SS	OBNM	Object Name	String	Generic Edit	10	0
TOP49: Transportation Management
30	F49T05	OTM Record Reservation	3	OR	OBNM	Object Name	String	Generic Edit	10	0
TOP76C: Colombia
31	F76CI01	Activate Colombian Localizations - COL - 76C	1	AC	OBNM	Object Name	String	Generic Edit	10	0
TOP81: DREAM Writer
32	F81A122	Dream Writer Processing Option Interim File F59012 - F81A122	8	M4	OBNM	Object Name	String	Generic Edit	10	0
TOP81A: DREAMWriter Conversion Tool
33	F81A01	DW Master Parameters Conversion Table	6	M1	OBNM	Object Name	String	Generic Edit	10	0
34	F81A10	DW Log File - OneWorld	8	ME	OBNM	Object Name	String	Generic Edit	10	0
TOP87: PeopleSoft Internal
35	F87SAR	SAR/Object Cross Reference	5	WS	OBNM	Object Name	String	Generic Edit	10	0
TOP89: Conversion Programs
36	F98305V	Batch Versions Web Versions	1	WV	OBNM	Object Name	String	Generic Edit	10	0
37	F98950T	TC Temporary table for AQ, CAFE1	3	WO	OBNM	Object Name	String	Generic Edit	10	0
TOP90CA: CRM Foundation
38	F90CA23A	Wizard Process Flow Settings	7	WP	OBNM	Object Name	String	Generic Edit	10	0
TOP98: Technical Tools
39	F05WEBMM	Web Mail Merge Letter Header	2	WM	OBNM	Object Name	String	Generic Edit	10	0
40	F05WMM01	Web Mail Merge Data Structure Header	1	DH	OBNM	Object Name	String	Generic Edit	10	0
41	F05WMM02	Web Mail Merge Data Structure Detail	1	DD	OBNM	Object Name	String	Generic Edit	10	0
42	F980014T	Web Mail Merge Template Tag file	1	MT	OBNM	Object Name	String	Generic Edit	10	0
43	F980014W	Mail Merge Web Objects	1	MM	OBNM	Object Name	String	Generic Edit	10	0
44	F98BLOB	DB2 Blob Support	1	KS	OBNM	Object Name	String	Generic Edit	10	0
TOPH79: Translation Tools
45	F001651	Generic Text Language Status	1	LS	OBNM	Object Name	String	Generic Edit	10	0
46	F79750	Forms Design Aid Extracted Text	1	FT	OBNM	Object Name	String	Generic Edit	10	0
47	F797501	Forms Design Aid Extracted Text Language Status	1	LS	OBNM	Object Name	String	Generic Edit	10	0
48	F79751	Forms Design Aid Extracted Spec	1	FS	OBNM	Object Name	String	Generic Edit	10	0
49	F79760	Report Design Aid Extracted Text	1	RT	OBNM	Object Name	String	Generic Edit	10	0
50	F797601	Report Design Aid Extracted Spec Language Status	1	LS	OBNM	Object Name	String	Generic Edit	10	0
51	F79761	Report Design Aid Extracted Spec	1	RS	OBNM	Object Name	String	Generic Edit	10	0
52	F983061	Processing Option Text Language Status	1	LS	OBNM	Object Name	String	Generic Edit	10	0
53	F989501	User Override Language Translation Table	3	LS	OBNM	Object Name	String	Generic Edit	10	0
TOPH90: EnterpriseOne TOOLS
54	F01133P	Mailbox Properties	2	ZS	OBNM	Object Name	String	Generic Edit	10	0
55	F9000	Task Master	6	TM	OBNM	Object Name	String	Generic Edit	10	0
56	F9021	ActivEra Qualifier Actions Detail	4	RA	OBNM	Object Name	String	Generic Edit	10	0
57	F90701	Interoperability Event Definition	13	ED	OBNM	Object Name	String	Generic Edit	10	0
58	F90701N	Interoperability Event Definition - Net Change	15	ED	OBNM	Object Name	String	Generic Edit	10	0
59	F90710	Event Transfer Table	10	ET	OBNM	Object Name	String	Generic Edit	10	0
60	F90712	Event Transfer Failure Table	10	FT	OBNM	Object Name	String	Generic Edit	10	0
61	F90730	Unique Sequence File - Next Available Unique Sequence	1	US	OBNM	Object Name	String	Generic Edit	10	0
62	F91014	Task Word Search Table	5	TM	OBNM	Object Name	String	Generic Edit	10	0
63	F980014	MailMerge Objects	1	MM	OBNM	Object Name	String	Generic Edit	10	0
64	F986102	Cluster Server Info	1	OM	OBNM	Object Name	String	Generic Edit	10	0
TOPH91: Design Tools
65	F984052	Table Conversion - History Log	2	SH	OBNM	Object Name	String	Generic Edit	10	0
66	F98610	Debug Information	1	DB	OBNM	Object Name	String	Generic Edit	10	0
67	F9865	Form Information File	9	SW	OBNM	Object Name	String	Generic Edit	10	0
TOPH92: Interactive Engine/OL
68	F00165T	Media Object Conversion Table	1	GD	OBNM	Object Name	String	Generic Edit	10	0
69	F98306	Processing Option Text	1	PT	OBNM	Object Name	String	Generic Edit	10	0
70	F9860	Object Librarian Master Table	1	SI	OBNM	Object Name	String	Generic Edit	10	0
71	F9861	Object Librarian - Status Detail	1	SI	OBNM	Object Name	String	Generic Edit	10	0
72	F986101	Object Configuration Master	3	OM	OBNM	Object Name	String	Generic Edit	10	0
73	F9862	Object Librarian - Function Detail	1	SI	OBNM	Object Name	String	Generic Edit	10	0
74	F9863	Object Librarian- Object Relationships	1	SI	OBNM	Object Name	String	Generic Edit	10	0
75	F98710	Table Header	2	TH	OBNM	Object Name	String	Generic Edit	10	0
76	F98711	Table Columns	2	TD	OBNM	Object Name	String	Generic Edit	10	0
77	F98712	Primary Index Header	2	TP	OBNM	Object Name	String	Generic Edit	10	0
78	F98713	Primary Index Detail	2	TL	OBNM	Object Name	String	Generic Edit	10	0
79	F98720	Business View Specifications	1	BV	OBNM	Object Name	String	Generic Edit	10	0
80	F98740	Event Rules - Link Table	1	EL	OBNM	Object Name	String	Generic Edit	10	0
81	F98743	Data Structure Templates	1	DT	OBNM	Object Name	String	Generic Edit	10	0
82	F98745	Smart Field Named Mappings	1	SF	OBNM	Object Name	String	Generic Edit	10	0
83	F98750	Forms Design Aid Text Information	1	FT	OBNM	Object Name	String	Generic Edit	10	0
84	F98751	Forms Design Aid Specification Information	1	FS	OBNM	Object Name	String	Generic Edit	10	0
85	F98752	Forms Design Aid/Software Versions Repository Header Info.	1	AH	OBNM	Object Name	String	Generic Edit	10	0
86	F98753	Forms Design Aid/Software Versions Repository Detail Info.	1	AD	OBNM	Object Name	String	Generic Edit	10	0
87	F98760	Report Design Aid Text Information	1	RT	OBNM	Object Name	String	Generic Edit	10	0
88	F98761	Report Design Aid Specification Info	1	RS	OBNM	Object Name	String	Generic Edit	10	0
89	F98762	JDEBLC - Behavior Information	1	BC	OBNM	Object Name	String	Generic Edit	10	0
90	F9882	Checkout Log Table	10	CL	OBNM	Object Name	String	Generic Edit	10	0
91	F98950	User Overrides Table	3	UO	OBNM	Object Name	String	Generic Edit	10	0
TOPH93: Data Base and Communications
92	F93011	Transaction Based Pricing Control Table	1	TC	OBNM	Object Name	String	Generic Edit	10	0
93	F93012	Transaction Based Pricing Detail Data Table	1	TD	OBNM	Object Name	String	Generic Edit	10	0
94	F98613	Business View Environmental Server	2	OM	OBNM	Object Name	String	Generic Edit	10	0
TOPH94: Batch Engine
95	F986168	OSA Interface Usage	2	OH	OBNM	Object Name	String	Generic Edit	10	0
TOPH95: Object and Environment Tech
96	F00165	Media Objects storage	1	GD	OBNM	Object Name	String	Generic Edit	10	0
97	F00166	Media Object Categories	1	GT	OBNM	Object Name	String	Generic Edit	10	0
98	F00167	Media Object Category Constant	1	GT	OBNM	Object Name	String	Generic Edit	10	0
99	F00821	Menu Selections File	31	MZ	OBNM	Object Name	String	Generic Edit	10	0
100	F00950	Security Workbench Table	3	FS	OBNM	Object Name	String	Generic Edit	10	0
101	F00950W	Web Objects Security Workbench Table	5	WS	OBNM	Object Name	String	Generic Edit	10	0
102	F9500004	Audit Detail Table	2	AD	OBNM	Object Name	String	Generic Edit	10	0
103	F9500005	Temporary Audit Table	2	TA	OBNM	Object Name	String	Generic Edit	10	0
104	F9509210	Table to store Duplicate Behaivor ID records for FDA	1	ID	OBNM	Object Name	String	Generic Edit	10	0
105	F9509211	Table to store Duplicate Behaivor ID records for RDA	1	ID	OBNM	Object Name	String	Generic Edit	10	0
106	F9509220	FDA Text ID Change table	1	ID	OBNM	Object Name	String	Generic Edit	10	0
107	F9509221	Output Table for R8998751A Fix FDA Text ID Table Conversion	2	OT	OBNM	Object Name	String	Generic Edit	10	0
108	F95150	Index Selection Table	1	IS	OBNM	Object Name	String	Generic Edit	10	0
109	F95151	Index Selection Detail Table	1	ID	OBNM	Object Name	String	Generic Edit	10	0
110	F95155	Index Selection Log Table	2	IL	OBNM	Object Name	String	Generic Edit	10	0
111	F952400	User Generated Contents Detail	6	UC	OBNM	Object Name	String	Generic Edit	10	0
112	F952420	OneCenter Watchlists Detail	8	WL	OBNM	Object Name	String	Generic Edit	10	0
113	F952430	Advance Query	4	AQ	OBNM	Object Name	String	Generic Edit	10	0
114	F952440	Grid Formats Detail	4	GF	OBNM	Object Name	String	Generic Edit	10	0
115	F952450	CafeOne Layout Table	7	WO	OBNM	Object Name	String	Generic Edit	10	0
116	F952460	Default UDO Detail	4	UO	OBNM	Object Name	String	Generic Edit	10	0
117	F952471	Modified Web Object Metadata	8	XM	OBNM	Object Name	String	Generic Edit	10	0
118	F95400	Application Failure Recovery Header	4	AH	OBNM	Object Name	String	Generic Edit	10	0
119	F95401	Application Failure Recovery Detail	4	AD	OBNM	Object Name	String	Generic Edit	10	0
120	F95410	Application Failure Administration	4	TO	OBNM	Object Name	String	Generic Edit	10	0
121	F95610	Fusion Reporting UBE Associations	1	FU	OBNM	Object Name	String	Generic Edit	10	0
122	F980011	Cross - Reference Relationships	1	SI	OBNM	Object Name	String	Generic Edit	10	0
123	F980021	Cross Reference Field Relationships	1	SJ	OBNM	Object Name	String	Generic Edit	10	0
124	F980041	Data Tags for Mail Merge	5	DT	OBNM	Object Name	String	Generic Edit	10	0
125	F98601	Object Librarian Extensions Table	1	OE	OBNM	Object Name	String	Generic Edit	10	0
126	F98602	Business Service Details	1	SD	OBNM	Object Name	String	Generic Edit	10	0
127	F986020	Business Service Temporary Artifacts	1	TA	OBNM	Object Name	String	Generic Edit	10	0
128	F98603	Business Service Published Methods	1	SM	OBNM	Object Name	String	Generic Edit	10	0
129	F986030	Business Service Temporary Published Methods	1	PM	OBNM	Object Name	String	Generic Edit	10	0
130	F9860W	Web Object Master Table	9	WO	OBNM	Object Name	String	Generic Edit	10	0
131	F98881CF	DSS Specification Logging File	1	CF	OBNM	Object Name	String	Generic Edit	10	0
132	F98881CU	Specification Logging File	1	SM	OBNM	Object Name	String	Generic Edit	10	0
133	F98950D	User Overrides Language Table	3	LO	OBNM	Object Name	String	Generic Edit	10	0
134	F98DRLOG	Data Replication Change Log	3	DR	OBNM	Object Name	String	Generic Edit	10	0
135	F98DRPCN	Data Replication Pending Change Notifications	3	DR	OBNM	Object Name	String	Generic Edit	10	0
136	F98DRPUB	Data Replication Publisher	3	DR	OBNM	Object Name	String	Generic Edit	10	0
137	F98DRSUB	Data Replication Subscribers	3	DR	OBNM	Object Name	String	Generic Edit	10	0
TOPH96: Deployment
138	F96400	Sar grouping file for ESUs	6	SG	OBNM	Object Name	String	Generic Edit	10	0
TOPH96B: Package Build
139	F9631	Software Package Detail	2	PD	OBNM	Object Name	String	Generic Edit	10	0
140	F988259	MDK Table for UBE Locking	5	DB	OBNM	Object Name	String	Generic Edit	10	0
TOPH96U: Upgrade
141	F9672	Software Update Pathcode Information	4	SU	OBNM	Object Name	String	Generic Edit	10	0
142	F968902	TC Performance Estimation Detail Table	2	ED	OBNM	Object Name	String	Generic Edit	10	0
143	F969000	Change Table - Task Master	8	CM	OBNM	Object Name	String	Generic Edit	10	0
144	F969861	Object Change Table Definition	3	CT	OBNM	Object Name	String	Generic Edit	10	0
145	F9698710	Change Table - Tables	1	TA	OBNM	Object Name	String	Generic Edit	10	0
146	F9698712	Change Table - Indexes	1	IX	OBNM	Object Name	String	Generic Edit	10	0
147	F96UCUST	Customization Workbench Table	1	CW	OBNM	Object Name	String	Generic Edit	10	0
148	F98405	Table Conversion Scheduler	3	ST	OBNM	Object Name	String	Generic Edit	10	0
149	F984072	Table and Index Creation Log	1	CL	OBNM	Object Name	String	Generic Edit	10	0
150	F9843	Table Conversion - JDE Scheduler	1	JS	OBNM	Object Name	String	Generic Edit	10	0
151	F9843T	TC Schedule - Tag File	1	JS	OBNM	Object Name	String	Generic Edit	10	0
152	F986115	Table and Data Source Sizing Table	2	TD	OBNM	Object Name	String	Generic Edit	10	0
153	F9886	Install Package Detail	2	IP	OBNM	Object Name	String	Generic Edit	10	0
154	F98881	Specification Merge Logging File	1	SM	OBNM	Object Name	String	Generic Edit	10	0
155	F988810	SpecMerge Tracking	4	SM	OBNM	Object Name	String	Generic Edit	10	0
TOPH97: Benchmarking/Performance
156	F9720	AutoPilot Script Repository Table	7	TS	OBNM	Object Name	String	Generic Edit	10	0
157	F972053	AutoPilot Script Object Utilization Table	2	SO	OBNM	Object Name	String	Generic Edit	10	0
158	F979860	AutoPilot B732 F9860 Conversion Table	1	SI	OBNM	Object Name	String	Generic Edit	10	0
159	F979865	AutoPilot B732 F9865 Conversion Table	3	SW	OBNM	Object Name	String	Generic Edit	10	0
TOPH98: Internet
160	F986150	Server Transfer Package Contents	4	SP	OBNM	Object Name	String	Generic Edit	10	0
TOPH99: Product Version Control
161	F99099	FDA Cleanup - Data Items	1	FS	OBNM	Object Name	String	Generic Edit	10	0
162	F99RDDS	DSTMPL Records With ID Data Item Type	1	DS	OBNM	Object Name	String	Generic Edit	10	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

162 columns | 920 | OBNM