| Print Open PDF Version of Online Help

#### 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 |  |  |
Cabo Verde | 4 | Street/ Number | Address 2 |  | City |  |  |  |
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
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, Democratic Republic of | 5 | Street/ Number |  |  | 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
Cote d'Ivoire | 5 | Street/ Number |  |  | City | Sorting Code |  | Boite Postale |
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
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 |
Eswatini | 4 |  |  |  | City | PO Box |  | 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 | 6 | Address 1 | Address 2 |  | City |  |  | Post Code | Province
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
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, Democratic People's Rep | 5 | Number/ Street | Address 2 |  | City |  |  | Post Code |
Korea, Republic | 6 | Address 1 | Address 2 |  | City |  |  | Post Code | Province
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 |
Lao People's Democratic Rep. | 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 |
Macao | 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
Palestine, State of | 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 | 2 | Street/ Number |  |  |  |  |  |  |
Poland | 5 | Street/ Number |  |  | City |  |  | Post Code |
Portugal | 7 | Street/ Number | Address 2 | Floor | City |  |  | Post Code | Province
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 (Dutch) | 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. Barthelemy | 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 (French) | 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 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
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 (Province of China) | 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
Timor-Leste | 5 | Street/ Number | Address 2 |  | City |  |  | Post Code |
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
Viet Nam | 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

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.