The following table lists the format for importing inventory bin move data from a WMS. Each record is a caret-delimited row in the import file.
Position |
Field Name |
Required |
Description |
1 |
BINMOVE |
Yes |
This is BINMOVE to indicate the record is a bin move record. |
2 |
Location |
Yes |
This is the location for the bin move. |
3 |
Product Code |
Yes |
This is the product code for the bin move. |
4 |
Quantity Moved |
Yes |
This is the quantity moved. It must be greater than zero. |
5 |
From Unit of Measure |
Yes |
This is the unit of measure for the product in the bin from which it is being moved. |
6 |
To Unit of Measure |
Yes |
This is the unit of measure for the product in the bin to which it is being moved. |
7 |
From Bin |
Yes |
This is the bin from which the product is being moved. |
8 |
To Bin |
Yes |
This is the bin to which the product is being moved. |
9 |
Lot |
Yes, only if the product is tracked by lot |
This is the lot of the product being moved if it is tracked by lot. |
10 |
Serial Number |
Yes, only if the product is tracked by serial number |
This is the serial number of the product being moved if it is tracked by serial number. |
11 |
WMS Transaction Date |
No |
This is the date the transaction occurred in the WMS. This defaults to the current date. |
12 |
WMS Transaction Time |
No |
This is the time the transaction occurred in the WMS. This defaults to the current time. |
13 |
WMS Import Key |
No |
This is a key value used to differentiate between WMS transactions. If this is imported, it must be a unique value that was not previously associated with a WMS transaction. |