Field

Description

Whs (Warehouse)

A code that identifies the warehouse where the location exists.

Numeric, 3 positions; optional.

Loc (Location)

The code that identifies the location.

Alphanumeric, 7 positions; optional.

Zone

The warehouse zone in which the location is situated.

Alphanumeric, 2 positions; optional.

Aisle

The aisle in which the location is situated.

Alphanumeric, 2 positions; optional.

Shelf

The shelf on which the location is situated.

Alphanumeric, 2 positions; optional.

Bin

The bin in which the location is situated.

Alphanumeric, 2 positions; optional.

Loc Type

A code identifying the location type.

P - Primary, or main, picking location

S - Secondary location

B - Bulk location

T - Temporary location

Alphanumeric, 1 position; optional.

H/F (Hang/Flat)

A code indicating how merchandise is stored in the location.

H - Hanging storage

F - Flat storage

O - Other storage type

C - Carousel storage. You can download pick control detail information to a Carousel system during pick slip generation for any pick control details containing a carousel location if the Use Carousel Interface (G55) system control value is set to Y.

Alphanumeric, 1 position; optional.

Pck (Pickable)

A code indicating whether inventory in the location can be picked to fulfill consumer orders.

Y - indicates the location is pickable.

N - indicates the location is not pickable.

Alphanumeric, 1 position; optional.

Stk Typ (Stock Type)

A user-defined code that describes the type of merchandise that can be found in the location.

Note: You must enter the full Stock Type code to scan; partial entry of the code is not allowed.

Alphanumeric, 3 positions; optional.

Frz (Freeze)

This value indicates whether the location and its merchandise are frozen. Valid values are:

Y = The location is frozen.

N = The location is not frozen.

If a location is frozen:

• Pick Slip Generation ignores the location when determining where inventory should be picked to fulfill an order. See Introducing Pick Slip Generation.

• Suggest Warehouse Placement (MSLO) ignores the location when suggesting where to place stock.

• Replenish Warehouses and Replenish Primary Locations do not replenish stock to or from the location.

Alphanumeric, 1 position; optional.

Frq (Frequency code)

A code that indicates the frequency with which merchandise in the location is picked. Informational only.

Alphanumeric, 1 position; optional.

Loc Cls (Location class)

A code that identifies the location class.

Alphanumeric, 2 positions; optional.

Field

Description

Warehouse

The warehouse code where the location is being defined. Warehouse codes are validated against the Warehouse file; see Creating and Maintaining Locations (WLOC).

Numeric, 3 positions.

Create screen: required.

Change screen: display-only.

Location

A user-defined code that represents a warehouse location where merchandise is stored. The warehouse location code can consist of a zone/aisle/shelf/bin combination, or it can be any user-defined code. Locations are required for inventory placement and movement. For example, merchandise is stored and picked from specific locations. The location code prints on pick slips and reports.

Note: If your warehouse locations consist of a warehouse zone, aisle, bin number, and shelf number combination, separate fields are provided for these values. The zone/ aisle/shelf/bin combination must still be entered in this field.

Alphanumeric, 7 positions.

Create screen: required.

Change screen: display-only.

Type

The location type, which determines whether the location is permanent or temporary, and whether merchandise will be replenished to or from the location.

P - Primary location

The primary, or main locations from which items are picked. An item can be stored in more than one primary location. The system will attempt to keep the primary location fully stocked via the Replenish Primary Locations function.

S - Secondary location

Secondary locations are generally used for additional storage when the primary location is full.

If a secondary location is pickable, the system will allocate from it when the total order quantity cannot be filled (completely) from a primary location. The system will allocate from both the primary and secondary locations when neither location contains enough stock to fulfill the entire order. Secondary locations can be used to replenish primary locations.

B - Bulk location

Bulk locations are additional storage locations that are generally used to store case lots or cartons that are not broken up at receiving.

If a bulk location is pickable, the system will allocate from it when the total order quantity cannot be filled (completely) from either a primary or secondary location. The system will allocate from primary, secondary and bulk locations when none of the locations contain enough stock to fulfill the entire order. Bulk locations can be used to replenish primary locations.

T - Temporary location

Temporary locations are used to place merchandise that you want recognized as received, before a permanent location is assigned. When stock is moved into a temporary location, the system creates an item/location record. When the on-hand in the item/location reaches zero, the system deletes the item/location record.

Note: CWDirect will not allocate merchandise from a temporary location even if the location is defined as pickable. In order to allocate stock, you must move the merchandise to a non-temporary, pickable location.

Alphanumeric, 1 position; required.

Zone

