Import parameters

Directory

/data/activities

Files reference

  • filename : header

  • filename-contexts : activity contexts

  • filename-details : effective date

  • filename-items : input/output items

  • filename-substitutes : substitute items

  • filename-operations : operations

  • filename-costitems : cost items

Other parameters

Import mode

Imports can be done with "full" or "update" mode.

  • Full mode : All entities in the file but not in the target application are created. All entities present in the target application but not in the file are deleted. The others are updated.

  • Update mode : same as "full" mode except that the entities present in the target application but not in the file are not deleted.

Files content

Data structure

Field Column Data type Required Business rules

Code

activityCode

String

X

20 characters max
All characters in uppercase accepted except characters \ ; | " < > µ and spaces at the beginning and at the end

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Label

label

String

X

50 characters max

Reference item code

refItemCode

String

X

20 characters max

Reference unit code

refUnitCode

String

X

5 characters max

Flow type

flowType

String

X

IN(PUSH,PULL)

Area code

areaCode

String

If Suite MES is active

10 characters max

Family code

activityFamilyCode

String

X

10 characters max

Validity end date

validityEndDate

String (ISO-8601)

YYYY-MM-DDTHH:MM:SSZ Set a passed date to make the entity inactive.

Example

activityCode;companyCode;establishmentCode;label;validityEndDate;refItemCode;refUnitCode;activityFamilyCode;flowType;areaCode
01;02;03;TEST;2014-05-28T12:00:00Z;100;KG;10;PUSH;01
01;02;03;TEST;;KG;10;PUSH;01
01;02;03;TEST;2014-04-25T12:00:00Z;100;KG;;PUSH;01

Activity contexts

Data structure

Field Column Data type Required Business rules

Code

activityCode

String

X

20 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Context code

contextCode

String

X

10 characters max

Priority

priority

Integer

Example

activityCode;companyCode;establishmentCode;contextCode;priority
01;02;03;04;1
01;02;03;05;2
01;02;03;06;

Effective date

Data structure

Field Column Data type Required Business rules

Code

activityCode

String

X

20 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Effective date

effectiveDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

Reference quantity

referenceQuantity

Double

Example

activityCode;companyCode;establishmentCode;effectiveDate;referenceQuantity
01;02;03;2014-05-26T12:00:00Z;10.5
01;02;03;2014-05-27T12:00:00Z;5.30
01;02;03;2015-05-28T12:00:00Z;52.36

input/output items

Data structure

Field Column Data type Required Business rules

Code

activityCode

String

X

20 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Effective date

effectiveDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

Item type

itemType

String

X

IN(INPUT,OUTPUT)

Area code

depositCode

String

10 characters max

Item’s unit code

unitCode

String

X

5 characters max

Shrinkage line

shrinkageLine

Boolean

X

Shrinkage rate

shrinkageRate

Double

MUST BE SET IF shrinkageLine = TRUE

Item code

itemCode

String

X

20 characters max

Constant quantity

constantQuantity

Boolean

X

Quantity

quantity

Double

X

MUST HAVE at most same number of decimal places as item’s unit

Unique reference

counter

Integer

X

INTERNAL UNIQUE NUMBER

Rank

rank

Integer

X

Comment

comment

String

100 characters max

Example

activityCode;companyCode;establishmentCode;effectiveDate;itemType;depositCode;unitCode;shrinkageLine;shrinkageRate;itemCode;constantQuantity;quantity;counter;rank;comment
01;02;03;2014-05-26T12:00:00Z;INPUT;01;KG;true;5.0;001;true;0.5;1;3;commentaire
01;02;03;2014-05-27T12:00:00Z;OUTPUT;;KG;false;;001;true;0.5;2;2;commentaire
01;02;03;2014-05-28T12:00:00Z;INPUT;01;KG;true;5.0;001;true;0.5;3;1;commentaire

Substitute items

Data structure

Field Column Data type Required Business rules

Code

activityCode

String

X

20 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Effective date

effectiveDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

Item code

itemCode

String

X

20 characters max

Substitute item code

replacementItemCode

String

X

20 characters max

Item’s unique reference

counter

Integer

X

Example

activityCode;companyCode;establishmentCode;effectiveDate;itemCode;replacementItemCode;counter
01;02;03;2014-05-26T12:00:00Z;001;002;2
01;02;03;2015-05-27T12:00:00Z;001;003;2
01;02;03;2015-05-28T12:00:00Z;001;005;2

Operations

Data structure

Field Column Data type Required Business rules

Code

activityCode

String

X

20 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Effective date

effectiveDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

Operating process code

operatingProcessCode

String

X

20 characters max

By default

isDefault

Boolean

X

Example

activityCode;companyCode;establishmentCode;effectiveDate;operatingProcessCode;isDefault
01;02;03;2014-05-26T12:00:00Z;01;true
01;02;03;2014-05-27T12:00:00Z;01;true
01;02;03;2015-05-28T12:00:00Z;01;true

Cost items

Data structure

Field Column Data type Required Business rules

Code

activityCode

String

X

20 characters max

Company code

companyCode

String

X

2 characters max

Establishment code

establishmentCode

String

X

2 characters max

Effective date

effectiveDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

Item code

itemCode

String

X

20 characters max

Constant quantity

constantQuantity

Boolean

X

Quantity

quantity

Double

X

MUST HAVE at most same number of decimal places as item’s unit

Unit code

unitCode

String

X

5 characters max

Example

activityCode;companyCode;establishmentCode;effectiveDate;itemCode;constantQuantity;quantity;unitCode
01;02;03;2014-05-26T12:00:00Z;001;true;10.5;KG
01;02;03;2014-05-27T12:00:00Z;001;false;30.0;PAL
01;02;03;2015-05-28T12:00:00Z;001;true;50.2;G