mibuso.com
Home› Navision Attain

Complete Country List

Christian_BuehlChristian_Buehl Member Posts: 145
edited 2004-05-26 in Navision Attain
Does anyone know if there is a complete table for all international countries available which can be imported into Navision. Especially including the local address format would be great. (I mean the table data for table 9)
Thanks

Comments

  • RobertMoRobertMo Member Posts: 484
    # Country codes in ISO 3166
    # File last modified: 2002-05-29
    # Data last modified: 2002-05-29
    # The format of this file is explained in
    # http://www.davros.org/misc/iso3166.html
    # which also contains further information about the codes

    # Table 1: current codes
    AF AFG 004 Afghanistan
AL ALB 008 Albania, People's Socialist Republic of
DZ DZA 012 Algeria, People's Democratic Republic of
AS ASM 016 American Samoa
AD AND 020 Andorra, Principality of
AO AGO 024 Angola, Republic of
AI AIA 660 Anguilla
AQ ATA 010 Antarctica (the territory South of 60 deg S)
AG ATG 028 Antigua and Barbuda
AR ARG 032 Argentina, Argentine Republic
AM ARM 051 Armenia
AW ABW 533 Aruba
AU AUS 036 Australia, Commonwealth of
AT AUT 040 Austria, Republic of
AZ AZE 031 Azerbaijan, Republic of
BS BHS 044 Bahamas, Commonwealth of the
BH BHR 048 Bahrain, Kingdom of
BD BGD 050 Bangladesh, People's Republic of
BB BRB 052 Barbados
BY BLR 112 Belarus
BE BEL 056 Belgium, Kingdom of
BZ BLZ 084 Belize
BJ BEN 204 Benin, People's Republic of
BM BMU 060 Bermuda
BT BTN 064 Bhutan, Kingdom of
BO BOL 068 Bolivia, Republic of
BA BIH 070 Bosnia and Herzegovina
BW BWA 072 Botswana, Republic of
BV BVT 074 Bouvet Island (Bouvetoya)
BR BRA 076 Brazil, Federative Republic of
IO IOT 086 British Indian Ocean Territory (Chagos Archipelago)
VG VGB 092 British Virgin Islands
BN BRN 096 Brunei Darussalam
BG BGR 100 Bulgaria, People's Republic of
BF BFA 854 Burkina Faso
BI BDI 108 Burundi, Republic of
KH KHM 116 Cambodia, Kingdom of
CM CMR 120 Cameroon, United Republic of
CA CAN 124 Canada
CV CPV 132 Cape Verde, Republic of
KY CYM 136 Cayman Islands
CF CAF 140 Central African Republic
TD TCD 148 Chad, Republic of
CL CHL 152 Chile, Republic of
CN CHN 156 China, People's Republic of
CX CXR 162 Christmas Island
CC CCK 166 Cocos (Keeling) Islands
CO COL 170 Colombia, Republic of
KM COM 174 Comoros, Federal and Islamic Republic of
CD COD 180 Congo, Democratic Republic of
CG COG 178 Congo, People's Republic of
CK COK 184 Cook Islands
CR CRI 188 Costa Rica, Republic of
CI CIV 384 Cote D'Ivoire, Ivory Coast, Republic of the
CU CUB 192 Cuba, Republic of
CY CYP 196 Cyprus, Republic of
CZ CZE 203 Czech Republic
DK DNK 208 Denmark, Kingdom of
DJ DJI 262 Djibouti, Republic of
DM DMA 212 Dominica, Commonwealth of
DO DOM 214 Dominican Republic
TL TLS 626 East Timor, Democratic Republic of
EC ECU 218 Ecuador, Republic of
EG EGY 818 Egypt, Arab Republic of
SV SLV 222 El Salvador, Republic of
GQ GNQ 226 Equatorial Guinea, Republic of
ER ERI 232 Eritrea
EE EST 233 Estonia
ET ETH 231 Ethiopia
FO FRO 234 Faeroe Islands
FK FLK 238 Falkland Islands (Malvinas)
FJ FJI 242 Fiji, Republic of the Fiji Islands
FI FIN 246 Finland, Republic of
FR FRA 250 France, French Republic
GF GUF 254 French Guiana
PF PYF 258 French Polynesia
TF ATF 260 French Southern Territories
GA GAB 266 Gabon, Gabonese Republic
GM GMB 270 Gambia, Republic of the
GE GEO 268 Georgia
DE DEU 276 Germany
GH GHA 288 Ghana, Republic of
GI GIB 292 Gibraltar
GR GRC 300 Greece, Hellenic Republic
GL GRL 304 Greenland
GD GRD 308 Grenada
GP GLP 312 Guadaloupe
GU GUM 316 Guam
GT GTM 320 Guatemala, Republic of
GN GIN 324 Guinea, Revolutionary People's Rep'c of
GW GNB 624 Guinea-Bissau, Republic of
GY GUY 328 Guyana, Republic of
HT HTI 332 Haiti, Republic of
HM HMD 334 Heard and McDonald Islands
VA VAT 336 Holy See (Vatican City State)
HN HND 340 Honduras, Republic of
HK HKG 344 Hong Kong, Special Administrative Region of China
HR HRV 191 Hrvatska (Croatia)
HU HUN 348 Hungary, Hungarian People's Republic
IS ISL 352 Iceland, Republic of
IN IND 356 India, Republic of
ID IDN 360 Indonesia, Republic of
IR IRN 364 Iran, Islamic Republic of
IQ IRQ 368 Iraq, Republic of
IE IRL 372 Ireland
IL ISR 376 Israel, State of
IT ITA 380 Italy, Italian Republic
JM JAM 388 Jamaica
JP JPN 392 Japan
JO JOR 400 Jordan, Hashemite Kingdom of
KZ KAZ 398 Kazakhstan, Republic of
KE KEN 404 Kenya, Republic of
KI KIR 296 Kiribati, Republic of
KP PRK 408 Korea, Democratic People's Republic of
KR KOR 410 Korea, Republic of
KW KWT 414 Kuwait, State of
KG KGZ 417 Kyrgyz Republic
LA LAO 418 Lao People's Democratic Republic
LV LVA 428 Latvia
LB LBN 422 Lebanon, Lebanese Republic
LS LSO 426 Lesotho, Kingdom of
LR LBR 430 Liberia, Republic of
LY LBY 434 Libyan Arab Jamahiriya
LI LIE 438 Liechtenstein, Principality of
LT LTU 440 Lithuania
LU LUX 442 Luxembourg, Grand Duchy of
MO MAC 446 Macao, Special Administrative Region of China
MK MKD 807 Macedonia, the former Yugoslav Republic of
MG MDG 450 Madagascar, Republic of
MW MWI 454 Malawi, Republic of
MY MYS 458 Malaysia
MV MDV 462 Maldives, Republic of
ML MLI 466 Mali, Republic of
MT MLT 470 Malta, Republic of
MH MHL 584 Marshall Islands
MQ MTQ 474 Martinique
MR MRT 478 Mauritania, Islamic Republic of
MU MUS 480 Mauritius
YT MYT 175 Mayotte
MX MEX 484 Mexico, United Mexican States
FM FSM 583 Micronesia, Federated States of
MD MDA 498 Moldova, Republic of
MC MCO 492 Monaco, Principality of
MN MNG 496 Mongolia, Mongolian People's Republic
MS MSR 500 Montserrat
MA MAR 504 Morocco, Kingdom of
MZ MOZ 508 Mozambique, People's Republic of
MM MMR 104 Myanmar
NA NAM 516 Namibia
NR NRU 520 Nauru, Republic of
NP NPL 524 Nepal, Kingdom of
AN ANT 530 Netherlands Antilles
NL NLD 528 Netherlands, Kingdom of the
NC NCL 540 New Caledonia
NZ NZL 554 New Zealand
NI NIC 558 Nicaragua, Republic of
NE NER 562 Niger, Republic of the
NG NGA 566 Nigeria, Federal Republic of
NU NIU 570 Niue, Republic of
NF NFK 574 Norfolk Island
MP MNP 580 Northern Mariana Islands
NO NOR 578 Norway, Kingdom of
OM OMN 512 Oman, Sultanate of
PK PAK 586 Pakistan, Islamic Republic of
PW PLW 585 Palau
PS PSE 275 Palestinian Territory, Occupied
PA PAN 591 Panama, Republic of
PG PNG 598 Papua New Guinea
PY PRY 600 Paraguay, Republic of
PE PER 604 Peru, Republic of
PH PHL 608 Philippines, Republic of the
PN PCN 612 Pitcairn Island
PL POL 616 Poland, Polish People's Republic
PT PRT 620 Portugal, Portuguese Republic
PR PRI 630 Puerto Rico
QA QAT 634 Qatar, State of
RE REU 638 Reunion
RO ROU 642 Romania, Socialist Republic of
RU RUS 643 Russian Federation
RW RWA 646 Rwanda, Rwandese Republic
SH SHN 654 St. Helena
KN KNA 659 St. Kitts and Nevis
LC LCA 662 St. Lucia
PM SPM 666 St. Pierre and Miquelon
VC VCT 670 St. Vincent and the Grenadines
WS WSM 882 Samoa, Independent State of
SM SMR 674 San Marino, Republic of
ST STP 678 Sao Tome and Principe, Democratic Republic of
SA SAU 682 Saudi Arabia, Kingdom of
SN SEN 686 Senegal, Republic of
SC SYC 690 Seychelles, Republic of
SL SLE 694 Sierra Leone, Republic of
SG SGP 702 Singapore, Republic of
SK SVK 703 Slovakia (Slovak Republic)
SI SVN 705 Slovenia
SB SLB 090 Solomon Islands
SO SOM 706 Somalia, Somali Republic
ZA ZAF 710 South Africa, Republic of
GS SGS 239 South Georgia and the South Sandwich Islands
ES ESP 724 Spain, Spanish State
LK LKA 144 Sri Lanka, Democratic Socialist Republic of
SD SDN 736 Sudan, Democratic Republic of the
SR SUR 740 Suriname, Republic of
SJ SJM 744 Svalbard & Jan Mayen Islands
SZ SWZ 748 Swaziland, Kingdom of
SE SWE 752 Sweden, Kingdom of
CH CHE 756 Switzerland, Swiss Confederation
SY SYR 760 Syrian Arab Republic
TW TWN 158 Taiwan, Province of China
TJ TJK 762 Tajikistan
TZ TZA 834 Tanzania, United Republic of
TH THA 764 Thailand, Kingdom of
TG TGO 768 Togo, Togolese Republic
TK TKL 772 Tokelau (Tokelau Islands)
TO TON 776 Tonga, Kingdom of
TT TTO 780 Trinidad and Tobago, Republic of
TN TUN 788 Tunisia, Republic of
TR TUR 792 Turkey, Republic of
TM TKM 795 Turkmenistan
TC TCA 796 Turks and Caicos Islands
TV TUV 798 Tuvalu
VI VIR 850 US Virgin Islands
UG UGA 800 Uganda, Republic of
UA UKR 804 Ukraine
AE ARE 784 United Arab Emirates
GB GBR 826 United Kingdom of Great Britain & N. Ireland
UM UMI 581 United States Minor Outlying Islands
US USA 840 United States of America
UY URY 858 Uruguay, Eastern Republic of
UZ UZB 860 Uzbekistan
VU VUT 548 Vanuatu
VE VEN 862 Venezuela, Bolivarian Republic of
VN VNM 704 Viet Nam, Socialist Republic of
WF WLF 876 Wallis and Futuna Islands
EH ESH 732 Western Sahara
YE YEM 887 Yemen
YU YUG 891 Yugoslavia, Socialist Federal Republic of
ZM ZMB 894 Zambia, Republic of
ZW ZWE 716 Zimbabwe

