MSC_REPL_POLICY_COMP_DATA

Table msc_repl_policy_comp_data holds values required for replenishment planning policy comparison process.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

msc_repl_policy_comp_data_PK

PLAN_ID, SEGMENT_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID

Columns

Name Datatype Length Precision Not-null Comments
PLAN_ID NUMBER 18 Yes Primary key and foreign key to msc_plan_definitions table.
SEGMENT_ID NUMBER 18 Yes Primary key and Id for the segment and foreign key to the msc_segment_b table.
INVENTORY_ITEM_ID NUMBER 18 Yes Primary key and Id for the item and foreign key to the msc_system_items table.
ORGANIZATION_ID NUMBER 18 Yes Primary key and Id for the organization and foreign key to the msc_parameters table.
POLICY_REVIEW_STATUS NUMBER Review status of the policy change. 32 = Automatically Accepted, 33 = Manually Accepted, 34 = To Be Reviewed, 35 = Reviewed, 36 = Adjusted, 37 = Retained.
POLICY_TYPE NUMBER Type of policy for which policy parameters are defined.
POLICY_UOM NUMBER Unit of measure in which the policy is defined.
MIN_QTY NUMBER Minimum quantity, specified in units.
MIN_QTY_ADJUSTED NUMBER Minimum quantity specified in units, as adjusted by the user.
MIN_QTY_SUGGESTED NUMBER Suggested minimum quantity in units. A suggested minimum quantity will be recommended when the difference between the final minimum quantity and suggested minimum quantity, calculated in the latest plan run, exceeds the threshold specified in the plan.
MIN_QTY_DEVIATION NUMBER Percentage of deviation between final minimum quantity and suggested minimum quantity.
MIN_QTY_PRIOR_TYPE NUMBER An indicator that specifies how the minimum quantity measure was determined in the previous policy calculation process.
MIN_QTY_PRIOR NUMBER The quantity calculated during the previous policy calculation process for the Minimum quantity measure.
MAX_QTY NUMBER Maximum quantity, specified in units.
MAX_QTY_ADJUSTED NUMBER Maximum quantity specified in units, as adjusted by the user.
MAX_QTY_SUGGESTED NUMBER Suggested maximum quantity in units. A suggested maximum quantity will be recommended when the difference between the final maximum quantity and suggested maximum quantity, calculated in the latest plan run, exceeds the threshold specified in the plan.
MAX_QTY_DEVIATION NUMBER Percentage of deviation between final maximum quantity and suggested maximum quantity.
MAX_QTY_PRIOR_TYPE NUMBER An indicator that specifies how the maximum quantity measure was determined in the previous policy calculation process.
MAX_QTY_PRIOR NUMBER The quantity calculated during the previous policy calculation process for the Maximum quantity measure.
ROP_QTY NUMBER Reorder point quantity, calculated in units.
ROP_QTY_ADJUSTED NUMBER Reorder point quantity specified in units, as adjusted by the user.
ROP_QTY_SUGGESTED NUMBER Suggested reorder point quantity in units. A suggested reorder point quantity will be recommended when the difference between the final reorder point quantity and suggested reorder point quantity, calculated in the latest plan run, exceeds the threshold specified in the plan.
ROP_QTY_DEVIATION NUMBER Percentage of deviation between final reorder point quantity and suggested reorder point quantity.
ROP_QTY_PRIOR_TYPE NUMBER An indicator that specifies how the reorder point quantity measure was determined in the previous policy calculation process.
ROP_QTY_PRIOR NUMBER The quantity calculated during the previous policy calculation process for the reorder point quantity measure.
MIN_DAYS NUMBER Minimum quantity, calculated in days.
MIN_DAYS_ADJUSTED NUMBER Minimum quantity specified in days, as adjusted by the user.
MIN_DAYS_SUGGESTED NUMBER Suggested minimum quantity in days. A suggested minimum quantity will be recommended when the difference between the final minimum quantity and suggested minimum quantity, calculated in the latest plan run, exceeds the threshold specified in the plan.
MIN_DAYS_DEVIATION NUMBER Percentage of deviation between final minimum days and suggested minimum days.
MIN_DAYS_PRIOR_TYPE NUMBER An indicator that specifies how the previous minimum days measure was determined in the previous policy calculation process.
MIN_DAYS_PRIOR NUMBER The minimum quantity, in days, calculated during the previous policy calculation process.
MAX_DAYS NUMBER Maximum quantity, calculated in days.
MAX_DAYS_ADJUSTED NUMBER Maximum quantity specified in days, as adjusted by the user.
MAX_DAYS_SUGGESTED NUMBER Suggested maximum quantity in days. A suggested maximum quantity will be recommended when the difference between the final maximum quantity and suggested maximum quantity, calculated in the latest plan run, exceeds the threshold specified in the plan.
MAX_DAYS_DEVIATION NUMBER Percentage of deviation between final maximum days and suggested maximum days.
MAX_DAYS_PRIOR_TYPE NUMBER An indicator that specifies how the previous maximum days measure was determined in the previous policy calculation process.
MAX_DAYS_PRIOR NUMBER The maximum quantity, in days, calculated during the previous policy calculation process.
ROP_DAYS NUMBER Reorder point quantity, calculated in days.
ROP_DAYS_ADJUSTED NUMBER Reorder point quantity specified in days, as adjusted by the user.
ROP_DAYS_SUGGESTED NUMBER Suggested reorder point quantity in days. A suggested reorder point quantity will be recommended when the difference between the final reorder point quantity and suggested reorder point quantity, calculated in the latest plan run, exceeds the threshold specified in the plan.
ROP_DAYS_DEVIATION NUMBER Percentage of deviation between final reorder point days and suggested reorder point days.
ROP_DAYS_PRIOR_TYPE NUMBER An indicator that specifies how the previous reorder point days measure was determined in the previous policy calculation process.
ROP_DAYS_PRIOR NUMBER The reorder point quantity, in days, calculated during the previous policy calculation process.
AVG_DAILY_DMD_SUGGESTED NUMBER Average daily demand, suggested by the policy comparison process.
AVG_DAILY_DMD_PRIOR NUMBER Average daily demand, calculated during the previous policy calculation process.
EOQ_SUGGESTED NUMBER Suggested economic order quantity, in units, Suggested by the policy comparison process.
EOQ_PRIOR NUMBER Suggested economic order quantity, in units, calculated during the previous policy calculation process.
SS_QTY_SUGGESTED NUMBER Safety stock quantity, suggested by the policy comparison process.
SS_QTY_PRIOR NUMBER Safety stock quantity, calculated during the previous policy calculation process.
SS_DAYS_SUGGESTED NUMBER Safety stock in days, suggested by the policy comparison process.
SS_DAYS_PRIOR NUMBER Safety stock in days, calculated during the previous policy calculation process.
ORDER_QTY_SUGGESTED NUMBER Order quantity, suggested by the policy comparison process.
ORDER_QTY_PRIOR NUMBER Order quantity, calculated during the previous policy calculation process.
UPDATE_STATUS NUMBER 1 Update status indicates the update status of the row. null = not updated, 1 = user updated, 2 = updated to plan data tables.
PAR_LEVEL NUMBER Periodic automatic replenishment level, specified in units.
PAR_LEVEL_ADJUSTED NUMBER Periodic automatic replenishment level specified in units, as adjusted by the user.
PAR_LEVEL_SUGGESTED NUMBER Suggested periodic automatic replenishment level in units. A suggested periodic automatic replenishment level will be recommended when the difference between the final periodic automatic replenishment level and suggested periodic automatic replenishment level, calculated in the latest plan run, exceeds the threshold specified in the plan.
PAR_LEVEL_DEVIATION NUMBER Percentage of deviation between final periodic automatic replenishment level and suggested periodic automatic replenishment level.
PAR_LEVEL_PRIOR_TYPE NUMBER An indicator that specifies how the periodic automatic replenishment level measure was determined in the previous policy calculation process.
PAR_LEVEL_PRIOR NUMBER The quantity calculated during the previous policy calculation process for the periodic automatic replenishment level measure.
PAR_MAX NUMBER Periodic automatic replenishment maximum level, specified in units.
PAR_MAX_ADJUSTED NUMBER Periodic automatic replenishment maximum level specified in units, as adjusted by the user.
PAR_MAX_SUGGESTED NUMBER Suggested periodic automatic replenishment maximum level in units. A suggested periodic automatic replenishment maximum level will be recommended when the difference between the final periodic automatic replenishment maximum level and suggested periodic automatic replenishment maximum level, calculated in the latest plan run, exceeds the threshold specified in the plan.
PAR_MAX_DEVIATION NUMBER Percentage of deviation between final periodic automatic replenishment maximum level and suggested periodic automatic replenishment maximum level.
PAR_MAX_PRIOR_TYPE NUMBER An indicator that specifies how the periodic automatic replenishment maximum level measure was determined in the previous policy calculation process.
PAR_MAX_PRIOR NUMBER The quantity calculated during the previous policy calculation process for the periodic automatic replenishment maximum level measure.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
MSC_REPL_POLICY_COMP_DATA_U1 Unique Default PLAN_ID, SEGMENT_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID