Usage - Order entry
Frequency - Daily or weekly 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 |
Description |
Sample data |
Field definition |
GUI order |
Visible |
|---|---|---|---|---|---|---|---|---|
|
SalesOrganization |
M |
20 |
ORGID |
OrgID |
001 |
AN |
1 |
Y |
|
OrderCode |
M |
128 |
ORDCODE |
Alternative item no. |
SX500 |
AN |
2 |
Y |
|
SellersMaterialNo |
M |
128 |
SELLMAT |
MAIN ERP item no. |
99999999 |
AN |
3 |
Y |
|
EDPNo |
O |
128 |
EDPNO |
Alternative item no. |
Alternative item no. |
AN |
6 |
Y |
|
ANSICode |
O |
128 |
ANSICO |
Alternative item no. |
Alternative item no. |
AN |
7 |
Y |
|
EANNo |
O |
128 |
EANNO |
Alternative item no. |
Alternative item no. |
AN |
4 |
Y |
|
ProductDescription |
M |
512 |
ITEMDESC |
|
Software für Order Extraction |
AN |
5 |
Y |
|
ProductFamilyDE |
O |
512 |
PRODFAM_DE |
|
Software |
AN |
8 |
Y |
|
ProductFamilyEN |
O |
512 |
PRODFAM_EN |
|
Software |
AN |
9 |
Y |
|
ProductFamilyFR |
O |
512 |
PRODFAM_FR |
|
|
AN |
10 |
Y |
|
ProductFamilyIT |
O |
512 |
PRODFAM_IT |
|
|
AN |
26 |
Y |
|
ProductFamilyES |
O |
512 |
PRODFAM_ES |
|
|
AN |
27 |
Y |
|
ItemRef1 |
not used |
40 |
ITEMREF1 |
|
Size |
AN |
15 |
N |
|
ItemRef2 |
not used |
40 |
ITEMREF2 |
|
Colour |
AN |
16 |
N |
|
ItemRef3 |
not used |
40 |
ITEMREF3 |
|
Width |
AN |
17 |
N |
|
ItemRef4 |
not used |
40 |
ITEMREF4 |
|
Length |
AN |
18 |
N |
|
DiscountGroup |
not used |
40 |
DISCGRP |
|
S007 |
AN |
19 |
N |
|
ListPriceGross |
O |
9.2 |
LISTPRICE |
|
12.34 |
N 9.2 |
11 |
Y |
|
Currency |
O |
20 |
CUR |
|
EUR |
AN |
12 |
Y |
|
PackageUnit |
O |
9.2 |
PACKUNIT |
|
10 |
N 9.2 |
13 |
Y |
|
OrderUnit |
O |
20 |
ORDERUNIT |
|
ST |
AN |
14 |
Y |
|
ArticleStatus |
not used |
|
STATUS |
|
V |
AN |
20 |
N |
|
CustomField1 |
O |
128 |
CUSTOM1 |
Alternative item no. |
Alternative item no. |
AN |
21 |
Y |
|
CustomField2 |
O |
128 |
CUSTOM2 |
Alternative item no. |
Alternative item no. |
AN |
22 |
Y |
|
CustomField3 |
O |
128 |
CUSTOM3 |
Alternative item no. |
Alternative item no. |
AN |
23 |
Y |
|
CustomField4 |
O |
128 |
CUSTOM4 |
Alternative item no. |
Alternative item no. |
AN |
24 |
Y |
|
CustomField5 |
O |
128 |
CUSTOM5 |
Alternative item no. |
Alternative item no. |
AN |
25 |
Y |
Sample
ORGID;ORDCODE;SELLMAT;EDPNO;ANSICO;EANNO;ITEMDESC;PRODFAM_DE;PRODFAM_EN;PRODFAM_FR;PRODFAM_IT;PRODFAM_ES;ITEMREF1;ITEMREF2;ITEMREF3;ITEMREF4;DISCGRP;LISTPRICE;CUR;PACKUNIT;ORDERUNIT;STATUS;CUSTOM1;CUSTOM2;CUSTOM3;CUSTOM4;CUSTOM5
001;SX500;99999999;;;;Software für Order Extraction;;;;;;;;;;;12.34;EUR;10.00;ST;;;;;;;
001;SX500;99999999;;;;Software für Order Extraction;;;;;;;;;;;12.34;EUR;10.00;ST;;;;;;;
001;SX500;99999999;;;;Software für Order Extraction;;;;;;;;;;;12.34;EUR;10.00;ST;;;;;;;
...