Dc Item Loc

Unique alphanumeric value that identifies the item.

Numeric identifier of the location in which the item is to be found.

Type of location in the location field. Valid values are S (store), W (warehouse), and E (external finisher).

Contains the unit retail price in the selling unit of measure for the item/location combination. This field is stored in the local currency.

Contains the selling unit of measure for an items single-unit retail.

Indicates if item is taxable at the store(Y/N).

Contains the local description of the item.

Contains the local short description of the item.

Number of shipping units (cases) that make up one tier of a pallet.

Number of tiers that make up a complete pallet (height).

This column contains the multiple in which the item needs to be shipped from a warehouse to the location.

Size of an each in terms of the uom_of_price.

Size to be used on the ticket in terms of the uom_of_price.

Unit of measure that will be used on the ticket for this item.

This field contains an item number that is a simple pack containing the item in the item column for this record.

This field indicates the number of inbound handling days for an item at a warehouse type location.

This value will be used by the ad-hoc PO/Transfer creation process to determine which warehouse to fill the stores request from.

This value will be used to specify how the adhoc PO/TSF creation process should source the item/location request.

This field contains the multi-units for the item/location (zone) combination.

This field holds the multi-unit retail in the multi-selling unit of measure for the item/location (zone) combination.

This field holds the selling unit of measure for this item/location (zone) combinations multiunit retail.

A new field to hold the average simple pack weight for a catch weight simple pack.

This column will contain the unique identification number (UIN) used to identify the instances of the item at the location.

This column will contain the label for the UIN when displayed in SIM.

This column will indicate when the UIN should be captured for an item during transaction processing.

This Yes/No indicator indicates if UIN is being generated in the external system.