Print      Open PDF Version of Online Help


Previous Topic

Next Topic

About Countries and Address Mapping

The following table shows:

  • Picklist values for the Country field in Oracle CRM On Demand

    The picklist values for the Country field in Oracle CRM On Demand cannot be edited. To capture all the data when importing your files, make sure your countries match the permissible names exactly, including punctuation and capitalization. Otherwise, the information is not imported.

    NOTE: Because the Country picklist values have a 30-character limit, some names that exceed that limit are truncated in the picklist.

  • Mappings for addresses per country

    When importing your data, you need to set up columns for each of the nine address fields that Oracle CRM On Demand uses. The following table shows how you want to map the address fields for each country to the appropriate fields within Oracle CRM On Demand. Mapping correctly ensures that you capture all the data in your files under the correct fields in the application.

Country (Uneditable Values)

No. of Fields

Address 1

Address2

Address3

City

County

US State

Zip/Post Code

Province

PO Box/
Sorting Code

USA

8

Number/
Street

Address 2

Address 3

City

County

US State

Zip

 

 

Afghanistan

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Albania

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Algeria

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

American Samoa

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Andorra

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Angola

4

Street/
Number

Address 2

 

City

 

 

 

 

 

Anguilla

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Antigua and Barbuda

4

 

 

 

City

 

 

 

Island

PO Box

Argentina

5

Number/
Street

Address 2

 

City

 

 

Post Code

Province

 

Armenia

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Aruba

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Ascension Island

5

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Australia

6

Number/
Street

Address 2

 

City

 

 

Zip

State

 

Austria

5

Street/

Number

Address 2

 

City

 

 

Post Code

 

 

 

Azerbaijan

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Bahamas

6

Address 1

Address 2

 

City

 

 

Island Code

Island

 

Bahrain

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Bangladesh

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Barbados

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Belarus

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Belgium

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Belize

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Benin

4

 

 

 

City

 

 

Boite Postale

 

Sorting Code

Bermuda

5

Number/Street

Address 2

 

City

 

 

Post Code

 

 

Bhutan

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Bolivia

4

Street/
Number

Address 2

 

City

 

 

 

 

 

Bosnia and Herzegovina

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Botswana

3

 

 

 

City

 

 

 

 

PO Box

Bouvet Island

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Brazil

7

Street/
Number

Address 2

Floor

City

 

 

Post Code

Province

 

British Indian Ocean Territory

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Brunei Darussalam

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Bulgaria

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Burkina Faso

4

 

 

 

City

 

 

Boite Postale

 

Sorting Code

Burundi

3

 

 

 

City

 

 

 

 

PO Box

Cambodia

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Cameroon

3

 

 

 

City

 

 

 

 

PO Box

Canada

6

Number/
Street

Address 2

 

City

 

 

Post Code

Province

 

Cape Verde

4

Street/
Number

Address 2

 

City

 

 

 

 

 

Cayman Island

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Central African Republic

3

 

 

 

City

 

 

 

 

PO Box

Chad

3

 

 

 

City

 

 

 

 

PO Box

Channel Islands

5

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Chile

6

Street/
Number

Address 2

Floor

City

 

 

Post Code

Province

 

China

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Christmas Island

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Cocos (Keeling) Islands

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Colombia

7

Street/
Number

Address 2

Floor

City

 

 

 

Province

Sorting Code

Comoros

3

 

 

 

City

 

 

 

 

PO Box

Congo

3

Street/
Number

 

 

City

 

 

 

 

 

Congo, The Democratic Republic

4

 

 

 

City

 

 

Boite Postale

 

Sorting Code

Cook Islands

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Costa Rica

6

Street/
Number

Address 2

Floor

City

 

 

Post Code

 

 

Croatia

4

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Cuba

4

Street/
Number

 

 

City

 

 

Codiga Postal

 

 

Curacao

5

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Cyprus

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Czech Republic

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Denmark

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Djibouti

3

 

 

 

