MSC_PLAN_DEFINITIONS
This table stores all the data related to plans
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_PLAN_DEFINITIONS_PK |
PLAN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | Yes | This is the unique identifier for the plan. | |
| PLAN_MEMORY_SIZE | NUMBER | This column stores the memory size. | |||
| SSQ_OVERRIDE | NUMBER | 1 | This column holds the value of the flag :Safety stock override. Values are Yes(1) or No (2). | ||
| END_ITEM_SUBST_FLAG | NUMBER | 1 | This column holds the values of the flag:Use end item substitutes. Values are Yes(1) or No(2). | ||
| SUBST_COMP_FLAG | NUMBER | 1 | This column holds the values of the flag: Use substitute components. Values are Yes(1) or No(2). | ||
| SUP_CAP_CONSTRAINTS_FLAG | NUMBER | 1 | This column holds the values of the flag: Apply supplier capacity constraints.Values are Yes(1) or No(2). | ||
| ALT_RESOURCES_FLAG | NUMBER | 1 | This column holds the values of the flag: Use alternate resources. Values are Yes(1) or No(2). | ||
| ALT_SUP_SOURCE_ORG_FLAG | NUMBER | 1 | This column holds the values of the flag: Use alternate suppliers and source organizations. Values are Yes(1) or No(2). | ||
| ITEM_IN_SUBS_CHAIN | NUMBER | 1 | This column holds the values of the flag: Item in the substitution chain for which supplies are created. Values are Yes(1) or No(2). | ||
| ALT_ITEM_WORK_DEF_FLAG | NUMBER | 1 | This column holds the values of the flag: Use alternate item structures and work definitions. Values are Yes(1) or No(2). | ||
| CAP_CONSTRAINTS_FLAG | NUMBER | 1 | This column holds the values of the flag: Apply capacity constraints to bottleneck resources only. Values are Yes(1) or No(2). | ||
| PLAN_FIRST_BUCKET | NUMBER | 1 | This column holds the values of the flag: Plan First Bucket. Values are Yes(1) or No(2). | ||
| PLAN_SECOND_BUCKET | NUMBER | 1 | This column holds the values of the flag: Plan Second Bucket. Values are Yes(1) or No(2). | ||
| NUM_FIRST_BUCKETS | NUMBER | This column holds the number of first buckets in this plan. | |||
| NUM_SECOND_BUCKETS | NUMBER | This column holds the number of second buckets in this plan. | |||
| PARTIAL_BUCKET | NUMBER | 1 | This column holds the values of the flag: Plan Partial Bucket. Values are Yes(1) or No(2). | ||
| EXPOSE_TO_ANALYTIC | NUMBER | 1 | This column holds the values of the flag: Expose to analytics. Values are Yes(1) or No(2). | ||
| SHORT_PLAN_ID | NUMBER | This is the short Plan Identifier which will be used for creating plan partitions. | |||
| SELF_INPUT_SCHEDULE | NUMBER | This column indicates whether same plan can be included as demand schedule or not.Applies to S &OP plans | |||
| WORK_AREA_TYPE | NUMBER | 2 | Column to store information related to area type ex: s&op,pc, etc... | ||
| COMPILE_DESIGNATOR | VARCHAR2 | 30 | Yes | This column holds the name of the plan. | |
| DESCRIPTION | VARCHAR2 | 100 | This column holds the description of the plan. | ||
| DATA_COMPLETION_DATE | TIMESTAMP | This column holds the snapshot completion date of the plan. | |||
| DATA_START_DATE | TIMESTAMP | This column holds the snapshot start date of the plan. | |||
| PLAN_COMPLETION_DATE | TIMESTAMP | This column shows the plan completion date after a run. | |||
| DEMAND_PLAN_COMPLETION_DATE | TIMESTAMP | This is the plan completion date for use by demand planning. | |||
| PLAN_START_DATE | TIMESTAMP | This column holds the plan start date. | |||
| DEMAND_PLAN_START_DATE | TIMESTAMP | This is the Plan Start Date for use by demand planning. | |||
| PLAN_HORIZON_START_DATE | DATE | This column holds the Plan horizon start date. | |||
| PLAN_TYPE | NUMBER | This column shows the numeric value of the plan type ( Demand Plan, Supply Plan, Demand and Supply Plan, Sales and Operations Plan, Replenishment Plan) | |||
| PRIVATE_PLAN | NUMBER | Indicates whether the plan is public or private. If 1, then the plan is public. If 2, then the plan is private. Only the plan owner or users that the plan references can view a private plan. | |||
| SAVED_FLAG | NUMBER | This column holds the values of the flag: Is this plan saved. Values are Yes(1) or No(2). | |||
| SAVE_TO_DB | NUMBER | This column holds the values of the flag: Is the plan saved to database. Values are Yes(1) or No(2). | |||
| PLAN_OWNER | VARCHAR2 | 64 | This is the identifier of the plan owner. | ||
| RELEASE_FLAG | NUMBER | This column holds the values of the flag: Release Flag. Values are Yes(1) or No(2). | |||
| ARCHIVE_FLAG | NUMBER | This column holds the values of the flag: Archive Flag. Values are Yes(1) or No(2). | |||
| APPLIED | NUMBER | This column holds a value used internally in code, used in the copy plan management. | |||
| BASE_PLAN_ID | NUMBER | 18 | This column holds a value used internally in code, used in the copy plan management, showing from which base plan the current plan was copied. | ||
| HAS_RUN | NUMBER | This column holds the values of the flag: Has this plan run. Values are Yes(1) or No(2). | |||
| LOADED_FLAG | NUMBER | This column holds the values of the flag: Was this plan loaded. Values are Yes(1) or No(2). | |||
| NEW_PLAN_ID | NUMBER | 18 | This column holds a value used internally in code, used in the copy plan management. | ||
| NEW_PLAN_LIST | VARCHAR2 | 256 | This column holds a value used internally in code, used in the copy plan management. It is a list of plans that were copied from this base plan. | ||
| PARENT_PLAN_ID | NUMBER | 18 | This column holds a value used internally in code, used in the copy plan management, this being the parent plan id of the current plan. | ||
| SNAPSHOT_LOCK | NUMBER | This column holds the values of the flag: Snapshot Lock. Values are Yes(1) or No(2). | |||
| STATUS | NUMBER | This column shows the status of a plan. Completed (0), Processing(1), Error (2), Warning(3). | |||
| PRODUCTION_FLAG | NUMBER | This column holds the values of the flag: Production Flag. Values are Yes(1) or No(2). | |||
| SAFETY_STOCK_PLANNING_METHOD | NUMBER | This column holds the numeric value of Safety Stock Planning Method. Do not plan Safety Stock(1), User-specified values (4), Statistical for end items, none for others (5) ,Statistical for end items, user-spec for others (6) | |||
| RECALCULATE_SAFETY_STOCK | NUMBER | This column holds the values of the flag: Recalculate Safety stock. Values are Yes(1) or No(2). | |||
| SAFETY_STOCK_SERVICE_LEVEL | NUMBER | This column holds the numeric value of Safety stock service level. | |||
| SAFETY_STOCK_FORECAST_ERROR | NUMBER | This column holds the numeric value of Safety stock forecast error. | |||
| SAFETY_STOCK_OVERWRITE_FLAG | NUMBER | This column holds the values of the flag: Safety stock overwrite Flag. Values are Yes(1) or No(2). | |||
| SAFETY_STOCK_SAVE_TO_SIM_SET | NUMBER | 18 | This column is currently not used. | ||
| SOP_CALCULATE_BOR_FLAG | NUMBER | This column holds the values of the flag: Calculate Bill of Resources. Values are Yes(1) or No(2). | |||
| SOP_PRODUCT_HIERARCHY | NUMBER | 18 | This column is holding the product hierarchy numeric identifier. | ||
| SOP_CUSTOMER_HIERARCHY | NUMBER | 18 | This column is holding the customer hierarchy numeric identifier. | ||
| SOP_PRODUCT_LEVEL | NUMBER | 18 | This column is holding the product level numeric identifier. | ||
| SOP_CUSTOMER_LEVEL | NUMBER | 18 | This column is holding the customer level numeric identifier. | ||
| SOP_BOTTLENECK_RESOURCE_FLAG | NUMBER | This column holds the values of the flag: Bottleneck Resource Flag. Values are Yes(1) or No(2). | |||
| SOP_CRITICAL_COMP_ONLY_FLAG | NUMBER | This column holds the values of the flag: Critical component only. Values are Yes(1) or No(2). | |||
| SOP_IGNORE_LEAD_TIME_FLAG | NUMBER | This column holds the values of the flag: Ignore Lead Time. Values are Yes(1) or No(2). | |||
| SUBSTITUTION_DESIGNATOR | VARCHAR2 | 50 | This column holds the value of the substitution designator. | ||
| DEM_PRIORITIZATION_METHOD | NUMBER | 2 | The column stores which prioritization method name is used during demand prioritization. | ||
| DEM_PRIORITY_RULE_ID | NUMBER | 18 | This column holds the demand priority rule identifier. | ||
| PLANNING_TIME_FENCE_FLAG | NUMBER | This column holds the values of the flag: Planning Time Fence. Values are Yes(1) or No(2). | |||
| DEMAND_TIME_FENCE_FLAG | NUMBER | This column holds the values of the flag: Demand Time Fence. Values are Yes(1) or No(2). | |||
| ASSIGNMENT_SET_ID | NUMBER | 18 | This column holds the assignment set identifier. | ||
| SIMULATION_SET_ID | NUMBER | 18 | This column holds the simulation set identifier that is associated with this plan. | ||
| EXCEPTION_SET_ID | NUMBER | 18 | This column holds the exception set identifier that is associated with this plan. | ||
| PLANNING_BUCKET_TYPE | NUMBER | This column holds the numeric value of the planning bucket type. | |||
| DAILY_CUTOFF_BUCKET | NUMBER | Yes | This column holds the numeric value of the daily cutoff bucket. | ||
| CUTOFF_DATE | DATE | This column holds the plan horizon end date. | |||
| FORECAST_ALLOCATION_METHOD | NUMBER | This column holds the numeric value of the forecast allocation method. | |||
| FORECAST_CONSUMPTION_METHOD | NUMBER | This column holds the numeric value of the forecast consumption method. | |||
| EXPLODE_FORECAST | NUMBER | This column holds the values of the flag: Explode Forecast. Values are Yes(1) or No(2). | |||
| AUTO_RELEASE_RP | NUMBER | This column holds the values of the flag: Auto Release. Values are Yes(1) or No(2). | |||
| RELEASE_RESCHEDULES | NUMBER | This column holds the values of the flag: Auto Release reschedules. Values are Yes(1) or No(2). | |||
| DM_INCLUDE_DEPENDENT_DEMAND | NUMBER | This column holds the values of the flag for DM: Include dependent demand. Values are Yes(1) or No(2). | |||
| DM_CAL_PLAN_PERCENT_FORECAST | NUMBER | This column holds the values of the flag for DM: Calculate Plan Percent Forecast. Values are Yes(1) or No(2). | |||
| DM_USE_PLAN_PERCENT_TYPE | NUMBER | This column holds the numeric value of the DM planning percent type. | |||
| DM_CTO_HISTORY_PERIODS | NUMBER | This column holds the value for DM for CTO History Periods. | |||
| DM_PUBLISH_CTO_BY_TOP_LEVEL | NUMBER | This column holds the values of the flag for DM: Publish CTO by top level. Values are Yes(1) or No(2). | |||
| PLAN_DIMENSION_CATALOG | NUMBER | 18 | This is the plan dimension catalog. | ||
| FORECAST_TIME_LEVEL | NUMBER | This column holds the value for Forecast Time Level. | |||
| PLAN_HORIZON_DAYS | NUMBER | This column holds the value for the Plan Horizon Days. | |||
| PLAN_TIME_LEVEL | NUMBER | This column holds the value for the Plan Time Level. | |||
| PLAN_MEASURE_CATALOG | NUMBER | 18 | This is the planning measure catalog. | ||
| EXTRACT_MEASURE_CATALOG | NUMBER | This column holds the values of the flag: Extract Measure Catalog Values are Yes(1) or No(2). | |||
| INCLUDE_INTERNAL_SALES_ORDER | NUMBER | This column holds the values of the flag: Include Sales Order. Values are Yes(1) or No(2). | |||
| SVC_DRILL_SUPPLIER_BY | NUMBER | This column is currently not used. | |||
| SVC_DRILL_ORGANIZATION_BY | NUMBER | This column is currently not used. | |||
| SVC_DRILL_CUSTOMER_BY | NUMBER | This column is currently not used. | |||
| FULL_PUBLISH_FLAG | NUMBER | This column holds the values of the flag: Full Publish Flag. Values are Yes(1) or No(2). | |||
| AUTO_REL_COMP_TOLERANCE | NUMBER | This is the Compression Days Tolerance for Automatic Release. Indicates the number of compression days allowed for the automatic release of planned orders. | |||
| CONSUME_FORECAST_WITHIN_DTF | NUMBER | This column holds the values of the flag: Consume Forecast within demand Time Fence. Values are Yes(1) or No(2). | |||
| CONSUME_FORECAST_WITH_NO_DC | NUMBER | This column is the Time Frame for Consuming Forecasts with No Demand Class. | |||
| DEFAULT_FORECAST_PRIORITY | NUMBER | This column holds the default forecast priority. | |||
| DEFAULT_SALES_ORDER_PRIORITY | NUMBER | This column holds the value for default sales order priority. | |||
| INFLATE_WIP_RESOURCE_REQ | NUMBER | This column holds the values of the flag: Inflate wip resource requirement. Values are Yes(1) or No(2). | |||
| INCL_SCHLD_RECEIPTS_CALCULATE | NUMBER | This column holds the value for the flag:Include Scheduled Receipts in Use-up Calculation. Values are Yes(1) or No(2). | |||
| INCL_POST_PROCESSING_LT | NUMBER | This column holds the value for the flag:Include post-processing lead time when planning for make orders. Values are Yes(1) or No(2). | |||
| RELEASE_WIP_IN_CLEAR_TO_BUILD | NUMBER | This column holds the value for the flag:Release wip in clear to build. Values are Yes(1) or No(2). | |||
| RELEASE_BY_USER_ONLY | NUMBER | This column holds the value for the flag:Release by user only. Values are Yes(1) or No(2). | |||
| LOAD_REQ_GROUP_BY | NUMBER | This column holds the numeric value of Load required Group By. | |||
| LOAD_TRANSFER_GROUP_BY | NUMBER | This column holds the numeric value of Load Transfer Group By. | |||
| GROUP_PLANNED_ORDER_BY | NUMBER | This column holds the numeric value of Group Planned Order By. | |||
| EXPLODE_DEPNDT_DMD_METHOD | NUMBER | This column holds the numeric value of the dependent demand method. | |||
| APPLY_ORDER_MODIFIER_TO_ST_QTY | NUMBER | This column holds the values of the flag: apply Order Modifier to Start Quantity. Values are Yes(1) or No(2). | |||
| CREATE_TIME_FENCE | NUMBER | This column holds the values of the flag: Create Time Fence. Values are Yes(1) or No(2). | |||
| FIRM_PLANNED_ORDER_TF | NUMBER | This column holds the value for the Create firm planned order time fence. | |||
| FIRM_IR_TF | NUMBER | This is the flag: Create firm internal requisition time fence. Values are Yes(1) or No(2). | |||
| USE_BASE_MODEL_IN_CONSUMPTION | NUMBER | This column holds the values of the flag: Use Base Model in Consumption. Values are Yes(1) or No(2). | |||
| HORIZON_FOR_AVG_DAILY_DMD | NUMBER | This column holds the value for the Horizon for average daily demand. | |||
| PRE_CON_FORECAST_BUCK | NUMBER | Prefer consumption within forecast bucket. Values are Yes(1) or No(2). | |||
| SS_CHNGE_TO_MRP_PLANNED | NUMBER | This column shows the flag: Apply safety stock change interval to all items. Values are Yes(1) or No(2). | |||
| SM_METHOD_TO_CAL_SS_INTERVAL | NUMBER | Smoothing Method to Calculate Safety Stock within Change Interval. Possible values are Minimum, Maximum, or Average | |||
| SS_CHNGE_INTERVAL_DAYS | NUMBER | The number of days in the time interval. | |||
| SS_BUCK_START_OFFSET_DAYS | NUMBER | The safety stock bucket start offset days. | |||
| MAX_PER_VAR_IN_SS_VAL | NUMBER | Maximum Percentage Variation in Safety Stock Values. | |||
| MIN_PER_VAR_IN_SS_VAL | NUMBER | Minimum Percentage Variation in Safety Stock Values | |||
| FORECAST_SPREADING_CALENDAR | NUMBER | This column holds the value of the Forecast Spreading Calendar. | |||
| PLANNING_MODE | NUMBER | This is the type of planning: Constrained or Unconstrained. | |||
| PLANNED_ITEM_TYPE | NUMBER | This column holds the value of the planned item type. Values are Manufacturing Plan (1) or Production Plan (2) | |||
| PLANNED_ITEMS | NUMBER | This column holds the numeric value of the planned items as follows: All items (1), Demand planned items and sales order items(2), Demand and wip components(5), Demand plan items (6), Demand, wip and sales order items(7) | |||
| FORECAST_SPREADING | NUMBER | This column holds the forecast spreading value. | |||
| CONSUME_FORECAST_WITH_ISO | NUMBER | This column is currently not used. | |||
| CONSUME_BY_FORECAST | NUMBER | This column holds the values of the flag: Consume by Forecast Bucket. Values are Yes(1) or No(2). | |||
| RELAX_CAPACITY_LT_FLAG | NUMBER | This column holds the values of the flag: Relax Capacity and Lead Time Constraints. Values are Yes(1) or No(2). | |||
| BACKWARD_DAYS | NUMBER | This column is currently not used. It was replaced by BACKWARD_CONSUMPTION_BUCKET. | |||
| FORWARD_DAYS | NUMBER | This column is currently not used. It was replaced by FORWARD_CONSUMPTION_BUCKET. | |||
| INCLUDE_MEASURES_FLAG | NUMBER | This column holds the values of the flag: Include Measures Flag. Values are Yes(1) or No(2). | |||
| ATP_FLAG | NUMBER | This column holds the values of the flag: ATP Flag. Values are Yes(1) or No(2). | |||
| COMPONENT_SUBSTITUTION_LOGIC | NUMBER | This column holds the values of the flag: use component substitution logic. Valid values are Yes(1) or No(2). | |||
| LATENESS_THRESHOLD | NUMBER | This column holds the value of the lateness threshold. | |||
| DEFAULT_CALENDAR | VARCHAR2 | 22 | This column holds the value of the Default Calendar. | ||
| SUBSTITUTION_SET_ID | NUMBER | 18 | This column holds the value of the End Item Substitution Set . | ||
| FORECASTING_CALENDAR | VARCHAR2 | 22 | This is the Forecasting Calendar. | ||
| OVERWRITE_OPTION | NUMBER | This column holds the value of the Overwrite Firm Planned Orders Flag. Values are yes(1) or No(2). | |||
| DEFAULT_CALENDAR_INST_ID | NUMBER | 18 | This is the Calendar Instance Identifier. | ||
| FORECASTING_CALENDAR_INST_ID | NUMBER | 18 | This column is currently not used. | ||
| PLAN_SUPPLY | NUMBER | This column is the Plan Supply Flag. Values are Yes(1) or No(2). | |||
| PLAN_DEMAND | NUMBER | This is the Plan Demand Flag.Values are Yes(1) or No(2). | |||
| SELECTIVE_SNAPSHOT_SEQ | NUMBER | System change number used in selective data snapshot to ensure read consistency for all plan data. | |||
| USE_SAME_CAL | NUMBER | 1 | This column is the Flag for :Use forecasting calendar for supply planning. Values are Yes(1) or No(2). | ||
| ITEM_LIST_PRICE | NUMBER | 1 | This is the Item Price List for Plan. (1 - Selected). | ||
| FORECAST_MEASURE | NUMBER | 18 | This column is the Safety Stock Forecast Measure. | ||
| FORECAST_ERROR_MEASURE | NUMBER | 18 | This is the Safety Stock Forecast Error Measure. | ||
| INTRL_TIMES_DMD_MEASURE | NUMBER | 18 | This column holds the Inter-arrival Times For Intermittent Demand Measure. | ||
| SAVE_TO_COLL_DATA | NUMBER | 1 | This column holds the flag:Save Statistical Safety Stock Quantity to collected data. Values are Yes(1) or No(2). | ||
| CAL_SS_QUANT_END_ITEMS | NUMBER | 1 | This column holds the flag:Calculate new safety stock quantities for end items. Values are Yes(1) or No(2). | ||
| CON_SUPPLIER_CAP_PUR_ORDERS | NUMBER | 1 | This column holds the flag:Consume supplier capacity with purchase orders. Values are Yes(1) or No(2). | ||
| SUPPLIER_CAP_CONSTRAINTS | NUMBER | 1 | This column holds the flag:Consider supplier capacity constraints. Values are Yes(1) or No(2). | ||
| SUPPLIER_CAP_MULTIPLIER | NUMBER | This is the Supplier Capacity Accumulation Multiplier. | |||
| INCLUDE_TRANSFER_ORDERS | NUMBER | 1 | This column holds the flag:Include Transfer Orders. Values are Yes(1) or No(2). | ||
| DEMAND_HISTORY_DAYS | NUMBER | This column holds the Demand History Days. | |||
| USE_ITEM_SPEC_VALUES | NUMBER | 1 | This column holds the value for the flag:Use item specific values. Values are Yes(1) or No(2). | ||
| AVG_INTERARRIVAL_TIME | NUMBER | 18 | This is the numeric value of the Average inter arrival times. | ||
| AVG_BATCH_SIZE | NUMBER | 18 | This is the numeric value for the Average Batch size. | ||
| SS_FORECAST_PLAN | NUMBER | 18 | This is the value for the Safety Stock Forecast Plan. | ||
| DEMAND_PLAN_PRIORITY | NUMBER | This is the value for the Demand Plan Priority. | |||
| DQ_LOG_LEVEL | NUMBER | 1 | This column holds the numeric value for the Data Query Log Level. | ||
| DP_LOG_LEVEL | NUMBER | 1 | This column holds the numeric value for the Data Processing Log Level. | ||
| STATISTICAL_LOG_LEVEL | NUMBER | 1 | This column holds the numeric value for the Statistical Log Level. | ||
| FA_LOG_LEVEL | NUMBER | 1 | This column holds the numeric value for Forecast Allocation Log Level. | ||
| LOG_GROUP_BY | VARCHAR2 | 250 | This column holds the numeric value for Log Group By. | ||
| PARAMETER_OVERRIDES | VARCHAR2 | 4000 | Define plan specific parameter overrides for existing demand profile or other parameters. | ||
| LAST_APPROVED_BY | VARCHAR2 | 64 | This is the User who initiated the approve plan action. | ||
| APPROVED_FLAG | NUMBER | 1 | This column holds the value for the flag: Approved Flag. Values are Yes(1) or No(2). | ||
| LAST_APPROVED_DATE | TIMESTAMP | This column holds the value for the Last Approved Date. | |||
| INCL_DROP_SHIP_DMD_SUP | NUMBER | 1 | This column holds the value for the flag: Include drop ship demands and supplies Values are Yes(1) or No(2). | ||
| MATCH_TOP_MODEL_FRCST_COSMP | NUMBER | This column is currently not used. | |||
| PLAN_VERSION | NUMBER | 18 | This column shows the plan version. | ||
| ENABLE_MULTI_THREADING | NUMBER | 1 | This column holds the value for the flag: Enable multi threading. Values are Yes(1) or No(2). | ||
| ALLOW_LEAD_TIME_COMPRESSION | NUMBER | 1 | This column holds the value for the flag: Allow lead time compression.. Values are Yes(1) or No(2). | ||
| INCLUDE_SALES_ORDERS | NUMBER | 1 | This column holds the value for the flag: Include sales orders. Values are Yes(1) or No(2). | ||
| INCLUDE_PTW_ORDERS | NUMBER | 1 | This column holds the value for the flag: Include purchase, transfer, and work orders.. Values are Yes(1) or No(2). | ||
| INCLUDE_WORK_ORDERS | NUMBER | 1 | This column holds the value for the flag: Include work orders.. Values are Yes(1) or No(2). | ||
| GLOBAL_FCST_VALID_ORG | NUMBER | This column holds the Global Forecast Validation Organization. | |||
| RECALCULATE_DM_PRIORITIES | NUMBER | 1 | This column holds the flag: Recalculate demand priorities after spreading. Values are Yes(1) or No(2). | ||
| ENFORCE_SOURCING_SPLITS | NUMBER | 1 | This column holds the value of the flag:Enforce sourcing splits. Values are Yes(1) or No(2). | ||
| SOURCING_SPLIT_PERCENT | NUMBER | This column holds the Sourcing Split Tolerance Percentage. | |||
| SOURCING_ALLOCATION_WINDOW | NUMBER | This column holds the numeric value of the Sourcing Allocation Window in Days. | |||
| HORIZON_PAST_DUE_SUP_DAYS | NUMBER | This column holds the value of the Horizon for past due supplies in days. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| GROUP_SPACES | VARCHAR2 | 30 | This Column stores the group space attached to plan. | ||
| PLAN_APPROVAL_STATUS | NUMBER | This column stores the plan approval status. | |||
| ARCHIVE_MEASURE_CATALOG | NUMBER | 18 | This column specifies the Measure Catalog for Archival. | ||
| ARCHIVE_VERSION_DAYS | NUMBER | This column shows the number of days to retain the Archived measure Versions. | |||
| ENABLE_ITEM_SUBSTITUTION | NUMBER | This column holds the flag for: Enable End Item Substitution. Values are Yes(1) or No(2). | |||
| PLN_PERCENT_CAL_LEVEL | NUMBER | 1 | This column shows the Planning Percentage Calculation Level. | ||
| PLAN_PERCENT_CAL_INTERVAL | NUMBER | 1 | This column shows the Planning Percentage Calculation Interval. | ||
| EXPLODE_MODEL_FORECASTS | NUMBER | 1 | This column shows the flag :Explode Model Forecasts. Values are Yes(1) or No(2). | ||
| USE_CAL_PLAN_PERCENT | NUMBER | 1 | This column shows the flag :Use Calculated Planning Percentage. Values are Yes(1) or No(2). | ||
| ARCH_TIME_HIERARCHY | NUMBER | 18 | This column holds the flag :Archive time hierarchy selected in the advanced options. Values are Yes(1) or No(2). | ||
| ARCH_TIME_LEVEL | NUMBER | 18 | This column holds the flag :Archive time level either week or month selected. Values are Yes(1) or No(2). | ||
| DELETE_ARCHIVE | NUMBER | 1 | Option provides either to 4-delete automatically or 5-do not delete archives | ||
| DEL_RECENT_OR_OLDEST | NUMBER | 1 | Either to delete the 1-keep the most recent or 2-delete the oldest | ||
| PLN_PCT_HIST_CAL_MEASURE | NUMBER | 18 | This column stores the Planning Percentage History Calculation Measure. | ||
| MEASURE_GROUP_ID | NUMBER | 18 | This column stores the selected measure group identifier. | ||
| ENABLE_ARCHIVE | NUMBER | 1 | This column holds the flag :Enable archive in the plan options UI. Values are Yes(1) or No(2). | ||
| ENABLE_WELCOME_PAGE | NUMBER | 1 | Flag indicates whether Plan is enabled for welcome page. Possible Values: 1-True & 2-False. | ||
| AGGR_NON_KEY_CUST | NUMBER | 1 | The column used to store the information regard ing whether non- key customer data would be aggregated to dummy zone. The possible values are - 1 - Aggregate Non Key Customer is enabled 2 - Aggregate Non Key Customer is disable | ||
| SOP_PLAN_RES_LEVEL | NUMBER | 1 | This column stores resource capacity level from a 2-level drop down: 0=Resource, 1=Work Center | ||
| SOP_ALLOW_RES_CAP_OVERLOAD | NUMBER | 1 | This column holds the value of the flag: constraining resource capacity, as defined in a checkbox. Values are 2=unconstrained(unchecked), 1=constrained(checked) | ||
| SOP_ALLOW_SUP_CAP_OVERLOAD | NUMBER | 1 | This column stores constraining flag supplier item capacity from a checkbox: 2=unconstrained(unchecked), 1=constrained(checked). | ||
| SEGMENT_GROUP_ID | NUMBER | 18 | This column stores segment group id for replenishment planning. | ||
| POLICY_ASSIGNMENT_SET_ID | NUMBER | 18 | This column stores policy assignment set id for replenishment planning. | ||
| FORECAST_FLAG | NUMBER | 1 | This column holds the Replenishment plan type flag for if forecasting engine is used. Values are Yes(1) or No(2). | ||
| REPLENISHMENTS_FLAG | NUMBER | 1 | This column holds the Replenishment plan type flag for if replenishment engine is used. Values are Yes(1) or No(2). | ||
| SUBINVENTORY_PLANNING_FLAG | NUMBER | 1 | This column shows the Replenishment plan type flag for if subinventory level is used. Values are Yes(1) or No(2). | ||
| POLICY_PARAMETERS_FLAG | NUMBER | 1 | This column shows the Replenishment plan type flag for if policy calculation engine is used. Values are Yes(1) or No(2). | ||
| REP_CREATION_TYPE | NUMBER | 1 | Replenishment plan type flag for Replenishment Creation Type | ||
| REP_PLANNING_TIME_LEVEL | NUMBER | 1 | Replenishment plan type for Replenishment Planning Time level | ||
| COLLECTIONS_END_SCN | NUMBER | 18 | Collections runs unique identified to keep track incremental changes | ||
| REPL_POLICY_COMP_FLAG | NUMBER | 1 | Replenishment plan type flag for if policy comparison feature is used 0 = No, 1 = Yes | ||
| REPL_THRESHOLD_COMPARISON | NUMBER | Threshold Percentage for Policy Comparison for replenishment plans. Holds Integer value between 0 to 100 | |||
| REPL_INCR_PLANNING_FLAG | NUMBER | 1 | Enables incremental planning for replenishment plans 0 = No, 1 = Yes | ||
| REPL_TIME_HORIZON | NUMBER | Time Horizon used for replenishment plans calculation of measure Demand within Lead Time. valid values are 0 = 'None' and 1 = 'Total Lead Time' | |||
| REPL_LEAD_TIME_MULTIPLIER | NUMBER | Lead time Multiplier for replenishment plans calculation of measure Demand within Lead Time. Holds integer value between 1 and 5 | |||
| LAST_PLAN_RUN_START_DATE | DATE | For Replenishment Planning, indicates the start date of the last successful plan run. Used in net change plan run to determine number of days to be rolled for the plan horizon. | |||
| REPL_RETAIN_POLICY_OVERRIDES | NUMBER | 1 | For Replenishment Planning when policy comparison is enabled, this flag indicates if policy measure user overrides should be retained during plan runs. null = Do not retain overrides, 1 = retain overrides, 2 = Do not retain overrides. | ||
| CONSUMPTION_CALENDAR | VARCHAR2 | 22 | Gregorian or Manufacturing Calendar for Forecast Consumption | ||
| CONSUMPTION_BUCKET_TYPE | NUMBER | Bucket Type for Forecast Consumption, e.g. 1 (Day) | |||
| BACKWARD_CONSUMPTION_BUCKET | NUMBER | Number of Buckets for Backward Consumption. | |||
| FORWARD_CONSUMPTION_BUCKET | NUMBER | Number of Buckets for Forward Consumption | |||
| PAST_DUE_DEMAND_BUCKET | NUMBER | Past Due Demand Bucket. The value may be either 1 (Supply Network Model) or 2 (Plan Option Values) | |||
| PAST_DUE_DEMAND_CALENDAR | VARCHAR2 | 22 | Gregorian or Manufacturing Calendar for Past Due Demand | ||
| PAST_DUE_DEMAND_BUCKET_TYPE | NUMBER | Bucket Type for Past Due Demand, e.g. 1 (Day) | |||
| PAST_DUE_OPEN_SO_BUCKET | NUMBER | Number of Buckets for Past Due Open Sales Order | |||
| PAST_DUE_SHIPPED_SO_BUCKET | NUMBER | Number of Buckets for Past Due Shipped Sales Order | |||
| PAST_DUE_FORECAST_BUCKET | NUMBER | Number of Buckets for Past Due Forecast | |||
| ATTR_BASED_NETTING_RULE | NUMBER | 18 | Attribute Based Netting Rules will be available in Supply tab of Plan options | ||
| TIME_WINDOWS_FOR_NET_SEQ | NUMBER | Stores time window in days for netting sequence. It is a positive non-zero integer | |||
| DEFAULT_TASK_ATTR_VALUE_FLAG | NUMBER | 1 | Default task attribute value flag. 1 - yes, 2 or null - no | ||
| INCLUDE_PROD_MONITORING_ALRTS | NUMBER | 1 | This column stores the flag:Include Production Monitoring Alerts. Values are Yes(1) or No(2). | ||
| SUPPLY_PARAMETER_OVERRIDES | VARCHAR2 | 250 | Store the internal option used by the Supply plan and ISD plan. | ||
| SOP_LOAD_FROM_DEMAND_PLAN | NUMBER | 1 | Load measure from demand plan to shipments forecast. | ||
| SOP_DEMAND_PLAN_LOADED | NUMBER | 18 | SOP Load plan id, for load measure from demand plan to shipments forecast. | ||
| SOP_DEMAND_MEASURE_LOADED | NUMBER | 18 | SOP Load demand measure id, for load measure from demand plan to shipments forecast. | ||
| SOP_MANUFACTURE_OFFSET | NUMBER | 1 | This column shows the value of the flag: Manufacture Offset. Values are Yes(1) or No(2). | ||
| REPL_SUPPLY_CUTOFF_DAYS | NUMBER | For Replenishment Planning, Snapshot supplies with due date up to plan cutoff date + supply cutoff days. | |||
| DEMAND_WINDOW_TO_CAL_PEGGING | NUMBER | This column stores the demand window to calculate pegging. | |||
| SHOW_ANOMALIES | NUMBER | 1 | This column indicates if Anomalies to be shown or not. Values are Yes(1) or No(2). | ||
| REPL_AGGR_PLANNED_ORDERS | NUMBER | 1 | For Replenishment Planning, the flexibility to consolidate orders in aggregate planning buckets. 1=Yes, 2 or null =No | ||
| ENFORCE_ORDER_MODIFIERS | NUMBER | 1 | Plan Option to Enforce order modifiers in aggregate buckets. | ||
| MAXIMUM_PLANNED_ORDERS | NUMBER | 4 | Maximum Planned Orders per Item per Time Bucket-Day, Week, and Period | ||
| PLAN_EX_MANUFACTURER_SUPPLIES | NUMBER | 1 | If this check box in plan option is unchecked, then the CM organization will not be further planned even if org level parameter is checked. Enabled value 1 and disabled value 2 | ||
| CONSUMPTION_DTLS_CUTOFF_DAYS | NUMBER | Number of days after plan start date to stop the writing of consumption details | |||
| MEASURE_CONTEXT_ID | NUMBER | 18 | An ID of MEASURE_CONTEXT entity (in measure_context_b) which this plan is attached to | ||
| INCLUDE_ITEMS_WITH_SSTOCK | NUMBER | With Planned Items Plan Option for Including Items with Safety Stock in Supply Planning customers will be able to plan supplies for safety stock without planning for any other type of demands. | |||
| MEASURE_CATALOG_BICC | NUMBER | 18 | This is the Measure catalog for Extract. | ||
| DIMENSION_CATALOG_BICC | NUMBER | 18 | This is the Dimension Catalog for Extract. | ||
| EXTRACT_TIME_HIERARCHY | NUMBER | 18 | Extract time hierarchy selected in the advanced options. | ||
| EXTRACT_TIME_LEVEL | NUMBER | 18 | Extract time level either week or month selected. | ||
| SCHEDULE_BY | NUMBER | 2 | This is a plan option to provide different scheduling options to user. This plan option will have two values, Schedule Ship Date ( 1) and Request Ship Date (3). Default value is 1. | ||
| ENABLE_EXTRACT_PLAN_DATA | NUMBER | 1 | Plan Option checkbox to enable extract plan data. | ||
| REPL_INV_REBALANCE_FLAG | NUMBER | 1 | Replenishment plan type flag for if inventory rebalancing feature is used, 1 = Yes, 2 = No. | ||
| REPL_INV_REB_PARTIALS | NUMBER | 1 | Replenishment plan flag for inventory rebalancing to reduce partial recommendations, 1 = Yes, 2 = No. | ||
| REPL_INV_REB_MOVE_EXCESS | NUMBER | 1 | Replenishment plan flag for inventory rebalancing to move excess to sweep locations, 1 = Yes, 2 = No. | ||
| REPL_INV_REB_INCLD_SS | NUMBER | 1 | Replenishment plan flag for inventory rebalancing to include safety stock in shortage calculation, 1 = Yes, 2 = No. | ||
| APPLY_SEGMENT_SS_PARAM | NUMBER | 1 | This parameter indicates whether safety stock parameters defined at the segment level should apply in a Supply Plan. If they apply, the policy assignment sets referred to by sp_policy_assignment_set_id will get used. 1=Yes, 2=No | ||
| SP_POLICY_ASSIGNMENT_SET_ID | NUMBER | 18 | In Supply Plans, this column indicates which set of segment level parameters should be used. This contains for example safety stock service levels at the segment level. | ||
| CURRENCY_FOR_REVENUE | NUMBER | 1 | Consider currency conversion rates for planning revenue, 1 = Yes, 2 = No. | ||
| CURRENCY_CONV_TYPE | VARCHAR2 | 30 | Represents the currency conversion type for Revenue Parameters. | ||
| PIVOT_CURRENCY_CODE | VARCHAR2 | 15 | Currency associated with amounts for Revenue Parameters. | ||
| SOP_DEMAND_TARGET_MEASURE | NUMBER | 18 | Target measure for copying from DM plan. | ||
| SOP_REPORT_RES_REQ | NUMBER | 1 | Report resource requirements by assembly, 1 = Yes, 2 = No. | ||
| ALLOW_ATTRIBUTE_TRANSFER | NUMBER | 1 | Column to denote whether Attribute Transfer is allowed or not. 1=Yes, 2 or null = No. | ||
| SOP_DEM_PC_MULTIPLIER | NUMBER | This column holds the SOP Demand Backordering Penalty Cost Multiplier to tune penalty cost of demand backordering | |||
| SOP_WC_CAP_PC_MULTIPLIER | NUMBER | This column holds the SOP Suppler Capacity Overloading Penalty Cost Multiplier to tune penalty cost of supplier category capacity | |||
| SOP_SUP_CAT_CAP_PC_MULTIPLIER | NUMBER | This column holds the SOP Resource Capacity Overloading Penalty Cost Multiplier to tune penalty cost of resource capacity | |||
| SOP_SRC_ALLOC_PCT_MULTIPLIER | NUMBER | This column holds the SOP Sourcing Capacity Overloading Penalty Cost Multiplier to tune penalty cost of sourcing split | |||
| SOP_DECLINING_STORAGE_COST | NUMBER | This column holds the SOP check box value to use declining storage costs to avoid prebuilding inventory. Values are checked(1) or unchecked(2) | |||
| NET_MULTIPLE_LOCAL_ORG | NUMBER | 1 | This column holds the value for net multiple local organization. Values are checked(1) or unchecked(2) | ||
| EIS_RULE | NUMBER | This column holds the numeric value for end item substitution decision rule. Values are Do not use related items supplies (1 or null), Maximize use of related items supplies to minimize new replenishment (2), Use related items supplies only when necessary to avoid stockouts (3). Default value is 1. | |||
| EXCESS_LT_MULTIPLIER | NUMBER | This column holds value of lead time multiplier for excess window. | |||
| INCLUDE_ITEMS_WITH_SUPPLY | NUMBER | 1 | This column indicates whether items with existing supplies, but no demand, to be considered in Supply Planning. | ||
| UNFIRM_IN_TRANSIT_SUPPLY | NUMBER | 1 | This column indicates whether in-transit and shipments in receiving supply to be considered as not firm. | ||
| ENFORCE_LT_INTRANSIT | NUMBER | 1 | This column indicates whether lead time should be enforced for In-Transit Supply and Shipments in Receiving when they are not firmed. This option applies to constrained supply plans. A value of 1 indicates that the lead time should be respected. Compression may happen when the lead time is respected. | ||
| REFERENCE_PLAN_FOR_EXECUTION | NUMBER | 1 | Indicates whether the current plan is used as a reference plan for execution systems. | ||
| FORECAST_CUTOFF_DAYS | NUMBER | Represents the number of days after the Forecast Demand Date which the forecast can be satisfied.The planning engine will not plan for forecasts, if the supply date is later than these many working days. This field is applicable for constrained planning engine only. | |||
| APPLY_CUTOFF_TO_ORDER_TYPE | NUMBER | Allows the user to override the Latest Acceptable Date on Sales Orders, Manual Demand and Forecast to NULL. This field is applicable for constrained planning engine only. | |||
| ECC_ENFORCE_RES_CAP | NUMBER | 1 | Allows the user to enforce honoring of resource capacity constraints in the constrained planning engine. Values Yes(1) or No(2). | ||
| ECC_ENFORCE_SUP_CAP | NUMBER | 1 | Allows the user to enforce honoring of supplier capacity constraints in the constrained planning engine. Values Yes(1) or No(2). | ||
| INCLUDE_LEAD_TIME_ALERTS | NUMBER | 1 | This column holds the value for the flag : Include Alerts from Lead Time Insights. values are Yes(1) or No(0) | ||
| USE_MODEL_SPEC_PLAN_PERCENT | NUMBER | 1 | This column indicates whether the plan honors model-specific planning percentages for options in an option class to calculate dependent demand. This flag is shown as 'Use model-specific planning percentages for options' on the 'Forecast Allocation and Consumption' subtab of the Supply tab on Plan Options. 1 indicates yes, model-specific planning percentages for options, null or 2 indicates not honor. | ||
| MULTIECHELON_FLAG | NUMBER | 1 | Replenishment plan type flag for if multi-echelon feature is used, 1 = Yes, 2 = No | ||
| CRITICAL_RES_SUPPLIER_CONSTR | NUMBER | 1 | This column indicates if the plan enforces capacity constraints only for critical resources or critical suppliers. | ||
| SOP_ADD_PAST_DUE_SO | NUMBER | 1 | Indicates if past due sales orders should be added to net demand in the first time bucket. 1 means Yes and 2 or null means No. | ||
| SOP_PLAN_ANCHOR_DATE | DATE | Indicates the anchored plan start date which is between the first day of first time bucket and system date. It is null if anchor date is not activated. | |||
| SOP_INTRANSIT_EXTRACTION_LOC | NUMBER | 1 | This column indicates if in-transit measure is to be extracted at source or destination organization. 1 means from destination organization. Otherwise from source organization. | ||
| SOP_DECL_RAC_MULTIPLIER | NUMBER | This column specifies a multiplier value on declining risk-adjusted cost in manufacturing network. | |||
| SUPPLY_SCHEDULE_FLAG | NUMBER | 1 | Plan parameter which indicates whether the replenishment plan considers supply schedules. Valid values as 1 (Yes) and 2 (No). Null indicates No. | ||
| RESP_RES_ASSIGN_FLAG | NUMBER | 1 | This column holds value for the flag:Respect resource assigned units in work definition. Valid values are 1 (Yes) and 2 (No). | ||
| ECC_CONSTRAINTS_CUTOFF_DAYS | NUMBER | ECC plans will enforce capacity constraints within the specified days. After that, the capacity will be unconstrained. Null value indicates the capacity constraints are enforced throughout the planning horizon. | |||
| SOP_MAX_SOURCING_RULE_RANK | NUMBER | 2 | This column specifies the highest rank to be considered in a Sales and Operations plan. Null value would mean 1 and maximum value is 99. | ||
| GLOBAL_FCST_CALENDAR | VARCHAR2 | 22 | This column specifies the global forecasting calendar. | ||
| GLOBAL_FCST_DISTR_SET_ID | NUMBER | 18 | This column specifies the assignment set identifier for global forecast distribution. | ||
| ELASTIC_DATA_READY | NUMBER | 1 | Determines if there is data in Elastic.1 = Yes, 2 or null = No. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| msc_plan_forecast_profiles | msc_plan_definitions | PLAN_ID |
| msc_sp_eng_status | msc_plan_definitions | PLAN_ID |
| msc_plan_access | msc_plan_definitions | PLAN_ID |
| msc_plan_organizations | msc_plan_definitions | PLAN_ID |
| msc_plan_optional_dimensions | msc_plan_definitions | PLAN_ID |
| msc_plan_price_lists | msc_plan_definitions | PLAN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_PLAN_DEFINITIONS_U1 | Unique | Default | PLAN_ID |
| MSC_PLAN_DEFINITIONS_U2 | Unique | Default | COMPILE_DESIGNATOR |