# Table 2: codes withdrawn from use

BQ ATB     British Antarctic Territory
BU BUR 104 Burma, Socialist Rep'c of the Union of
BY BYS 112 Byelorussian SSR Soviet Socialist Republic
CT CTE 128 Canton & Enderbury Islands
CS CSK 200 Czechoslovakia, Czechoslovak Socialist Republic
DY DHY 204 Dahomey
NQ ATN 216 Dronning Maud Land
TP TMP 626 East Timor
ET ETH 230 Ethiopia
FX FXX 249 France, Metropolitan
AI AFI 262 French Afars and Issas
FQ ATF     French Southern and Antarctic Territories
DD DDR 278 German Democratic Republic
DE DEU 280 Germany, Federal Republic of
GE GEL 296 Gilbert & Ellice Islands
JT JTN 396 Johnston Island
MI MID 488 Midway Islands
AN ANT 532 Netherlands Antilles
NT NTZ 536 Neutral Zone
NH NHB 548 New Hebrides
PC PCI 582 Pacific Islands (trust territory)
PA PAN 590 Panama, Republic of
PZ PCZ     Panama Canal Zone
RO ROM 642 Romania, Socialist Republic of
KN KNA 658 St. Kitts-Nevis-Anguilla
SK SKM     Sikkim
RH RHO 716 Southern Rhodesia
EH ESH 732 Spanish Sahara
PU PUS 849 US Miscellaneous Pacific Islands
SU SUN 810 USSR, Union of Soviet Socialist Republics
HV HVO 854 Upper Volta, Republic of
VA VAT 336 Vatican City State (Holy See)
VD VDR     Viet-Nam, Democratic Republic of
WK WAK 872 Wake Island
YD YMD 720 Yemen, Democratic, People's Democratic Republic of
YE YEM 886 Yemen, Yemen Arab Republic
YU YUG 890 Yugoslavia, Socialist Federal Republic of
ZR ZAR 180 Zaire, Republic of
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • Christian_BuehlChristian_Buehl Member Posts: 145
    Thanks a lot, but this list I've got already and its no real problem to import.
    But it does not contain the different address formats and contact address formats what I'm looking for.
    e.g.
    Germany: Adress format Post Code + City Contact Format: After Company
    USA: City + County + Post Code Contact Format: First
    ....
  • RobertMoRobertMo Member Posts: 484
    Maybe we can create a list here: 
    SI SVN Slovenija "Blank Line+Post Code+City" "After Company Name"
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • Christian_BuehlChristian_Buehl Member Posts: 145
    That would be great!
    DE DEU Germany "Post Code+City" "After Company Name"
