	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

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

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

164 columns | 812 | LNGP | STOCK UDC

TOPUDC 01 / LP (Language) stock values