Data interface requirements > Sales and issues

Sales and issues

File name sales.csv
Importance Required
Description Sales and issues history provided as either:
  • A. Sales summarised by month (the preferred method), or
  • B. Individual sales/returns/issues transactions
Criteria Ideally 3 years of sales history plus the current month (to provide a solid basis for forecasting).
For large volumes of data, the 3 years of history can be provided as a one off extract, and thereafter just the last month and current month of sales on an ongoing basis.
 

Columns

A. Summarised by Month:

Pos Name Type Importance Description
1 Item Code Char Required Product / SKU code
2 Location Char Required Warehouse / branch code
3 Period Date Required First day of the period that the summarised sales are for
YYYY/MM/DD FORMAT
FOR STANDARD CALENDAR MONTHS USE YYYY/MM/01
4 Sales Quantity Integer Required Total quantity sold for the period (minus returns)
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
NET RETURNS SHOULD BE EXPRESSED IN NEGATIVES
5 Cost of Sales Decimal Preferred Total value of the quantity sold at cost
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
NET RETURNS SHOULD BE EXPRESSED IN NEGATIVES
6 Sales Value Decimal Preferred Total value of the quantity sold at sale price (incl. discounts)
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
NET RETURNS SHOULD BE EXPRESSED IN NEGATIVES
7 Issues Quantity Integer If Applicable Total quantity issued from a warehouse to its branches/stores
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
 

B. Individual sales transactions:

Pos Name Type Importance Description
1 Item Code Char Required Product / SKU code
2 Location Char Required Warehouse / branch code
3 Customer Code Char If Applicable The customer code
4 Order Date Date Required Date the order was taken
YYYY/MM/DD FORMAT
5 Invoice/Issue Date Date Required Date the item was sold, issued to manufacturing / another location or returned
YYYY/MM/DD FORMAT
6 Sales Quantity Integer Required Quantity sold
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
RETURNS SHOULD BE EXPRESSED IN NEGATIVES
7 Cost of Sales Decimal Preferred Value of the quantity sold at sale price (incl. discounts)
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
RETURNS SHOULD BE EXPRESSED IN NEGATIVES
8 Sales Value Decimal Preferred Value of the quantity sold at sale price (incl. discounts)
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
RETURNS SHOULD BE EXPRESSED IN NEGATIVES
9 Issues Quantity Integer If Applicable Quantity issued from a warehouse to its branches/stores
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
10 Transaction Type Char Required Identifies transaction type:
  • S = Sale
  • R = Return