Outstanding transfers

File name	transfer.csv
Importance	If Applicable
Description	Outstanding transfer lines
Criteria	All transfer lines where there is still an outstanding quantity to be supplied to the destination location

Columns

Pos. Name	Type	Importance	Description
1. Item Code	Char	Required	Product / SKU code
2. Source Location	Char	Required	Warehouse / branch that is supplying this transfer
3. Destination Location	Char	Required	Warehouse / branch that is receiving this transfer
4. Transfer Number	Char	Required	Transfer number
5. Line Number	Char	Required	Transfer line number
6. Transfer Date	Date	Required	Date the transfer was raised YYYY/MM/DD FORMAT
7. Expected Arrival Date	Date	Required	Current expected arrival date YYYY/MM/DD FORMAT
8. Transfer Quantity	Integer	Required	Original transfer quantity Express in terms of the "Netstock unit of measure"
9. Quantity to Ship	Integer	Required	Quantity not yet allocated or shipped at the source location To prevent the double-up of demand, stock already allocated to the customer order must not contribute to the outstanding quantity (refer to the "allocated field" in the Stock by Location file) Express in terms of the "Netstock unit of measure"
10. Quantity to Receive	Integer	Required	Quantity not yet received by the destination location Express in terms of the "Netstock unit of measure"