Bin Import Format

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

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

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Location

3

Character

Yes

Enter a valid location prefix for the bin.

B

2

Bin

20

Character

Yes

Enter a bin ID.

C

3

Zone

20

Character

Yes, only if the bin is a staging bin, or if the Zone Required for Bins check box is selected for the bin's location in Location Maintenance.

Enter a zone associated with the bin.

D

4

Description

80

Character

No

Enter a detailed description of the bin.

E

5

Height Capacity

12

>>>,>>9.9999

No

Enter the maximum height capacity in the specified dimensional unit of measure for the bin. This is used for directed putaway.

F

6

Length Capacity

12

>>>,>>9.9999

No

Enter the maximum length capacity in the specified dimensional unit of measure for the bin. This is used for directed putaway.

G

7

Width Capacity

12

>>>,>>9.9999

No

Enter the maximum width capacity in the specified dimensional unit of measure for the bin. This is used for directed putaway.

H

8

Cubic Capacity

12

>>>,>>9.9999

No

Enter the maximum cubic capacity for the bin. This is used for directed putaway.

I

9

Weight Capacity

12

>>>,>>9.9999

No

Enter the maximum weight capacity for the bin. This is used for directed putaway.

J

10

Cubic Capacity Unit of Measure

8

Character

No

Enter the unit of measure for the cubic capacity.

K

11

Capacity Unit of Measure

8

Character

No

Enter the unit of measure for the bin for height, width, and length. This is used for directed putaway.

L

12

Weight Capacity Unit of Measure

8

Character

No

Enter the unit of measure for the weight capacity.

M

13

Not Available

3

Yes/No

No

Enter Yes to make the quantity in the bin unavailable for picking or replenishment.

Note This option is often selected for a bin that stores product returns. Since there often is uncertainty about the salability of returned products, putting them in a not available bin keeps them under control, but unavailable for sales allocation or picking.

Note A bin can only be turned into a not available bin if there are no quantities currently in it.

N

14

Do Not Pick

3

Yes/No

No

Enter Yes to have this bin ignored during pick demand creation. Products can be taken out of this bin for work order creation or bin replenishment.

O

15

Raw Materials Only

3

Yes/No

No

Enter Yes to prevent any inventory in the bin from being allocated during pick demand printing. This setting works in conjunction with the Manufacturing module and the use of backflush bins when completing work orders.

P

16

Cross Dock Bin

3

Yes/No

No

Enter Yes to use cross-dock features, and to make the bin available for cross dock selection in Dock Maintenance.

Q

17

Can Break Inventory

3

Yes/No

No

Enter Yes to allow products in the bin to be broken down to smaller units of measure or built up to larger units of measure.

Example If there is a pallet unit of measure of product stored on a high, out-of-the-way bin, you may not want a picker to pick in an each unit of measure from it.

R

18

Speed Bin Override

3

Yes/No

No

Enter Yes to have pick demand creation first pick from the bin, regardless of the unit of measure required. Typically, this is used for a high velocity product that is temporarily staged in a speed bin to facilitate an efficient pick.

S

19

Staging Bin

3

Yes/No

No

Enter Yes to mark the bin as only to be used for staging.

T

20

User Bin

3

Yes/No

No

Enter Yes to mark the bin as only to be used for a Wireless Warehouse user as a temporary bin when picking or moving products.

U

21

 

 

 

 

Leave this field blank.

V

22

Bin Sequence

7

Integer

No

Enter a bin sequence number for the bin. Use the sequence number to create an efficient pick path through a warehouse and/or zone.

W

23

Laydown Bin

3

Yes/No

No

Enter Yes to mark the bin as one that can be used when picking or moving products.

X

24

Velocity

12

Character

No

Enter a valid velocity code for the bin.

Y

25

Potential Discrepancy

3

Yes/No

No

Enter Yes to mark the bin as having a potential inventory count discrepancy.

Z

26

Do Not Issue Material

3

Yes/No

No

Enter Yes if you do not want to allow component products to be issued from this bin when issuing material for manufacturing.

AA

27

Bin Cycle Count Group

12

Character

No

Enter a bin cycle count group for the bin. You can use bin cycle count groups to group together similar bins in the same zone or sales location / shipping location for Wireless Warehouse cycle counting. For more information, see Bin Cycle Count Group Maintenance.

AB

28

 

 

 

 

Leave this field blank.

AC

29

Warehouse Area

20

Character

No

Enter the warehouse area associated with the bin. For information on setting up warehouse areas, see Warehouse Area Maintenance.

AD

30

DRP Calculation Option

19

Character

No

Enter one of the following if the bin is marked as not available:

  • Buying Method Based - Include or exclude inventory in the bin from DRP calculations based on the reorder quantity method settings for the buying method.

  • Exclude - Exclude inventory in the bin from DRP calculations.

  • Include - Include inventory in the bin in DRP calculations.

If this field is blank, it defaults to Buying Method Based.

AE

31

Pending Receipt Bin

3

Yes/No

No

Enter Yes if the bin is used for the pending receipt process. If you enter Yes, the bin will only store inventory for containers and purchase orders that are in the process of being received and put away. If this field is blank, it defaults to No.

Prerequisites

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