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	Date	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"