1. Tables and Views for SCM
  2. MSC_INV_PA_SEGMENT

MSC_INV_PA_SEGMENT

Table that collects all policy parameters for a policy assignment set

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MSC_INV_PA_SEGMENT_PK

POLICY_SET_ID, PLAN_ID, SEGMENT_ID

Columns

Name Datatype Length Precision Not-null Comments
POLICY_SET_ID NUMBER 18 Yes POLICY_SET_ID Sequence generated primary key
PLAN_ID NUMBER 18 Yes PLAN_ID Foreign key to the MSC_PLAN_DEFINITIONS table for Plan specific data, -1 for non-plan specific data
SEGMENT_ID NUMBER 18 Yes SEGMENT_ID field is the foreign key to the MSC_SEGMENT_B table
POLICY_TYPE NUMBER Yes Default is set to "Min-Max planning" . The other values must be "Fixed Order Calendar", "ROP-OQ" ("Re-Order Point - Order Quantity") and "ROP-EOQ" ("Re-Order Point - economic Order Quantity")
ORDERING_CALENDAR VARCHAR2 22 Only editable and mandatory when the Policy type is Fixed Order Calendar. This calendar governs on days when replenishment orders can be placed.
POLICY_UOM NUMBER 4 Yes defines the uom of the values that will be calculated 1 - Units (Default), 2 - Days
SS_CALC_METHOD NUMBER 4 Yes Determines the calculation method for safety stock value. Default is ‘Days of Cover’. The other allowable value is "Service Level Based".
SS_DAYS_OF_COVER NUMBER Number of days to use when calculating safety stock. Only editable and mandatory when ‘Safety Stock Calculation Method’ is ‘Days of Cover’.
DATA_IN_DAYS NUMBER Number of days to use for history or forecast values
EXTRAPOLATION_PERCENTAGE NUMBER Extrapolation percentage is used to extrapolate the ‘Average historical daily demand’. Only editable when ‘Days of Cover basis’ is ‘History’.
DAYS_OF_COVER_BASIS NUMBER 4 Yes Determines if History or Forecast values are used for calculating safety stock
TGT_SERVICE_LVL_PERCENT NUMBER A single Target Service Level % value can be specified here - the calculated Safety Stock will depend on this value, the Forecast Distribution and the forecast attributes (Mean, Variance, etc)
MAX_QTY_CALC_METHOD NUMBER defines the calculation method for max quantity
MAX_QTY_COVERAGE_DAYS NUMBER number of days for max value calculation. Editable and Mandatory when ‘Max quantity Calculation Method’ is ‘Days of coverage’
DEFAULT_ORDER_QTY NUMBER User entered default for order quantity. Editable when Max Quantity calculation method
DEF_CARRYING_COST_PERCENT NUMBER User entered carrying cost percent. Only integer values between 1 and 100 allowed. Editable when Max quantity calculation method is ‘Min + EOQ’
DEFAULT_ORDERING_COST NUMBER user entered default ordering cost. Editable when Max quantity calculation method is ‘Min + EOQ’
DEFAULT_STANDARD_COST NUMBER User entered standard cost. Editable when Max quantity calculation method is ‘Min + EOQ’
DEFAULT_DAILY_DEMAND NUMBER Default daily demand is a user defined default if the calculated daily demand is null
DEFAULT_EOQ NUMBER User entered EOQ used when calculated EOQ is null
SS_OVERRIDE NUMBER user entered Safety Stock Override, value is used and safety stock is not calculated
MIN_OVERRIDE NUMBER Min Quantity Override - Only integer none zero values allowed. If SS Override is defined then a check should be done to ensure Min Quantity Override > SS Override.
MAX_OVERRIDE NUMBER Max Quantity Override - Only integer none zero values allowed. Have a check to ensure Max Quantity Override > Min Quantity Override > SS Override. Should be editable only when Policy type is ‘Min-Max Planning’.
EOQ_OVERRIDE NUMBER EOQ Override - Only integer none zero values allowed. Should be editable only when Policy type is ‘ROP-EOQ’.
ORDER_QTY_OVERRIDE NUMBER Order Quantity Override - Only integer none zero values allowed. Should be editable only when Policy type is ‘ROP-OQ’.
ROP_OVERRIDE NUMBER Only integer none zero values allowed. Should be editable only when Policy type is ROP-OQ or ROP-EOQ.
PAR_TIME_PERIOD NUMBER Time Period for PAR Replenishments - Available for editing when PAR Replenishment policy type is selected. Valid values between 1 and 120. 0 not allowed. Upto 2 decimal places.
DELIVERIES_PER_TIME_PERIOD NUMBER Number of Deliveries per Time Period - Available for editing when PAR Replenishment policy type is selected. Valid values between 1 and 30. 0 not allowed. Only integers.
PAR_LEVEL_OVERRIDE NUMBER PAR Level Override - Available for editing when PAR Replenishment policy type is selected. Fields can be null. Zero is not allowed.
PAR_MAX_OVERRIDE NUMBER PAR Maximum Override - Available for editing when PAR Replenishment policy type is selected. Fields can be null. Zero is not allowed.
MODIFIED NUMBER 1 A value of 1 signifies policy parameters for this segment were modified in simulation mode
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_INV_PA_SEGMENT_U1 Unique Default POLICY_SET_ID, PLAN_ID, SEGMENT_ID