Customer ShipTo
Usage - Order entry
Frequency - Daily or weekly full load
Mandatory fields must contain a value.
If no value is available, use a dot (.) as a placeholder. Otherwise, the import will be rejected.
Field | M/O | Max. length | CSV column naming | Sample data | GUI order | Visible |
|---|---|---|---|---|---|---|
SalesOrganization | O | 20 | ORGID | 001 | 1 | Y |
CustomerID | M | 20 | CUSTID | 12345 | 3 | Y |
CustomerName | M | 128 | NAME | Retarus GmbH | 2 | Y |
ShipToID | M | 20 | SHIPTOID | 65432 | 4 | Y |
Name1 | M | 128 | NAME1 | Abteilung Einkauf | 5 | Y |
Name2 | O | 128 | NAME2 | . | 6 | Y |
Street | M | 128 | STREET | Aschauer Str. | 7 | Y |
Street2 | O | 128 | STREET2 | . | 8 | Y |
StreetNo | M | 20 | STREETNO | 30 | 9 | Y |
ZipCode | M | 20 | ZIP | 80549 | 10 | Y |
Region | O | 40 | REGION | i.e. US-State | 11 | Y |
City | M | 128 | CITY | München | 12 | Y |
Country | O | 128 | COUNTRY | DE | 13 | Y |
InternationalAddress | O | 128 | INTFLAG | I | 14 | N |
IntAddressName | O | 128 | INTNAME | . | 15 | N |
IntAddressName2 | O | 128 | INTNAME2 | . | 16 | N |
IntAddressSearchTerm1 | O | 128 | INTSEARCHT1 | . | 17 | N |
IntAddressSearchTerm2 | O | 128 | INTSEARCHT2 | . | 18 | N |
IntAddressStreet | O | 128 | INTSTREET | . | 19 | N |
IntAddressStreet2 | O | 128 | INTSTREET2 | . | 20 | N |
IntAddressStreetNo | O | 128 | INTSTREETNO | . | 21 | N |
IntAddressZipCode | O | 128 | INTZIP | . | 22 | N |
IntAddressCity | O | 128 | INTCITY | . | 23 | N |
IntAddressRegion | O | 128 | INTREGION | . | 24 | N |
IntAddressCountry | O | 128 | INTCOUNTRY | . | 25 | N |
IntAddressCountryCoded | O | 128 | INTCODE | DE | 26 | N |
CustomField1 | not used | 128 | CUSTOM1 | not used | 27 | N |
CustomField2 | not used | 128 | CUSTOM2 | not used | 28 | N |
CustomField3 | not used | 128 | CUSTOM3 | not used | 29 | N |
CustomField4 | not used | 128 | CUSTOM4 | not used | 30 | N |
CustomField5 | not used | 128 | CUSTOM5 | not used | 31 | N |
Sample
ORGID;CUSTID;NAME;SHIPTOID;NAME1;NAME2;STREET;STREET2;STREETNO;ZIP;REGION;CITY;COUNTRY;INTFLAG;INTNAME;INTNAME2;INTSEARCHT1;INTSEARCHT2;INTSTREET;INTSTREET2;INTSTREETNO;INTZIP;INTCITY;INTREGION;INTCOUNTRY;INTCODE;CUSTOM1;CUSTOM2;CUSTOM3;CUSTOM4;CUSTOM5
001;12345;Retarus;65432;Retarus GmbH;.;Aschauer Str.;.;30;88400;i.e. US-State;München;;;;;;;;;;;;;;;;;;;;
001;12345;Retarus;65432;Retarus GmbH;.;Aschauer Str.;.;30;88400;i.e. US-State;München;;;;;;;;;;;;;;;;;;;;