Repl Results

Contains a character indicator to determine where the recommended order quantity is coming from. It will only contain one valid value. This column, used in conjunction with the SOURCE_TYPE column on IB_RESULTS and BUYER_WKSHT_MANUAL will aid in distinguishing which table the ROQ is coming from when displayed on the Buyer Worksheet form. R - Replenishment

Status of the record. Valid values include: W - Worksheet P - PO-Processed (is associated with a PO) D - Deleted

This field will allow a link to be created between repl_results and ord_temp. It will be used by rplbld.pc when calculating due orders. Rplbld needs to have visibility to SSO and ESO from repl_results.

A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (i.e. warehouse) on the transfer to fulfill the transfer quantity to the to location (i.e store) on the transfer.

Contains the number of the order on which the item/location has been placed.

Contains the number of the allocation on which the item/location has been placed.

Contains the item that is being reviewed and against which replenishment calculations are performed. The item placed on the order/transfer may not necessarily be this item, but may be a simple pack used in ordering this item or a substitute item used in transferring this item.

contains the item that is on replenishment.

Contains a character indicator to determine if the item being ordered/transferred is the item actually being reviewed and against which replenishment calculations are performed (i.e. the master item), or if the item is a simple pack or substitute item being used to replenish the master item. Valid values include: M - Master item. This indicates that the item being reviewed is actually the item being ordered/transferred. P - Simple pack item. This indicates that the item being reviewed is actually being replenished through the use of a simple pack. S - Substitute item. This indicates that the item being reviewed is actually being replenished through the use of a substitute item.

The number of the department to which the item is attached.

The number of the class to which the item is attached.

The number of the subclass to which the item is attached.

The number that uniquely identifies the buyer for the items department.

Contains the quantity of the item in the pack being used to replenish the item.

contains the type of the location on replenishment. Valid values include Store, Warehouse.

contains the numeric identifier of the location that is on replenishment.

The number of the physical warehouse that is assigned to the virtual warehouse.

Contains the numeric identifier of the supplier from which the specified location will source the replenishment demand for the specified item location.

contains the country code of the supplier country that will be used to supply the replenishment demand for the specified item location.

This column will link the supplier, supplier/department, supplier/location, or the supplier/department/location to a master supplier.

This field is used to store the unit cost of the item specified at the item/supplier/origin country/location level. It will never be modified. This field, in conjunction with the unit cost field, will determine the cost source to be used at the order/item/location level. It is stored in the suppliers currency.

- The unit cost of the item defaulted from the item/supplier/origin country/location level. It may be edited. This field, in conjunction with the supplier unit cost field, will determine the cost source to be used at the order/item/location level. It is stored in the suppliers currency.

Contains the original recommended order quantity (ROQ) before any recalculations were performed on the quantity.

Contains the original recommended order quantity (ROQ) for the items simple pack before any recalculations were performed on the quantity.

Contains the raw recommended order quantity (ROQ) calculated by the system before any pack size rounding, proration, etc. was performed on the quantity

Contains the raw recommended order quantity (ROQ) for the items simple pack calculated by the system before any pack size rounding, proration, etc. was performed on the quantity.

Contains the recommended order quantity (ROQ) for the item/location before order scaling processing was performed on the quantity and after pack size rounding, proration, ec. Was performed.

Contains the actual recommended order quantity (ROQ) for the item/location after all pack size rounding, proration and scaling logic is performed on the order quantity.

Contains the recommended order quantity (ROQ) for the item/location that was to be sourced using contracts.

Contains the recommended order quantity (ROQ) that can actually be sourced using contracts. If the entire order quantity could be sourced from contracts, this number will be the same as the contract_roq.

This column will hold the most recent system rounded order quantity value for the line item.

This column will hold the last system rounded order quantity for the rounding group the location is apart of.

Contains the net inventory for the item/location. Includes stock on hand, orders, transfers, allocations, unavailable inventory, reserved inventory.

Contains the current stock on hand position of the item at the location.

Contains the current stock on hand position of the item at the location as a component of a pack.

Contains the current on-order position of the item at the location.

Contains the quantity of the item that is currently in transit to the location.

Contains the quantity of item that is currently in transit to the location as a component of a pack.

Contains the quantity of the item reserved for transfers from the location.

Contains the quantity of the item reserved for transfers from the location as a component of a pack.

Contains the quantity of the item expected for transfers to the location.

Contains the quantity of the item expected for transfers to the location as a component of a pack.

Contains the quantity of the item waiting to be returned from the location.

Contains the quantity of the item on allocations to the location.

Contains the quantity of the item on allocations out of the location.

Contains the quantity of the item that is non-sellable at the location.

Contains the level below which a recommended order quantity is generated if the net inventory is lower than the order point, for the item/location.

Contains the level up to which a recommended order quantity should bring the net inventory of the item.

Contains the quantity of the calculated safety stock for the item/location.

Contains the quantity of the calculated lost sales for the item/location.

Contains the forecasted amount over the minimum time supply days. Used for the time supply replenishment methods.

Contains the forecasted amount over the maximum time supply days. Used for the time supply replenishment methods.

Contains the forecasted amount over the time supply horizon. Used for the time supply replenishment methods.

Contains the forecasted amount over the inventory selling days. Used for the dynamic replenishment methods.

Contains the forecasted amount over the review time. Used for the dynamic replenishment methods.

Contains the forecasted amount over the order lead time. Used for the dynamic replenishment methods.

Contains the Next review cycles lead time forecast. This value is used in the dynamic order quantity calculations.

Contains the accepted stock out (ASO) quantity for the item/location.

