Files content
Header
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 | YYYY-MM-DDTHH:MM:SSZ | 
| Order date | orderDate | String (ISO-8601) | YYYY-MM-DDTHH:MM:SSZ | |
| Delivery Date | deliveryDate | String (ISO-8601) | YYYY-MM-DDTHH: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;;;;;;;;;;;;