log-inf-printandsend-kundenstammdaten - Excel

Document Sample
log-inf-printandsend-kundenstammdaten - Excel Powered By Docstoc
					  Parcels, express and VinoLog                                Print + Send: Upload customer data


Customer data for parcels, express and Vinolog

Description of CSV file for the function [Upload customer data]
Below are the fields used in the CSV file (for sample see table [Template]) and corresponding restrictions.
You can upload the files to the Print & Send service in the application under the [Tools] menu using the [Upload customer data] function
and thus incorporate them into your address master data. The uploaded addresses are available for all services.
Important:
- The column headings must be entitled in accordance with the 'Original field name'.
- The order of the columns can be changed
- The columns of optional fields that have not been completed can be deleted.

Original field name             Field name English                      Example               Format Description
CLIENT-ID                       Client ID                               T001                   30/A Unique client identification
NAME                            Company/name                            Company/name PEV       35/A
NAME ADD1                       Name addition 1                         Name addition 1 PEV 35/A
NAME ADD2                       Name addition 2                         Name addition 2 PEV 35/A
NAME ADD3                       Name addition 3                         Name addition 3 PEV 35/A
                                                                                                     If no street is available, enter a full stop here (.), so that the address
STREET                          Street/no.                              Street/no. PEV         35/A can be processed.
STREET ADD1                     Address addition                        Address addition PEV 35/A
COUNTRY                         Country                                 CH                      3/A Allowed only for CH (Switzerland) or LI (Principality of Liechtenstein)
ZIP                             Postcode/zip code                       3007                    4/N
CITY                            Town                                    Berne                  30/A
PROVINCE                        Province / State                                                     Column can be left blank or deleted.
CONTACT                         Contact                                 Contact                35/A
PHONE                           Telephone                               031 111 22 33          50/A
FAX                             Fax                                     031 999 88 77          50/A
EMAIL                           E-mail                                  test@postlogistics.ch  50/A
VATNO                           VAT no.                                                              Column can be left blank or deleted.
CUSTOMSNO                       Customs number                                                       Column can be left blank or deleted.
AVISTYPE1                       Advance notice: confirmation of mailing N                             'Send confirmation of mailing' activated = Y / deactivated = N
AVISTYPE2                       Advance notice: delivery instructions N                               'Send delivery instructions' activated = Y / deactivated = N
AVISTYPE3                       Advance notice: collection instructions N                             'Send collection instructions' activated = Y / deactivated = N
AVISLANG                        Advance notice: language                DE                           Languages: GE, FR, IT, EN possible
AVISMOBILEACTIV                 Advance notice: active mobile no.       N                            SMS message activated = Y / deactivated = N
AVISEMAILACTIV                  Advance notice: active e-mail address N                              E-mail message activated = Y / deactivated = N
AVISMOBILE                      Advance notice: mobile no.              0790000000             50/N Mobile no.
AVISEMAIL                       Advance notice: e-mail address          test@domain.tld        50/A E-mail address


Explanation of colours
mandatory                       red = mandatory field
optional                        green = optional field


  März 2007
Save sheet with function [Save as…] as file type [CSV (separate separators) (*.csv)] and delete this entire line (lne 1).
CLIENT-ID      NAME             NAME ADD1           NAME ADD2         NAME ADD3           STREET          STREET ADD1      COUNTRY ZIP   CITY
T001           Firma / Name PEVName Zusatz 1 PEVName Zusatz 2 PEVName Zusatz 3 PEVStrasse/Nr. PEV                          CH
                                                                                                          Adresse Zusatz PEV        3007 Bern
PROVINCE CONTACT PHONE           FAX             EMAIL               VATNO CUSTOMSNO AVISTYPE1 AVISTYPE2 AVISTYPE3
         Kontakt 031 111 22 33   031 999 88 77   qsyw@yellowworld.ch                 N         N         N
AVISLANG             AVISEMAILACTIV
           AVISMOBILEACTIV     AVISMOBILE AVISEMAIL
DE         N         N         0790000000 test@domain.tld
    PostLogistics small consignment                       Print + Send: Upload customer data




Customer data for small consignments

