Customer master
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.
Filed | M/O | Max. length | CSV column naming | Sample data | GUI order | Visible |
|---|---|---|---|---|---|---|
SalesOrganization | M | 20 | ORGID | 001 | 1 | Y |
CustomerID | M | 20 | CUSTID | 12345 | 2 | Y |
Name | M | 128 | NAME | Retarus GmbH | 3 | Y |
Name2 | O | 128 | NAME2 | . | 4 | Y |
SearchTerm1 | O | 128 | SEARCHT1 | retarus | 22 | Y |
SearchTerm2 | O | 128 | SEARCHT2 | . | 23 | Y |
Street | M | 128 | STREET | Aschauer Str. | 5 | Y |
Street2 | O | 128 | STREET2 | . | 6 | Y |
StreetNo | M | 20 | STREETNO | 30 | 7 | Y |
ZipCode | M | 20 | ZIP | 80549 | 8 | Y |
City | M | 128 | CITY | München | 9 | Y |
Region | O | 40 | REGION | BY | 10 | Y |
Country | O | 40 | COUNTRY | DE | 11 | Y |
VATID | M | 40 | VATID | DE123456789 | 12 | Y |
O | 128 | max.mustermann@retarus.com | 13 | Y | ||
Phone | O | 128 | PHONE | +49 89 5528 0000 | 14 | Y |
Fax | O | 128 | FAX | +49 888888888 | 15 | N |
Contact1ID | O | 20 | CTC1ID | 123451 | 20 | N |
ContactName1 | O | 128 | CTCNAME1 | Mustermann | 16 | Y |
ContactFirstName1 | O | 128 | CTCFIRSTNAME1 | Max | 17 | Y |
ContactFax1 | O | 128 | CTCFAX1 | . | 21 | N |
ContactMail1 | O | 128 | CTCMAIL1 | max.mustermann@retarus.com | 18 | Y |
ContactPhone1 | O | 128 | CTCPHONE1 | +49 176 15528 1234 | 19 | N |
Contact2ID | not used | 128 | CTC2ID | . | 24 | N |
ContactName2 | not used | 128 | CTCNAME2 | . | 25 | N |
ContactFirstName2 | not used | 128 | CTCFIRSTNAME2 | . | 26 | N |
ContactFax2 | not used | 128 | CTCFAX2 | . | 27 | N |
ContactMail2 | not used | 128 | CTCMAIL2 | . | 28 | N |
ContactPhone2 | not used | 128 | CTCPHONE2 | . | 29 | N |
RelatedClerkEmail | not used | 128 | CLERKEMAIL | . | 30 | N |
RelatedClerkName | not used | 128 | CLERKNAME | . | 31 | N |
RelatedClerkBusinessUnit | not used | 128 | CLERKBU | . | 32 | N |
InternationalAddress | not used | 128 | INTFLAG | I = there is an international address | 33 | N |
IntAddressName | not used | 128 | INTNAME | . | 34 | N |
IntAddressName2 | not used | 128 | INTNAME2 | . | 35 | N |
IntAddressSearchTerm1 | not used | 128 | INTSEARCHT1 | . | 36 | N |
IntAddressSearchTerm2 | not used | 128 | INTSEARCHT2 | . | 37 | N |
IntAddressStreet | not used | 128 | INTSTREET | . | 38 | N |
IntAddressStreet2 | not used | 128 | INTSTREET2 | . | 39 | N |
IntAddressStreetNo | not used | 128 | INTSTREETNO | . | 40 | N |
IntAddressZipCode | not used | 128 | INTZIP | . | 41 | N |
IntAddressCity | not used | 128 | INTCITY | . | 42 | N |
IntAddressRegion | not used | 128 | INTREGION | . | 43 | N |
IntAddressCountry | not used | 128 | INTCOUNTRY | Country Name | 44 | N |
IntAddressCountryCoded | not used | 128 | INTCODE | 2-letter code of the country | 45 | N |
CustomField1 | not used | 128 | CUSTOM1 | Content to be defined (project specific) | 46 | N |
CustomField2 | not used | 128 | CUSTOM2 | Content to be defined (project specific) | 47 | N |
CustomField3 | not used | 128 | CUSTOM3 | Content to be defined (project specific) | 48 | N |
CustomField4 | not used | 128 | CUSTOM4 | Content to be defined (project specific) | 49 | N |
CustomField5 | not used | 128 | CUSTOM5 | Content to be defined (project specific) | 50 | N |
Sample
ORGID;CUSTID;NAME;NAME2;SEARCHT1;SEARCHT2;STREET;STREET2;STREETNO;ZIP;CITY;REGION;COUNTRY;VATID;EMAIL;PHONE;FAX;CTC1ID;CTCNAME1;CTCFIRSTNAME1;CTCFAX1;CTCMAIL1;CTCPHONE1;CTC2ID;CTCNAME2;CTCFIRSTNAME2;CTCFAX2;CTCMAIL2;CTCPHONE2;CLERKEMAIL;CLERKNAME;CLERKBU;INTFLAG;INTNAME;INTNAME2;INTSEARCHT1;INTSEARCHT2;INTSTREET;INTSTREET2;INTSTREETNO;INTZIP;INTCITY;INTREGION;INTCOUNTRY;INTCODE;CUSTOM1;CUSTOM2;CUSTOM3;CUSTOM4;CUSTOM5
001;12345:Retarus GmbH;.;retarus;.;Aschauer Str.;.;30;88400;München;BY;DE;DE12345678;max.mustermann@retarus.de;+49 751 5685 0;+49 751 5685 180;123451;Mustermann;Max;.;max.mustermann@retarus.de;+49 176 300 11 903;;;;;;;;;;;;;;;;;;;;;;;;;;;;
001;12345:Retarus GmbH;.;retarus;.;Aschauer Str.;.;30;88400;München;BY;DE;DE12345678;max.mustermann@retarus.de;+49 751 5685 0;+49 751 5685 180;123451;Mustermann;Max;.;max.mustermann@retarus.de;+49 176 300 11 903;;;;;;;;;;;;;;;;;;;;;;;;;;;;
...