Files content
Header
Data structure
Field | Column | Data type | Required | Business rules |
---|---|---|---|---|
Company code |
companyCode |
String |
X |
2 characters max |
Establishment code |
establishmentCode |
String |
X |
2 characters max |
Item code |
itemCode |
String |
20 characters max |
|
Item group code |
itemGroupCode |
String |
10 characters max |
|
Item group level |
itemGroupLevel |
Integer |
required if itemGroupCode is filled in |
|
Item group value code |
itemGroupValueCode |
String |
20 characters max |
|
Supplier code |
supplierCode |
String |
10 characters max |
|
Start date |
startDate |
String (ISO-8601) |
X |
YYYY-MM-DDTHH:MM:SSZ |
End date |
endDate |
String (ISO-8601) |
X |
YYYY-MM-DDTHH:MM:SSZ |
Quantity |
quantity |
Double |
X |
|
Unit |
unitCode |
String |
X |
5 characters max |
Area code |
depositCode |
String |
10 characters max |
Example
companyCode;establishmentCode;startDate;endDate;unitCode;itemCode;quantity;supplierCode;depositCode;itemGroupCode;itemGroupLevel;itemGroupValueCode 02;03;2014-05-28T00:00:00Z;2014-05-28T00:00:00Z;KG;01;1.0;CUST;DEP;01;3;111 02;03;2014-05-28T00:00:00Z;2014-05-28T00:00:00Z;KG;01;1.0;;;;; 02;03;2015-05-28T00:00:00Z;2014-05-28T00:00:00Z;KG;01;1.0;;;;;