Import parameters

Directory

/data/sales-prices

Files reference

  • filename : header

Other parameters

Context (companyCode, establishmentCode and priceTypeCode)

The import is set by a context defined by the company code (companyCode), the establishment code (establishmentCode) and the price type code (priceTypeCode)

Files content

Header

Data structure

Field Column Data type Required Business rules

Effective date

effectiveDate

String (ISO-8601)

X

YYYY-MM-DDTHH:MM:SSZ

Item code

itemCode

String

X

20 characters max

Customer code

customerCode

String

10 characters max

Price

price

Double

X

Currency code

currencyCode

String

X

3 characters max

Unit code

unitCode

String

X

5 characters max

Customer group code

groupCode

String

10 characters max

Customer group level

groupLevel

Integer

Customer group value code

groupValueCode

String

20 characters max

Example

effectiveDate;itemCode;customerCode;price;currencyCode;unitCode;groupCode;groupLevel;groupValueCode
2014-05-28T00:00:00Z;ART1;01;100.0;EUR;KG;01;1;01
2014-05-29T00:00:00Z;ART2;02;105.0;EUR;G;;;

Export parameters

Directory

/data/export/sales-prices

Files reference

  • filename : header

Other parameters

Context (companyCode, establishmentCode)

The export is set by a context defined by the company code (companyCode) and the establishment code (establishmentCode)

Plan code (optional)

Only sales prices of the forecast plan code

Price type code (optional)

Only sales prices of the price type code

Only forced prices ? (optional)

Only forced sales prices

Files content

Header

Data structure

Field Column Data type Business rules

Company code

companyCode

String

Establishment code

establishmentCode

String

Item code

itemCode

String

Customer code

customerCode

String

Customer group code

groupCode

String

Customer group level

groupLevel

Integer

Customer group value

groupValueCode

String

Effective date

effectiveDate

String (ISO-8601)

YYYY-MM-DDTHH:MM:SSZ

Price

price

Double

Initial price

initialPrice

Double

Currency code

currencyCode

String

Unit code

unitCode

String

Plan code

planCode

String

Price type code

priceTypeCode

String

Price state

priceState

String