Item Loc

Unique alphanumeric value that identifies the item.

Numeric identifier of the location in which the item is to be found. This field may contain a store, warehouse, or external finisher.

Alphanumeric value that uniquely identifies the item/group at the level above the item.

Alphanumeric value that uniquely identifies the item/group two levels above the item.

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 standard unit of measure for the item/location combination. This field is stored in the local currency.

This field holds the unit retail in the standard unit of measure for the item/location (zone) combination. This field is stored in the local currency.

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 is stored in teh local currency.

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

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.

Contains the current promotional unit retail price in the standard unit of measure for the item/store combination. This field will only contain a value if the item is on promotion. This field is stored in the local currency.

Contains the current promotional unit retail price in the selling unit of measure for the item/store combination. This field will only contain a value if the item is on promotion. This field is stored in the local currency.

Contains the selling unit of measure for an items promotional single-unit retail. This field will only contain a value if the item is on promotion.

Indicates if item is on clearance at the store. Valid values are: Y = Yes, the item is on clearance N = No, the item is not on clearance

Indicates if item is taxable at the store. Valid values are: Y = Yes, the item is taxable N = No, the item is not taxable

Contains the local description of the item. This field will default to the items description but will be over-ridable. This value will be downloaded to the POS.

Contains the local short description of the item. This field will default to the items short description but will be over-ridable. This value will be downloaded to the POS.

Number of shipping units (cases) that make up one tier of a pallet. Multiply TI x HI to get total number of cases for a pallet.

Number of tiers that make up a complete pallet (height). Multiply TI x HI to get total number of cases for a pallet.

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

Current status of item at the store. Valid values are: A = Active, item is valid and can be ordered and sold I = Inactive, item is valid but cannot be ordered or sold C = Discontinued, item is valid and sellable but no longer orderable D = Delete, item is invalid and cannot be ordered or sold

Date on which the status for item at the store was most recently changed.

Average percentage lost from inventory on a daily basis due to natural wastage.

Size of an each in terms of the uom_of_price. For example 12 oz. Used in ticketing.

Size to be used on the ticket in terms of the uom_of_price. For example, if the user wants the ticket to have the label print the price per ounce, this value would be 1. If the user wanted the price per 100 grams this value would be 100. Used in ticketing.

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

This field is used to address sales of PLUs (i.e. above transaction level items) when inventory is tracked at a lower level (i.e. UPC). This field will only contain a value for items one level higher than the transaction level. Valid choices will be any transaction level item that is a child of this item. In order to select a transaction level item as the primary variant, the item/location relationship must exist at the transaction level. Both the transaction level item (i.e. UPC) and the higher than transcation level item (i.e. PLU) will be sent to the POS to allow the store to sell the PLU. The information sent for the PLU will be the same information sent for the Transaction level item (i.e. UPC).

This field contains an item number that is a simple pack containing the item in the item column for this record. If populated, the cost of the future cost table will be driven from the simple pack and the deals and cost changes for the simple pack.

Numeric identifier of the supplier who will be considered the primary supplier for the specified item/loc. The supplier/origin country combination will determine the value of the unit cost field on item_loc. If the supplier is changed and ELC = N, the unit cost field on item_loc will be updated with the new suppliers cost.

Contains the identifier of the origin country which will be considered the primary country for the specified item/location.

This column determines whether the stock on hand for a pack component item or the pack itself will be updated when a pack is received at a warehouse. Valid values are Each (E) or Pack (P). This value is required for all pack items where the location type is Warehouse (W). For vendor packs, this must be set to Pack (P), for buyer packs it can be either Each (E) or Pack (P).

Date/time stamp of when the record was created. This date/time will be used in export processing. This value should only be populated on insert - it should never be updated

Holds the date time stamp of the most recent update by the last_update_id. This field is required by the database.

Holds the Oracle user-id of the user who most recently updated this record. This field is required by the database.

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

This value will be used to specify how the ad-hoc PO/TSF creation process should source the item/location request. If the value is Warehouse, the process will attempt to fill the request by creating a transfer from the warehouse mentioned in the source_wh field. If this warehouse doesn't have enough inventory to fill the request, a purchase order will be created for the item/location's primary supplier. For warehouses, it is used by Oracle Retail Allocation to determine the valid sources and destinations for warehouse to warehouse allocations.

This value will be used by the ad-hoc PO/Transfer creation process to determine which warehouse to fill the stores request from. It will also be used by the Allocation process to support warehouse to warehouse allocations. A value will be required in this field if the sourcing method is Warehouse.

This field indicates if an item at a particular store location can have the unit retail marked down by the store.

This column indicates whether or not RPM has processed the item/location combination.

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.

This column determines if the location is ranged intentionally by the user for replenishment/selling or incidentally ranged by the RMS programs when item is not ranged to a specific location on the transaction.

Numeric identifier of the costing location for the franchise store. This field may contain a store or a warehouse.

This field holds the type of costing location in the costing location field.

This column holds the User id of the user who created the record.

This attribute, which has valid values of Y or N, determines whether or not the item can be promoted. This flag will be sent to the selling solutions (e.g. POS, OMS) to help their pricing engines know whether or not to include this item location in the items eligible for a specific promotion. This new attribute is intended to be used for item location combinations that are never promoted so that users setting up promotions do not need to specify them as exclusions on the promotion.

This field allows the retailer to specify if the item should be RFID tagged or not.

Contains the date upon which the item will begin its selling phase at the store. It is used to determine the timing of the generation of markdown recommendation, which will occur x weeks after the start of this phase. It may get reset each time a new receipt comes in, or entered manually via the UI, or determined by a planning system and integrated in.

Oracle Retail target column UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND on ITEM_LOC.

Oracle Retail target column UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND on ITEM_LOC.

Oracle Retail target column UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND on ITEM_LOC.

Contains the minimum shipped quantity of an item on a transfer/allocation that will trigger the resetting of the Selling Phase Start Date. This value is only used if either of the Set Selling Start Date upon Receipt of a Warehouse to Store Transfer/Allocation or Set Selling Start Date upon Receipt of a Store to Store Transfer are set to Yes (Y). If this field is left NULL and the warehouseh to store or store to store flags are Yes (Y), the minimum will be considered zero, so if any units are received the date is set/reset.

This field holds the tax-inclusive Manufacturer Suggested Retail in local currency and in item’s standard UOM.

This field holds the tax-exclusive Manufacturer Suggested Retail in local currency and in item’s standard UOM.