# ISO Country and Currency Codes Reference for ERP Master Data

> Source: https://netray.co/tools/iso-country-and-currency-codes-reference-for-erp-master-data
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Look up ISO 3166 alpha-2, alpha-3 and numeric country codes with the usual ISO 4217 currency and decimal places.

## Category

erp-operations

## Audience

- ERP admin
- MDM analyst
- Finance systems

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### Country

**Key:** country

**Type:** text

#### Alpha-2

**Key:** alpha2

**Type:** text

#### Alpha-3

**Key:** alpha3

**Type:** text

#### Numeric

**Key:** numeric

**Type:** text

#### Currency (ISO 4217)

**Key:** currency

**Type:** text

#### Minor units

**Key:** minor

**Type:** text

**Rows:**

**Country:** United States

**Alpha2:** US

**Alpha3:** USA

**Numeric:** 840

**Currency:** USD

**Minor:** 2

**Country:** Canada

**Alpha2:** CA

**Alpha3:** CAN

**Numeric:** 124

**Currency:** CAD

**Minor:** 2

**Country:** Mexico

**Alpha2:** MX

**Alpha3:** MEX

**Numeric:** 484

**Currency:** MXN

**Minor:** 2

**Country:** Brazil

**Alpha2:** BR

**Alpha3:** BRA

**Numeric:** 076

**Currency:** BRL

**Minor:** 2

**Country:** United Kingdom

**Alpha2:** GB

**Alpha3:** GBR

**Numeric:** 826

**Currency:** GBP

**Minor:** 2

**Country:** Germany

**Alpha2:** DE

**Alpha3:** DEU

**Numeric:** 276

**Currency:** EUR

**Minor:** 2

**Country:** France

**Alpha2:** FR

**Alpha3:** FRA

**Numeric:** 250

**Currency:** EUR

**Minor:** 2

**Country:** Italy

**Alpha2:** IT

**Alpha3:** ITA

**Numeric:** 380

**Currency:** EUR

**Minor:** 2

**Country:** Spain

**Alpha2:** ES

**Alpha3:** ESP

**Numeric:** 724

**Currency:** EUR

**Minor:** 2

**Country:** Netherlands

**Alpha2:** NL

**Alpha3:** NLD

**Numeric:** 528

**Currency:** EUR

**Minor:** 2

**Country:** Poland

**Alpha2:** PL

**Alpha3:** POL

**Numeric:** 616

**Currency:** PLN

**Minor:** 2

**Country:** Czechia

**Alpha2:** CZ

**Alpha3:** CZE

**Numeric:** 203

**Currency:** CZK

**Minor:** 2

**Country:** Sweden

**Alpha2:** SE

**Alpha3:** SWE

**Numeric:** 752

**Currency:** SEK

**Minor:** 2

**Country:** Norway

**Alpha2:** NO

**Alpha3:** NOR

**Numeric:** 578

**Currency:** NOK

**Minor:** 2

**Country:** Denmark

**Alpha2:** DK

**Alpha3:** DNK

**Numeric:** 208

**Currency:** DKK

**Minor:** 2

**Country:** Switzerland

**Alpha2:** CH

**Alpha3:** CHE

**Numeric:** 756

**Currency:** CHF

**Minor:** 2

**Country:** Turkiye

**Alpha2:** TR

**Alpha3:** TUR

**Numeric:** 792

**Currency:** TRY

**Minor:** 2

**Country:** Israel

**Alpha2:** IL

**Alpha3:** ISR

**Numeric:** 376

**Currency:** ILS

**Minor:** 2

**Country:** Saudi Arabia

**Alpha2:** SA

**Alpha3:** SAU

**Numeric:** 682

**Currency:** SAR

**Minor:** 2

**Country:** United Arab Emirates

**Alpha2:** AE

**Alpha3:** ARE

**Numeric:** 784

**Currency:** AED

**Minor:** 2

**Country:** India

**Alpha2:** IN

**Alpha3:** IND

**Numeric:** 356

**Currency:** INR

**Minor:** 2

**Country:** China

**Alpha2:** CN

**Alpha3:** CHN

**Numeric:** 156

**Currency:** CNY

**Minor:** 2

**Country:** Japan

**Alpha2:** JP

**Alpha3:** JPN

**Numeric:** 392

**Currency:** JPY

**Minor:** 0

**Country:** South Korea

**Alpha2:** KR

**Alpha3:** KOR

**Numeric:** 410

**Currency:** KRW

**Minor:** 0

**Country:** Taiwan

**Alpha2:** TW

**Alpha3:** TWN

**Numeric:** 158

**Currency:** TWD

**Minor:** 2

**Country:** Singapore

**Alpha2:** SG

**Alpha3:** SGP

**Numeric:** 702

**Currency:** SGD

**Minor:** 2

**Country:** Malaysia

**Alpha2:** MY

**Alpha3:** MYS

**Numeric:** 458

**Currency:** MYR

**Minor:** 2

**Country:** Thailand

**Alpha2:** TH

**Alpha3:** THA

**Numeric:** 764

**Currency:** THB

**Minor:** 2

**Country:** Vietnam

**Alpha2:** VN

**Alpha3:** VNM

**Numeric:** 704

**Currency:** VND

**Minor:** 0

**Country:** Indonesia

**Alpha2:** ID