Desription of the CSV file for the function [Upload customer data]
Below are the fields used in the CSV file (for sample see table [Template]) and corresponding restrictions.
You can upload the files to the Print & Send service in the application under the [Tools] menu using the [Upload customer data] function
and thus incorporate them into your address master data. The uploaded addresses are available for all services.
Important:
- The column headings must be entitled in accordance with the 'Original field name'.
- The order of the columns can be changed
- The columns of optional fields that have not been completed can be deleted.
Original field name           Field name English                  Example              Format Description
CLIENT-ID                     Client ID                           T003                  30/A Unique customer identification
NAME                          Company/name                        Company/name PL3      30/A
NAME ADD1                     Name addition 1                     Name addition 1 PL3 30/A
NAME ADD2                     Name addition 2                     Name addition 2 PL3 30/A
NAME ADD3                     Name addition 3                     Name addition 3 PL3 30/A
STREET                        Street/no.                          Street/no. PL3        25/A
STREET ADD1                   Address addition                    Address addition PL3 30/A
COUNTRY                       Country                             CH                     3/A Allowed only for CH (Switzerland) or LI (Principality of Liechtenstein)
ZIP                           Postcode/zip code                   3030                   8/A
CITY                          Town                                Berne                 22/A
PROVINCE                      Province / State                                                Column can be left blank or deleted.
CONTACT                       Contact                             Contact person        30/A
PHONE                         Telephone                           031 111 22 33         15/A
FAX                           Fax                                 031 999 88 77         50/A Indicate, if possible
EMAIL                         E-mail                              test@postlogistics.ch 50/A Indicate, if possible


Explanation of colours
mandatory                     red = mandatory field
optional                      green = optional field




    März 2007
Save sheet with function [Save as…] as file type [CSV (separate separators) (*.csv)] and delete this entire line (lne 1).
CLIENT-ID NAME                NAME ADD1           NAME ADD2         NAME ADD3            STREET           STREET ADD1     COUNTRY ZIP CITY
T003        Firma / Name PL3 Name Zusatz 1 PL3 Name Zusatz 2 PL3 Name Zusatz 3 PL3 Strasse/Nr. PL3Adresse Zusatz PL3 CH           3030 Bern
PROVINCE CONTACT       PHONE         FAX           EMAIL
         Kontaktperson 031 111 22 33 031 999 88 77 qsyw@yellowworld.ch
Swiss Post International                                   Print + Send: Upload customer data


    Customer data for Swiss Post International

    Desription of the CSV file for the function [Upload customer data]
    Below are the fields used in the CSV file (for sample see table [Template]) and corresponding restrictions.
    You can upload the files to the Print & Send service in the application under the [Tools] menu using the [Upload customer data] function
    and thus incorporate them into your address master data. The uploaded addresses are available for all services.
    Important:
    - The column headings must be entitled in accordance with the 'Original field name'.
    - The order of the columns can be changed
    - The columns of optional fields that have not been completed can be deleted.
    Original field name           Field name English                  Example                  Format   Description
    CLIENT-ID                     Customer ID                         T002                      30/A    Unique customer identification
    NAME                          Company/name                        Company/name SPI          30/A
    NAME ADD1                     Name addition 1                     Name addition 1 SPI       30/A
    NAME ADD2                     Name addition 2                     Name addition 2 SPI       30/A
    STREET                        Street/no.                          Street/no. SPI            30/A    [Street/no.] or [Address addition] must be indicated
    STREET ADD1                   Address addition                    Address addition SPI      30/A    [Street/no.] or [Address addition] must be indicated
    COUNTRY                       Country                             DE                         3/A    Enter ISO country code as per ISO country codes table
    ZIP                           Postcode                            20001                      8/A
    CITY                          Town                                Hamburg                   22/A
    PROVINCE                      Province / State                                                      May be indicated for addresses in Canada, Mexico or USA
    CONTACT                       Contact                             Contact                   30/A    Indicate, if possible
    PHONE                         Telephone                           +49 11 111 22 33          20/A
    FAX                           Fax                                 +49 11 999 88 77          50/A    Indicate, if possible
    EMAIL                         E-mail                              test@postlogistics.ch     50/A    Indicate, if possible
    VATNO                         VAT no.                             VAT-12345                 16/A    VAT no.
    CUSTOMSNO                     Customs no.                         DE-12345                  7/A     Must only be entered for addresses in Germany


    Explanation of colours                                            Note about ISO country codes
    mandatory                     red = mandatory field               Specific ISO codes exist for the following countries and must be used.
    optional                      green = optional field              France                 FR1
                                                                      Corsica                FR2
                                                                      United Kingdom         GB1
                                                                      Guernsey               GB2
                                                                      Jersey                 GB3
                                                                      Isle of Man            GB4
                                                                      Ascension              SH1
                                                                      St. Helena             SH2
                                                                      Tristan da Cunha       SH3


