Supplier master
Usage - Invoice entry, Order Confirmation 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 |
|---|---|---|---|---|---|---|
OrgID | M | 20 | ORGID | 0001 | 1 | Y |
SuppId | M | 20 | SUPPID | 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 |
Zip | M | 20 | ZIP | 81549 | 8 | Y |
City | M | 128 | CITY | München | 9 | Y |
Region | O | 40 | REGION | BY | 10 | Y |
Country | M | 128 | COUNTRY | DE | 11 | Y |
VATid | M | 128 | VATID | DE123456789 | 12 | Y |
SWIFT | O | 128 | SWIFT |
| 13 | Y |
IBAN | O | 128 | IBAN |
| 14 | Y |
TaxNo | O | 128 | TAXNO |
| 15 | N |
O | 128 | max.mustermann@retarus.de | 16 | N | ||
Phone | O | 128 | PHONE | +49 89751 5685 0 | 17 | Y |
Fax | O | 128 | FAX | +4989 751 5685 180 | 18 | Y |
Contact1ID | O | 128 | CTC1ID | 123451 | 21 | N |
ContactName1 | O | 128 | CTCNAME1 | Mustermann | 19 | Y |
ContactFirstName1 | O | 128 | CTCFIRSTNAME1 | Max | 20 | N |
ContactFax1 | O | 128 | CTCFAX1 | . | 24 | N |
ContactMail1 | O | 128 | CTCMAIL1 | max.mustermann@retarus.de | 25 | N |
ContactPhone1 | O | 128 | CTCPHONE1 | +49 176 300 11 903 | 26 | N |
Contact2ID | not used | 128 | CTC2ID | . | 27 | N |
ContactName2 | not used | 128 | CTCNAME2 | . | 28 | N |
ContactFirstName2 | not used | 128 | CTCFIRSTNAME2 | . | 29 | N |
ContactFax2 | not used | 128 | CTCFAX2 | . | 30 | N |
ContactMail2 | not used | 128 | CTCMAIL2 | . | 31 | N |
ContactPhone2 | not used | 128 | CTCPHONE2 | . | 32 | N |
RelatedClerkEmail | not used | 128 | CLERKEMAIL | . | 33 | N |
RelatedClerkName | not used | 128 | CLERKNAME | . | 34 | N |
RelatedClerkBusinessUnit | not used | 128 | CLERKBU | . | 35 | N |
International Address | not used | 128 | INTFLAG | I = there is an international address | 36 | N |
Int. Address Name | not used | 128 | INTNAME | . | 37 | N |
Int. Address Name2 | not used | 128 | INTNAME2 | . | 38 | N |
Int. Address SearchTerm1 | not used | 128 | INTSEARCHT1 | . | 39 | N |
Int. Address SearchTerm2 | not used | 128 | INTSEARCHT2 | . | 40 | N |
Int. Address Street | not used | 128 | INTSTREET | . | 41 | N |
Int. Address Street2 | not used | 128 | INTSTREET2 | . | 42 | N |
Int. Address StreetNo | not used | 128 | INTSTREETNO | . | 43 | N |
Int. Address Zip | not used | 128 | INTZIP | . | 44 | N |
Int. Address City | not used | 128 | INTCITY | . | 45 | N |
Int. Address Region | not used | 128 | INTREGION | . | 46 | N |
Int. Address Country | not used | 128 | INTCOUNTRY | Country Name | 47 | N |
Int. Address Country Coded | not used | 128 | INTCODE | Country Coded | 48 | N |
Custom Field1 | not used | 128 | CUSTOM1 | Content to be defined (project specific) | 49 | N |
Custom Field2 | not used | 128 | CUSTOM2 | Content to be defined (project specific) | 50 | N |
Custom Field3 | not used | 128 | CUSTOM3 | Content to be defined (project specific) | 51 | N |
Custom Field4 | not used | 128 | CUSTOM4 | Content to be defined (project specific) | 52 | N |
Custom Field5 | not used | 128 | CUSTOM5 | Content to be defined (project specific) | 53 | N |
Sample
ORGID;SUPPID;NAME;NAME2;SEARCHT1;SEARCHT2;STREET;STREET2;STREETNO;ZIP;CITY;REGION;COUNTRY;VATID;EMAIL;PHONE;FAX;CTCID1;CTCNAME1;CTCFIRSTNAME1;CTCFAX1;CTCMAIL1;CTCPHONE1;CTCID2;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
0001;12345:Retarus GmbH;.;Retarus;.;Aschauer Str.;.;30;80549;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;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
0001;12345:Retarus GmbH;.;Retarus;.;Aschauer Str.;.;30;80549;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;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
...