**Alpha3:** IDN

**Numeric:** 360

**Currency:** IDR

**Minor:** 2

**Country:** Australia

**Alpha2:** AU

**Alpha3:** AUS

**Numeric:** 036

**Currency:** AUD

**Minor:** 2

**Country:** New Zealand

**Alpha2:** NZ

**Alpha3:** NZL

**Numeric:** 554

**Currency:** NZD

**Minor:** 2

**Country:** South Africa

**Alpha2:** ZA

**Alpha3:** ZAF

**Numeric:** 710

**Currency:** ZAR

**Minor:** 2

**Country:** Nigeria

**Alpha2:** NG

**Alpha3:** NGA

**Numeric:** 566

**Currency:** NGN

**Minor:** 2

**Country:** Kenya

**Alpha2:** KE

**Alpha3:** KEN

**Numeric:** 404

**Currency:** KES

**Minor:** 2

**Country:** Egypt

**Alpha2:** EG

**Alpha3:** EGY

**Numeric:** 818

**Currency:** EGP

**Minor:** 2

**Country:** Ghana

**Alpha2:** GH

**Alpha3:** GHA

**Numeric:** 288

**Currency:** GHS

**Minor:** 2

**Country:** Morocco

**Alpha2:** MA

**Alpha3:** MAR

**Numeric:** 504

**Currency:** MAD

**Minor:** 2

**Country:** Tanzania

**Alpha2:** TZ

**Alpha3:** TZA

**Numeric:** 834

**Currency:** TZS

**Minor:** 2

**Notes:** Reference only: these are the common ISO 3166-1 and ISO 4217 pairings. Always confirm against the current ISO maintenance agency lists before loading, since currencies and codes change. Numeric codes are text so the leading zero is kept (Brazil 076, Australia 036). Many ERPs also need a separate tax jurisdiction or region code that is not part of ISO 3166-1.

## Content

**Intro:** Country and currency codes look trivial until a vendor load fails because someone typed UK instead of GB, or a Japanese yen amount is stored with two decimals. This reference lists the ISO 3166-1 country codes with the usual ISO 4217 currency and its minor units, ready to search and export.

**Sections:**

#### How to use the reference

**Body:** Type a country name, code or currency into the search box to filter the table. Use the alpha-2 column for most ERP country fields, the alpha-3 column for trade and customs documents that need three letters, and the numeric column for banking and some EDI interfaces. Export the table to Excel to use as a lookup list in a data load template, or as the validation list behind a drop-down in a vendor request form. The minor units column tells you how many decimal places a currency normally uses.

#### The standards behind the codes

**Body:** ISO 3166-1 defines three codes per country: a two-letter alpha-2, a three-letter alpha-3 and a three-digit numeric code. ISO 4217 defines the three-letter currency codes, a numeric code and the number of minor units, meaning the decimal digits in common use. The first two letters of most currency codes are the country's alpha-2 code and the third is the currency initial, which is why USD and CAD look familiar, but the euro, EUR, is shared by many countries.

**Bullets:**

- The United Kingdom is GB, not UK, in ISO 3166-1
- JPY, KRW and VND use zero minor units
- Euro countries all share the EUR currency code
- Numeric codes keep leading zeros, so store them as text

#### Where master data goes wrong

**Body:** Free-text country fields are a leading source of dirty vendor and customer data: USA, U.S.A., United States and US all appear in the same table. Fix this by storing the ISO code and displaying the name. Currency issues are subtler. If a zero-decimal currency such as JPY is stored in a field with two decimals, interface files can multiply or truncate amounts by 100. Check that rounding rules and decimal places in the ERP currency table match ISO 4217 minor units.

#### Common mistakes

**Body:** Do not treat country and currency as one-to-one: Germany and France both use EUR, and some countries have more than one active currency in practice. Do not use the country code as the tax jurisdiction in ERPs that need state, province or GST state codes. Do not hand-type codes; validate against a controlled list. And do not assume a code never changes, since new currencies appear and old ones are withdrawn, so refresh your list from the ISO maintenance agencies at least annually.

**Cta:** If your vendor and customer masters carry inconsistent country or currency values, we can profile them against an ISO list and propose corrections for your review.

**Faq:**

#### Why is the United Kingdom GB and not UK?

**Answer:** ISO 3166-1 assigns GB as the alpha-2 code for the United Kingdom. UK is reserved exceptionally and is not the official ISO code, though it is common in everyday use. ERP country tables should use GB.

#### What are minor units in ISO 4217?

**Answer:** Minor units are the number of decimal digits normally used for a currency. USD and EUR use 2, JPY and KRW use 0. The value tells you how to round and how to store amounts in interfaces.

#### Which code should my ERP store?

**Answer:** Most ERPs store the alpha-2 country code and the alpha-3 currency code. Check what each interface expects: customs documents often use alpha-3, banking messages often use numeric, and EDI partners usually specify their own.

#### Does this list include every country?

**Answer:** No. It lists commonly used manufacturing and trade countries. ISO 3166-1 has well over two hundred entries, so use the official ISO list for a complete load and treat this table as a quick lookup.

## Search terms

iso 3166 country codes list, iso 4217 currency codes, country code alpha 2 alpha 3 table, currency decimal places list, erp country master data, country code lookup excel, currency minor units table

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json