City

 

 

 

 

PO Box

Dominica

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Dominican Republic

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

East Timor

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Ecuador

5

Address 1

 

Floor

City

 

 

Post Code

Province

 

Egypt

6

Address 1

 

District

City

 

 

Post Code

Province

 

El Salvador

5

Street/
Number

 

 

City

 

 

Post Code

Province

 

Equatorial Guinea

3

 

 

 

City

 

 

 

 

PO Box

Eritrea

3

Street/
Number

 

 

City

 

 

 

 

 

Estonia

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Ethiopia

3

 

 

 

City

 

 

 

 

PO Box

Falkland Islands (Malvinas)

3

Street/
Number

 

 

City

 

 

 

 

 

Faroe Islands

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Fiji

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Finland

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

France

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

French Guiana

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

French Polynesia

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

French Southern Territories

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Gabon

3

 

 

 

City

 

 

 

 

PO Box

Gambia

3

Street/
Number

 

 

City

 

 

 

 

 

Georgia

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Germany

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Ghana

3

 

 

 

City

 

 

 

 

PO Box

Gibraltar

3

Street/
Number

 

 

City

 

 

 

 

 

Greece

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Greenland

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Grenada

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Guadeloupe

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Guam

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Guatemala

4

Street/
Number

 

 

City

 

 

Codiga Postal

 

 

Guinea

3

 

 

 

City

 

 

 

 

PO Box

Guinea-bissau

4

Street/
Number

 

 

City

 

 

Codiga Postal

 

 

Guyana

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Haiti

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Heard and Mc Donald Islands

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Holy See (Vatican City State)

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Honduras

7

Street/
Number

Address 2

Floor

City

 

 

Post Code

Province

 

Hong Kong

7

Number/
Street

Address 2

District

City

 

 

 

Part of Territory

Address 4

Hungary

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Iceland

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

India

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Indonesia

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Iran (Islamic Republic of)

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Iraq

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Ireland

6

Number/
Street

Address 2

Address 3

City

 

 

 

 

County

Israel

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Italy

6

Street/
Number

Address 2

 

City

 

 

Post Code

Province

 

Ivory Coast

4

 

 

 

City

 

 

Boite Postale

 

Sorting Code

Jamaica

6

Number/
Street

Address 2

 

City

 

 

 

Parish

Sorting Code

Japan

6

Chome

Ku

 

Chi/Gun

 

 

Post Code

Prefecture

 

Jordan

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Kazakhstan

4

Address 1

 

 

City

 

 

Post Code

 

 

Kenya

4

 

 

 

City

 

 

Post Code

 

PO Box

Kirbati

4

Address 1

 

 

City

 

 

 

Island

 

Korea

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Kosovo

6

Street/Number

Address 2

District

City

 

 

Post Code

 

 

Korea, Democratic People's Rep

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Kuwait

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Kyrgyzstan

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Laos

5

Number/ Street

2

 

City

 

 

Post Code

Province

 

Latvia

5

Street/
Number

 

 

City

 

 

Post Code

 

Sorting Code

Lebanon

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Lesotho

3

 

 

 

City

 

 

 

 

PO Box

Liberia

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Libyan Arab Jamahiriya

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Liechtenstein

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Lithuania

4

Street/
Number

 

 

City

 

 

Codigo Postal

 

 

Luxembourg

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Macau

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Macedonia, The Former Yugoslav

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Madagascar

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Malawi

3

 

 

 

City

 

 

 

 

PO Box

Malaysia

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Maldives

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Mali

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Malta

6

Number/
Street

Address 2

 

City

 

 

Post Code

Island

 

Marshall Islands

6

Number/
Street

Address 2

 

City

 

 

Zip

State

 

Martinique

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Mauritania

3

 

 

 

City

 

 

 

 

PO Box

Mauritius

3

Street/
Number

 

 

City

 

 

 

 

 

Mayotte

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Mexico

8

Street/
Number

Address 2

Floor

City

 

 