März 2007
CLIENT-ID   NAME             NAME ADD1         NAME ADD2         STREET         STREET ADD1       COUNTRY ZIP   CITY    PROVINCE
T002        Firma / Name SPI Name Zusatz 1 SPI Name Zusatz 2 SPI Strasse/Nr. SPIAdresse Zusatz SPIDE      20001 Hamburg
CONTACT PHONE            FAX              EMAIL               VATNO      CUSTOMSNO
Kontakt +49 11 111 22 33 +49 11 999 88 77 qsyw@yellowworld.ch MWST-12345 DE-12345
Country codes ISO                                                        Print & Send




                                ISO-Ländercodes             Codes pays ISO                                  Codici paesi ISO
                     Nr. ISO    Deutsch                     Français                                        Italiano

                     1    AF    Afghanistan                 Afghanistan                                     Afganistan
                     2    EG    Ägypten                     Egypte                                          Egitto
                     3    AL    Albanien                    Albanie                                         Albania
                     4    DZ    Algerien                    Algérie                                         Algeria
                     5    AD    Andorra                     Andorre                                         Andorra
                     6    AO    Angola                      Angola                                          Angola
                     7    AI    Anguilla                    Anguilla                                        Anguilla
                     8    AG    Antigua und Barbuda         Antigua et Barbuda                              Antigua e Barbuda
                     9    GQ    Äquatorial-Guinea           Guinée équatoriale                              Guinea Equatoriale
                     10   AR    Argentinien                 Argentine                                       Argentina
                     11   AM    Armenien                    Arménie                                         Armenia
                     12   AW    Aruba                       Aruba                                           Aruba
                     13   SH1   Ascension                   Ascension                                       Ascensione
                     14   AZ    Aserbaidschan               Azerbaïdjan                                     Azerbaigian
                     15   ET    Äthiopien                   Ethiopie                                        Etiopia
                     16   AU    Australien                  Australie                                       Australia
                     17   BS    Bahamas                     Bahamas                                         Bahama
                     18   BH    Bahrain                     Bahrain                                         Bahrein
                     19   BD    Bangladesh                  Bangladesh                                      Bangladesh
                     20   BB    Barbados                    Barbade                                         Barbados
                     21   BY    Belarus                     Bélarus                                         Bielorussia
                     22   BE    Belgien                     Belgique                                        Belgio
                     23   BZ    Belize                      Belize                                          Belize
                     24   BJ    Benin                       Bénin                                           Benin
                     25   BM    Bermuda                     Bermudes                                        Bermude
                     26   BT    Bhutan                      Bhoutan                                         Bhutan
                     27   BO    Bolivien                    Bolivie                                         Bolivia
                     28   BA    Bosnien-Herzegowina         Bosnie-Herzégovine                              Bosnia-Erzegovina
                     29   BW    Botswana                    Botswana                                        Botswana
                     30   BR    Brasilien                   Brésil                                          Brasile
                     31   BN    Brunei                      Brunéi                                          Brunei
                     32   BG    Bulgarien                   Bulgarie                                        Bulgaria
                     33   BF    Burkina Faso                Burkina Faso                                    Burkina Faso
                     34   BI    Burundi                     Burundi                                         Burundi
                     35   KY    Cayman                      Cayman                                          Cayman
                     36   CL    Chile                       Chili                                           Cile
                     37   TW    China Taiwan                Chine, Taïwan                                   Cina, Taiwan
                     38   CN    China (Volksrepublik)       Chine (Rép. pop)                                Cina (Repubblica Popolare)
                     39   CK    Cook Inseln                 Cook, Iles                                      Cook, Isole
                     40   CR    Costa Rica                  Costa-Rica                                      Costa Rica
                     41   CI    Côte d'Ivoire               Côte d'Ivoire                                   Côte d'Ivoire
                     42   DK    Dänemark                    Danemark                                        Danimarca
                     43   FO    Färöer                      Féroé, îles                                     Faeröer, isole
                     44   GL    Grönland                    Groenland                                       Groenlandia
                     45   DE    Deutschland                 Allemagne                                       Germania
                     46   DJ    Djibouti                    Djibouti                                        Gibuti
                     47   DM    Dominica                    Dominique (île)                                 Dominica
                     48   DO    Dominikanische Republik     Dominicaine, République                         Dominicana, Repubblica
                     49   EC    Ekuador                     Equateur                                        Equatore




