Data interface requirements > Outstanding purchase orders

Outstanding purchase orders

File name po.csv
Importance Required
Description Outstanding purchase / production order lines
Criteria
  • All purchase order lines where there is still an outstanding quantity to be supplied; and
  • All firm plans for internal manufacture of finished goods (if applicable)
 

Columns

Pos Name Type Importance Description
1 Item Code Char Required Product / SKU code
2 Location Char Required Warehouse / branch code
3 Supplier Code Char Required Vendor code of the supplier
4 Order Number Char Required Purchase order number
5 Line Number Char Required Purchase order line number
6 Order Date Date Required Date the purchase 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 Expected Arrival Date Date Required Current expected arrival date
YYYY/MM/DD FORMAT
9 Outstanding Quantity Integer Required Quantity still outstanding for this line item
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
10 Order Type Char Required Designate the order type:
  • P = Purchase orders
  • M = Manufactured orders
11 Purchase Unit Cost Decimal If Applicable The purchase unit cost for this item when purchased
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"