Data interface requirements > Completed purchase orders

Completed purchase orders

File name pohist.csv
Importance PREFERRED
Description Completed purchase order lines and their associated receipts.
This data will be used to assess supplier delivery performance, adjust safety stock and possibly estimate lead times.
Note that purchase order lines with multiple deliveries will result in multiple records where only the Date of Receipt and Quantity Received change.
Criteria All closed purchase order lines completed in the last 12 months.
For large volumes of data, the 12 month history can be provided as a one off extract, and thereafter just purchase orders completed in the last 30 days on an ongoing basis.
 

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 Integer Preferred Expected arrival date
YYYY/MM/DD FORMAT
9 Order Urgency Char If Applicable Use the most appropriate value:
  • ST = Standard order (the default)
  • EM = Emergency order (an order that was forced to be significantly quicker than the standard delivery time)
IT IS VALUABLE TO CATEGORISE "EMERGENCY" ORDERS TO PREVENT FAST DELIVERIES FROM SKEWING DELIVERY PERFORMANCE CALCULATIONS
10 Quantity Received Integer Required Quantity delivered by the vendor
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"
11 Date of Receipt Date Required Date the delivery was received
YYYY/MM/DD FORMAT
12 Purchase Unit Cost Decimal If Applicable The purchase unit cost for this item when purchased
EXPRESS IN TERMS OF THE "NETSTOCK UNIT OF MEASURE"