Inventory Bin Move Demand Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Inventory Bin Move Demand Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Product Code

40

Character

Yes

Enter a valid product code. This product must exist in the location entered for the Location Prefix field.

B

2

Location Prefix

3

Character

Yes

Enter a valid location prefix for the location in which the inventory is being moved.

C

3

From Bin Name

20

Character

Yes

Enter a valid bin from which the product is being moved.

D

4

To Bin Name

20

Character

Yes

Enter a valid bin to which the product is being moved.

E

5

Unit of Measure

8

Character

Yes

Enter a valid unit of measure for the product being moved.

F

6

Quantity

15

Decimal or Integer based on the unit of measure entered for the Unit of Measure field

Yes

Enter the quantity of the product being moved.

G

7

Wireless Warehouse Task Type

25

Character

No

Enter the Wireless Warehouse task type for the bin move.

H

8

Lot

20

Character

Yes, only for lot-tracked products

Enter the lot of the product being moved if the product is tracked by lot.

I

9

Serial Number

40

Character

Yes, only for serial-tracked products

Enter the serial number of the product being moved if the product is tracked by serial number.

J

10

To Unit of Measure

8

Character

No

Enter a valid unit of measure in which the product will be stored after the bin move. If this field is blank, it defaults to the unit of measure entered for the Unit of Measure field (position 5).

K

11

License Plate ID

30

Character

No

Enter a license plate ID for which to transfer inventory.

Prerequisites

Before using this import, the following must be set up: