MSC_DP_CTO_BOM_COMP
ODS table to store the details of the BOM Components. This table is primarily for CTO.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_DP_CTO_BOM_COMP_PK |
ITEM_BOM_COMP_ID, ORGANIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ITEM_BOM_COMP_ID | NUMBER | 18 | Yes | ID of the item bom component. The ID is uniquely generated using a DB sequence. | |
| PARENT_ITEM_BOM_COMP_ID | NUMBER | 18 | Parent ID of the item bom component. | ||
| ROOT_ITEM_BOM_COMP_ID | NUMBER | 18 | Root item of the item bom component. | ||
| ITEM_BOM_COMP_NUM | VARCHAR2 | 2000 | Yes | Concatenation of the inventory item id of all parent nodes. | |
| ITEM_BOM_COMP_NAME | VARCHAR2 | 2000 | Concatenation of the inventory item name of all parent nodes. | ||
| PARENT_ITEM_BOM_COMP_NUM | VARCHAR2 | 2000 | Denotes the item bom component number of the parent node. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifier of the component item. | |
| PARENT_INV_ITEM_ID | NUMBER | 18 | Identifier of the parent item. | ||
| ROOT_INV_ITEM_ID | NUMBER | 18 | Yes | Identifier of the item being assembled. | |
| DEPTH | NUMBER | 3 | Yes | Depth of the item in the bom tree. | |
| EFFECTIVITY_DATE | DATE | Date of effectivity for this component. | |||
| DISABLE_DATE | DATE | End date of the bom effectivity. | |||
| PLANNING_PERCENTAGE | NUMBER | Product of the planning factor and quantity. | |||
| USAGE_QUANTITY | NUMBER | Stores the usage quantity of the bom component. | |||
| BILL_SEQUENCE_ID | NUMBER | 18 | Identifier of the bom sequence. | ||
| PARENT_BILL_SEQUENCE_ID | NUMBER | 18 | unique identifier of the parent bom. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | Identifier of the organization to which the bom belongs to. | |
| COMPONENT_TYPE | NUMBER | 2 | Type of the bom component in the structure. | ||
| DELETED_FLAG | NUMBER | 3 | Denotes whether or not the component is marked for deletion. | ||
| REFRESH_NUMBER | NUMBER | 18 | Yes | The identifier of the data collection cycle. | |
| 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_DP_CTO_BOM_COMP_U1 | Unique | Default | ITEM_BOM_COMP_ID, ORGANIZATION_ID |