Version: V02.00
Abnahmedatum SPI: 02.09.2005                              Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls                                Seite 11/20
Country codes ISO                                                              Print & Send




                                ISO-Ländercodes                   Codes pays ISO                                  Codici paesi ISO
                     Nr. ISO    Deutsch                           Français                                        Italiano

                     50   ER    Eritrea                           Erythrée                                        Eritrea
                     51   EE    Estland                           Estonie                                         Estonia
                     52   FK    Falkland                          Falkland                                        Falkland Islands (Malvine)
                     53   FJ    Fidschi                           Fidji                                           Figi
                     54   FI    Finnland                          Finlande                                        Finlandia
                     55   FR1   Frankreich                        France                                          Francia
                     56   FR2   Frankreich (Korsika)              France (Corse)                                  Francia (Corsica)
                     57   GF    Französisch Guyana                Guyane française                                Guiana Francese
                     58   PF    Französisch-Polynesien            Polynésie francaise                             Polinesia Francese
                     59   GA    Gabun                             Gabon                                           Gabon
                     60   GM    Gambia                            Gambie                                          Gambia
                     61   GE    Georgien                          Géorgie                                         Georgia (Republica)
                     62   GH    Ghana                             Ghana                                           Ghana
                     63   GI    Gibraltar                         Gibraltar                                       Gibilterra
                     64   GD    Grenada                           Grenade                                         Grenada
                     65   GR    Griechenland                      Grèce                                           Grecia
                     66   GB1   Grossbritanien und Nordirland     Grande-Bretagne et Irlande du Nord              Gran Bretagna e Irlanda del Nord
                     67   GP    Guadeloupe                        Guadeloupe                                      Guadalupa
                     68   GT    Guatemala                         Guatémala                                       Guatemala
                     69   GB2   Guernesey                         Guernesey                                       Guernesey
                     70   GN    Guinea (Republik)                 Guinée (République)                             Guinea (Repubblica)
                     71   GW    Guinea-Bissau                     Guinée-Bissau                                   Guinea-Bissau
                     72   GY    Guyana                            Guyane                                          Guiana
                     73   HT    Haiti                             Haïti                                           Haiti
                     74   HN    Honduras                          Honduras                                        Honduras
                     75   HK    Hongkong                          Hong-Kong                                       Hongkong
                     76   IN    Indien                            Inde                                            India
                     77   ID    Indonesien                        Indonésie                                       Indonesia
                     78   IQ    Irak                              Iraq                                            Iraq
                     79   IR    Iran                              Iran                                            Iran
                     80   IE    Irland                            Irlande                                         Irlanda
                     81   IS    Island                            Islande                                         Islanda
                     82   IL    Israel                            Israël                                          Israele
                     83   IT    Italien                           Italie                                          Italia
                     84   JM    Jamaika                           Jamaïque                                        Giamaica
                     85   JP    Japan                             Japon                                           Giappone
                     86   YE    Jemen                             Yémen                                           Yemen
                     87   GB3   Jersey                            Jersey                                          Jersey
                     88   JO    Jordanien                         Jordanie                                        Giordania
                     89   CS    Serbien und Montenegro            Serbie et Monténégro                            Serbia e Montenegro
                     90   KH    Kambodscha                        Cambodge                                        Cambogia
                     91   CM    Kamerun                           Cameroun                                        Camerun
                     92   CA    Kanada                            Canada                                          Canada
                     93   CV    Kapverdische Inseln               Cap-Vert, îles du                               Capo Verde, isole del
                     94   KZ    Kasachstan                        Kazakhstan                                      Kazakistan
                     95   KE    Kenia                             Kenya                                           Kenya
                     96   KG    Kirgisistan                       Kirghizistan                                    Kirghizistan
                     97   KI    Kiribati                          Kiribati                                        Kiribati
                     98   CO    Kolumbien                         Colombie                                        Colombia