A user-defined code to identify the warehouse zone where the location is situated. Assigning zone codes allows you to perform a physical inventory for selected zones only and provides for inventory analysis reporting by zone. Zone codes are also used to sort pick slips when the Cart Bin Picking method is used.

QuickPick zone: If the zone you enter matches the zone defined in the QuickPick Zone Identifier (J41) system control value, the system performs QuickPick Zone Processing during pick slip allocation and printing, separating items allocated to the QuickPick zone from items allocated to non-QuickPick zones.

Alphanumeric, 1 position; optional.

Aisle

A user-defined code to identify the warehouse aisle of the location. Assigning aisle codes allows you to do the following:

• perform a physical inventory for selected zones and aisles

• generate the Warehouse Utilization Report for selected zones and aisles.

Numeric, 2 positions; optional.

Shelf

A user-defined code to identify the location's shelf number within the aisle.

Alphanumeric, 2 positions; optional.

Bin

A user-defined code to identify the location's bin number on the shelf.

Alphanumeric, 2 positions; optional.

Hang/Flat

A code indicating how inventory is stored in the location.

H - indicates that inventory in the location is hung.

F - indicates that inventory in the location is laid flat, or is stored in a conventional manner.

O - indicates that inventory is stored in the location in some other manner.

C - indicates that inventory is stored in a carousel area. You can download pick control detail information to a Carousel system during pick slip generation for any pick control details containing a carousel location if the Use Carousel Interface (G55) system control value is set to Y.

Alphanumeric, 1 position; required.

Picking Sequence

A user-defined sequence number which is used during Pick Slip Generation to determine the sort of the Batch Pick Sheet. When picking sequence numbers are not assigned, the system sorts the locations alphabetically by Location code. The picking sequence code is used by all pick slip generation methods.

The system considers the pick sequence number when sorting picks in a batch if the Sort Picks by Pick Sequence (E89) system control value is set to Y.

Numeric, 7 positions; optional.

Bar code #

A system generated sequence number assigned to the location when it is created. The sequence number prints in bar code format on the bin location labels that can be generated during Receiving Purchase Orders (PORC).

Numeric, 7 positions; display only.

Fill factor

A user-defined percentage value that is used during the Suggest Warehouse Placement program to determine when the location is stocked to capacity. The system evaluates the location capacity entered in the cubic field against the fill factor to determine location's true item capacity.

Example: A location may be considered filled to capacity when 80% of its cubic volume is consumed because of the shape of the items that are stored in it. The cubic volume of a location may be 100 cubic feet, but may hold only eight items that are 10 cubic feet each because the items are spherical in shape. See Chapter 46: Suggest Warehouse Placement (MSLO).

Note: The system assumes the fill factor is 100% if this field is left blank.

Alphanumeric, 5 positions with a 2- place decimal; optional.

Pickable location

A code indicating whether inventory can be picked from the location. All other inventory inquiries display pickable and non-pickable quantities.

Y - indicates that inventory can be picked from the location.

N - indicates that inventory cannot be picked from the location. Bulk locations, or locations where defective merchandise is kept might be defined as non-pickable.

Inventory will be reserved from all locations in the warehouse; if all locations are not pickable, it is possible to reserve more inventory than can be picked. In this situation, one of the following will occur:

• The Pick Slip Generation program will print pick slips for the total quantity that can be obtained from pickable locations. The item number and the quantity that cannot be picked will print on the Stock Allocation Error Report when the Pick Slip Generation program completes.

• Pick slips will be printed for the full 'reserve quantity' using the primary location defined in the Item file as the picking location. Let Down Replenishment will determine the quantity that must be transferred from other locations to fulfill the pick slip run and will process an inventory transfer transaction.

Alphanumeric, 1 position; required.

Freeze

This value indicates whether the location and its merchandise are frozen. Valid values are:

Y = The location is frozen.

N = The location not frozen.

If a location is frozen:

• Pick Slip Generation ignores the location when determining where inventory should be picked to fulfill an order. See Introducing Pick Slip Generation.

• Suggest Warehouse Placement (MSLO) ignores the location when suggesting where to place stock.

• Replenish Warehouses and Replenish Primary Locations do not replenish stock to or from the location.

Alphanumeric, 1 position; required.

Stock type

A user-defined code that describes the type of merchandise that can be found in the location. Examples include DEF (Defective), or RTV (Return to Vendor). This field is informational only.

Alphanumeric, 3 positions; optional.

Frequency Code

A user-defined code that represents the frequency with which inventory is picked from the location. Informational only. Validated against the Frequency Code file. See Merchandising Chapter 2: Working with Frequency Codes (WFRQ).

Alphanumeric, 1 position; optional.

