Repl Attr Upd Hist

This field contains the sequence value from REPL_ATTR_UPD_ID_S.

Department id. Oracle Retail target column DEPT on REPL_ATTR_UPD_HIST.

Class id. Oracle Retail target column CLASS on REPL_ATTR_UPD_HIST.

Subclass id. Oracle Retail target column SUBCLASS on REPL_ATTR_UPD_HIST.

This field holds the concatenated value of the aggregated differentiators.

Item value. Oracle Retail target column ITEM on REPL_ATTR_UPD_HIST.

Location type of the location where replenishment attributes are being applied.

Location at which the replenishment attributes are being applied.

Parent item number. Oracle Retail target column ITEM_PARENT on REPL_ATTR_UPD_HIST.

Grandparent item number. Oracle Retail target column ITEM_GRANDPARENT on REPL_ATTR_UPD_HIST.

Size profile indicator checkbox value.

Stores the supplier to which an order would be sent for replenishment.

Supplier origin country. Oracle Retail target column ORIGIN_COUNTRY_ID on REPL_ATTR_UPD_HIST.

Contains the number representing when the specified item location will be reviewed for replenishment.

Sourcing strategy for the item/location relationship.

Determines in what way the replenishment process will create an order.

Numeric identifier for the warehouse through which the item will cross-dock.

Date on which the item location will start to be reviewed for replenishment.

Date at which time the item location will no longer be reviewed for replenishment.

Minimum amount of stock that needs to be on store shelves.

Amount of stock that cannot be sold as new and is not counted as part of inventory in the replenishment calculations.

Character code for the algorithm that will be used to calculate the recommended order quantity for the item location.

Required minimum number of units available for sale.

Required maximum number of units available for sale.

Percentage by which the min and max stock levels will be multiplied when calculating the recommended order quantity.

Minimum number of days of supply of stock to maintain. Used in the Time Supply replenishment method algorithm.

Maximum number of days of supply of stock to maintain. Used in the Time Supply replenishment method algorithm.

Number of days over which an average sales rate is calculated to be used in the Time Supply replenishment method algorithm.

Number of required days of on hand inventory to satisfy demand. Used in the Dynamic replenishment method algorithm.

Required measure of probability that demand is satisfied from on hand inventory. Used in the Dynamic replenishment method algorithm.

Percentage of sales that could have occurred if inventory had been available through the order lead- time.

Indicator that determines if uploaded store orders should be rejected.

Indicator used to determine if the item/location should be exempt from scaling during the order scaling process during replenishment.

Contains the limit up to which order scaling can increase the order quantity for the item/location during the replenishment process.

Expected number of days required to ship the item from the supplier to the intitial receiving location.

Expected number of days required to move the item from the warehouse to the store defined on this record.

Contains desired stock on hand for the item location when the end of season is reached.

Season for which this item location is being replenished.

Phase within the season for which this item location is being replenished.

Primary simple pack that will be used to replenish the item.

Quantity of the item in the simple pack if a primary replenishment pack is being used to replenish the item.

The allowable unit change to order quantities generated from replenishment.

The allowable percent change to order quantities generated from replenishment.

Indicates whether or not unit and percent tolerance will be used.

Drives the safety stock calculation algorithm.

Pack size level at which the item (or primary replenishment pack) is shipped between warehouses and stores.

Date on which the item location was last reviewed.

Week number in the year. Oracle Retail target column WEEK_NUM on REPL_ATTR_UPD_HIST.

Holds user information who last updated the repl attributes.

Records the date and time stamp at which the repl attr form was submitted.

This indicates if a transfer should be created even though the warehouse does not have enough stock on hand. Default value is N

This indicates if an item can be replenished multiple times per day at the location. Default value is N

When selected, this field is used by Inventory Optimization (IO) to determine whether to optimize the item/location. Currently this field will be used for Min/Max of replenishment method.

Indicates whether the additional demand is enabled for an Item/Location or not.

Indicates the default access that a store user has for updating and approving semi-automatic single location store orders and transfers. Valid values are: 'RES - Restricted', 'REV - Review', 'APRV - Approve', defined in code detail with code type 'STUA'.

Indicates the Tolerance Type that should be applicable for edits done by store system to the quantities requested in the semi-automatic single location store orders and transfers. Valid values are 'PER - Percentage', 'UNI- Units', defined in code detail with code type 'STTY'.