1. Tables and Views for SCM
  2. MSC_DM_MODEL_BOM_COMP

MSC_DM_MODEL_BOM_COMP

This table is used to derive the relationship between the model item and its dependent item in the CTO BOM

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MSC_DM_MODEL_BOM_COMP_PK

ORGANIZATION_ID, COMPONENT_ITEM_ID, TREE_DEPTH, ITEM_BC_NUM

Columns

Name Datatype Length Precision Not-null Comments
SR_INSTANCE_ID NUMBER 18 Source Instance identifier
ORGANIZATION_ID NUMBER 18 Yes Organization Identifier
BASE_MODEL_ID NUMBER 18 Unique identifier for Base model
PARENT_ITEM_ID NUMBER 18 Parent Item Identifier
COMPONENT_ITEM_ID NUMBER 18 Yes Item unique identifier
TREE_DEPTH NUMBER 3 Yes Depth of the item in the tree
ITEM_BC_NUM VARCHAR2 2000 Yes concatenated value of the inventory item id of the item
PARENT_ITEM_BC_NUM VARCHAR2 2000 concatenated value of the inventory item id of the parent item
ITEM_BC_NAME VARCHAR2 4000 concatenated value of the item name of the item
EFFECTIVITY_DATE DATE Effectivity date of the item in bom
DISABLE_DATE DATE Disable date of the item in the bom
PLNG_PCT_EXISTING NUMBER Planning Percentage of the item in bom
BOM_ITEM_TYPE NUMBER 1 BOM_ITEM_TYPE of the item
IS_BASE_MODEL NUMBER 1 used to identify the base model
BILL_SEQUENCE_ID NUMBER 18 Bill sequence identifier
REFRESH_NUMBER NUMBER 18 Refresh Number
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.

Indexes

Index Uniqueness Tablespace Columns
MSC_DM_MODEL_BOM_COMP_U1 Unique Default ORGANIZATION_ID, COMPONENT_ITEM_ID, TREE_DEPTH, ITEM_BC_NUM