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 stockout 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.