	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

56 columns | 920 | RT

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00091	Supplemental Database Data Types	10	T2	RT	User Defined Codes	String	Generic Edit	2	0
2	F0019	Generic Message/Rate Types	2	CG	RT	User Defined Codes	String	Generic Edit	2	0
3	F00191	Generic Message/Rates	2	CE	RT	User Defined Codes	String	Generic Edit	2	0
4	F00192	General Message Detail	2	CF	RT	User Defined Codes	String	Generic Edit	2	0
5	F0048	Code Mappings Master	2	CM	RT	User Defined Codes	String	Generic Edit	2	0
6	F00690	Cost Center Types of Data	5	M1	RT	User Defined Codes	String	Generic Edit	2	0
TOP01: Address Book
7	F01090	Supplemental Database - Core	6	A1	RT	User Defined Codes	String	Generic Edit	2	0
TOP05A: PeopleSoft HR & PR Foundation
8	F08096	HR Generic Table Headings	10	H$	RT	User Defined Codes	String	Generic Edit	2	0
TOP08: Human Resources
9	F05410	Employee E-Signature	6	ES	RT	User Defined Codes	String	Generic Edit	2	0
10	F080701	Fusion Lookup Map	12	LU	RT	User Defined Codes	String	Generic Edit	2	0
11	F080702	Fusion Entity Map	20	EM	RT	User Defined Codes	String	Generic Edit	2	0
12	F080703	Fusion Lookup Table	5	LT	RT	User Defined Codes	String	Generic Edit	2	0
13	F08090	HRM Supplemental Data Types	7	JX	RT	User Defined Codes	String	Generic Edit	2	0
TOP08C: PeopleSoft HR Canadian
14	F08021	Canadian Employment Equity	2	YY	RT	User Defined Codes	String	Generic Edit	2	0
TOP08U: PeopleSoft HR US
15	F08366	NDT - Key Employee Detail	18	HY	RT	User Defined Codes	String	Generic Edit	2	0
TOP09: General Accounting
16	F0907	Chart of Accounts Format	10	GY	RT	User Defined Codes	String	Generic Edit	2	0
TOP10: Financial Reporting
17	F10005	User Defined Code Control File	2	GO	RT	User Defined Codes	String	Generic Edit	2	0
TOP12: Fixed Assets
18	F12090	Asset Mgt Supplemental Database Types	5	F2	RT	User Defined Codes	String	Generic Edit	2	0
19	F1215	Specification Cross Reference	11	GV	RT	User Defined Codes	String	Generic Edit	2	0
TOP16: Profit Management (EPS)
20	F1620	Cost Object Types	9	CT	RT	User Defined Codes	String	Generic Edit	2	0
TOP31B: Blend Management
21	F31B0710	Harvest Assumptions	12	HA	RT	User Defined Codes	String	Generic Edit	2	0
TOP32: Configuration Management
22	F3291	Configured Item Segments	12	KW	RT	User Defined Codes	String	Generic Edit	2	0
TOP34A: Advanced Planning & Scheduling
23	F34A30	Order Status Definition Table	2	N0	RT	User Defined Codes	String	Generic Edit	2	0
TOP37: Quality Management
24	F3701	Test Definitions Master File	11	QA	RT	User Defined Codes	String	Generic Edit	2	0
25	F37013	Test Result Name	22	TR	RT	User Defined Codes	String	Generic Edit	2	0
26	F3711	Test Results	36	TR	RT	User Defined Codes	String	Generic Edit	2	0
27	F3711Z1	Test Results Unedited Transaction Table	49	SZ	RT	User Defined Codes	String	Generic Edit	2	0
28	F37900	Certificate of Analysis (COA) Extract	36	TR	RT	User Defined Codes	String	Generic Edit	2	0
29	F40318	Preference Profile - Quality Management	25	QC	RT	User Defined Codes	String	Generic Edit	2	0
TOP40: Inventory/OP Base
30	F40318R	Preference Resolution Ledger - Quality Management	27	QC	RT	User Defined Codes	String	Generic Edit	2	0
TOP40G: Grower Management
31	F40G151	Quality Result Limits	12	QL	RT	User Defined Codes	String	Generic Edit	2	0
TOP41: Inventory Management
32	F41090	Item Supplemental Data Types	6	T1	RT	User Defined Codes	String	Generic Edit	2	0
TOP41F: Apparel Management
33	FCW05	Collection Structure Definition	4	CS	RT	User Defined Codes	String	Generic Edit	2	0
TOP46L: License Plating
34	F46L010	License Plate Segments	10	LS	RT	User Defined Codes	String	Generic Edit	2	0
TOP48: Work Order Processing
35	F48090	WO Supplemental Data Types	6	W7	RT	User Defined Codes	String	Generic Edit	2	0
TOP49: Transportation Management
36	F490051	Generate Tracking Number Segment	10	XG	RT	User Defined Codes	String	Generic Edit	2	0
TOP74R: Russia
37	F74R0005	User Defined Codes - RUS - 00 - 74R	2	DR	RT	User Defined Codes	String	Generic Edit	2	0
TOP75I: India
38	F75I009	Item Attributes/Category Codes Mapping - IND - 41	2	IS	RT	User Defined Codes	String	Generic Edit	2	0
TOP76C: Colombia
39	F76C001	General Parameters - COL - 04	8	PG	RT	User Defined Codes	String	Generic Edit	2	0
40	F76C577	File to report - DIAN - Nit Max Minimal - COL - 04	4	CM	RT	User Defined Codes	String	Generic Edit	2	0
41	F76CT1	Tributary Information - COL - 76C	24	TI	RT	User Defined Codes	String	Generic Edit	2	0
TOPH79: Translation Tools
42	F00041	User Defined Code Types Language Status	2	LS	RT	User Defined Codes	String	Generic Edit	2	0
TOPH90: EnterpriseOne TOOLS
43	F9050	Rough Cut Answer Dependency	2	AX	RT	User Defined Codes	String	Generic Edit	2	0
44	F98882	Composer Rough Cut Selections	2	RC	RT	User Defined Codes	String	Generic Edit	2	0
45	F98885	Composer Industry and Geographical Regions	1	GI	RT	User Defined Codes	String	Generic Edit	2	0
46	F98887	Composer Industry and Geograhpic Locations Xref	1	PC	RT	User Defined Codes	String	Generic Edit	2	0
TOPH95: Object and Environment Tech
47	F0004	User Defined Code Types	2	DT	RT	User Defined Codes	String	Generic Edit	2	0
48	F0004D	User Defined Codes - Alternate Language Descriptions	2	DT	RT	User Defined Codes	String	Generic Edit	2	0
49	F0005	User Defined Code Values	2	DR	RT	User Defined Codes	String	Generic Edit	2	0
50	F0005D	User Defined Codes - Alternate Language Descriptions	2	DR	RT	User Defined Codes	String	Generic Edit	2	0
51	F82103	World Writer Query Output Print Fields	19	A2	RT	User Defined Codes	String	Generic Edit	2	0
52	F9593311	PM Metric Definition UDC Display (n/a)	3	PS	RT	User Defined Codes	String	Generic Edit	2	0
TOPH96U: Upgrade
53	F960004	Change Table - User Defined Code Types	4	CU	RT	User Defined Codes	String	Generic Edit	2	0
54	F960005	Change Table - User Defined Codes	4	CR	RT	User Defined Codes	String	Generic Edit	2	0
55	F964725	Special Instructions UDC Description	3	SI	RT	User Defined Codes	String	Generic Edit	2	0
56	F9746	Change Table - User Defined Codes	2	D$	RT	User Defined Codes	String	Generic Edit	2	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

56 columns | 920 | RT