	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

27 columns | 812 | CCPR | STOCK UDC

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

27 columns | 812 | CCPR | STOCK UDC

TOPUDC 00 / CN (Country Codes) stock values