	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

33 columns | 920 | AT1 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00091	Supplemental Database Data Types	25	T2	AT1	Search Type	String	UDC	3	0
2	F17001	Service/Warranty Constants Table - F17001	12	CS	AT1	Search Type	String	UDC	3	0
TOP01: Address Book
3	F0101	Address Book Master	9	AB	AT1	Search Type	String	UDC	3	0
4	F0101Z2	Address Book - Interoperability	22	SZ	AT1	Search Type	String	UDC	3	0
5	F01090	Supplemental Database - Core	2	A1	AT1	Search Type	String	UDC	3	0
6	F01092	Supplemental Database - Code	3	A2	AT1	Search Type	String	UDC	3	0
7	F01093	Supplemental Database - Narrative	2	A3	AT1	Search Type	String	UDC	3	0
8	F01138	AB Data Permission List Definitions	3	DS	AT1	Search Type	String	UDC	3	0
TOP03: Accounts Receivable
9	F0311	Accounts Receivable Ledger	121	RP	AT1	Search Type	String	UDC	3	0
TOP03B: Enhanced Accounts Receivable
10	F03B465	A/R Netting Workfile	45	RO	AT1	Search Type	String	UDC	3	0
TOP04: Accounts Payable
11	F04514	1099 Merged Worktables (F045141:F045143)	6	G1	AT1	Search Type	String	UDC	3	0
12	F045141	1099 G/L Worktable	6	G1	AT1	Search Type	String	UDC	3	0
13	F045143	1099 A/P Worktable	6	G1	AT1	Search Type	String	UDC	3	0
TOP05: Time Accounting and HRM Base
14	F085590	Disability and Veteran Status History Table	3	DS	AT1	Search Type	String	UDC	3	0
15	F085590W	Disability Status Work Table	8	DS	AT1	Search Type	String	UDC	3	0
16	F085605W	Veteran Status Work Table	9	VS	AT1	Search Type	String	UDC	3	0
TOP05A: PeopleSoft HR & PR Foundation
17	F060116Z	Unedited Quick Hire Transaction File	20	SZ	AT1	Search Type	String	UDC	3	0
TOP08: Human Resources
18	F08090	HRM Supplemental Data Types	21	JX	AT1	Search Type	String	UDC	3	0
TOP43Q: Strategic Sourcing
19	F43Q30	Event Invited Bidders	12	EV	AT1	Search Type	String	UDC	3	0
20	F43Q90	Sourcing Constants	4	SC	AT1	Search Type	String	UDC	3	0
TOP47: Electronic Commerce
21	F47056	EDI Payment Order Header - Outbound	54	D1	AT1	Search Type	String	UDC	3	0
22	F47056W	EDI Payment Order Header - Work	54	D1	AT1	Search Type	String	UDC	3	0
TOP49: Transportation Management
23	F49T80	Locations Staging Table	2	LC	AT1	Search Type	String	UDC	3	0
TOP74L: Portugal
24	F74LUI01	Referential Account Details - Temp Table - 74L	4	TT	AT1	Search Type	String	UDC	3	0
TOP76B: Brazil
25	F76B20	Account Payable and Receivable Table - IN68 - 03B	2	PR	AT1	Search Type	String	UDC	3	0
26	F76B30	Nota Fiscal Header/Table for Goods - IN68 - 42	7	MM	AT1	Search Type	String	UDC	3	0
27	F76B31	Nota Fiscal Detail/Table for Goods - IN68 - 42	5	IM	AT1	Search Type	String	UDC	3	0
28	F76B40	Nota Fiscal Header/Table for Services - IN68 - 42	7	MS	AT1	Search Type	String	UDC	3	0
29	F76B41	Nota Fiscal Detail/Table for Services - IN68 - 42	5	IS	AT1	Search Type	String	UDC	3	0
30	F76B70	Physical and Legal Person Table - IN68 - 42	2	FJ	AT1	Search Type	String	UDC	3	0
TOP89: Conversion Programs
31	F01111	Contact Information	3	WN	AT1	Search Type	String	UDC	3	0
32	F01111Z1	Batch - Contact Information	31	CB	AT1	Search Type	String	UDC	3	0
TOP90CA: CRM Foundation
33	F90CA50B	MEMBER PERSON Table	5	ME	AT1	Search Type	String	UDC	3	0

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 01 / ST (Search Type) stock values

	Value	Description	Hard Coded
1	A	Applicants	N
2	B	Bidder	N
3	C	Customers	N
4	CMQ	Case Provider Group	Y
5	D	Competitor	Y
6	DL	Workflow Distribution List	Y
7	E	Employees	N
8	EXU	Excise Unit	N
9	F	Facilities	N
10	I	Investors	N
11	J	Jobs	N
12	JP	Junction Point/Port	N
13	LI	Delivery Address	N
14	M	Mail Distribution List	N
15	N	New Hire	N
16	O	Company	N
17	P	Prospects	N
18	PA	Partner	N
19	Q	Participants	N
20	R	Role	Y
21	S	Subcontractors	N
22	SG	Sales Group	Y
23	SVQ	Service Order Queue	Y
24	T	Tenants	N
25	TAX	Tax Authorities	N
26	TC	Transportation Carriers	N
27	V	Suppliers	N
28	W	Warehouse	N
29	X	Ex-employees	N
30	Z2	Data Rep Test	N

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

33 columns | 920 | AT1 | STOCK UDC

TOPUDC 01 / ST (Search Type) stock values