	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

171 columns | 920 | LNGP | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006D	Business Unit Alternate Description Master	2	LJ	LNGP	Language	String	UDC	2	0
2	F0006DZ1	Business Unit Alternate Description Z file	16	SZ	LNGP	Language	String	UDC	2	0
3	F00090D	Supplemental Database Language Preferences	2	T5	LNGP	Language	String	UDC	2	0
4	F0012D	AAI Alternate Description Master	3	LJ	LNGP	Language	String	UDC	2	0
5	F0039M	Generated Document Media Object History	6	GH	LNGP	Language	String	UDC	2	0
6	F5192D	Supplier Analysis Alternate Language Description	3	JC	LNGP	Language	String	UDC	2	0
TOP01: Address Book
7	F0101	Address Book Master	8	AB	LNGP	Language	String	UDC	2	0
8	F0101Z2	Address Book - Interoperability	21	SZ	LNGP	Language	String	UDC	2	0
TOP03B: Enhanced Accounts Receivable
9	F03B28	Letter Text	3	RJ	LNGP	Language	String	UDC	2	0
TOP05: Time Accounting and HRM Base
10	F051124	Director Text Setup File	4	Y4	LNGP	Language	String	UDC	2	0
11	F051421	Word Index	2	WI	LNGP	Language	String	UDC	2	0
12	F05430	ESS User Defined Text	5	UT	LNGP	Language	String	UDC	2	0
13	F069016T	Payroll Tax Area Profile - Tag File	4	YP	LNGP	Language	String	UDC	2	0
TOP05A: PeopleSoft HR & PR Foundation
14	F060117	Employee Master - International Data	7	YA	LNGP	Language	String	UDC	2	0
TOP08: Human Resources
15	F05401	Self-Service Process Flow Director Text	5	DT	LNGP	Language	String	UDC	2	0
16	F0800612	User Defined Job Competency Description Reference	2	JC	LNGP	Language	String	UDC	2	0
17	F085540	Benefits Enrollment Plan/Option URL Address	5	PU	LNGP	Language	String	UDC	2	0
18	F087711B	Performance Appraisal Header Template Keys	8	XK	LNGP	Language	String	UDC	2	0
19	F08776	CBPA Appraisal Templates	6	XO	LNGP	Language	String	UDC	2	0
TOP08B: Benefits Administration
20	F085518	Benefit Confirmation Statement Options	3	SO	LNGP	Language	String	UDC	2	0
TOP09: General Accounting
21	F0901D	Account Master - Alternate Description	1	LK	LNGP	Language	String	UDC	2	0
22	F09340	OVFS Statement Version Setup Table	14	VS	LNGP	Language	String	UDC	2	0
TOP12: Fixed Assets
23	F1201D	Asset Master - Alternate Description	2	LJ	LNGP	Language	String	UDC	2	0
24	F1215	Specification Cross Reference	3	GV	LNGP	Language	String	UDC	2	0
TOP15: Real Estate Management
25	F150120D	Tenant Exclusion - Alternate Description	2	NW	LNGP	Language	String	UDC	2	0
26	F150122D	Share Factor Denominator - Alternate Description	2	NY	LNGP	Language	String	UDC	2	0
27	F15019D	Billing Frequency - Alternate Description	2	NL	LNGP	Language	String	UDC	2	0
28	F1501BD	Lease Master Header - Alternate Description	3	NE	LNGP	Language	String	UDC	2	0
29	F1502BD	Recurring Billings Master - Alternate Description	3	NF	LNGP	Language	String	UDC	2	0
30	F1506D	Floor Master - Alternate Description	5	OP	LNGP	Language	String	UDC	2	0
31	F1507D	Unit Master - Alternate Description	3	NH	LNGP	Language	String	UDC	2	0
32	F1512D	Billing Code Extension - Alternate Description	3	NA	LNGP	Language	String	UDC	2	0
33	F1514D	Area Master - Alternate Description	8	NW	LNGP	Language	String	UDC	2	0
34	F1521D	Log Detail Master - Alternate Description	2	NB	LNGP	Language	String	UDC	2	0
35	F1523D	Log Standards Master - Alternate Description	2	OG	LNGP	Language	String	UDC	2	0
36	F1530HD	E.P. Class Master Alternate Description	2	HD	LNGP	Language	String	UDC	2	0
37	F1531D	Expense Participation Class Adj. - Alternate Description	3	OM	LNGP	Language	String	UDC	2	0
38	F1544BD	Sales Analysis Control - Alternate Description	2	OB	LNGP	Language	String	UDC	2	0
39	F157011D	Lease Option Type Header - Alternate Description	2	NA	LNGP	Language	String	UDC	2	0
40	F157012D	Lease Option Type Detail - Alternate Description	3	NC	LNGP	Language	String	UDC	2	0
41	F15702D	Legal Clause Space Detail - Alternate Description	5	NF	LNGP	Language	String	UDC	2	0
42	F159071D	Market/Potential/Renewal Rent Master - Alternate Description	5	NY	LNGP	Language	String	UDC	2	0
TOP17: Customer Service Management
43	F4801TZ2	Warranty Claim/Supplier Recovery processing	77	WQ	LNGP	Language	String	UDC	2	0
44	F48161	Failure Analysis Codes	3	KC	LNGP	Language	String	UDC	2	0
TOP17C: Call Management
45	F1754	Case Provider Group Routing Rules	8	ZB	LNGP	Language	String	UDC	2	0
46	F1755	Case Master	21	ZA	LNGP	Language	String	UDC	2	0
TOP40: Inventory/OP Base
47	F4001Z	Batch Receiver File - Order Headings	97	SY	LNGP	Language	String	UDC	2	0
48	F4016	Print Messages	6	TU	LNGP	Language	String	UDC	2	0
49	F40241D	UNSPSC Code Alternate Description	2	CA	LNGP	Language	String	UDC	2	0
50	F4201Z1	Sales Order Header Unedited Transaction File	86	SY	LNGP	Language	String	UDC	2	0
TOP41: Inventory Management
51	F410014D	Template Master - Alternative Description	3	T8	LNGP	Language	String	UDC	2	0
52	F41008D	Matrix Detail Alternate Language	4	S0	LNGP	Language	String	UDC	2	0
53	F4101D	Item Master - Alternative Description	4	IM	LNGP	Language	String	UDC	2	0
54	F4101HD	Item Hierarchy - Alternate Description	3	IH	LNGP	Language	String	UDC	2	0
TOP41F: Apparel Management
55	FCW16	Work File F4016	3	WF	LNGP	Language	String	UDC	2	0
TOP42: Sales Management
56	F4201	Sales Order Header File	73	SH	LNGP	Language	String	UDC	2	0
57	F42019	Sales Order Header History File	73	SH	LNGP	Language	String	UDC	2	0
58	F42UI01	SO Header Cache File (MBF)	78	ZH	LNGP	Language	String	UDC	2	0
TOP43: Procurement
59	F4301	Purchase Order Header	70	PH	LNGP	Language	String	UDC	2	0
60	F4301Z	PO Header Work File	74	PA	LNGP	Language	String	UDC	2	0
61	F4301Z1	Purchase Order Header Unedited Transaction Table	83	SY	LNGP	Language	String	UDC	2	0
TOP47: Electronic Commerce
62	F47011	EDI Purchase Order Header - Inbound	84	SY	LNGP	Language	String	UDC	2	0
63	F47016	EDI Purchase Order Header - Outbound	85	SY	LNGP	Language	String	UDC	2	0
64	F47021	EDI P.O. Acknowledgment Header - Inbound	85	SY	LNGP	Language	String	UDC	2	0
65	F47026	EDI P.O. Acknowledgment Header - Outbound	80	SY	LNGP	Language	String	UDC	2	0
66	F47031	EDI Shipping Notice Header - Inbound	80	SY	LNGP	Language	String	UDC	2	0
67	F470373	EDI ASN Shipping	26	AG	LNGP	Language	String	UDC	2	0
68	F47046	EDI Invoice Header (Sales) - Outbound	80	SY	LNGP	Language	String	UDC	2	0
69	F47071	EDI Receiving Advice Header - Inbound	86	SY	LNGP	Language	String	UDC	2	0
70	F47076	EDI Receiving Advice Header - Outbound	86	SY	LNGP	Language	String	UDC	2	0
71	F47091	EDI Request for Quote Header - Inbound	84	SY	LNGP	Language	String	UDC	2	0
72	F47096	EDI Request for Quote Header - Outbound	85	SY	LNGP	Language	String	UDC	2	0
73	F47101	EDI Response to RFQ Header - Inbound	85	SY	LNGP	Language	String	UDC	2	0
74	F47106	EDI Response to RFQ Header - Outbound	80	SY	LNGP	Language	String	UDC	2	0
75	F47131	EDI Purchase Order Change Header - Inbound	81	SY	LNGP	Language	String	UDC	2	0
76	F47136	EDI Purchase Order Change Header - Outbound	85	SY	LNGP	Language	String	UDC	2	0
77	F47141	EDI P.O. Change Acknowledgment Header - Inbound	86	SY	LNGP	Language	String	UDC	2	0
78	F47146	EDI P.O. Change Acknowledgment Header - Outbound	81	SY	LNGP	Language	String	UDC	2	0
79	F47156	EDI Shipping Schedule Header - Outbound	89	SY	LNGP	Language	String	UDC	2	0
80	F4716	EDI Item Text - Inbound/Outbound	17	SZ	LNGP	Language	String	UDC	2	0
TOP48: Work Order Processing
81	F4801ST	Purge - Work Order Master Tag File	64	WA	LNGP	Language	String	UDC	2	0
82	F4801T	Work Order Master Tag File	64	WA	LNGP	Language	String	UDC	2	0
83	F4817	Service Order Extension	18	SR	LNGP	Language	String	UDC	2	0
TOP74: EMEA Localization
84	F7430030	Legal Document Header (Print Info) - COMM - 03B	28	PI	LNGP	Language	String	UDC	2	0
TOP74U: United Kingdom Localizations
85	F74U0430	Authenticated Receipts Letter Text - UK - 43	4	SG	LNGP	Language	String	UDC	2	0
TOP81: DREAM Writer
86	F81A122	Dream Writer Processing Option Interim File F59012 - F81A122	12	M4	LNGP	Language	String	UDC	2	0
TOP81A: DREAMWriter Conversion Tool
87	F81A10	DW Log File - OneWorld	12	ME	LNGP	Language	String	UDC	2	0
TOP83: Management Reporting - FASTR
88	F83100	Date Title	2	DT	LNGP	Language	String	UDC	2	0
89	F83110	Column Headings	2	CH	LNGP	Language	String	UDC	2	0
90	F83110B	52 Period Column Headings	2	CH	LNGP	Language	String	UDC	2	0
TOP89: Conversion Programs
91	F98950T	TC Temporary table for AQ, CAFE1	8	WO	LNGP	Language	String	UDC	2	0
92	F99302	Processing Options Text Table	10	PO	LNGP	Language	String	UDC	2	0
93	F993022	Processing Options Error Table	10	PO	LNGP	Language	String	UDC	2	0
94	F993023	Translated Processing Options Text Table	10	PO	LNGP	Language	String	UDC	2	0
TOP90CA: CRM Foundation
95	F90CA24E	Simple Template Alternate Key	4	SK	LNGP	Language	String	UDC	2	0
TOPH79: Translation Tools
96	F00041	User Defined Code Types Language Status	3	LS	LNGP	Language	String	UDC	2	0
97	F001651	Generic Text Language Status	3	LS	LNGP	Language	String	UDC	2	0
98	F00831	Menu Text Overrides Language Status	3	LS	LNGP	Language	String	UDC	2	0
99	F7901	Language Master	2	LM	LNGP	Language	String	UDC	2	0
100	F7910	Translations Suggestions	2	TS	LNGP	Language	String	UDC	2	0
101	F7920	Resource Text Translation Work File	7	RT	LNGP	Language	String	UDC	2	0
102	F79201	Resource Text Translation Language Status	7	LS	LNGP	Language	String	UDC	2	0
103	F79750	Forms Design Aid Extracted Text	3	FT	LNGP	Language	String	UDC	2	0
104	F797501	Forms Design Aid Extracted Text Language Status	3	LS	LNGP	Language	String	UDC	2	0
105	F79760	Report Design Aid Extracted Text	4	RT	LNGP	Language	String	UDC	2	0
106	F797601	Report Design Aid Extracted Spec Language Status	4	LS	LNGP	Language	String	UDC	2	0
107	F831001	FASTR Date/Title Language Status	2	LS	LNGP	Language	String	UDC	2	0
108	F831101	FASTR Column Headings Language Status	2	LS	LNGP	Language	String	UDC	2	0
109	F90021	Task Master Language Status	2	LS	LNGP	Language	String	UDC	2	0
110	F90051	Variant Description Language Status	7	LS	LNGP	Language	String	UDC	2	0
111	F90061	Variant Detail Language Status	7	LS	LNGP	Language	String	UDC	2	0
112	F90601	Component Definition Language Status	2	LS	LNGP	Language	String	UDC	2	0
113	F90611	Workspace Definition Language Status	2	LS	LNGP	Language	String	UDC	2	0
114	F90621	Top Navigation Definition Language Status	2	LS	LNGP	Language	String	UDC	2	0
115	F911001	Favorites Language Status	1	LS	LNGP	Language	String	UDC	2	0
116	F92021	Data Dictionary Row Description Language Status	2	LS	LNGP	Language	String	UDC	2	0
117	F92031	Data Dictionary Alpha Description Language Status	2	LS	LNGP	Language	String	UDC	2	0
118	F983061	Processing Option Text Language Status	5	LS	LNGP	Language	String	UDC	2	0
119	F989501	User Override Language Translation Table	9	LS	LNGP	Language	String	UDC	2	0
120	F99301	Interleaf Processing Option Download Work File	2	PO	LNGP	Language	String	UDC	2	0
TOPH90: EnterpriseOne TOOLS
121	F9002	Task Alternate Descriptions	2	TD	LNGP	Language	String	UDC	2	0
122	F9005D	Variant Description Alternate Description	7	VK	LNGP	Language	String	UDC	2	0
123	F9006D	Variant Detail Alternate Description	7	DK	LNGP	Language	String	UDC	2	0
124	F9030	Documentation Cross Reference	3	DI	LNGP	Language	String	UDC	2	0
125	F98800D	Process Master Alternate Description	3	PK	LNGP	Language	String	UDC	2	0
126	F98800DN	Process Master Alternate Description - Net Change	5	PK	LNGP	Language	String	UDC	2	0
127	F98810D	Task Master Alternate Description	4	AK	LNGP	Language	String	UDC	2	0
128	F98810DN	Task Master Alternate Description - Net Change	6	AK	LNGP	Language	String	UDC	2	0
TOPH91: Design Tools
129	F91100D	Favorites - Alternative Description	1	FD	LNGP	Language	String	UDC	2	0
TOPH92: Interactive Engine/OL
130	F00165T	Media Object Conversion Table	3	GD	LNGP	Language	String	UDC	2	0
131	F00941	Environment Detail - One World	13	LM	LNGP	Language	String	UDC	2	0
132	F9060D	Component Definition - Alternate Description	2	CD	LNGP	Language	String	UDC	2	0
133	F9061D	Workspace Definition - Alternate Description	2	WD	LNGP	Language	String	UDC	2	0
134	F9062D	Top-Level Navigation Icon Definition - Alternate Description	2	ID	LNGP	Language	String	UDC	2	0
135	F9063D	Secondary Navigation Definition - Alternate Description	3	SD	LNGP	Language	String	UDC	2	0
136	F98220D	OMW Project Descriptions	2	PD	LNGP	Language	String	UDC	2	0
137	F98306	Processing Option Text	5	PT	LNGP	Language	String	UDC	2	0
138	F98750	Forms Design Aid Text Information	4	FT	LNGP	Language	String	UDC	2	0
139	F98760	Report Design Aid Text Information	4	RT	LNGP	Language	String	UDC	2	0
140	F98950	User Overrides Table	8	UO	LNGP	Language	String	UDC	2	0
TOPH95: Object and Environment Tech
141	F0004D	User Defined Codes - Alternate Language Descriptions	3	DT	LNGP	Language	String	UDC	2	0
142	F0005D	User Defined Codes - Alternate Language Descriptions	4	DR	LNGP	Language	String	UDC	2	0
143	F00165	Media Objects storage	5	GD	LNGP	Language	String	UDC	2	0
144	F0083	Menu Text Override File	3	MT	LNGP	Language	String	UDC	2	0
145	F00921	User Display Preferences	2	UL	LNGP	Language	String	UDC	2	0
146	F00926	Anonymous User Access Table	4	AU	LNGP	Language	String	UDC	2	0
147	F89000	Translation Contant	1	T1	LNGP	Language	String	UDC	2	0
148	F9202	Data Field Display Text	2	FR	LNGP	Language	String	UDC	2	0
149	F9203	Data Item Alpha Descriptions	2	FR	LNGP	Language	String	UDC	2	0
150	F9500002	Reason Codes	2	RC	LNGP	Language	String	UDC	2	0
151	F952400	User Generated Contents Detail	7	UC	LNGP	Language	String	UDC	2	0
152	F952420	OneCenter Watchlists Detail	19	WL	LNGP	Language	String	UDC	2	0
153	F952440	Grid Formats Detail	8	GF	LNGP	Language	String	UDC	2	0
154	F952460	Default UDO Detail	9	UO	LNGP	Language	String	UDC	2	0
155	F95900D	PM System Definition Language (PSPMSYSDEFN_LNG)	2	PS	LNGP	Language	String	UDC	2	0
156	F959310D	PM Event Set Language (PSPMEVENTSET_LN)	2	PS	LNGP	Language	String	UDC	2	0
157	F959311D	PM Event Definition Language (PSPMEVENT_LNG)	3	PS	LNGP	Language	String	UDC	2	0
158	F959320D	PM Transaction Set Language (PSPMTRANSSET_LN)	2	PS	LNGP	Language	String	UDC	2	0
159	F959321D	PM Transaction Definition Language (PSPMTRANS_LNG)	3	PS	LNGP	Language	String	UDC	2	0
160	F959331D	PM Metric Definition Language (PSPMMETRIC_LNG)	2	PS	LNGP	Language	String	UDC	2	0
161	F959332D	PM Metric Value Language (PSPMMETRICVALUE_LN)	3	PS	LNGP	Language	String	UDC	2	0
162	F959341D	PM Context Defenition Language (PSPMCONTEXTDEFN_LNG)	2	PS	LNGP	Language	String	UDC	2	0
163	F9860WD	Web Object Language Descriptions Table	2	WD	LNGP	Language	String	UDC	2	0
164	F98950D	User Overrides Language Table	8	LO	LNGP	Language	String	UDC	2	0
165	F98980	Font Override by Language	1	FT	LNGP	Language	String	UDC	2	0
TOPH96U: Upgrade
166	F964726	Special Instructions DD Glossary	4	SI	LNGP	Language	String	UDC	2	0
167	F96491	Language_OMW groupings detail	2	LG	LNGP	Language	String	UDC	2	0
168	F967611	Software Update Language Table	2	SL	LNGP	Language	String	UDC	2	0
169	F969002	Change Table - Task Translation	2	CT	LNGP	Language	String	UDC	2	0
170	F9757	Change Table - Data Item Alpha Description	2	D$	LNGP	Language	String	UDC	2	0
171	F984031	Language Plan by Environment	3	PL	LNGP	Language	String	UDC	2	0

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

TOPUDC 01 / LP (Language) stock values

	Value	Description	Special Handling Code	Hard Coded
1		Domestic Language		N
2	1	North America Public Services		N
3	1B	Single Byte Search Description		Y
4	AR	Arabic		N
5	BG	Bulgarian		N
6	C	Czech		N
7	CS	Chinese Simplified		N
8	CT	Chinese Traditional		N
9	DN	Danish		N
10	DU	Dutch		N
11	E	English		N
12	F	French		N
13	FN	Finnish		N
14	G	German		N
15	GR	Greek		N
16	HR	Croatian		N
17	HU	Hungarian		N
18	I	Italian		N
19	J	Japanese	3	N
20	KO	Korean		N
21	NO	Norwegian		N
22	P	Portuguese		N
23	PO	Polish		N
24	RO	Romanian		N
25	RU	Russian		N
26	S	Spanish		N
27	TR	Turkish		N
28	W	Swedish		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

171 columns | 920 | LNGP | STOCK UDC

TOPUDC 01 / LP (Language) stock values