Import parameters

Directory

/data/orders

Files reference

  • filename : header

Other parameters

Context (companyCode and establishmentCode)

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

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

Order number

chrono

Integer

X

Command Line Number

nb1

Integer

X

Customer Code

customerCode

String

X

10 characters max

Item code

itemCode

String

X

20 characters max

Shipping Date

shippingDate

String (ISO-8601)

X

AAAA-MM-JJTHH:MM:SSZ

Order date

orderDate

String (ISO-8601)

AAAA-MM-JJTHH:MM:SSZ

Delivery Date

deliveryDate

String (ISO-8601)

AAAA-MM-JJTHH:MM:SSZ

First quantity ordered

firstQuantity

Double

X

First unit code

firstUnitCode

String

X

5 characters max

Second quantity ordered

secondQuantity

double

Second unit code

secondUnitCode

String

5 characters max

Shipping Site Code

shippingSiteCode

String

10 characters max

Gross amount

grossAmount

Double

Discount amount 1

discountAmount1

Double

Can be negative depending on the nature of discount

Discount amount 2

discountAmount2

Double

Can be negative depending on the nature of discount

Discount amount 3

discountAmount3

Double

Can be negative depending on the nature of discount

Discount amount 4

discountAmount4

Double

Can be negative depending on the nature of discount

Discount amount 5

discountAmount5

Double

Can be negative depending on the nature of discount

Discount amount 6

discountAmount6

Double

Can be negative depending on the nature of discount

Discount amount 7

discountAmount7

Double

Can be negative depending on the nature of discount

Discount amount 8

discountAmount8

Double

Can be negative depending on the nature of discount

Discount amount 9

discountAmount9

Double

Can be negative depending on the nature of discount

Discount amount 10

discountAmount10

Double

Can be negative depending on the nature of discount

Delivered to

deliveredTo

String

10 characters max

Sold under promotion

soldUnderPromotion

Boolean

if true or false, the flag is forced (not re-evaluated by treatment)

Example

companyCode;establishmentCode;chrono;nb1;customerCode;itemCode;shippingDate;orderDate;deliveryDate;firstQuantity;firstUnitCode;secondQuantity;secondUnitCode;shippingSiteCode;grossAmount;discountAmount1;discountAmount2;discountAmount3;discountAmount4;discountAmount5;discountAmount6;discountAmount7;discountAmount8;discountAmount9;discountAmount10
MM;03;298289;1;010026;200003;2017-02-17T12:00:00Z;2017-02-17T12:00:00Z;2017-02-18T12:00:00Z;4;UVC;1;COL;C01;;;;;;;;;;;;
MM;03;298289;2;010026;200013;2017-02-17T12:00:00Z;2017-02-17T12:00:00Z;2017-02-18T12:00:00Z;6;UVC;1;COL;C01;;;;;;;;;;;;

Example 2

companyCode;establishmentCode;chrono;nb1;customerCode;itemCode;shippingDate;firstQuantity;firstUnitCode
MM;03;288448;1;010026;200003;2014-05-28T12:00:00Z;2.386;KG