Contains the estimated stock out (ESO) quantity for the item/location.

Indicator to determine if the item/location is Due. This is where the estimated stock out (ESO) value of the item/location is greater than the accepted stock out (ASO) value of the item/location. Valid values include: Y - Yes. The item/location is due. N - No. The item/location is not due.

Contains the number of days in the review time used in the recommended order quantity calculations.

Determines if the replenishment process will create an actual order/transfer line item for the item location if there is a need for the item location or if only a record is written to the Replenishment Results table. Valid values are Manual (a record is written to the Replenishment Results table - no order/transfer line item is created), Semi-Automatic (an order/transfer line item is created - the order line item will be added to an order in Worksheet status, the transfer line item will be added to a transfer in Approved status with a freight type of Hold), Automatic (an order/transfer line item is created - the order line item will be added to an order in Approved status, the transfer line item will be added to a transfer in Approved status), Buyer Worksheet (a record is written to the Replenishment Results table and can be added to a purchase order on the Buyer Worksheet form/a transfer line item is added to a transfer in Approved status with a freight type of Hold).

Contains the number representing when the specified item location will be reviewed for replenishment. Valid values are 0 - 14. A 0 represents a weekly review cycle, a 1 represents a daily review cycle, a 2 represents a review cycle of every 2 weeks, a 3 represents a review cycle of every 3 weeks, etc.

Contains the sourcing strategy for the item/location relationship. Valid values are Direct to store (supplier to store), Cross-docked (supplier to store flowing through the warehouse), Warehouse stocked (warehouse to store), L for WH/Cross Link (warehouse to store and supplier to warehouse if insufficient warehouse stock).

Contains the numeric identifier of the warehouse through which the specified item will cross-dock to the specified store for a stock category of Cross-docked; or the numeric identifier of the warehouse from which the specified item will be sourced for the specified store for a stock category of Warehouse Stocked.

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

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

Contains the minimum amount of stock that needs to be on store shelves. The presentation stock is nor expected to satisfy consumer demand but is expected to remain in the fixture.

Contains the amount of stock that cannot be sold as new and is not counted as part of inventory in the replenishment calculations. The value in this field is the amount of stock used strictly for demonstration purposes.

Contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. Valid values include Constant, Min/Max, Floating point, Time Supply, Dynamic, SO Store Orders.

Contains the required minimum number of units available for sale. Used in the Min/Max replenishment method algorithm.

Contains the required maximum number of units available for sale. Used in the Constant, Min/Max and Floating Point replenishment method algorithms.

Contains the percentage by which the min and max stock levels will be multiplied when calculating the recommended order quantity. Ex. Actual max stock = max stock * increment percent.

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

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

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

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

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

Contains the percentage of sales that could have occurred if inventory had been available through the order lead time. Used in the Dynamic replenishment method algorithm.

Contains the desired stock on hand for the item location when the end of season is reached. Used in the Seasonal Dynamic and Seasonal Time Supply replenishment methods.

Contains the numeric identifier of the season for which this item location is being replenished. Used in the Seasonal Dynamic and Seasonal Time Supply replenishment methods.

Contains the numeric identifier of the phase within the season for which this item location is being replenished. Used in the Seasonal Dynamic and Seasonal Time Supply replenishment methods.

Contains an indicator that determines if uploaded store orders should be rejected. If the indicator is N, then store orders for all need dates are valid. If Y, store orders with needs date on or after the NEXT_DELIVERY_DATE are valid.

Indicator used to determine if the item/location should be exempt from scaling during the order scaling process during the replenishment process. Y - Yes. The item/locations order quantity will not be adjusted during the order scaling process. N - No. The item/locations order quantity will be adjusted during the order scaling process.

Contains the limit up to which order scaling can increase the order quantity for the item/location during the replenishment process. If the replenishment method is C (constant), M (min/max), F (floating point) this value will be a quantity (ex. 1,000 eaches). If the replenishment method is a dynamic or time supply method this value will be a number of days. This field is intended to prevent run-away scaling processes as well as to protect items from being ordered to locations in such amounts that would result in perishability or obscelesence issues.

Contains the expected number of days required to send the order to the supplier and have the item ready for pickup to the initial receiving location.

Contains the expected number of days required to ship the item from the supplier to the initial receiving location, which may be a store or warehouse defined on this record or the cross-dock warehouse through which the item will flow to get to the store defined on this record.

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

Contains the calculated lead time for the next review cycle used in the replenishment calculations.

Contains the number of days added to the current lead time during the replenishment calculation due to a location being closed for delivery.

Contains the number of days added to the next order lead time during the replenishment calculation due to a location being closed for delivery..

Contains the inner size quantity for the item.

Contains the case size quantity for the item.

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

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

Contains the store order multiple for the item

Determines if the item/location replenishment attributes have been changed and the item/location is eligible for replenishment recalculation and if so, what type of recalculation. Valid values include: N - No. Recalculation is not required. Q - Quantity. The order quantity should be updated using the quantity manually entered. A - Attributes. The order quantity should be updated by recalculating the order quantity based on the changed replenishment attributes.

Contains the date of the replenishment run that created this record.

Contains the quantity the order should be set to if the recalc_type field is set to Quantity.

This column will store the auditing session ID when the user selects this record to create purchase orders with from the Buyer Worksheet form. This value will be used to identify which records should be grouped together for the purchase order and rounding libraries per user.

The date on which the item is needed at the store.

This column specifies when the store requested quantity is needed at the store on the need date.

Holds the expected number of days for the current order to arrive.

This field contains the in progress sales quantity of the item in store.

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.

Repl results record unique identifier.

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'.