Skip to main content
Order Formats - Orders upload - Standard CSV
Ruvisha Pillay avatar
Written by Ruvisha Pillay
Updated over 2 years ago

Orders upload - standard CSV

The default CSV order format is used when no specific ERP order upload format has been configured.

Order file format

Position. Field Name

Description

1. Supplier code

The preferred vendor code as linked to the product or the amended supplier code selected while ordering.

2. Supplier description

Name / description of the supplier.

3. Product code

The product code of the item being ordered.

4. Product description

Description of the product code.

5. Recommended order

Recommended order quantity that was suggested by the system.

6. Amended order

Amended order as per the changes made.

7. Unit cost

Single cost per unit based on the last purchase price for the product.

8. Order value

Value of the order based on the amended order quantity and unit cost.

9. MOQ

Minimum order quantity required when ordering the product.

10. Order Multiple

Order multiples that apply after initial minimum requirement has been met.

11. Unit volume

Volume of the product based on the unit of measure set for this.

12. Unit weight

Weight of the product per unit of measure used.

13. Group 1

Groups as linked to the SIA system.

14. Group n

Additional group codes as linked to the system.

15. Classification

ABC SIA classification set for the product in that location.

16. Velocity

Velocity for the product in that location.

17. Status

The status of the product in that specific location ranging from stock out through to surplus orders.

18. LT days

Lead time used for the product, expressed in calendar days.

19. LT units

Lead time used for the product, expressed in units based on future demand.

20. SS days

Safety stock calculated for the product, expressed in calendar days.

21. SS units

Safety stock calculated for the product, expressed in units based on future demand.

22. RC days

Replenishment (order) cycle set based on position in matrix for the product, expressed in calendar days.

23. RC units

Replenishment (order) cycle set based on position in matrix for the product, expressed in units based on future demand.

24. O/H days

Stock on hand for the product, expressed in days based on future demand.

25. O/H units

Stock on hand for the product, expressed in units.

26. O/O days

Stock on order for the product, expressed in days based on future demand.

27. O/O units

Stock on order for the product, expressed in units.

28. B/O units

Accumulated back order quantity for the product.

29. Age

Age of the product indicating how many months it has existed in the system.

30. Ave Sales

Average sales based on the preceding 12 month period or age (whichever is less).

31. Ave FC

Average forecast for the product based on the next 12 months.

32. Avg BOM/CW

Average monthly forecast for BOM and distribution demand based on the next 12 months.

33. EAD

Expected arrival date of this recommended order based on the lead time.

34. Comments

The order line comment, if one was specified.

35. Warehouse code

The ordering location code.

36. Warehouse description

The ordering location description.

37. Purchase factor

Quantity of units to convert to the purchase unit of measure.

38. Last 12 months sales

Total sales over the last 12 months.

39. Current month sales

Sales so far in the current month.

40. Ideal order

The ideal order quantity without minimum order quantity or order multiple constraints.

Did this answer your question?