	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

92 columns | 910 | CTR | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0030	Bank Transit Master	26	AY	CTR	Country	String	UDC	3	0
2	F004201	Prepayment Transaction Table	29	PT	CTR	Country	String	UDC	3	0
3	F0070	Country Constants Master File	1	CK	CTR	Country	String	UDC	3	0
TOP01: Address Book
4	F0101Z2	Address Book - Interoperability	93	SZ	CTR	Country	String	UDC	3	0
5	F0116	Address by Date	14	AL	CTR	Country	String	UDC	3	0
6	F01161	Alternate Address	13	WL	CTR	Country	String	UDC	3	0
7	F01161DW	Customer Alternate Address Export	16	DW	CTR	Country	String	UDC	3	0
8	F01161Z1	Batch - Alternative Address	26	LB	CTR	Country	String	UDC	3	0
9	F0117	Postal Codes	5	A8	CTR	Country	String	UDC	3	0
TOP05: Time Accounting and HRM Base
10	F054101	Employee Personal Profile Information History Table	21	EH	CTR	Country	String	UDC	3	0
11	F054101W	Employee Personal Profile Information Work Table	21	EP	CTR	Country	String	UDC	3	0
12	F054111	Employee Emergency Contact History Table	12	CH	CTR	Country	String	UDC	3	0
13	F054111W	Employee Emergency Contact Work Table	12	EC	CTR	Country	String	UDC	3	0
TOP05A: OW HR & PR Foundation
14	F05003	Verification of Employment Data	18	EV	CTR	Country	String	UDC	3	0
15	F060116Z	Unedited Quick Hire Transaction File	76	SZ	CTR	Country	String	UDC	3	0
TOP07: Payroll
16	F074001	New Hire Reporting Workfile - OneWorld Only	19	NH	CTR	Country	String	UDC	3	0
17	F07880	SUI Magnetic Media Workfile	35	YW	CTR	Country	String	UDC	3	0
18	F07900	Non Calendar Tax Fiscal Date Patterns	1	NC	CTR	Country	String	UDC	3	0
19	F07940	Set Vertex Tax Table	4	YY	CTR	Country	String	UDC	3	0
20	F8907444	New Hire Detail File Transfer - Texas (44)	15	TX	CTR	Country	String	UDC	3	0
TOP08A: eRecruit
21	F08490	Recruitment Information	13	RI	CTR	Country	String	UDC	3	0
TOP08B: Benefits Administration
22	F0833WF	Benefit Statement Work file	12	WF	CTR	Country	String	UDC	3	0
TOP08H: Health and Safety
23	F08601	Injury/Illness Case Master	43	HL	CTR	Country	String	UDC	3	0
24	F08601B	Injury/Illness Case Master Tag Table	2	IT	CTR	Country	String	UDC	3	0
TOP09E: Expense Reimbursment
25	F09E105	Tax Mapping	3	TM	CTR	Country	String	UDC	3	0
TOP12: Fixed Assets
26	F1217	Equipment Master Extension	2	WR	CTR	Country	String	UDC	3	0
27	F1217P	Equipment Master Extension Purge Table	2	WR	CTR	Country	String	UDC	3	0
28	F1217Z1	Unedited Equipment Tag Transactions	15	WR	CTR	Country	String	UDC	3	0
29	F1217Z2	Unedited Equipment Tag Transactions	15	WR	CTR	Country	String	UDC	3	0
TOP13C: Condition-Base Maintenance
30	F1310	Condition-Based Alerts	55	CA	CTR	Country	String	UDC	3	0
31	F1310Z1	Unedited Condition-Based Alerts	69	CB	CTR	Country	String	UDC	3	0
TOP15: Property Management
32	F1507	Unit Master	21	NH	CTR	Country	String	UDC	3	0
TOP17: Customer Service Management
33	F17113	Assessor Defaults	3	AD	CTR	Country	String	UDC	3	0
34	F1791	Entitlement Dates	6	EM	CTR	Country	String	UDC	3	0
35	F4801TZ2	Warranty Claim/Supplier Recovery processing	73	WQ	CTR	Country	String	UDC	3	0
TOP17C: Call Management
36	F17111	Base Warranty Defaults	3	BC	CTR	Country	String	UDC	3	0
37	F17311	Equipment Master Location Details	21	LD	CTR	Country	String	UDC	3	0
38	F1755	Case Master	36	ZA	CTR	Country	String	UDC	3	0
TOP31B: Blend Management
39	F31B01	Winery Master	9	WI	CTR	Country	String	UDC	3	0
TOP40: Inventory/OP Base
40	F4006	Order Address Information	16	OA	CTR	Country	String	UDC	3	0
41	F4006Z	Batch Order Receiver - Order Address Information	16	OY	CTR	Country	String	UDC	3	0
42	F40333	Preference Profile - Carrier	22	CA	CTR	Country	String	UDC	3	0
43	F40334	Preference Profile - Mode of Transport	21	MT	CTR	Country	String	UDC	3	0
44	F4215	Shipment Header	38	XH	CTR	Country	String	UDC	3	0
TOP40R: Demand Scheduling
45	F40R14	Demand Addresses	15	DA	CTR	Country	String	UDC	3	0
46	F40R143	Demand Address History	14	DS	CTR	Country	String	UDC	3	0
47	F471722	EDI Demand Addresses	24	EA	CTR	Country	String	UDC	3	0
TOP47: Electronic Commerce
48	F47037	EDI Shipping Notice Detail - Outbound	212	SZ	CTR	Country	String	UDC	3	0
49	F470373	EDI ASN Shipping	25	AG	CTR	Country	String	UDC	3	0
50	F470374	EDI ASN Demand Addresses	26	AM	CTR	Country	String	UDC	3	0
51	F470561	EDI Payment Order Bank N & A - Outbound	32	D2	CTR	Country	String	UDC	3	0
52	F470561W	EDI Payment Order Bank N & A - Work	32	D2	CTR	Country	String	UDC	3	0
53	F470562	EDI Payment Order Vendor N & A - Outbound	32	D4	CTR	Country	String	UDC	3	0
54	F470562W	EDI Payment Order Vendor N & A - Work	32	D4	CTR	Country	String	UDC	3	0
55	F470563	EDI Payment Order Payee N & A - Outbound	32	D5	CTR	Country	String	UDC	3	0
56	F470563W	EDI Payment Order Payee N & A - Work	32	D5	CTR	Country	String	UDC	3	0
57	F4706	EDI Order Address Information	26	ZA	CTR	Country	String	UDC	3	0
58	F47081	EDI Price Sales Catalog Header - Inbound	29	FV	CTR	Country	String	UDC	3	0
TOP48: Work Order Processing
59	F4801ST	Purge - Work Order Master Tag File	60	WA	CTR	Country	String	UDC	3	0
60	F4801T	Work Order Master Tag File	60	WA	CTR	Country	String	UDC	3	0
61	F4817	Service Order Extension	14	SR	CTR	Country	String	UDC	3	0
TOP49: Transportation Management
62	F49020	Vehicle/Staff License Information	7	VL	CTR	Country	String	UDC	3	0
63	F4950	Routing Entries	13	RT	CTR	Country	String	UDC	3	0
64	F4951	Carrier Zone Definitions	8	ZN	CTR	Country	String	UDC	3	0
65	F4960	Load Header	12	TM	CTR	Country	String	UDC	3	0
66	F49T50	Order Release Location Staging	21	LO	CTR	Country	String	UDC	3	0
67	F49T80	Locations Staging Table	17	LC	CTR	Country	String	UDC	3	0
TOP54HS: Health & Safety Incident Mgt
68	F54HS01	Incident Master	28	S1	CTR	Country	String	UDC	3	0
69	F54HS01M	Incident Master Change History	31	I1	CTR	Country	String	UDC	3	0
70	F54HS02	Incident People	46	S2	CTR	Country	String	UDC	3	0
71	F54HS02M	Incident People Change History	49	I2	CTR	Country	String	UDC	3	0
TOP70: Multi-National Products - obsolete-do not reuse
72	F700030	International Bank Account Number - COMM - 70	3	IB	CTR	Country	String	UDC	3	0
TOP74: EMEA Localization
73	F7430031	Legal Document Address (Print Info) - COMM - 03B	16	PI	CTR	Country	String	UDC	3	0
74	F74900	Foreign Receivables and Payables - EMEA	10	RP	CTR	Country	String	UDC	3	0
TOP74R: CIS
75	F74R0018	Russian Tax File - 74R	57	TD	CTR	Country	String	UDC	3	0
TOP74U: United Kingdom Localizations
76	F74U4052	Subcontractor Detail - CIS Monthly Return - UK - 04	9	SM	CTR	Country	String	UDC	3	0
77	F74UUI52	Subcontractor Detail - XML WF CIS Monthly Return - UK - 04	9	SM	CTR	Country	String	UDC	3	0
TOP74Y: Italy - Reporting System Only
78	F74Y010	Black List Setup by Country Tax Area	1	BL	CTR	Country	String	UDC	3	0
79	F74Y015	Yearly List Declaration - WF - IT - 00	14	YL	CTR	Country	String	UDC	3	0
80	F74Y020	Italy Intrastat Declarations - Header - ITA - 00	7	IH	CTR	Country	String	UDC	3	0
81	F74Y021	Italy Intrastat Declarations - Detail Sections - ITA - 00	13	ID	CTR	Country	String	UDC	3	0
TOP75A: Australia - Reporting System Only
82	F75A0010	Australian Employee Termination Details	62	A0	CTR	Country	String	UDC	3	0
TOP76A: Argentina
83	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	31	C6	CTR	Country	String	UDC	3	0
TOP76H: Chile
84	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	16	PI	CTR	Country	String	UDC	3	0
TOP79A: Greenhouse Gas Accounting
85	F79A09	GHG Energy Rates	27	ER	CTR	Country	String	UDC	3	0
86	F79A10	GHG Rates	31	ER	CTR	Country	String	UDC	3	0
87	F79A11	GHG Ledger	34	GR	CTR	Country	String	UDC	3	0
88	F79A11Z1	GHG Ledger - Batch File	52	GL	CTR	Country	String	UDC	3	0
89	F79A12	GHG Ledger Audit	35	GR	CTR	Country	String	UDC	3	0
90	F79A75	GHG Organization Name	12	GO	CTR	Country	String	UDC	3	0
91	F79AU11	GHG Ledger Work Table	37	GR	CTR	Country	String	UDC	3	0
TOPH95: Tech Resources/Applications
92	F00921	User Display Preferences	9	UL	CTR	Country	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 00 / CN (Country Codes) stock values

	Value	Description	Hard Coded
