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 | ITEM_BOM_COMP_NUMBER of the corresponding 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 of effectivity | |||
| PLANNING_PERCENTAGE | NUMBER | Product of the planning Factor and Quantity | |||
| BILL_SEQUENCE_ID | NUMBER | 18 | Identifier of the BOM | ||
| PARENT_BILL_SEQUENCE_ID | NUMBER | 18 | Identifier of the PARENT BOM | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | BOM_ITEM_TYPE | |
| COMPONENT_TYPE | NUMBER | 2 | COMPONENT_TYPE | ||
| DELETED_FLAG | NUMBER | 3 | DELETED_FLAG | ||
| REFRESH_NUMBER | NUMBER | 18 | Yes | Collection Cycle Id | |
| 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 |