Class (Location class)

A user-defined code that identifies the type of merchandise that will be placed in the location.

This code is used to restrict the placement of certain item types to specific locations. For example, if the location is defined as a 'Jewelry' location, only items that contain the item type code for 'Jewelry' can be placed in the location. The class code entered is validated against the Location Class file; see Chapter 42: Creating and Maintaining Location Classes (WLCL).

Note: If this field is left blank, only items that have a blank location class can be stored in the location.

Alphanumeric, 2 positions; optional.

Capacity: Units

The total number of units that can fit in the location. Suggest Warehouse Placement (MSLO), Replenish Warehouses and Replenish Primary Locations will consider the location filled to capacity when it reaches this number of units.

Numeric, 7 positions; optional.

Capacity: Weight

The total weight the location can hold, expressed in whole pounds. Suggest Warehouse Placement (MSLO), Replenish Warehouses and Replenish Primary Locations will consider the location filled to capacity when the total weight of the items in the location (Shipping weight in the Item file for non-SKUed items, or Shipping weight in the SKU file for SKUed items) in the reaches this weight.

Numeric, 7 positions with 3-place decimal; optional.

Capacity: Cubic

The total cubic volume of the location. Suggest Warehouse Placement (MSLO), Replenish Warehouses and Replenish Primary Locations will consider the location filled to capacity when the total cubic volume of the items in the location reaches this value.

The cubic volume can be expressed in any measurement you wish (e.g., inches, feet, meters, etc.) as long as the same measurement is used throughout the system in the Dimensions: Height, Dimensions: Length, Dimensions: Width, and cubic fields. The system calculates the cubic capacity if values are entered in the height, length, and weight fields.

Note: The value in the Fill factor field works in conjunction with this field.

Numeric, 7 positions; optional.

Dimensions: Height

The total height (the distance from the top to the bottom) of the location. The height can be expressed in any measurement you wish (e.g., inches, feet, meters, etc.) as long as the same measurement is used throughout the system in all Dimensions: Height, Dimensions: Length, Dimensions: Width, and Capacity: Cubic fields.

Numeric, 3 positions; optional.

Dimensions: Length

The total length (the distance from one side to the other) of the location. The length can be expressed in any measurement you wish (e.g., inches, feet, meters, etc.) as long as the same measurement is used throughout the system in all height, length, weight, and cubic fields.

Numeric, 3 positions; optional.

Dimensions: Width

The total width (the distance from the front to the back) of the location. The width can be expressed in any measurement you wish (e.g., inches, feet, meters, etc.) as long as the same measurement is used throughout the system in the height, length, weight, and cubic fields.

Numeric, 3 positions; optional.

Comment

A user-defined comment about the location.

Alphanumeric, 20 positions; optional.

Field

Description

Item

The code of the item assigned to this warehouse location. You can enter any portion of the code to search for the item.

Alphanumeric, 12 positions; optional.

SKU

The code defining unique item characteristics such as its color, size and width. You can enter any portion of the code to search for the SKU.

Alphanumeric, 14 positions; optional.

On hand quantity

The number of units for the item in this location.

Numeric, 7 positions; display-only.

Printed quantity

The number of units currently “allocated” for the item in this location, determined by the total quantity of the item on printed pick slips.

When determining the locations from which to reserve items during pick slip generation, the printed quantity is subtracted from the on-hand quantity in the location to determine the quantity available for reservation.

Numeric, 7 positions; display-only.

Freeze (Reservation freeze flag)

This value indicates whether the item location or SKU location is frozen. Valid values are:

Y = The item/SKU location is frozen.

N = The item/SKU location is not frozen.

If a location is frozen, Replenish Warehouses and Replenish Primary Locations do not replenish stock to or from the location, and Pick Slip Generation does not print picks. See Introducing Pick Slip Generation.

Note: Even though a pick slip does not print for an item from a frozen item location, the system still reserves the item on the Order Lines Fields in Order Entry.

Alphanumeric, 1 position; display-only.

Physical (Physical freeze flag)

This system-updated flag indicates whether the item or SKU location is currently being counted in a physical inventory. Valid values are:

Y = A physical inventory is being performed on the item location.

N = A physical inventory is not being performed on the item location.

If this flag is set to Y, the item is frozen from any transaction affecting the on-hand quantity in this location, for example receiving, picking, replenishment, and either immediate or batch inventory transaction activity.

The system resets this flag to N when you perform the physical inventory update. In situations where the flag is not reset (for example, if there was an inventory transaction error), you can use Resetting the Freeze Flags (RPFF) to unfreeze the item location.

Alphanumeric, 1 position; display-only.