	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

99 columns | 812 | 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
TOP01RS: Rapid Start
3	F01RS010	Rapid Start Reporting Workfile	10	RR	DTAI	Data Item	String	Generic Edit	10	0
TOP03B: Enhanced Accounts Receivable
4	F03BUI04	Work File for Integrity by Offset Account	7	W3	DTAI	Data Item	String	Generic Edit	10	0
TOP04: Accounts Payable
5	F0450	Payee Control File	3	PC	DTAI	Data Item	String	Generic Edit	10	0
6	F04UI004	Integrity Report Table F04UI004	7	RP	DTAI	Data Item	String	Generic Edit	10	0
TOP05: Time Accounting and HRM Base
7	F05005	Generic UBE File	4	GF	DTAI	Data Item	String	Generic Edit	10	0
8	F051400	Searchable Competency Fields	2	SF	DTAI	Data Item	String	Generic Edit	10	0
9	F051424	Competency Detail UDC Words	2	CD	DTAI	Data Item	String	Generic Edit	10	0
10	F051425	Competency Detail Words	2	CD	DTAI	Data Item	String	Generic Edit	10	0
TOP05A: OW HR & PR Foundation
11	F05004	Common Settings for HR Employee Self Service Programs	1	SC	DTAI	Data Item	String	Generic Edit	10	0
12	F06041	Specify Future Data Fields	2	JK	DTAI	Data Item	String	Generic Edit	10	0
13	F06045	Employee Master - Mass Changes	1	BB	DTAI	Data Item	String	Generic Edit	10	0
14	F08041	Select Data Items for History Tracking	2	JU	DTAI	Data Item	String	Generic Edit	10	0
15	F08042	HR History	3	JW	DTAI	Data Item	String	Generic Edit	10	0
TOP06: Payroll (old) - Obsolete-do not reuse
16	F06042	Future Data EE Master Revisions	3	JO	DTAI	Data Item	String	Generic Edit	10	0
TOP07: Payroll
17	F06271	Retro Processing Selection	3	JQ	DTAI	Data Item	String	Generic Edit	10	0
18	F07811	Negative Amount Workfile	10	JE	DTAI	Data Item	String	Generic Edit	10	0
19	F07826	Additional Parameters	3	JB	DTAI	Data Item	String	Generic Edit	10	0
TOP08: Human Resources
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
TOP12: Fixed Assets
26	F12911ER	Post G/L to FA Exceptions Work File	17	GL	DTAI	Data Item	String	Generic Edit	10	0
TOP16: Profit Management (EPS)
27	F1620	Cost Object Types	5	CT	DTAI	Data Item	String	Generic Edit	10	0
28	F1630	Driver Definitions	6	CD	DTAI	Data Item	String	Generic Edit	10	0
29	F16UI001	Enabled Tables by Application work file	4	CA	DTAI	Data Item	String	Generic Edit	10	0
TOP17C: Call Management
30	F1759	Call Required Fields	6	CL	DTAI	Data Item	String	Generic Edit	10	0
TOP18: Resource Scheduling
31	F186101	Field and Function Definitions	5	FD	DTAI	Data Item	String	Generic Edit	10	0
TOP31B: Blend Management
32	F31B0800	F31B0800 Recalculation Error Handling	6	RE	DTAI	Data Item	String	Generic Edit	10	0
TOP32: Configuration Management
33	F3291	Configured Item Segments	9	KW	DTAI	Data Item	String	Generic Edit	10	0
34	F32UI002	External Data Item Work File	4	WY	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
TOP53: Change Management
51	F53005	Job Specific UDC's Master Table	2	D1	DTAI	Data Item	String	Generic Edit	10	0
TOP76A: Argentina
52	F76AUI51	Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A	10	IK	DTAI	Data Item	String	Generic Edit	10	0
TOP76H: Chile
53	F76HUI33	Workfile for R76H3B40 - CHI - 42 - 76H	15	WF	DTAI	Data Item	String	Generic Edit	10	0
TOP76P: Peru
54	F76PUI45	Workfile VAT Purchasing Ledger - PER - 04 - 76P	10	WF	DTAI	Data Item	String	Generic Edit	10	0
TOP81: DREAM Writer
55	F81A122	Dream Writer Processing Option Interim File F59012 - F81A122	14	M4	DTAI	Data Item	String	Generic Edit	10	0
TOP81A: DREAMWriter Conversion Tool
56	F81A01	DW Master Parameters Conversion Table	16	M1	DTAI	Data Item	String	Generic Edit	10	0
57	F81A10	DW Log File - OneWorld	14	ME	DTAI	Data Item	String	Generic Edit	10	0
58	F81A11E	Migration Aid PO Value Validation Error log	11	ME	DTAI	Data Item	String	Generic Edit	10	0
TOP89: Conversion Programs
59	F89701	List of Data Items Not Used in FDA	1	PB	DTAI	Data Item	String	Generic Edit	10	0
60	F89702	List of Data Items Not Used in RDA	1	PB	DTAI	Data Item	String	Generic Edit	10	0
TOP98: Technical Tools
61	F05WMM02	Web Mail Merge Data Structure Detail	4	DD	DTAI	Data Item	String	Generic Edit	10	0
62	F9201	Data Field Specifications	1	FR	DTAI	Data Item	String	Generic Edit	10	0
63	F9204	Data Item Aliases	1	FR	DTAI	Data Item	String	Generic Edit	10	0
64	F9205	Data Dictionary - Error Message Program ID	1	FR	DTAI	Data Item	String	Generic Edit	10	0
TOPF31K: DFM Kanban Management
65	FF31K25	DFM Kanban Master -- TEMP	25	KM	DTAI	Data Item	String	Generic Edit	10	0
TOPH79: CS - Forecasting
66	F79751	Forms Design Aid Extracted Spec Information - Translations	13	FS	DTAI	Data Item	String	Generic Edit	10	0
67	F79761	Report Design Aid Extracted Spec Information - Translations	14	RS	DTAI	Data Item	String	Generic Edit	10	0
68	F92021	Data Dictionary Row Description Language Status	1	LS	DTAI	Data Item	String	Generic Edit	10	0
69	F92031	Data Dictionary Alpha Description Language Status	1	LS	DTAI	Data Item	String	Generic Edit	10	0
TOPH90: ONEWORLD TOOLS
70	F98850	Argument Mapping	6	AR	DTAI	Data Item	String	Generic Edit	10	0
TOPH91: Design Tools
71	F91410	Report Director Templates Sequence Items	3	DS	DTAI	Data Item	String	Generic Edit	10	0
72	F91420	Report Director Templates Smart Field Activation	2	SM	DTAI	Data Item	String	Generic Edit	10	0
73	F91430	Smart Field Template Criteria	2	SC	DTAI	Data Item	String	Generic Edit	10	0
74	F984052	Table Conversion - History Log	20	SH	DTAI	Data Item	String	Generic Edit	10	0
TOPH95: Tech Resources/Applications
75	F00950	Security Workbench Table	4	FS	DTAI	Data Item	String	Generic Edit	10	0
76	F91510	Tip Details for Tip of the Day	5	TD	DTAI	Data Item	String	Generic Edit	10	0
77	F9200	Data Item Master	1	FR	DTAI	Data Item	String	Generic Edit	10	0
78	F9202	Data Field Display Text	1	FR	DTAI	Data Item	String	Generic Edit	10	0
79	F9203	Data Item Alpha Descriptions	1	FR	DTAI	Data Item	String	Generic Edit	10	0
80	F9207	Data Dictionary - Error Message Information	1	FR	DTAI	Data Item	String	Generic Edit	10	0
81	F9210	Data Field Specifications (OneWorld)	1	FR	DTAI	Data Item	String	Generic Edit	10	0
82	F9211	Data Dictionary - Smart Fields	1	FR	DTAI	Data Item	String	Generic Edit	10	0
83	F9212	Smart Field Criteria-Setup Rules	1	SF	DTAI	Data Item	String	Generic Edit	10	0
84	F980041	Data Tags for Mail Merge	4	DT	DTAI	Data Item	String	Generic Edit	10	0
TOPH96: Deployment
85	F9691410	Change Table - Report Director Template Sequence	5	DT	DTAI	Data Item	String	Generic Edit	10	0
86	F9691420	Change Table - Smart Field Activity	5	SM	DTAI	Data Item	String	Generic Edit	10	0
87	F9691430	Change Table - Smart Field Criteria	5	SM	DTAI	Data Item	String	Generic Edit	10	0
88	F9691510	Change Table - Tips of the Day Detail	5	TP	DTAI	Data Item	String	Generic Edit	10	0
89	F9755	Change Table - Data Item Master	1	D$	DTAI	Data Item	String	Generic Edit	10	0
90	F9757	Change Table - Data Item Alpha Description	1	D$	DTAI	Data Item	String	Generic Edit	10	0
91	F9759	Change Table - Error Message Pgm Call	1	D$	DTAI	Data Item	String	Generic Edit	10	0
92	F9760	Change Table - OneWorld Data Field Specification	1	D$	DTAI	Data Item	String	Generic Edit	10	0
93	F98405	Table Conversion Scheduler	27	ST	DTAI	Data Item	String	Generic Edit	10	0
94	F98881	Specification Merge Logging File	18	SM	DTAI	Data Item	String	Generic Edit	10	0
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
TOPH99: Product Version Control
97	F99099	FDA Cleanup - Data Items	8	FS	DTAI	Data Item	String	Generic Edit	10	0
98	F99101	Data Dictionary Duplicate OWDI - Work File	1	DI	DTAI	Data Item	String	Generic Edit	10	0
99	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

99 columns | 812 | DTAI