Skip to main content
Data Interface Requirements - Outstanding Purchase Orders
Ruvisha Pillay avatar
Written by Ruvisha Pillay
Updated over 2 years ago

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 (or the production order is planned to start)


โ€‹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"

Did this answer your question?