Outstanding purchase orders
File name | po.csv |
Importance | Required |
Description | Outstanding purchase / production order lines |
Criteria |
|
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 (or the production order is planned to start)
|
7. Order Quantity | Integer | Required | Original quantity ordered
|
8. Expected Arrival Date | Date | Required | Current expected arrival date
|
9. Outstanding Quantity | Integer | Required | Quantity still outstanding for this line item
|
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" |