Version: V02.00
Abnahmedatum SPI: 02.09.2005                                    Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls                                      Seite 12/20
Country codes ISO                                                               Print & Send




                                 ISO-Ländercodes                   Codes pays ISO                                  Codici paesi ISO
                     Nr. ISO     Deutsch                           Français                                        Italiano

                      99   KM    Komoren                           Comores                                         Comore
                     100   CD    Kongo, Demokratische Republik     Congo, République démocratique                  Congo, Repubblica democratica
                     101   CG    Kongo (Republik)                  Congo (République)                              Congo (Repubblica)
                     102   KP    Korea, Dem. Volksrepublik         Corée, Rép. pop. dém.                           Corea, Repubblica Popolare Democratic
                     103   KR    Korea, Republik                   Corée, République                               Corea, Repubblica
                     104   XZ    Kosovo                            Kosovo                                          Kosovo
                     105   HR    Kroatien                          Croatie                                         Croazia
                     106   CU    Kuba                              Cuba                                            Cuba
                     107   KW    Kuwait                            Kuwait                                          Kuwait
                     108   LA    Laos                              Laos                                            Laos
                     109   LS    Lesotho                           Lesotho                                         Lesotho
                     110   LV    Lettland                          Lettonie                                        Lettonia
                     111   LB    Libanon                           Liban                                           Libano
                     112   LR    Liberia                           Libéria                                         Liberia
                     113   LY    Libyen                            Libye                                           Libia
                     114   LT    Litauen                           Lituanie                                        Lituania
                     115   LU    Luxemburg                         Luxembourg                                      Lussemburgo
                     116   MO    Macao                             Macao                                           Macao
                     117   MG    Madagaskar                        Madagascar                                      Madagascar
                     118   MW    Malawi                            Malawi                                          Malawi
                     119   MY    Malaysia                          Malaisie                                        Malaisia
                     120   MV    Malediven                         Maldives                                        Maldive, isole
                     121   ML    Mali                              Mali                                            Mali
                     122   MT    Malta                             Malte                                           Malta
                     123   GB4   Man (Insel)                       Man, île de                                     Man, isola di-
                     124   MA    Marokko                           Maroc                                           Marocco
                     125   MQ    Martinique                        Martinique                                      Martinica
                     126   MR    Mauretanien                       Mauritanie                                      Mauritania
                     127   MU    Mauritius                         Maurice (île)                                   Maurizio
                     128   YT    Mayotte                           Mayotte                                         Mayotte
                     129   MK    Mazedonien                        Macedoine                                       Macedonia
                     130   MX    Mexiko                            Mexique                                         Messico
                     131   MD    Moldova                           Moldova                                         Moldova
                     132   MC    Monaco                            Monaco                                          Monaco
                     133   MN    Mongolei                          Mongolie                                        Mongolia
                     134   MS    Montserrat                        Montserrat                                      Montserrat
                     135   MZ    Mosambik                          Mozambique                                      Mozambico
                     136   MM    Myanmar                           Myanmar                                         Myanmar
                     137   NA    Namibia                           Namibie                                         Namibia
                     138   NR    Nauru                             Nauru                                           Nauru
                     139   NP    Nepal                             Népal                                           Nepal
                     140   NC    Neukaledonien                     Nouvelle-Calédonie                              Nouva Caledonia
                     141   NZ    Neuseeland                        Nouvelle-Zélande                                Nouva Zelanda
                     142   NL    Niederlande                       Pays-Bas                                        Paesi Bassi
                     143   AN    Niederländische Antillen          Antilles néerlandaises                          Antille Olandesi
                     144   NE    Niger                             Niger                                           Niger
                     145   NG    Nigeria                           Nigéria                                         Nigeria
                     146   NI    Nikaragua                         Nicaragua                                       Nicaragua
                     147   NF    Norfolk                           Norfolk                                         Norfolk




