|
Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > About Countries and Address Mapping
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 must set up columns for each of the 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.
NOTE: In addition to sovereign states, the following table includes other entities, such as dependencies, foreign territories, and regions of sovereign states. For example, the Isle of Man is a British crown dependency, and Svalbard is a region in Norway.
Country (Uneditable Values)
|
No. of Fields
|
ADDR
|
ADDR2
|
ADDR3
|
CITY
|
COUNTY
|
STATE
|
ZIP
|
PROVINCE
|
USA
|
8
|
Number/
Street
|
Address 2
|
Address 3
|
City
|
County
|
US State
|
Zip
|
|
Afghanistan
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Aland Islands
|
5
|
Number/Street
|
Address 2
|
|
|
|
|
Post Code
|
Island
|
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
|
PO Box
|
|
|
Island
|
Argentina
|
7
|
Number/
Street
|
Address 2
|
Address 3
|
City
|
|
|
Post Code
|
Province
|
Armenia
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Aruba
|
5
|
Number/
Street
|
Address 2
|
Floor
|
City
|
|
|
|
|
Ascension Island
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Australia
|
6
|
Number/
Street
|
Address 2
|
Address 3
|
City
|
|
|
Post Code
|
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
|
Sorting Code
|
|
Post Code
|
|
Belgium
|
6
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
Post Code
|
|
Belize
|
5
|
Number/
Street
|
Address 2
|
Floor
|
City
|
|
|
|
|
Benin
|
4
|
|
|
|
City
|
Sorting Code
|
|
Boite Postale
|
|
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
|
|
|
|
|
Bonaire, Sint Eustatius, and Saba
|
5
|
Address 1
|
Address 2
|
|
City
|
|
|
|
Island
|
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
|
State
|
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
|
Sorting Code
|
|
Boite Postale
|
|
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
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Chile
|
7
|
Street/
Number
|
Address 2
|
Floor
|
City
|
Commune
|
|
Post Code
|
Province
|
China
|
7
|
Number/
Street
|
Address 2
|
District
|
City
|
|
|
Post Code
|
Province
|
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
|
Sorting Code
|
|
|
Province
|
Congo
|
3
|
Street/Number
|
|
|
City
|
|
|
|
|
Congo, The Democratic Republic
|
4
|
|
|
|
City
|
Sorting Code
|
|
Boite Postale
|
|
Cook Islands
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Costa Rica
|
7
|
Street/
Number
|
Address 2
|
Floor
|
City
|
|
|
Post Code
|
Province
|
Croatia
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Cuba
|
4
|
Street/
Number
|
|
|
City
|
|
|
Codigo Postal
|
|
Curacao
|
6
|
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
|
Sorting Code
|
|
Post Code
|
|
Denmark
|
6
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
Post Code
|
|
Djibouti
|
3
|
|
|
|
City
|
PO Box
|
|
|
|
Dominica
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Dominican Republic
|
6
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
East Timor
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Ecuador
|
7
|
Address 1
|
Address 2
|
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
|
|
|
Post Code
|
|
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
|
Sorting Code
|
|
Post Code
|
|
France
|
6
|
Number/
Street
|
Address 2
|
|
City
|
CEDEX Code
|
|
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
|
5
|
Number/Street
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Guam
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Guatemala
|
5
|
Street/
Number
|
|
|
City
|
|
|
Codigo Postal
|
Province
|
Guernsey
|
6
|
Number/Street
|
Address 2
|
Address 3
|
|
|
|
Post Code
|
Island
|
Guinea
|
3
|
|
|
|
City
|
PO Box
|
|
|
|
Guinea-bissau
|
4
|
Street/
Number
|
|
|
City
|
|
|
Codigo Postal
|
|
Guyana
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Haiti
|
6
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
Post 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
|
Sorting Code
|
|
Post Code
|
|
Honduras
|
7
|
Street/
Number
|
Address 2
|
Floor
|
City
|
|
|
Post Code
|
Province
|
Hong Kong
|
7
|
Number/
Street
|
Address 2
|
District
|
City
|
Address 4
|
|
|
Part of Territory
|
Hungary
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Iceland
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
India
|
6
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Post Code
|
State
|
Indonesia
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Iran
|
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
|
|
Eircode
|
|
Isle of Man
|
7
|
Number/Street
|
Address 2
|
Address 3
|
City
|
County
|
|
Post Code
|
|
Israel
|
5
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Italy
|
6
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Ivory Coast
|
4
|
|
|
|
City
|
Sorting Code
|
|
Boite Postale
|
|
Jamaica
|
6
|
Number/
Street
|
Address 2
|
|
City
|
Sorting Code
|
|
|
Parish
|
Japan
|
6
|
Number/Street/Chome
|
Ku
|
|
ShiGun
|
|
|
Post Code
|
Prefecture
|
Jersey
|
5
|
Street/Number
|
Address 2
|
|
|
|
|
Post Code
|
Parish
|
Jordan
|
5
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Kazakhstan
|
4
|
Address 1
|
|
|
City
|
|
|
Post Code
|
|
Kenya
|
4
|
|
|
|
City
|
PO Box
|
|
Post Code
|
|
Kiribati
|
4
|
Address 1
|
|
|
City
|
|
|
|
Island
|
Korea
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Korea, Democratic People's Rep
|
5
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Kosovo
|
6
|
Street/ Number
|
Address 2
|
District
|
City
|
|
|
Post Code
|
|
Kuwait
|
6
|
Street/
Number
|
Address 2
|
|
City
|
County
|
|
Post Code
|
|
Kyrgyzstan
|
6
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
Post Code
|
|
Laos
|
5
|
Number/ Street
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Latvia
|
5
|
Street/
Number
|
|
|
City
|
Sorting Code
|
|
Post Code
|
|
Lebanon
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Lesotho
|
3
|
|
|
|
City
|
PO Box
|
|
|
|
Liberia
|
6
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
Post Code
|
|
Libya
|
5
|
Number/ Street
|
Address 2
|
Floor
|
City
|
|
|
|
|
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
|
6
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
Post Code
|
|
Madagascar
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Malawi
|
3
|
|
|
|
City
|
PO Box
|
|
|
|
Malaysia
|
7
|
Number/
Street
|
Address 2
|
Address 3
|
City
|
|
|
Post Code
|
State
|
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
|
Colonia/ Section
|
|
Post Code
|
State
|
Micronesia
|
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
|
6
|
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
|
Township
|
|
Post Code
|
|
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
|
6
|
Number/
Street
|
Address 2
|
District
|
City
|
|
|
Post Code
|
|
Nicaragua
|
6
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
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
|
Sorting Code
|
|
Post Code
|
|
Oman
|
4
|
|
|
|
City
|
PO Box
|
|
Post Code
|
Region
|
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
|
Sorting Code
|
|
|
Province
|
Papua New Guinea
|
3
|
|
|
|
City
|
|
|
|
Province
|
Paraguay
|
4
|
Street/
Number
|
Address 2
|
|
City
|
|
|
|
|
Peru
|
8
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
|
Province
|
Philippines
|
7
|
Street/
Number
|
Address 2
|
District
|
City
|
|
|
Post Code
|
Province
|
Pitcairn Islands
|
1
|
|
|
|
|
|
|
|
|
Poland
|
5
|
Street/
Number
|
|
|
City
|
|
|
Post Code
|
|
Portugal
|
6
|
Street/
Number
|
Address 2
|
Floor
|
City
|
|
|
Post Code
|
|
Puerto Rico
|
5
|
Address 1
|
|
|
City
|
URB
|
|
Post Code
|
|
Qatar
|
6
|
|
Address2
|
|
City
|
County
|
|
Post Code
|
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
|
Sorting Code
|
|
Post Code
|
|
Rwanda
|
3
|
|
|
|
City
|
PO Box
|
|
|
|
Samoa
|
6
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Zip
|
State
|
San Marino
|
6
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
Post 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
|
PO Box
|
|
|
Island
|
Sierra Leone
|
5
|
Number/
Street
|
Address 2
|
Floor
|
City
|
|
|
|
|
Singapore
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Sint Maarten
|
5
|
Address 1
|
Address 2
|
|
City
|
|
|
|
Island
|
Slovakia
|
6
|
Street/
Number
|
Address 2
|
|
City
|
Sorting Code
|
|
Post Code
|
|
Slovenia
|
5
|
Street/
Number
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Solomon Islands
|
5
|
|
|
|
City
|
PO Box
|
|
Island Code
|
Island
|
Somalia
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
South Africa
|
5
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Post Code
|
|
South Georgia/South Sandwich
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
South Sudan
|
4
|
Number/
Street
|
|
|
City
|
PO Box
|
|
Post Code
|
|
Spain
|
7
|
Street/
Number
|
Address 2
|
Floor
|
City
|
|
|
Post Code
|
Province
|
Sri Lanka
|
5
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Post Code
|
|
St. Barts
|
6
|
Number/
Street
|
Address 2
|
|
City
|
CEDEX Code
|
|
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
|
6
|
Number/
Street
|
Address 2
|
|
City
|
CEDEX Code
|
|
Post Code
|
|
St. Pierre and Miquelon
|
5
|
Number/
Street
|
Address 2
|
|
City
|
|
|
Post Code
|
|
St. Vincent and the Grenadines
|
5
|
Number/
Street
|
Address 2
|
Floor
|
City
|
|
|
|
|
Sudan
|
4
|
|
|
|
City
|
PO Box
|
|
Post Code
|
|
Suriname
|
3
|
Street/
Number
|
|
|
City
|
|
|
|
|
Svalbard and Jan Mayen Islands
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Swaziland
|
4
|
|
|
|
City
|
PO Box
|
|
Post Code
|
|
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
|
PO Box
|
|
|
Island
|
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
|
Region
|
Turkmenistan
|
4
|
Number/
Street
|
|
|
City
|
|
|
Post Code
|
|
Turks and Caicos Islands
|
6
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
Province
|
Tuvalu
|
4
|
|
|
|
City
|
PO Box
|
|
|
Island
|
Uganda
|
3
|
|
|
|
City
|
PO Box
|
|
|
|
Ukraine
|
5
|
Address 1
|
Address 2
|
|
City
|
|
|
Post Code
|
|
Union of the Comoros
|
3
|
|
|
|
City
|
PO Box
|
|
|
|
United Arab Emirates
|
6
|
|
Address 2
|
|
City
|
PO Box
|
|
Post Code
|
Emirate
|
United Kingdom
|
7
|
Number/
Street
|
Address 2
|
Address 3
|
City
|
County
|
|
Post Code
|
|
US Minor Outlying Islands
|
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
|
7
|
Street/
Number
|
Address 2
|
Floor
|
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 Abbreviations for USA
This table shows the picklist values for US states.
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 Territory Abbreviations for USA
This table shows the picklist values for US territories.
Abbreviations
|
Complete Names
|
AS
|
American Samoa
|
FM
|
Federated States of Micronesia
|
GU
|
Guam
|
MH
|
Marshall Islands
|
MP
|
Northern Mariana Islands
|
PW
|
Palau
|
UM
|
US Minor Outlying Islands
|
VI
|
US Virgin Islands
|
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
|
NL
|
Newfoundland and Labrador
|
NS
|
Nova Scotia
|
NT
|
Northwest Territories
|
NU
|
Nunavut
|
ON
|
Ontario
|
PE
|
Prince Edward Island
|
QC
|
Quebec
|
SK
|
Saskatchewan
|
YT
|
Yukon
|
|
