Data interface requirements > Outstanding customer orders

Outstanding customer orders

File name co.csv
Importance If Applicable
Description Outstanding customer order lines
Criteria
  • All customer order lines where there is still an outstanding quantity to be supplied
  • Exclude customer orders where the entire outstanding quantity has already been allocated from stock on hand
 

Columns

Pos Name Type Importance Description
1 Item Code Char Required Product / SKU code
2 Location Char Required Warehouse / branch code
3 Customer Code Char Preferred Customer code
4 Order Number Char Required Order number
5 Line Number Char Required Order line number
6 Order Date Date Required Date the customer order was raised
YYYY/MM/DD FORMAT
7 Order Quantity Integer Required Original quantity ordered
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
8 Requested Date Date Required The requested delivery date
YYYY/MM/DD FORMAT
9 Outstanding Quantity Integer Required Quantity still outstanding
TO PREVENT THE DOUBLE-UP OF DEMAND, STOCK ALREADY ALLOCATED TO THE CUSTOMER ORDER MUST NOT CONTRIBUTE TO THE OUTSTANDING QUANTITY (REFER TO THE ‘ALLOCATED’ FIELD IN THE STOCK BY LOCATION FILE)
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"