Version: V02.00
Abnahmedatum SPI: 02.09.2005                                     Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls                                           Seite 13/20
Country codes ISO                                                            Print & Send




                                 ISO-Ländercodes                Codes pays ISO                                  Codici paesi ISO
                     Nr. ISO     Deutsch                        Français                                        Italiano

                     148   NO    Norwegen                       Norvège                                         Norvegia
                     149   OM    Oman                           Oman                                            Oman
                     150   AT    Österreich                     Autriche                                        Austria
                     151   PK    Pakistan                       Pakistan                                        Pakistan
                     152   PA    Panama                         Panama                                          Panama
                     153   PG    Papua-Neuguinea                Papouasie-Nouvelle-Guinée                       Papua-Nuova Guinea
                     154   PY    Paraguay                       Paraguay                                        Paraguay
                     155   PE    Peru                           Pérou                                           Perù
                     156   PH    Philippinen                    Philippines                                     Filippine
                     157   PN    Pitcairn                       Pitcairn                                        Pitcairn
                     158   PL    Polen                          Pologne                                         Polonia
                     159   PT    Portugal                       Portugal                                        Portogallo
                     160   PR    Puerto Rico                    Porto Rico                                      Porto Rico
                     161   QA    Qatar                          Qatar                                           Qatar
                     162   RE    Réunion                        Réunion                                         Riunione
                     163   RO    Rumänien                       Roumanie                                        Romania
                     164   RU    Russische Föderation           Russie, Fédération de                           Russia, Federazione di
                     165   RW    Rwanda                         Rwanda                                          Rwanda
                     166   SB    Salomon-Inseln                 Salomon, Iles                                   Salomone, Isole
                     167   SV    Salvador, El                   Salvador, El                                    Salvador
                     168   ZM    Sambia                         Zambie                                          Zambia
                     169   AS    Samoa, amerikanischer Teil     Samoa, partie américaine                        Samoa, parte statunitense
                     170   WS    Samoa, West                    Samoa, occidental                               Samoa, occidentale
                     171   SM    San Marino                     St-Marin                                        San Marino
                     172   LC    Santa Lucia                    Sainte Lucie                                    Saint Lucia
                     173   SA    Saudiarabien                   Arabie Saoudite                                 Arabia Saudita
                     174   SE    Schweden                       Suède                                           Svezia
                     175   SN    Senegal                        Sénégal                                         Senegal
                     176   SC    Seychellen                     Seychelles                                      Seicelle
                     177   SL    Sierra Leone                   Sierra Leone                                    Sierra Leone
                     178   SG    Singapur                       Singapour                                       Singapore
                     179   SK    Slowakische Republik           Slovaque (République)                           Slovacca, Repubblica
                     180   SI    Slowenien                      Slovénie                                        Slovenia
                     181   SO    Somalia                        Somalie                                         Somalia
                     182   ES    Spanien                        Espagne                                         Spagna
                     183   LK    Sri Lanka                      Sri Lanka                                       Sri Lanka
                     184   KN    St. Christoph und Nevis        St- Christophe et Nevis                         San Cristoforo e Nevis
                     185   SH2   St. Helena                     Ste-Hélène                                      Sant'Elena
                     186   PM    St. Pierre und Miquelon        St-Pierre et Miquelon                           Saint-Pierre et Miquelon
                     187   ST    St. Thomas und Principe        St - Thomas et Prince                           Sao Tomé e Principe
                     188   VC    St. Vincent und Grenadinen     St-Vincent et Grenadines                        Saint Vincent e Grenadine
                     189   ZA    Südafrika                      Afrique du Sud                                  Sudafrica
                     190   SD    Sudan                          Soudan                                          Sudan
                     191   SR    Suriname                       Suriname                                        Suriname
                     192   SZ    Swasiland                      Swaziland                                       Swaziland
                     193   SY    Syrien                         Syrie                                           Siria
                     194   TJ    Tadschikistan                  Tadjikistan                                     Tagiskistan
                     195   TZ    Tansania                       Tanzanie                                        Tanzania
                     196   TH    Thailand                       Thaïlande                                       Tailandia