Post Code

State

Colonia/Section

Micronesia, Federated States of

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Moldova, Republic of

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Monaco

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Mongolia

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Montenegro

5

Address 1

Address2

 

City

 

 

Post Code

Province

 

Montserrat

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Morocco

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Mozambique

4

Street/
Number

 

 

City

 

 

Codigo Postal

 

 

Myanmar

5

Address 1

 

 

City

 

 

Post Code

 

Township

Namibia

3

 

 

 

City

 

 

 

 

PO Box

Nauru

3

 

 

District

 

 

 

 

 

PO Box

Nepal

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Netherlands

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Netherlands Antilles

5

Address 1

Address 2

 

City

 

 

 

Island

 

New Caledonia

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

New Zealand

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Nicaragua

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Niger

3

 

 

 

City

 

 

 

 

PO Box

Nigeria

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Niue

3

 

 

 

City

 

 

 

 

PO Box

Norfolk Island

6

Number/
Street

Address 2

 

City

 

 

Zip

State

 

Northern Mariana Islands

6

Number/
Street

Address 2

 

City

 

 

Zip

State

 

Norway

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Oman

4

 

 

 

 

 

 

Post Code

Region

PO Box

Pakistan

6

Number/
Street

Address 2

Address 3

City

 

 

Post Code

 

 

Palau

6

Number/
Street

Address 2

 

City

 

 

Zip

State

 

Palestinian Authority

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Panama

5

Address 1

 

 

City

 

 

 

Province

Sorting Code

Papua New Guinea

3

 

 

 

City

 

 

 

Province

 

Paraguay

4

Street/
Number

Address 2

 

City

 

 

 

 

 

Peru

5

Street/
Number

Address 2

 

City

 

 

 

 

Sorting Code

Philippines

7

Street/
Number

Address 2

District

City

 

 

Post Code

Province

 

Pitcairn

1

 

 

 

 

 

 

 

 

 

Poland

4

Street/
Number

 

 

City

 

 

Codigo Postal

 

 

Portugal

6

Street/
Number

Address 2

Floor

City

 

 

Post Code

 

 

Puerto Rico

5

Address 1

 

 

City

 

 

Post Code

 

URB

Qatar

3

 

 

 

City

 

 

 

 

PO Box

Reunion

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Romania

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Russian Federation

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Rwanda

3

 

 

 

City

 

 

 

 

PO Box

Samoa

5

Number/
Street

Address 2

 

City

 

 

Zip

State

 

San Marino

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Sao Tome and Principe

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Saudi Arabia

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Senegal

3

Street/
Number

 

 

City

 

 

 

 

 

Serbia

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Seychelles

4

 

 

 

City

 

 

 

Island

PO Box

Sierra Leone

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Singapore

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Slovakia (Slovak Republic)

6

Street/
Number

Address 2

 

City

 

 

Post Code

 

Sorting Code

Slovenia

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Solomon Islands

5

 

 

 

City

 

 

Island Code

Island

PO Box

Somalia

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

South Africa

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

South Georgia and the Sandwich Isles

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Spain

7

Street/
Number

Address 2

Floor

City

 

 

Post Code

Province

 

Sri Lanka

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

St. Barts

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

St. Helena

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

St. Kitts and Nevis

5

Address 1

Address 2

 

City

 

 

 

Island

 

St. Lucia

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

St. Martin

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

St. Pierre and Miquelon

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

St. Vincent and the Grenadines

4

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Sudan

4

 

 

 

City

 

 

Post Code

 

PO Box

Suriname

3

Street/
Number

 

 

City

 

 

 

 

 

Svalbard and Jan Mayen Islands

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Swaziland

4

 

 

 

City

 

 

Post Code

 

PO Box

Sweden

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Switzerland

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Syrian Arab Republic

3

Street/
Number

 

 

City

 

 

 

 

 

Taiwan

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Tajikistan

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Tanzania, United Republic of

3

 

 

 

City

 

 

 

 

