Import parameters

Directory

/data/item-planning-stocks

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)

One deposit list can be passed to the depositCode field

A list of parameters can be passed to the parameterType field

Files content

Data structure

Field Column Data type Required Business rules

Item code

itemCode

String

X

20 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Deposit code

depositCode

Double

10 characters max

Parameter code

parameterCode

String

X

Within (MINIMUM_SALES_HEDGE, MINIMUM_INVENTORY_HEDGE, MAXIMUM_INVENTORY_HEDGE, SAFETY_STOCK, MAXIMUM_STOCK)

Parameter unit

parameterUnit

String

X

Within (DAY, SALES_DAY, WEEK) if parameterCode = MINIMUM_SALES_HEDGE Within (DAY, WEEK, WORKING_DAY) if parameterCode = MINIMUM_INVENTORY_HEDGE Within (DAY, WEEK, WORKING_DAY) if parameterCode = MAXIMUM_INVENTORY_HEDGE 5 characters max if parameterCode = SAFETY_STOCK or MAXIMUM_STOCK

Parameter value

parameterValue

Double

X

Example

itemCode;companyCode;establishmentCode;depositCode;parameterCode;parameterValue;parameterUnit
01;02;03;D1;MINIMUM_SALES_HEDGE;15;DAY
01;02;04;D2;MINIMUM_INVENTORY_HEDGE;14;WORKING_DAY
01;02;05;D2;MAXIMUM_INVENTORY_HEDGE;3;WEEK
01;02;06;D1;SAFETY_STOCK;2.350;KG
01;02;06;D2;MAXIMUM_STOCK;4;PCE