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 |
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;;;;;;;;;;;;