Data interface requirements > Outstanding transfers

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"