1		.	N
2	AE	UNITED ARAB EMIRATES	N
3	AN	NETHERLANDS ANTILLES	N
4	AZ	AZERBAIJAN	N
5	BA	BOSNIA	N
6	BB	BARBADOS	N
7	BD	BANGLADESH	N
8	BE	BELGIUM	N
9	BF	BURKINA FASO	N
10	BG	BULGARIA	N
11	BH	BAHRAIN	N
12	BI	BURUNDI	N
13	BJ	BENIN	N
14	BM	BERMUDA	N
15	BN	BRUNEI	N
16	BO	BOLIVIA	N
17	BR	BRAZIL	N
18	BS	BAHAMAS	N
19	BT	BHUTAN	N
20	BW	BOTSWANA	N
21	BY	BELARUS	N
22	BZ	BELIZE	N
23	CA	CANADA	N
24	CD	CONGO,	N
25	CF	CENTRAL AFRICAN	N
26	CG	CONGO	N
27	CH	SWITZERLAND	N
28	CI	COTE D'IVOIRE	N
29	CK	COOK ISLANDS	N
30	CL	CHILE	N
31	CM	CAMEROON	N
32	CN	CHINA,	N
33	CO	COLOMBIA	N
34	CR	COSTA RICA	N
35	CU	CUBA	N
36	CV	CAPE VERDE	N
37	CY	CYPRUS	N
38	CZ	CZECH REPUBLIC, THE	N
39	DE	GERMANY	N
40	DJ	DJIBOUTI	N
41	DK	DENMARK	N
42	DM	DOMINICA	N
43	DO	DOMINICAN REPUBLIC	N
44	EC	ECUADOR	N
45	EE	ESTONIA	N
46	EG	EGYPT	N
47	ER	ERITREA	N
48	ES	SPAIN	N
49	ET	ETHIOPIA	N
50	FI	FINLAND	N
51	FJ	FIJI	N
52	FK	FALKLAND ISLANDS	N
53	FM	MICRONESIA,	N
54	FO	FAROE ISLANDS	N
55	FR	FRANCE	N
56	GA	GABON	N
57	GB	UNITED KINGDOM	N
58	GD	GRENADA	N
59	GE	GEORGIA	N
60	GF	FRENCH GUYANA	N
61	GG	GUERNSEY	N
62	GH	GHANA	N
63	GI	GIBRALTAR	N
64	GL	GREENLAND	N
65	GM	GAMBIA	N
66	GN	GUINEA REPUBLIC	N
67	GP	GUADELOUPE	N
68	GQ	GUINEA-EQUATORIAL	N
69	GR	GREECE	N
70	GT	GUATEMALA	N
71	GU	GUAM	N
72	GW	GUINEA-BISSAU	N
73	GY	GUYANA (BRITISH)	N
74	HK	HONG KONG	N
75	HN	HONDURAS	N
76	HR	CROATIA	N
77	HT	HAITI	N
78	HU	HUNGARY	N
79	IC	CANARY ISLANDS, THE	N
80	ID	INDONESIA	N
81	IE	IRELAND, REPUBLIC OF	N
82	IL	ISRAEL	N
83	IN	INDIA	N
84	IQ	IRAQ	N
85	IR	IRAN (ISLAMIC REPUBLIC OF)	N
86	IS	ICELAND	N
87	IT	ITALY	N
88	JE	JERSEY	N
89	JM	JAMAICA	N
90	JO	JORDAN	N
91	JP	JAPAN	N
92	KE	KENYA	N
93	KG	KYRGYZSTAN	N
94	KH	CAMBODIA	N
95	KI	KIRIBATI	N
96	KM	COMOROS	N
97	KN	ST. KITTS	N
98	KP	KOREA, THE D.P.R OF	N
99	KR	KOREA, REPUBLIC OF	N
100	KV	KOSOVO	N
101	KW	KUWAIT	N
102	KY	CAYMAN ISLANDS	N
103	KZ	KAZAKHSTAN	N
104	LA	LAO PEOPLE'S	N
105	LB	LEBANON	N
106	LC	ST. LUCIA	N
107	LI	LIECHTENSTEIN	N
108	LK	SRI LANKA	N
109	LR	LIBERIA	N
110	LS	LESOTHO	N
111	LT	LITHUANIA	N
112	LU	LUXEMBOURG	N
113	LV	LATVIA	N
114	LY	LIBYA	N
115	MA	MOROCCO	N
116	MC	MONACO	N
117	MD	MOLDOVA, REPUBLIC OF	N
118	ME	MONTENEGRO,	N
119	MG	MADAGASCAR	N
120	MH	MARSHALL ISLANDS	N
121	MK	MACEDONIA,	N
122	ML	MALI	N
123	MM	MYANMAR	N
124	MN	MONGOLIA	N
125	MO	MACAU	N
126	MP	SAIPAN	N
127	MQ	MARTINIQUE	N
128	MR	MAURITANIA	N
129	MS	MONTSERRAT	N
130	MT	MALTA	N
131	MU	MAURITIUS	N
132	MV	MALDIVES	N
133	MW	MALAWI	N
134	MX	MEXICO	N
135	MY	MALAYSIA	N
136	MZ	MOZAMBIQUE	N
137	NA	NAMIBIA	N
138	NC	NEW CALEDONIA	N
139	NE	NIGER	N
140	NG	NIGERIA	N
141	NI	NICARAGUA	N
142	NL	NETHERLANDS, THE	N
143	NO	NORWAY	N
144	NP	NEPAL	N
145	NR	NAURU, REPUBLIC OF	N
146	NU	NIUE	N
147	NZ	NEW ZEALAND	N
148	OM	OMAN	N
149	PA	PANAMA	N
150	PE	PERU	N
151	PF	TAHITI	N
152	PG	PAPUA NEW GUINEA	N
153	PH	PHILIPPINES, THE	N
154	PK	PAKISTAN	N
155	PL	POLAND	N
156	PR	PUERTO RICO	N
157	PT	PORTUGAL	N
158	PW	PALAU	N
159	PY	PARAGUAY	N
160	QA	QATAR	N
161	RE	REUNION, ISLAND OF	N
162	RO	ROMANIA	N
163	RS	SERBIA, REPUBLIC OF	N
164	RU	RUSSIAN FEDERATION, THE	N
165	RW	RWANDA	N
166	SA	SAUDI ARABIA	N
167	SB	SOLOMON ISLANDS	N
168	SC	SEYCHELLES	N
169	SD	SUDAN	N
170	SE	SWEDEN	N
171	SG	SINGAPORE	N
172	SI	SLOVENIA	N
173	SK	SLOVAKIA	N
174	SL	SIERRA LEONE	N
175	SM	SAN MARINO	N
176	SN	SENEGAL	N
177	SO	SOMALIA	N
178	SR	SURINAME	N
179	ST	SAO TOME AND PRINCIPE	N
180	SV	EL SALVADOR	N
181	SY	SYRIA	N
182	SZ	SWAZILAND	N
183	TC	TURKS AND CAICOS ISLANDS	N
184	TD	CHAD	N
185	TG	TOGO	N
186	TH	THAILAND	N
187	TJ	TAJIKISTAN	N
188	TM	TURKMENISTAN	N
189	TN	TUNISIA	N
190	TO	TONGA	N
191	TP	EAST TIMOR	N
192	TR	TURKEY	N
193	TT	TRINIDAD AND TOBAGO	N
194	TV	TUVALU	N
195	TW	TAIWAN	N
196	TZ	TANZANIA	N
197	UA	UKRAINE	N
198	UG	UGANDA	N
199	US	UNITED STATES OF AMERICA	N
200	UY	URUGUAY	N
201	UZ	UZBEKISTAN	N
202	VC	ST. VINCENT	N
203	VE	VENEZUELA	N
204	VG	VIRGIN ISLANDS (BRITISH)	N
205	VI	VIRGIN ISLANDS (US)	N
206	VN	VIETNAM	N
207	VU	VANUATU	N
208	WS	SAMOA	N
209	XB	BONAIRE	N
210	XC	CURACAO	N
211	XE	ST. EUSTATIUS	N
212	XM	ST. MAARTEN	N
213	XN	NEVIS	N
214	XS	SOMALILAND,	N
215	XY	ST. BARTHELEMY	N
216	YE	YEMEN, REPUBLIC OF	N
217	YT	MAYOTTE	N
218	ZA	SOUTH AFRICA	N
219	ZM	ZAMBIA	N
220	ZW	ZIMBABWE	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

92 columns | 910 | CTR | STOCK UDC

TOPUDC 00 / CN (Country Codes) stock values