	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

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

155 columns | 910 | OBNM