MSC_SYSTEM_ITEMS
MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning process. Most of the columns in MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
MSC_SYSTEM_ITEMS_PK |
PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record. | Active | ||
DEMAND_TIME_FENCE_DATE | DATE | Demand time fence date for this item org in this plan | ||||
PLANNING_TIME_FENCE_DATE | DATE | Planning time fence date for this item org in this | ||||
RELEASE_TIME_FENCE_DATE | DATE | Release time fence date for this item org in this plan | ||||
ORGANIZATION_ID | NUMBER | 18 | Yes | Organization identifier, foreign key to msc_parameters | Active | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the inventory item id | Active | |
PART_KEY1 | NUMBER | 18 | Yes | Source application instance identifier | Active | |
ITEM_NAME | VARCHAR2 | 300 | Identifies the inventory item name | Active | ||
LOTS_EXPIRATION | NUMBER | 38 | Shelf_life_days from MTL_SYSTEM_ITEMS??? | Active | ||
LOT_CONTROL_CODE | NUMBER | Yes | Flag indicating if lots_expiration is used or not | Active | ||
SHRINKAGE_RATE | NUMBER | Percentage of shinkage for this item | Active | |||
FIXED_DAYS_SUPPLY | NUMBER | Period of the supply days (in days) | Active | |||
FIXED_ORDER_QUANTITY | NUMBER | Fixed order quantity for Vendor managed inventory | Active | |||
FIXED_LOT_MULTIPLIER | NUMBER | Fixed quantitiy that a lot can contain | Active | |||
MINIMUM_ORDER_QUANTITY | NUMBER | Minimum size of an order for this item | Active | |||
MAXIMUM_ORDER_QUANTITY | NUMBER | Maximum size of an order for the inventory item. | Active | |||
ROUNDING_CONTROL_TYPE | NUMBER | Yes | Flag indicating if rounding of the quantity is allowed | Active | ||
PLANNING_TIME_FENCE_CODE | NUMBER | Planning time fence code of the inventory item. | Active | |||
PLANNING_TIME_FENCE_DAYS | NUMBER | Planning time fences days of the item | Active | |||
DEMAND_TIME_FENCE_DAYS | NUMBER | This value indicates the Demand time fence days. | Active | |||
DEMAND_TIME_FENCE_CODE | NUMBER | Demanding time fence code as computed by the planning engine | Active | |||
DESCRIPTION | VARCHAR2 | 240 | Textual description of the item for UI and reports | Active | ||
RELEASE_TIME_FENCE_CODE | NUMBER | Release time fence code. Used during Auto release of the supplies within this time fence. | Active | |||
RELEASE_TIME_FENCE_DAYS | NUMBER | Release time fence days. Used during Auto release of the supplies within this time fence. | Active | |||
MRP_PLANNING_CODE | NUMBER | Yes | Type of planning required for this item: MRP(3), MPS(4), Not Planned(6), MRP and DRP(7), MPS and DRP(8), DRP(9) | Active | ||
FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operations start and end date for the supplier operation. | Active | |||
VARIABLE_LEAD_TIME | NUMBER | Variable lead time used in conjunction with the quantity of the item. | Active | |||
PREPROCESSING_LEAD_TIME | NUMBER | Pre processing lead time used in supply network for supply generation. | Active | |||
POSTPROCESSING_LEAD_TIME | NUMBER | Post processing lead time used in supply network for supply generation. | Active | |||
FULL_LEAD_TIME | NUMBER | Full lead time defined for an inventory item at item organization level. | Active | |||
CUMULATIVE_TOTAL_LEAD_TIME | NUMBER | Cumulative total lead time. This is used during item replenishment. | Active | |||
CUM_MANUFACTURING_LEAD_TIME | NUMBER | Cumulative manufacturing lead time | Active | |||
UOM_CODE | VARCHAR2 | 3 | Yes | Unit of measure code of the inventory item. | Active | |
UNIT_WEIGHT | NUMBER | Unit of measure of the weight class of the item. | ||||
UNIT_VOLUME | NUMBER | Unit of measure of the volume class of the item. | ||||
WEIGHT_UOM | VARCHAR2 | 3 | This value indicates the unit of measure defined in terms of weight. | |||
VOLUME_UOM | VARCHAR2 | 3 | This value indicates the unit of measure defined in terms of volume. | |||
PRODUCT_FAMILY_ID | NUMBER | 18 | This stores the value of Product family identifier if the item is part of product family. | Active | ||
ATP_COMPONENTS_FLAG | VARCHAR2 | 1 | Yes | Flag indicating whether to calculate components ATP | Active | |
BUILD_IN_WIP_FLAG | NUMBER | Yes | Flag to indicate if the item can be built in WIP | Active | ||
PURCHASING_ENABLED_FLAG | NUMBER | Yes | Flag to indicate if the item can be purchased | Active | ||
PLANNING_MAKE_BUY_CODE | NUMBER | Yes | Indicate if this item should be made or bought. Make(1), Buy(2) | Active | ||
CARRYING_COST | NUMBER | Inventory carrying cost for the inventory item. | Active | |||
ORDER_COST | NUMBER | This value indicates the order cost of the item. | Active | |||
MATERIAL_COST | NUMBER | This value indicates the material cost for the inventory item. | Active | |||
RESOURCE_COST | NUMBER | The value indicates resource code collected from source system. | Active | |||
SUPPLIER_CAP_OVERUTIL_COST | NUMBER | Supplier cap over utilization cost | Active | |||
LIST_PRICE | NUMBER | The list price of this item per unit | Active | |||
AVERAGE_DISCOUNT | NUMBER | Average discount on the price of the item | Active | |||
WIP_SUPPLY_TYPE | NUMBER | Flag to indicate whether this a phantom (order modifiers are not used) | Active | |||
SAFETY_STOCK_CODE | NUMBER | Yes | Safety stock code: User-defined quantity(1), User-defined percentage(2), or mean absolute deviation | Active | ||
SAFETY_STOCK_PERCENT | NUMBER | Percent of average gross requirment for dynamically calculated safety-stocks | Active | |||
SAFETY_STOCK_BUCKET_DAYS | NUMBER | Days over which to average demand for MRP Planned safety stock percent | Active | |||
PLANNER_CODE | VARCHAR2 | 10 | This value indicates the Planner code associated with the record. | Active | ||
BOM_ITEM_TYPE | NUMBER | BOM item type: Model(1), Option Class(2), Planning(3), Standard(4), Product Family(5) | Active | |||
ATO_FORECAST_CONTROL | NUMBER | ATO forecast control code: Consume(1), Consume and derive(2), None(3) | Active | |||
EFFECTIVITY_CONTROL | NUMBER | Yes | Effectivity control code: Date Effectivity(1), Unit Number effectivity(2) | Active | ||
ORGANIZATION_CODE | VARCHAR2 | 49 | Organization code (use for UI and report) | Active | ||
ACCEPTABLE_EARLY_DELIVERY | NUMBER | The value indicates acceptable early delivery range. | Active | |||
CALCULATE_ATP | NUMBER | Yes | Flag indicating whether to calculate ATP when planning this part | Active | ||
INVENTORY_ITEM_FLAG | NUMBER | Indicates whether the item is an inventory item | Active | |||
BASE_ITEM_ID | NUMBER | 18 | Base item identifier for configuration | Active | ||
ATP_FLAG | NUMBER | Yes | Flag used for ATP. Possible values 1(Yes), 2(No). | Active | ||
PICK_COMPONENTS_FLAG | NUMBER | Flag indicating whether all shippable components should be picked | Active | |||
REPLENISH_TO_ORDER_FLAG | NUMBER | Flag indicating item to be planned as replenish to order | Active | |||
CREATE_SUPPLY_FLAG | NUMBER | When Create supply is set to No, new planned orders are not created for the item in constrained plans | Active | |||
VMI_FIXED_ORDER_QUANTITY | NUMBER | Fixed order quantity. Used in vendor managed inventory. | Active | |||
LIFE_CYCLE_PHASE | VARCHAR2 | 120 | This value indicates the Life cycle phase defined for an item. | |||
SHIPPABLE_ITEM_FLAG | NUMBER | Flag indicates whether item can shipped. 1-Yes, 2-No. | ||||
CUSTOMER_ORDER_FLAG | NUMBER | Flag indicates whether the item is customer orderable or not. 1-Yes, 2-No. | ||||
SHIP_MODEL_COMPLETE_FLAG | NUMBER | Ship model complete flag. Indicates if the PTO is SMC enabled. | ||||
BACK_TO_BACK_FLAG | NUMBER | Indicates whether a item is a back-to-back item. | ||||
ENGINEERING_ITEM_FLAG | NUMBER | Flag indicating whether this is an ECO item | ||||
MIN_SHELF_LIFE_DAYS | NUMBER | Minimum shelf life days demand for the demand. | ||||
REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | Active | |||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | ||
PROGRAM_APPLICATION_ID | NUMBER | This value indicates the Program application identifier. | Active | |||
PROGRAM_ID | NUMBER | This value indicates the Program identifier. | Active | |||
PROGRAM_UPDATE_DATE | DATE | This value indicates the update date of the program. | Active | |||
NEW_PLAN_ID | NUMBER | Yes | Incremental plan id used in conjunction with new_plan_list | Active | ||
NEW_PLAN_LIST | VARCHAR2 | 256 | List indicates the new plan identifiers for the record. | Active | ||
SIMULATION_SET_ID | NUMBER | Yes | Simulation set to which the current record is added. | Active | ||
APPLIED | NUMBER | Flag used for online replanning | Active | |||
CONSIDER_IN_CTB_FLAG | VARCHAR2 | 1 | Yes/No flag indicating CTB calculation to be considered for the item. | |||
CALCULATE_CTB_FLAG | VARCHAR2 | 1 | Yes/No flag indicating CTB calculation for the item. | |||
CTB_KPI_HORIZON | DATE | The value indicates CTB KPI date range. | ||||
NO_PL_ORD_BEFORE_WIP_WIN | NUMBER | This value indicates whether planned order can be generated before WIP WIN. | ||||
EXCESS_HORIZON | NUMBER | This value indicates the excess horizon of the item. | ||||
PLANNING_UNITS_OF_WORK | NUMBER | Planning units of work specified for the inventory item. | ||||
OBSOLESCENCE_DATE | DATE | This value indicates the Obsolescence date specified for the inventory item. | ||||
SAFETY_STOCK_QUANTITY | NUMBER | Safety stock quantity for the inventory item. | ||||
SAFETY_STOCK_QUANTITY_OVERRIDE | NUMBER | Safety stock quantity override value for the inventory item. | ||||
FORECAST_NAME | VARCHAR2 | 256 | Unique Name assigned to the forecast | Obsolete | ||
SERVICE_LEVEL_PERCENT | NUMBER | Service level percent specified in the shipping method. | ||||
FORECAST_ERROR_TYPE | VARCHAR2 | 30 | This value indicates the forecast error type. | |||
MAD | NUMBER | MAD defined for the inventory item. This is populated by engine/UI. | ||||
MAD_OVERRIDE | NUMBER | MAD_OVERRIDE defined for the inventory item. This is populated by engine/UI. | ||||
MAPE | NUMBER | MAPE defined for the inventory item. This is populated by engine/UI. | ||||
SS_FORECAST_PLAN_ID | NUMBER | 18 | Safety stock forecast plan identifier value. | |||
SS_FORECAST_MEASURE_ID | NUMBER | 18 | Safety stock forecast measure identifier. | |||
MAPE_OVERRIDE | NUMBER | MAPE_OVERRIDE defined for the inventory item. This is populated by engine/UI. | ||||
INTERMITTENT_DEMAND | NUMBER | Flag indicates whether the item is for the intermittent demand. | ||||
INTERMITTENT_DEMAND_OVERRIDE | NUMBER | User value to override the system calculated Intermittent Demand | ||||
AVG_INTERARRIVAL_TIME | NUMBER | Average inter-arrival time of the inventory item. | ||||
AVG_INTERARRIVAL_TIME_OVERRIDE | NUMBER | Average inter-arrival time of the inventory item. | ||||
SAFETY_STOCK_NEEDS_RECALC | NUMBER | Flag indicates whether safety stock for the item needs recalculation. | ||||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Active | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | |||
ATTRIBUTE1 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE2 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE3 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE4 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE5 | VARCHAR2 | 20 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
BUYER_NAME | VARCHAR2 | 240 | Name of the buyer of the inventory item, used for reporting. | |||
REVISION | VARCHAR2 | 3 | Inventory item revision code for the item. | |||
REDUCE_MPS | NUMBER | 18 | This value indicates the Reduce MPS. | |||
DMD_LATENESS_COST | NUMBER | Demand lateness cost for independent demands | ||||
ITEM_COST_OVERRIDE | NUMBER | Item cost entered from VCP UI to override value collected from source | ||||
ABC_CLASS_NAME | VARCHAR2 | 40 | This is the name of the ABC class for the item. | |||
SOURCE_ORG_ID | NUMBER | This value indicates the Organization identifier of the item source. | ||||
CRITICAL_COMPONENT_FLAG | NUMBER | Critical component flag of item. | ||||
ENABLE_SUPPLY_ORCHESTRATION | NUMBER | 1 | Enable_Supply_Orchestration values: 1- Yes, 2-No | Obsolete | ||
SUPPLY_ORCHESTRATION_ENABLED | NUMBER | 1 | Flag indicates whether the item is enabled for Supply chain orchestration. | |||
AUTO_CREATED_CONFIG_FLAG | NUMBER | 1 | Auto-created Configuration Flag values: 1- Yes, 2-No | |||
AVG_BATCH_SIZE | NUMBER | 18 | Plan measure containing average batch sizes used in safety stock calculations | |||
AVG_BATCH_SIZE_OVERRIDE | NUMBER | 18 | User can override the system generated Average Batch Size by using this field | |||
SAFETY_STOCK_FORECAST_PLAN | VARCHAR2 | 30 | Plan name of the measure used for safety stocks. This column is not populated by collection. | Obsolete | ||
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. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CHAR20 | 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. | ||||
CONSUME_BEF_PRIMARY_FLAG | NUMBER | This attribute controls whether to consume substitutes existing supplies before creating new supplies of this item. | ||||
COMP_SUBSTITUTION_FLAG | NUMBER | This attribute controls whether to consume substitutes existing supplies before creating new supplies of this item. | ||||
SIM_EDIT_FLAGS | NUMBER | Indicates which columns are edited in simulation set records | ||||
ORDER_MODIFIER_TO_START_QTY | NUMBER | Flag indicates Apply Order Modifier to Start Quantity: Yes(1), No(2); if No, it means Apply Order Modifier to Order Quantity. | ||||
ENFORCE_PURCHASE_LT | NUMBER | 1 | The column indicates whether the Purchase lead time has to be enforced: Yes(1) means enforced. No(2) means not enforced. Default value is Yes. | |||
SEGMENT_ID | NUMBER | 18 | Foreign key to the msc_segment table, identifies the segment that the item / org belong to | |||
INDIVISIBLE_FLAG | NUMBER | Attribute indicating whether the item can be ordered in fractions. | ||||
SUBINV_FLAG | NUMBER | 1 | Indicates whether its item+org / item+subinv | |||
IN_SOURCE_PLAN | NUMBER | Flag indicating whether the item is in the plan (the snapshot initially gets more items than the planned items) | ||||
HARD_PEGGING_LEVEL | VARCHAR2 | 25 | It determines the type of pegging considered by the planning engine during the supply or demand netting process. | |||
COMN_SUPPLY_PRJ_DEMAND_FLAG | NUMBER | It determines if material can be planned, picked and issued from common inventory if sufficient inventory does not exist in project inventory. | ||||
LEAD_TIME_LOT_SIZE | NUMBER | Attribute indicating quantity used to compute processing lead time. | ||||
ASSET_TRACKED_FLAG | NUMBER | Attribute indicating whether item is tracked as an asset in installed base. Valid values are 1-Yes, 2-No. | ||||
LEAD_TIME_OFFSET_WEEK_BKTS | NUMBER | The constrained planning engine will offset the lead time in week buckets by this number of days. | ||||
LEAD_TIME_OFFSET_PERIOD_BKTS | NUMBER | The constrained planning engine will offset the lead time in period/month buckets by this number of days. | ||||
CREATE_SUPPLY_AFTER | DATE | When Create_supply_flag is set to Yes, this date column indicates from when the new planned orders can be created for the item in constrained plans | ||||
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. | ||||
LOW_LEVEL_CODE | NUMBER | A number indicating the order in which items will be planned by replenishment planning engine. Items with lower value are planned ahead of those with a higher value. |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
MSC_SYSTEM_ITEMS_N1 | Non Unique | Default | PLAN_ID, PLANNER_CODE, ORGANIZATION_ID, INVENTORY_ITEM_ID | Active |
MSC_SYSTEM_ITEMS_N2 | Non Unique | Default | ITEM_NAME, PLAN_ID, ORGANIZATION_ID | Active |
MSC_SYSTEM_ITEMS_N3 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, PRODUCT_FAMILY_ID | Active |
MSC_SYSTEM_ITEMS_N4 | Non Unique | Default | PLAN_ID, INVENTORY_ITEM_ID | Active |
MSC_SYSTEM_ITEMS_N5 | Non Unique | Default | PLAN_ID, UPPER("ITEM_NAME") | Obsolete |
MSC_SYSTEM_ITEMS_N6 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, WIP_SUPPLY_TYPE | Active |
MSC_SYSTEM_ITEMS_N7 | Non Unique | Default | UPPER("ITEM_NAME") | |
MSC_SYSTEM_ITEMS_N8 | Non Unique | Default | PLAN_ID, BUYER_NAME, BOM_ITEM_TYPE | Active |
MSC_SYSTEM_ITEMS_U1 | Unique | Default | PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 | |
MSC_SYSTEM_ITEMS_U2 | Unique | Default | PLAN_ID, ORGANIZATION_ID, ITEM_NAME, NEW_PLAN_ID, SIMULATION_SET_ID, PART_KEY1 | Active |