WMS Inventory Bin Move Import Format

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.