Version: V02.00
Abnahmedatum SPI: 02.09.2005                                  Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls                               Seite 14/20
Country codes ISO                                                                                        Print & Send




                                 ISO-Ländercodes                                          Codes pays ISO                                  Codici paesi ISO
                     Nr. ISO     Deutsch                                                  Français                                        Italiano

                     197   TL    Timor Leste                                              Timor Leste                                     Timor Leste
                     198   TG    Togo                                                     Togo                                            Togo
                     199   TO    Tonga                                                    Tonga                                           Tonga, isole-
                     200   TT    Trinidad und Tobago                                      Trinite et Tobago                               Trinidad e Tobago
                     201   SH3   Tristan da Cunha                                         Tristan da Cunha                                Tristan da Cunha
                     202   TD    Tschad                                                   Tchad                                           Ciad
                     203   CZ    Tschechische Republik                                    Tchèque (République)                            Ceca, Repubblica
                     204   TN    Tunesien                                                 Tunisie                                         Tunisia
                     205   TR    Türkei                                                   Turquie                                         Turchia
                     206   TM    Turkmenistan                                             Turkménistan                                    Turkmenistan
                     207   TC    Turks und Caicos                                         Turques et Caïques                              Turks e Caicos
                     208   TV    Tuvalu                                                   Tuvalu                                          Tuvalu
                     209   UG    Uganda                                                   Ouganda                                         Uganda
                     210   UA    Ukraine                                                  Ukraine                                         Ucraina
                     211   HU    Ungarn                                                   Hongrie                                         Ungheria
                     212   UY    Uruguay                                                  Uruguay                                         Uruguay
                     213   UZ    Usbekistan                                               Ouzbékistan                                     Uzbekistan
                     214   VU    Vanuatu                                                  Vanuatu                                         Vanuatu
                     215   VA    Vatikan                                                  Vatican                                         Vaticano
                     216   VE    Venezuela                                                Vénézuéla                                       Venezuela
                     217   AE    Vereinigte arabische Emirate                             Emirats Arabes Unis                             Emirati Arabi Uniti
                     218   US    Vereinigte Staaten von Amerika                           Etats-Unis d'Amérique                           Stati Uniti d'America
                     219   VN    Vietnam                                                  Viet Nam                                        Vietnam
                     220   VG    Virginische Inseln (britisch) - To                       Vierges, Iles (britanniques) - Tortola          Vergini, Isole delle- (britanniche) -
                     221   WF    Wallis und Futuna                                        Wallis et Futuna                                Wallis e Futuna
                     222   CX    Weihnachtsinsel                                          Christmas, Ile                                  Christmas, isole
                     223   CF    Zentralafrika                                            Centrafrique                                    Centrafrica
                     224   ZW    Zimbabwe                                                 Zimbabwe                                        Zimbabwe
                     225   CY    Zypern                                                   Chypre                                          Cipro

                    Diese Länder erscheinen nur in der Liste Ursprungsländer (für Artikel):
                     226 CH    Schweiz                                                   Suisse                                           Svizzera
                     227 LI    Liechtenstein, Fürstentum                                 Liechtenstein, Principauté de                    Liechtenstein, Principato del
                     228 EU    Europäische Union                                         Union Européenne                                 Unione Europea