PO Box

Thailand

7

Address 1

Address 2

Address 3

City

 

 

Post Code

Province

 

Togo

3

 

 

 

City

 

 

 

 

PO Box

Tokelau

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Tonga

4

 

 

 

City

 

 

 

Island

PO Box

Trinidad and Tobago

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Tunisia

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Turkey

5

Street/
Number

Address 2

 

City

 

 

Post Code

 

 

Turkmenistan

4

Number/
Street

 

 

City

 

 

Post Code

 

 

Turks and Caicos Islands

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Tuvalu

4

 

 

 

City

 

 

 

Island

PO Box

Uganda

3

 

 

 

City

 

 

 

 

PO Box

Ukraine

5

Address 1

Address 2

 

City

 

 

Post Code

 

 

United Arab Emirates

3

 

 

 

 

 

 

 

Emirate

PO Box

United Kingdom

7

Number/
Street

Address 2

 

City

 

 

Post Code

 

County

United States Minor Outlying I

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Uruguay

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Uzbekistan

6

Address 1

Address 2

 

City

 

 

Post Code

Oblast

 

Vanuatu

3

 

 

 

City

 

 

 

 

PO Box

Venezuela

6

Street/
Number

Address 2

 

City

 

 

Post Code

Province

 

Vietnam

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Virgin Islands (British)

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Virgin Islands (U.S.)

6

Number/
Street

Address 2

 

City

 

 

Zip

State

 

Wallis and Futuna Islands

6

Address 1

Address 2

 

City

 

 

Post Code

Province

 

Western Sahara

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Yemen

3

Street/
Number

 

 

City

 

 

 

 

 

Zambia

5

Number/
Street

Address 2

 

City

 

 

Post Code

 

 

Zimbabwe

5

Number/
Street

Address 2

Floor

City

 

 

 

 

 

Valid State/Territory Abbreviations for USA

This table shows the picklist values for USA.

Abbreviations

Complete Names

AK

Alaska

AL

Alabama

AR

Arkansas

AZ

Arizona

CA

California

CO

Colorado

CT

Connecticut

DC

District of Columbia

DE

Delaware

FL

Florida

GA

Georgia

HI

Hawaii

IA

Iowa

ID

Idaho

IL

Illinois

IN

Indiana

KS

Kansas

KY

Kentucky

LA

Louisiana

MA

Massachusetts

MD

Maryland

ME

Maine

MI

Michigan

MN

Minnesota

MO

Missouri

MS

Mississippi

MT

Montana

NC

North Carolina

ND

North Dakota

NE

Nebraska

NH

New Hampshire

NJ

New Jersey

NM

New Mexico

NV

Nevada

NY

New York

OH

Ohio

OK

Oklahoma

OR

Oregon

PA

Pennsylvania

PR

Puerto Rico

RI

Rhode Island

SC

South Carolina

SD

South Dakota

TN

Tennessee

TX

Texas

UT

Utah

VA

Virginia

VT

Vermont

WA

Washington

WI

Wisconsin

WV

West Virginia

WY

Wyoming

Valid Mailing Codes for USA

This table shows the three, official state-codes for U.S. military mail recipients.

Abbreviations

Description

AE (ZIP codes 09xxx)

Armed Forces Europe. This term includes Canada, Middle East, and Africa.

AK (ZIP codes 962xx - 966xx)

Armed Forces Pacific.

AA (ZIP codes 340xx)

Armed Forces Americas. This term includes Central and South America.

Valid Province/Territory Abbreviations for Canada

This table shows the official abbreviations for Canadian provinces (text fields).

Abbreviations

Complete Names

AB

Alberta

BC

British Columbia

MB

Manitoba

NB

New Brunswick

NF

Newfoundland and Labrador

NS

Nova Scotia

NT

Northwest Territories

NU

Nunavut

ON

Ontario

PE

Prince Edward Island

QC

Quebec

SK

Saskatchewan

YT

Yukon


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.