Import parameters

Directory

/data/actual-manufacturings

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)

Timelapse (dateType, startDate and endDate)

Import period is :

  • Relative and defined by the dateType field : Previous month / Previous week / Previous 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

Start date

startDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

End date

endDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

Item code

itemCode

String

X

20 characters max

Activity code

activityCode

String

20 characters max

Activity suite code

activitySuiteCode

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;startDate;endDate;itemCode;activityCode;activitySuiteCode;depositCode;firstQuantity;firstUnitCode;secondQuantity;secondUnitCode
02;03;2014-05-28T00:00:00Z;2014-05-28T00:00:00Z;ART1;01;01;DEP;1.0;KG;1000.0;G
02;04;2014-05-28T00:00:00Z;2014-05-28T00:00:00Z;ART1;01;01;DEP;1.0;KG;;