AT AUT Austria "Post Code+City" "After Company Name"
US USA United States  "City+County+Post Code" "First "
GB GBR Great Britain "City+Post Code","After Company Name"
  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Why not use the table layout, as it is used in Navision?
    So we need following info: Code, Name, EU Country Code, Intrastat Code, Address Format, Contact Address.

    Following data is already available in the W1 3.70 database:
    "AE","United Arab Emirates","","","City+Post Code","After Company Name"
"AT","Austria","AT","AT","Post Code+City","After Company Name"
"AU","Australia","","","City+County+Post Code","After Company Name"
"BE","Belgium","BE","BL","Post Code+City","After Company Name"
"BG","Bulgaria","","","City+County+Post Code","After Company Name"
"BR","Brazil","","","City+Post Code","First"
"CA","Canada","","","City+Post Code","After Company Name"
"CH","Switzerland","","","Post Code+City","After Company Name"
"CZ","Czech Republic","","","Post Code+City","After Company Name"
"DE","Germany","DE","DE","Post Code+City","After Company Name"
"DK","Denmark","DK","DK","Post Code+City","After Company Name"
"DZ","Algeria","","","Post Code+City","After Company Name"
"EE","Estonia","","","Post Code+City","After Company Name"
"ES","Spain","ES","ES","Post Code+City","After Company Name"
"FI","Finland","FI","FI","Post Code+City","After Company Name"
"FR","France","FR","FR","Post Code+City","After Company Name"
"GB","Great Britain","GB","GB","City+Post Code","After Company Name"
"GR","Greece","GR","GR","Post Code+City","After Company Name"
"HU","Hungary","","","City+Post Code","After Company Name"
"ID","Indonesia","","","Post Code+City","After Company Name"
"IE","Ireland","IE","IE","City+County+Post Code","After Company Name"
"IN","India","","","City+Post Code","First"
"IS","Iceland","","","Post Code+City","After Company Name"
"IT","Italy","IT","IT","Post Code+City","After Company Name"
"KE","Kenya","","","Post Code+City","After Company Name"
"LT","Lithuania","","","Post Code+City","After Company Name"
"LV","Latvia","","","Post Code+City","After Company Name"
"MO","Morocco","","","Post Code+City","After Company Name"
"MX","Mexico","","","City+County+Post Code","After Company Name"
"MY","Malaysia","","","Post Code+City","After Company Name"
"MZ","Mozambique","","","Post Code+City","After Company Name"
"NG","Nigeria","","","City+Post Code","After Company Name"
"NL","Holland","NL","NL","Post Code+City","After Company Name"
"NO","Norway","","","Post Code+City","After Company Name"
"NZ","New Zealand","","","City+Post Code","After Company Name"
"PH","Philippines","","","Post Code+City","After Company Name"
"PL","Poland","","","Post Code+City","After Company Name"
"PT","Portugal","PT","PT","Post Code+City","After Company Name"
"RO","Romania","","","Post Code+City","After Company Name"
"RU","Russia","","","City+Post Code","Last"
"SE","Sweden","SE","SE","Post Code+City","After Company Name"
"SG","Singapore","","","City+Post Code","After Company Name"
"SI","Slovenia","","","Post Code+City","After Company Name"
"SZ","Swaziland","","","City+Post Code","After Company Name"
"TH","Thailand","","","Post Code+City","After Company Name"
"TN","Tunisia","","","Post Code+City","After Company Name"
"TR","Turkey","","","Post Code+City","First"
"TZ","Tanzania","","","Post Code+City","After Company Name"
"UG","Uganda","","","City+Post Code","After Company Name"
"US","USA","","","City+County+Post Code","After Company Name"
"ZA","South Africa","","","City+Post Code","First"
    So, now we only need info for countries that is not listed here, or that contains errors.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • RobertMoRobertMo Member Posts: 484
    Slovenia is different as specified in standard Navision and as Christian writes US is different too: 
    SI SVN Slovenia "Blank Line+Post Code+City" "After Company Name"
US USA United States  "City+County+Post Code" "First "

    I posted ISO-3166 list, because it has more types of codes (see below) that are often useful, but unfortunatley not included in standard Navision (but they could be).
    Each country or territory has three codes:
    - a two letter code
    - a three letter code
    - a three digit code
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Sign In or Register to comment.