Skip to main content

Data Interface Requirements - Outstanding Customer Orders

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

Outstanding Customer Orders

File name

co.csv

Importance

If Applicable

Description

Outstanding customer order lines

Criteria

Include all customer order lines where there is still an outstanding quantity to be supplied.
​
❌ Exclude customer orders where the entire outstanding quantity has already been allocated from stock on hand.


Columns

Pos.

Name

Type

Importance

Description

1

Item Code

Char

Required

Product / SKU code

2

Location

Char

Required

Warehouse / branch code

3

Customer Code

Char

Preferred

Customer code

4

Order Number

Char

Required

Customer order number

5

Line Number

Char

Required

Customer order line number

6

Order Date

Date

Required

Date the order was raised. Format: YYYY/MM/DD

7

Order Quantity

Integer

Required

Original quantity ordered (in Netstock unit of measure)

8

Requested Date

Date

Required

Requested delivery date. Format: YYYY/MM/DD

9

Outstanding Quantity

Integer

Required

Quantity still outstanding (in Netstock unit of measure). Must exclude stock already allocated to prevent double-counting demand (see Allocated Stock field in Stock by Location).


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

Did this answer your question?