Skip to main content

Data Interface Requirements - Outstanding Purchase Orders

Judi Zietsman avatar
Written by Judi Zietsman
Updated over 3 months ago

Outstanding Purchase Orders

File name

po.csv

Importance

Required

Description

Outstanding purchase / production order lines

Criteria

Include 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 PO was raised, or production order planned to start. Format: YYYY/MM/DD

7

Order Quantity

Integer

Required

Original quantity ordered (in Netstock unit of measure)

8

Expected Arrival Date

Date

Required

Current expected arrival date. Format: YYYY/MM/DD

9

Outstanding Quantity

Integer

Required

Quantity still outstanding for this line (in Netstock unit of measure)

10

Order Type

Char

Required

Order type:
β€’ P = Purchase order
β€’ M = Manufactured order

11

Purchase Unit Cost

Decimal

If Applicable

Purchase unit cost when purchased (in Netstock unit of measure)


Forget about these πŸ‘‡ 😞 😐 πŸ˜ƒ Have your say here!

Did this answer your question?