Version: V02.00
Abnahmedatum SPI: 02.09.2005                                                            Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls                                           Seite 15/20
Country codes ISO                                  Print & Send




                               Country codes ISO
                               English

                               Afghanistan
                               Egypt
                               Albania
                               Algeria
                               Andorra
                               Angola
                               Anguilla
                               Antigua and Barbuda
                               Equatorial Guinea
                               Argentina
                               Armenia
                               Aruba
                               Ascension Island
                               Azerbaijan
                               Etiopia
                               Australia
                               Bahamas
                               Bahrain
                               Bangladesh
                               Barbados
                               Belarus
                               Belgium
                               Belize
                               Benin
                               Bermuda
                               Bhutan
                               Bolivia
                               Bosnia and Herzegovina
                               Botswana
                               Brazil
                               Brunei Darussalam
                               Bulgaria
                               Burkina Faso
                               Burundi
                               Cayman Islands
                               Chile
                               China, Taiwan
                               China (People's Republic of)
                               Cook Islands
                               Costa Rica
                               Côte d'Ivoire
                               Denmark
                               Faroe Islands
                               Greenland
                               Germany
                               Djibouti
                               Dominica
                               Dominican Republic
                               Ecuador




Version: V02.00
Abnahmedatum SPI: 02.09.2005       Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls   Seite 16/20
Country codes ISO                                  Print & Send




                               Country codes ISO
                               English

                               Eritrea
                               Estonia
                               Falkland Islands
                               Fiji
                               Finland
                               France
                               France (Corsica)
                               French Guiana
                               French Polynesia
                               Gabon
                               Gambia
                               Georgia
                               Ghana
                               Gibraltar
                               Grenada
                               Greece
                               United Kingdom
                               Guadeloupe
                               Guatemala
                               Guernsey
                               Guinea (Republic)
                               Guinea-Bissau
                               Guyana
                               Haiti
                               Honduras
                               Hong Kong
                               India
                               Indonesia
                               Iraq
                               Iran
                               Ireland
                               Iceland
                               Israel
                               Italy
                               Jamaica
                               Japan
                               Yemen
                               Jersey
                               Jordan
                               Serbia and Montenegro
                               Cambodia
                               Cameroon
                               Canada
                               Cape Verde
                               Kazakstan
                               Kenya
                               Kyrgyzstan
                               Kiribati
                               Colombia




Version: V02.00
Abnahmedatum SPI: 02.09.2005      Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls   Seite 17/20
Country codes ISO                                  Print & Send




                               Country codes ISO
                               English

                               Comoros
                               Congo, Democratic Republic
                               Congo (Republic)
                               Korea, Democratic People's Republic of
                               Korea, Republic of
                               Kosovo
                               Croatia
                               Cuba
                               Kuwait
                               Laos People's Democratic Republic
                               Lesotho
                               Latvia
                               Lebanon
                               Liberia
                               Libyan
                               Lithuania
                               Luxembourg
                               Macao
                               Madagascar
                               Malawi
                               Malaysia
                               Maldives
                               Mali
                               Malta
                               Island of Man
                               Morocco
                               Martinique
                               Mauritania
                               Mauritius
                               Mayotte
                               Macedonia
                               Mexico
                               Moldova
                               Monaco
                               Mongolia
                               Montserrat
                               Mozambique
                               Myanmar
                               Namibia
                               Nauru
                               Nepal
                               New Caledonia
                               New Zealand
                               Netherlands
                               Netherlands Antilles
                               Niger
                               Nigeria
                               Nicaragua
                               Norfolk




Version: V02.00
Abnahmedatum SPI: 02.09.2005       Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls   Seite 18/20
Country codes ISO                                  Print & Send




                               Country codes ISO
                               English

                               Norway
                               Oman
                               Austria
                               Pakistan
                               Panama
                               Papua New Guinea
                               Paraguay
                               Peru
                               Philippines
                               Pitcairn
                               Poland
                               Portugal
                               Puerto Rico
                               Qatar
                               Réunion
                               Romania
                               Russian Federation
                               Rwanda
                               Solomon Islands
                               El Salvador
                               Zambia
                               Samoa, American Part
                               Western Samoa
                               San Marino
                               Saint Lucia
                               Saudi Arabia
                               Sweden
                               Senegal
                               Seychelles
                               Sierra Leone
                               Singapore
                               Slovak Republic
                               Slovenia
                               Somalia
                               Spain
                               Sri Lanka
                               Saint Kitts and Nevis
                               Saint Helena
                               Saint Pierre and Miquelon
                               Sao Tome and Principe
                               Saint Vincent and the Grenadines
                               South Africa
                               Sudan
                               Suriname
                               Swaziland
                               Syria
                               Tajikistan
                               Tanzania
                               Thailand




Version: V02.00
Abnahmedatum SPI: 02.09.2005       Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls   Seite 19/20
Country codes ISO                                     Print & Send




                               Country codes ISO
                               English

                               Timor Leste
                               Togo
                               Tonga
                               Trinidad and Tobago
                               Tristan da Cunha
                               Chad
                               Czech Republic
                               Tunisia
                               Turkey
                               Turkmenistan
                               Turks and Caicos
                               Tuvalu
                               Uganda
                               Ukraine
                               Hungary
                               Uruguay
                               Uzbekistan
                               Vanuatu
                               Vatican City State
                               Venezuela
                               United Arab Emirates
                               United States of America
                               Viet Nam
                               Virgin Islands (britisch) - Tortola
                               Wallis and Futuna Islands
                               Christmas Island
                               Central African Republic
                               Zimbabwe
                               Cyprus


                               Switzerland
                               Liechtenstein, Principality of
                               European Union




Version: V02.00
Abnahmedatum SPI: 02.09.2005       Datei: d984dad7-c3ac-453e-b6cf-5aeb431bdd92.xls   Seite 20/20