MSC_SNAPSHOT_ITEMS
This table is used to store the items that are needed for plan snapshot processing.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | This value indicates the plan identifier for the record. | ||
| INVENTORY_ITEM_ID | NUMBER | Yes | This fields identifies the Inventory item. | ||
| ORGANIZATION_ID | NUMBER | Yes | This fields identifies the Organization. | ||
| SOURCING_RULE_ID | NUMBER | This field stores the Sourcing Rule Identifier. | |||
| ASSIGNMENT_ID | NUMBER | 18 | Sourcing Rule/Bill of Distribution Identifier | ||
| MRP_PLANNING_CODE | NUMBER | Type of planning required for this item: MRP(3), MPS(4), Not Planned(6), MRP and DRP(7), MPS and DRP(8), DRP(9) | |||
| BOM_ITEM_TYPE | NUMBER | BOM item type: Model(1), Option Class(2), Planning(3), Standard(4), Product Family(5) | |||
| INVENTORY_ITEM_FLAG | NUMBER | Indicates whether the item is an inventory item. | |||
| ENGINEERING_ITEM_FLAG | NUMBER | Flag indicating if engineering items are used for prototypes or research. Used for UI and reports | |||
| EAM_ITEM_TYPE | NUMBER | This field stores EAM item type of the inventory. | |||
| ROUNDING_CONTROL_TYPE | NUMBER | Flag indicating if rounding of the quantity is allowed | |||
| SAFETY_STOCK_CODE | NUMBER | Safety stock code: User-defined quantity(1), User-defined percentage(2), or mean absolute deviation | |||
| SR_CATEGORY_ID | NUMBER | Source application category identifier for the planning category set; used for UI and reports | |||
| CATEGORY_NAME | VARCHAR2 | 200 | Category name for the planning category | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Unit of measure code of the inventory item. | |
| STANDARD_COST | NUMBER | This field stores the standard cost of the item. | |||
| SUPPLIER_CAP_OVERUTIL_COST | NUMBER | Supplier cap over utilization cost | |||
| LIST_PRICE | NUMBER | This field stores the list price of the item | |||
| AVERAGE_DISCOUNT | NUMBER | This field stores the Average discount of the item. | |||
| DMD_LATENESS_COST | NUMBER | This field is for Demand lateness cost of the item | |||
| DEMAND_TIME_FENCE_DATE | DATE | Demand time fence date for this item org in this plan. | |||
| PLANNING_TIME_FENCE_DATE | DATE | Planning time fence as computed by the planning engine. | |||
| ASSIGNMENT_TYPE | NUMBER | Sourcing Assignment type for the item. | |||
| REDUCE_MPS | NUMBER | Indicates how MPS orders are reduced when plan is re-run. | |||
| IN_SOURCE_PLAN | NUMBER | Flag indicating whether the item is in the plan (the snapshot initially gets more items than the planned items. | |||
| PROCESSING_LEAD_TIME | NUMBER | This field is the Full lead time of the item. | |||
| BASE_ITEM_ID | NUMBER | 18 | Base Item Identifier for Configuration | ||
| AUTO_CREATED_CONFIG_FLAG | NUMBER | 1 | Auto-created Configuration Flag Values: 1- Yes, 2-No | ||
| PICK_COMPONENTS_FLAG | NUMBER | Flag indicating whether all shippable components should be picked | |||
| HARD_PEGGING_LEVEL | VARCHAR2 | 25 | It determines the type of pegging considered by the planning engine during the supply or demand netting process. | ||
| 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. | ||
| 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. | |||
| PARENT_ITEM_ID | NUMBER | Parent item identifier. It is equal to item identifier in the case of dummy item or "simple" item - item that is not aggregated. | |||
| SEGMENT_ID | NUMBER | 18 | Foreign key to the msc_segment table | ||
| BATCH_ID | NUMBER | 18 | items will be grouped into batches for processing them in batches thru child ess jobs | ||
| COLLECTIONS_END_SCN | NUMBER | 18 | To track item-orgs incremental changes going back in history - Selective snapshot | ||
| SUBINV_FLAG | NUMBER | 1 | Indicates whether its item+org / item+subinv |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_SNAPSHOT_ITEMS_N1 | Non Unique | Default | PLAN_ID, SOURCING_RULE_ID |
| MSC_SNAPSHOT_ITEMS_N2 | Non Unique | Default | PLAN_ID, BATCH_ID |
| MSC_SNAPSHOT_ITEMS_N3 | Non Unique | Default | PLAN_ID, COLLECTIONS_END_SCN |
| MSC_SNAPSHOT_ITEMS_U1 | Unique | Default | PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID |