Import parameters

Directory

/data/stock-statements

Files reference

  • filename : header

Other parameters

Context (companyCode and establishmentCode)

The import is set by a context defined by at least the company code (companyCode) and optionally the establishment code (establishmentCode)

A deposit list can be passed by the depositCodes fields

Timelapse (dateType, startDate and endDate)

Import period is :

  • Relative and defined by the dateType field : Begin of current month / Begin of current week / Begin of current day (in this case startDate and endDate are ignored)

  • Absolute and defined by boundaries markers (startDate and endDate)

Files content

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

Date de stock

stockDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

Item code

itemCode

String

X

20 characters max

Batch

batch

String

20 characters max

Area code

depositCode

String

X

10 characters max

First quantity

firstQuantity

Double

X

Second quantity

secondQuantity

Double

First unit code

firstUnitCode

String

X

5 characters max

Second unit code

secondUnitCode

String

5 characters max

Example

companyCode;establishmentCode;stockDate;itemCode;depositCode;firstQuantity;firstUnitCode;secondQuantity;secondUnitCode;batch;
02;03;2014-05-28T00:00:00Z;ART1;DEP;1.0;KG;1000.0;G;B1
02;04;2014-05-28T00:00:00Z;ART1;DEP;1.0;KG;;;