Usage - Order entry
Frequency - Daily or weekly full load (depending on volatility)
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 |
M |
20 |
ORGID |
001 |
1 |
Y |
|
CustomerID |
M |
20 |
CUSTID |
12345 |
2 |
Y |
|
SellersMaterialNo |
M |
128 |
SELLMAT |
99999999 |
3 |
Y |
|
ItemDescriptionCustomer |
M |
512 |
ITEMDESC |
Sensor 24V X1 |
5 |
Y |
|
ItemNoCustomer |
M |
128 |
CUSTMAT |
ABC2929 |
4 |
Y |
|
CustomField1 |
not used |
128 |
CUSTOM1 |
Content to be defined (project specific) |
6 |
N |
|
CustomField2 |
not used |
128 |
CUSTOM2 |
Content to be defined (project specific) |
7 |
N |
|
CustomField3 |
not used |
128 |
CUSTOM3 |
Content to be defined (project specific) |
8 |
N |
|
CustomField4 |
not used |
128 |
CUSTOM4 |
Content to be defined (project specific) |
9 |
N |
|
CustomField5 |
not used |
128 |
CUSTOM5 |
Content to be defined (project specific) |
10 |
N |
Sample
ORGID;CUSTID;SELLMAT;ITEMDESC;CUSTMAT;CUSTOM1;CUSTOM2;CUSTOM3;CUSTOM4;CUSTOM5
001;12345;9l099999;Sensor 24V X1;ABC2924;;;;;
001;19945;99999l99;Sensor 18V X1;ABC2918;;;;;
001;12345;99990099;Sensor 12V X1;ABC2912;;;;;
001;12345;99889999;Sensor 6V X1;ABC2906;;;;;
...