	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

109 columns | 920 | DTAI

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0040Z1	Error Message Log Table	9	ZB	DTAI	Data Item	String	Generic Edit	10	0
2	F0048	Code Mappings Master	3	CM	DTAI	Data Item	String	Generic Edit	10	0
TOP03B: Enhanced Accounts Receivable
3	F03BUI04	Work File for Integrity by Offset Account	7	W3	DTAI	Data Item	String	Generic Edit	10	0
TOP04: Accounts Payable
4	F0450	Payee Control	3	PC	DTAI	Data Item	String	Generic Edit	10	0
5	F04UI004	Integrity Report Worktable	7	RP	DTAI	Data Item	String	Generic Edit	10	0
TOP05: Time Accounting and HRM Base
6	F05005	Generic UBE File	4	GF	DTAI	Data Item	String	Generic Edit	10	0
7	F051400	Searchable Competency Fields	2	SF	DTAI	Data Item	String	Generic Edit	10	0
8	F051424	Competency Detail UDC Words	2	CD	DTAI	Data Item	String	Generic Edit	10	0
9	F051425	Competency Detail Words	2	CD	DTAI	Data Item	String	Generic Edit	10	0
TOP05A: PeopleSoft HR & PR Foundation
10	F05004	Common Settings for HR Employee Self Service Programs	1	SC	DTAI	Data Item	String	Generic Edit	10	0
11	F06041	Specify Future Data Fields	2	JK	DTAI	Data Item	String	Generic Edit	10	0
12	F06045	Employee Master - Mass Changes	1	BB	DTAI	Data Item	String	Generic Edit	10	0
13	F08041	Select Data Items for History Tracking	2	JU	DTAI	Data Item	String	Generic Edit	10	0
14	F08042	HR History	3	JW	DTAI	Data Item	String	Generic Edit	10	0
TOP06: Payroll (old) - Obsolete-do not reuse
15	F06042	Future Data EE Master Revisions	3	JO	DTAI	Data Item	String	Generic Edit	10	0
TOP07: Payroll
16	F06271	Retro Processing Selection	3	JQ	DTAI	Data Item	String	Generic Edit	10	0
17	F07811	Negative Amount Workfile	10	JE	DTAI	Data Item	String	Generic Edit	10	0
18	F07826	Additional Parameters	3	JB	DTAI	Data Item	String	Generic Edit	10	0
TOP08: Human Resources
19	F080703	Fusion Lookup Table	6	LT	DTAI	Data Item	String	Generic Edit	10	0
20	F08721	Employee Status Change Details	2	SD	DTAI	Data Item	String	Generic Edit	10	0
21	F08731	Employee Status Change Setup Detail	2	SL	DTAI	Data Item	String	Generic Edit	10	0
TOP08B: Benefits Administration
22	F08320D	Plan Master Tag Table	5	PD	DTAI	Data Item	String	Generic Edit	10	0
23	F08500	Enrollment Event Setup	5	ES	DTAI	Data Item	String	Generic Edit	10	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
24	F08045	Employee Turnover Analysis	1	HT	DTAI	Data Item	String	Generic Edit	10	0
TOP09: General Accounting
25	F0907	Chart of Accounts Format	11	GY	DTAI	Data Item	String	Generic Edit	10	0
26	F09305	OVFS Row Definition Grouping Elements Table	1	GR	DTAI	Data Item	String	Generic Edit	10	0
TOP12: Fixed Assets
27	F12911ER	Post G/L to FA Exceptions Work File	17	GL	DTAI	Data Item	String	Generic Edit	10	0
TOP16: Profit Management (EPS)
28	F1620	Cost Object Types	5	CT	DTAI	Data Item	String	Generic Edit	10	0
29	F1630	Driver Definitions	6	CD	DTAI	Data Item	String	Generic Edit	10	0
30	F16UI001	Enabled Tables by Application work file	4	CA	DTAI	Data Item	String	Generic Edit	10	0
TOP17C: Call Management
31	F1759	Case Required Fields	6	CL	DTAI	Data Item	String	Generic Edit	10	0
TOP18: Timecard Automation
32	F186101	Field and Function Definitions	5	FD	DTAI	Data Item	String	Generic Edit	10	0
TOP31B: Blend Management
33	F31B0800	F31B0800 Recalculation Error Handling	6	RE	DTAI	Data Item	String	Generic Edit	10	0
TOP32: Configuration Management
34	F3291	Configured Item Segments	9	KW	DTAI	Data Item	String	Generic Edit	10	0
TOP40: Inventory/OP Base
35	F40711	Preference Values Definition	5	PD	DTAI	Data Item	String	Generic Edit	10	0
36	F40721	Preference Values Detail	5	PV	DTAI	Data Item	String	Generic Edit	10	0
37	F40741	Preference Adjustment History	8	PH	DTAI	Data Item	String	Generic Edit	10	0
38	F40UI801	Generic Error Table	17	ZB	DTAI	Data Item	String	Generic Edit	10	0
TOP40R: Demand Scheduling
39	F40R30WF	Demand Work File	27	DS	DTAI	Data Item	String	Generic Edit	10	0
TOP41: Inventory Management
40	F4101H	Item Hierarchy (Web)	6	IH	DTAI	Data Item	String	Generic Edit	10	0
TOP41B: Bulk Stock Management
41	F415091	Four-Point Temperature Maintenance	5	PG	DTAI	Data Item	String	Generic Edit	10	0
TOP45: Advanced Pricing
42	F45511	Search Agent Directives Detail	2	SD	DTAI	Data Item	String	Generic Edit	10	0
43	F45511W	Search Agent Directives Work File	5	SW	DTAI	Data Item	String	Generic Edit	10	0
44	F4572Z1	Live Promotions Interface - Inbound / Outbound	31	LP	DTAI	Data Item	String	Generic Edit	10	0
45	F4572ZP	Purge Live Promotions Interface	31	PG	DTAI	Data Item	String	Generic Edit	10	0
TOP47: Electronic Commerce
46	F47003	EDI Discrepancy Report Work File	14	SX	DTAI	Data Item	String	Generic Edit	10	0
47	F471411	Purchase Order Edit Object Log Table	8	SZ	DTAI	Data Item	String	Generic Edit	10	0
TOP48S: Service Billing
48	F48051	Invoice Sequence/Summarization Table Detail	2	WK	DTAI	Data Item	String	Generic Edit	10	0
49	F48091	Billing System Constants	20	WZ	DTAI	Data Item	String	Generic Edit	10	0
50	F4848	Sequence/Summarization Data Item Table	1	SQ	DTAI	Data Item	String	Generic Edit	10	0
TOP49: Transportation Management
51	F49T70W	Corporations Staging Work Table	3	CW	DTAI	Data Item	String	Generic Edit	10	0
52	F49T80W	Locations Staging Work Table	3	LW	DTAI	Data Item	String	Generic Edit	10	0
TOP51X: In-Memory Project Management
53	F51X30	Project Advisor Results Header	9	PB	DTAI	Data Item	String	Generic Edit	10	0
TOP53: Change Management
54	F53005	Job Specific UDC's Master Table	2	D1	DTAI	Data Item	String	Generic Edit	10	0
TOP70: Multi-National Products
55	F7000110	Detail Localization Additional Data	4	DA	DTAI	Data Item	String	Generic Edit	10	0
TOP74: EMEA Localization
56	F74101W	Additional Address Book & Vat Id Info Work File - EU - 01	14	VW	DTAI	Data Item	String	Generic Edit	10	0
TOP74U: United Kingdom Localizations
57	F74U0429	SPL Cross Reference Table - UK - 43	1	CR	DTAI	Data Item	String	Generic Edit	10	0
TOP76A: Argentina
58	F76AUI51	Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A	10	IK	DTAI	Data Item	String	Generic Edit	10	0
TOP76H: Chile
59	F76HUI33	Workfile for R76H3B40 - CHI - 42 - 76H	15	WF	DTAI	Data Item	String	Generic Edit	10	0
TOP76P: Peru
60	F76PUI45	Workfile VAT Purchasing Ledger - PER - 04 - 76P	10	WF	DTAI	Data Item	String	Generic Edit	10	0
TOP79A: Greenhouse Gas Accounting
61	F79A14	GHG Ledger Energy & Emissions Recalculation Error Workfile	3	EW	DTAI	Data Item	String	Generic Edit	10	0
TOP81: DREAM Writer
62	F81A122	Dream Writer Processing Option Interim File F59012 - F81A122	14	M4	DTAI	Data Item	String	Generic Edit	10	0
TOP81A: DREAMWriter Conversion Tool
63	F81A01	DW Master Parameters Conversion Table	16	M1	DTAI	Data Item	String	Generic Edit	10	0
64	F81A10	DW Log File - OneWorld	14	ME	DTAI	Data Item	String	Generic Edit	10	0
65	F81A11E	Migration Aid PO Value Validation Error log	11	ME	DTAI	Data Item	String	Generic Edit	10	0
TOP89: Conversion Programs
66	F32UI002	Needed for upgrade from Xe and below	4	WY	DTAI	Data Item	String	Generic Edit	10	0
67	F89701	List of Data Items Not Used in FDA	1	PB	DTAI	Data Item	String	Generic Edit	10	0
68	F89702	List of Data Items Not Used in RDA	1	PB	DTAI	Data Item	String	Generic Edit	10	0
TOP98: Technical Tools
69	F05WMM02	Web Mail Merge Data Structure Detail	4	DD	DTAI	Data Item	String	Generic Edit	10	0
70	F9201	Data Field Specifications	1	FR	DTAI	Data Item	String	Generic Edit	10	0
71	F9204	Data Item Aliases	1	FR	DTAI	Data Item	String	Generic Edit	10	0
72	F9205	Data Dictionary - Error Message Program ID	1	FR	DTAI	Data Item	String	Generic Edit	10	0
TOPF31K: DFM Kanban Management
73	FF31K25	DFM Kanban Master -- TEMP	25	KM	DTAI	Data Item	String	Generic Edit	10	0
TOPH79: Translation Tools
74	F79751	Forms Design Aid Extracted Spec	13	FS	DTAI	Data Item	String	Generic Edit	10	0
75	F79761	Report Design Aid Extracted Spec	14	RS	DTAI	Data Item	String	Generic Edit	10	0
76	F92021	Data Dictionary Row Description Language Status	1	LS	DTAI	Data Item	String	Generic Edit	10	0
77	F92031	Data Dictionary Alpha Description Language Status	1	LS	DTAI	Data Item	String	Generic Edit	10	0
TOPH90: EnterpriseOne TOOLS
78	F98850	Argument Mapping	6	AR	DTAI	Data Item	String	Generic Edit	10	0
TOPH91: Design Tools
79	F91410	Report Director Templates Sequence Items	3	DS	DTAI	Data Item	String	Generic Edit	10	0
80	F91420	Report Director Templates Smart Field Activation	2	SM	DTAI	Data Item	String	Generic Edit	10	0
81	F91430	Smart Field Template Criteria	2	SC	DTAI	Data Item	String	Generic Edit	10	0
82	F984052	Table Conversion - History Log	20	SH	DTAI	Data Item	String	Generic Edit	10	0
TOPH95: Object and Environment Tech
83	F00950	Security Workbench Table	4	FS	DTAI	Data Item	String	Generic Edit	10	0
84	F91510	Tip Details for Tip of the Day	5	TD	DTAI	Data Item	String	Generic Edit	10	0
85	F9200	Data Item Master	1	FR	DTAI	Data Item	String	Generic Edit	10	0
86	F9202	Data Field Display Text	1	FR	DTAI	Data Item	String	Generic Edit	10	0
87	F9203	Data Item Alpha Descriptions	1	FR	DTAI	Data Item	String	Generic Edit	10	0
88	F9207	Data Dictionary - Error Message Information	1	FR	DTAI	Data Item	String	Generic Edit	10	0
89	F9210	Data Field Specifications (OneWorld)	1	FR	DTAI	Data Item	String	Generic Edit	10	0
90	F9211	Data Dictionary - Smart Fields	1	FR	DTAI	Data Item	String	Generic Edit	10	0
91	F9212	Smart Field Criteria-Setup Rules	1	SF	DTAI	Data Item	String	Generic Edit	10	0
92	F980041	Data Tags for Mail Merge	4	DT	DTAI	Data Item	String	Generic Edit	10	0
93	F98881CF	DSS Specification Logging File	14	CF	DTAI	Data Item	String	Generic Edit	10	0
94	F98881CU	Specification Logging File	14	SM	DTAI	Data Item	String	Generic Edit	10	0
TOPH96I: EnterpriseOne Installs
95	F99410	OneWorld System Control File	2	OC	DTAI	Data Item	String	Generic Edit	10	0
TOPH96U: Upgrade
96	F964726	Special Instructions DD Glossary	3	SI	DTAI	Data Item	String	Generic Edit	10	0
97	F9691410	Change Table - Report Director Template Sequence	5	DT	DTAI	Data Item	String	Generic Edit	10	0
98	F9691420	Change Table - Smart Field Activity	5	SM	DTAI	Data Item	String	Generic Edit	10	0
99	F9691430	Change Table - Smart Field Criteria	5	SM	DTAI	Data Item	String	Generic Edit	10	0
100	F9691510	Change Table - Tips of the Day Detail	5	TP	DTAI	Data Item	String	Generic Edit	10	0
101	F9755	Change Table - Data Item Master	1	D$	DTAI	Data Item	String	Generic Edit	10	0
102	F9757	Change Table - Data Item Alpha Description	1	D$	DTAI	Data Item	String	Generic Edit	10	0
103	F9759	Change Table - Error Message Pgm Call	1	D$	DTAI	Data Item	String	Generic Edit	10	0
104	F9760	Change Table - OneWorld Data Field Specification	1	D$	DTAI	Data Item	String	Generic Edit	10	0
105	F98405	Table Conversion Scheduler	27	ST	DTAI	Data Item	String	Generic Edit	10	0
106	F98881	Specification Merge Logging File	18	SM	DTAI	Data Item	String	Generic Edit	10	0
TOPH99: Product Version Control
107	F99099	FDA Cleanup - Data Items	8	FS	DTAI	Data Item	String	Generic Edit	10	0
108	F99101	Data Dictionary Duplicate OWDI - Work File	1	DI	DTAI	Data Item	String	Generic Edit	10	0
109	F99RDDS	DSTMPL Records With ID Data Item Type	4	DS	DTAI	Data Item	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

109 columns | 920 | DTAI