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:
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. |
Before using this import, the following must be set up: