	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

52 columns | 812 | 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	Suplemental Data Base - CORE	6	A1	RT	User Defined Codes	String	Generic Edit	2	0
TOP05A: OW 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	F08090	HRM Supplemental Data Types	7	JX	RT	User Defined Codes	String	Generic Edit	2	0
TOP08C: OW HR Canadian
11	F08021	Canadian Employment Equity	2	YY	RT	User Defined Codes	String	Generic Edit	2	0
TOP08U: OW HR US
12	F08366	NDT - Key Employee Detail	18	HY	RT	User Defined Codes	String	Generic Edit	2	0
TOP09: General Accounting
13	F0907	Chart of Accounts Format	10	GY	RT	User Defined Codes	String	Generic Edit	2	0
TOP10: Financial Reporting
14	F10005	User Defined Code Control File	2	GO	RT	User Defined Codes	String	Generic Edit	2	0
TOP12: Fixed Assets
15	F12090	Asset Mgt Supplemental Database Types	5	F2	RT	User Defined Codes	String	Generic Edit	2	0
16	F1215	Specification Cross Reference	11	GV	RT	User Defined Codes	String	Generic Edit	2	0
TOP16: Profit Management (EPS)
17	F1620	Cost Object Types	9	CT	RT	User Defined Codes	String	Generic Edit	2	0
TOP31B: Blend Management
18	F31B0710	Harvest Assumptions	12	HA	RT	User Defined Codes	String	Generic Edit	2	0
TOP32: Configuration Management
19	F3291	Configured Item Segments	12	KW	RT	User Defined Codes	String	Generic Edit	2	0
TOP34A: Advanced Planning & Scheduling
20	F34A30	Order Status Definition Table	2	N0	RT	User Defined Codes	String	Generic Edit	2	0
TOP37: Quality Management
21	F3701	Test Definitions Master File	11	QA	RT	User Defined Codes	String	Generic Edit	2	0
22	F37013	Test Result Name	22	TR	RT	User Defined Codes	String	Generic Edit	2	0
23	F3711	Test Results	36	TR	RT	User Defined Codes	String	Generic Edit	2	0
24	F3711Z1	Test Results Unedited Transaction Table	49	SZ	RT	User Defined Codes	String	Generic Edit	2	0
25	F37900	Certificate of Analysis (COA) Extract	36	TR	RT	User Defined Codes	String	Generic Edit	2	0
26	F40318	Preference Profile - Quality Management	25	QC	RT	User Defined Codes	String	Generic Edit	2	0
TOP40: Inventory/OP Base
27	F40318R	Preference Resolution Ledger - Quality Management	27	QC	RT	User Defined Codes	String	Generic Edit	2	0
TOP40G: Grower Management
28	F40G151	Quality Result Limits	12	QL	RT	User Defined Codes	String	Generic Edit	2	0
TOP41: Inventory Management
29	F41090	Item Supplemental Data Types	6	T1	RT	User Defined Codes	String	Generic Edit	2	0
TOP46L: License Plating
30	F46L010	License Plate Segments	10	LS	RT	User Defined Codes	String	Generic Edit	2	0
TOP48: Work Order Processing
31	F48090	WO Supplemental Data Types	6	W7	RT	User Defined Codes	String	Generic Edit	2	0
TOP49: Transportation Management
32	F490051	Generate Tracking Number Segment	10	XG	RT	User Defined Codes	String	Generic Edit	2	0
TOP74R: CIS
33	F74R0005	User Defined Codes - RUS - 00 - 74R	2	DR	RT	User Defined Codes	String	Generic Edit	2	0
TOP76C: Colombia
34	F76C001	General Parameters - COL - 04	8	PG	RT	User Defined Codes	String	Generic Edit	2	0
35	F76C577	File to report - DIAN - Nit Max Minimal - COL - 04	4	CM	RT	User Defined Codes	String	Generic Edit	2	0
36	F76CT1	Tributary Information - COL - 76C	24	TI	RT	User Defined Codes	String	Generic Edit	2	0
TOPH79: CS - Forecasting
37	F00041	User Defined Code Types Language Status	2	LS	RT	User Defined Codes	String	Generic Edit	2	0
38	F00051	User Defined Codes Language Status	2	LS	RT	User Defined Codes	String	Generic Edit	2	0
TOPH90: ONEWORLD TOOLS
39	F9050	Rough Cut Answer Dependency	2	AX	RT	User Defined Codes	String	Generic Edit	2	0
40	F98882	Composer Rough Cut Selections	2	RC	RT	User Defined Codes	String	Generic Edit	2	0
41	F98885	Composer Industry and Geographical Regions	1	GI	RT	User Defined Codes	String	Generic Edit	2	0
42	F98887	Composer Industry and Geograhpic Locations Xref	1	PC	RT	User Defined Codes	String	Generic Edit	2	0
TOPH95: Tech Resources/Applications
43	F0004	User Defined Code Types	2	DT	RT	User Defined Codes	String	Generic Edit	2	0
44	F0004D	User Defined Codes - Alternate Language Descriptions	2	DT	RT	User Defined Codes	String	Generic Edit	2	0
45	F0005	User Defined Codes	2	DR	RT	User Defined Codes	String	Generic Edit	2	0
46	F0005D	User Defined Codes - Alternate Language Descriptions	2	DR	RT	User Defined Codes	String	Generic Edit	2	0
47	F82103	World Writer Query Output Print Fields	19	A2	RT	User Defined Codes	String	Generic Edit	2	0
48	F9593311	PM Metric Definition UDC Display (n/a)	3	PS	RT	User Defined Codes	String	Generic Edit	2	0
TOPH96: Deployment
49	F960004	Change Table - User Defined Code Types	4	CU	RT	User Defined Codes	String	Generic Edit	2	0
50	F960005	Change Table - User Defined Codes	4	CR	RT	User Defined Codes	String	Generic Edit	2	0
51	F9746	Change Table - User Defined Codes	2	D$	RT	User Defined Codes	String	Generic Edit	2	0
TOPH96U: Upgrade
52	F964725	Special Instructions UDC Description	3	SI	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

52 columns | 812 | RT