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;;;;;;;;;;;;;;;;;;;;