MSC_API_WD_OP_MATERIALS
This table is to populate data from the API tables and to use as source side tables to populate the staging tables
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_API_WD_OP_MATERIALS_PK |
WD_OPERATION_ID, INVENTORY_ITEM_ID, CONFIG_ITEM_ID, ORGANIZATION_ID, EFFECTIVE_FROM_DATE |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| WD_OPERATION_MATERIAL_ID | NUMBER | Work definition operation material identifier specified for the routing. | ||
| OPERATION_SEQ_NUMBER | NUMBER | Yes | OPERATION_SEQ_NUMBER | |
| MATERIAL_SEQ_NUMBER | NUMBER | Yes | MATERIAL_SEQ_NUMBER | |
| MATERIAL_TYPE | VARCHAR2 | 30 | Yes | MATERIAL_TYPE |
| INVENTORY_ITEM_ID | NUMBER | Yes | Identifies the inventory item id | |
| DESCRIPTION | VARCHAR2 | 240 | Description of the WD operation material | |
| QUANTITY | NUMBER | Quantity of the work definition operation material. | ||
| MATERIAL_QUANTITY | NUMBER | Yes | MATERIAL_QUANTITY | |
| INVERSE_MATERIAL_QUANTITY | NUMBER | Indicates the material quantity in inverse of the material consumed in the operation performed. | ||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the work definition operation materials. | |
| BASIS_TYPE | NUMBER | Indicates whether the item quantity is fixed (e.g., quantity per lot produced) or variable (e.g., quantity per item produced). | ||
| SUPPLY_TYPE | NUMBER | Yes | This value indicates the Supply type of the work definition material. | |
| SUPPLY_SUBINVENTORY_NAME | VARCHAR2 | 30 | This value indicates the supply subinventory name. | |
| SUPPLY_LOCATOR_ID | NUMBER | Supply locator identifier of the work definition operation material. | ||
| YIELD_FACTOR | NUMBER | Yes | This value indicates the Yield specified for the operation in resource demand. | |
| COMPONENT_SEQUENCE_ID | NUMBER | Reference to the Item Structure component | ||
| WD_OPERATION_ID | NUMBER | Yes | Work definition operation identifier specified for the routing. | |
| LEVEL_NUMBER | NUMBER | LEVEL_NUMBER | ||
| EFFECTIVE_FROM_DATE | TIMESTAMP | Yes | Indicate the date from when this operation is effective | |
| EFFECTIVE_TO_DATE | TIMESTAMP | Indicate the date from which this operation is no longer effective | ||
| ITEM_STRUCT_COMP_REF_FLAG | VARCHAR2 | 1 | Yes | Item structure component reference flag. Setup for work definition operation material. |
| COMPONENT_SEQUENCE_ID_PATH | CLOB | Contains the lineage key of this component in the ATO Model Item Structure. This attribute refers to EGP_EXPLOSIONS_V.COMP_SEQ_PATH. It is used to uniquely identify this component in the exploded ATO Model item structure . | ||
| OPTIONAL | VARCHAR2 | 1 | This is the optional value for work definition operation materials. | |
| CHECK_ATP | VARCHAR2 | 1 | Flag indicating if ATP check is required | |
| ROUNDING_DIRECTION | NUMBER | Rounding direction for work definition or a bom/IS component. | ||
| CONFIG_ITEM_ID | NUMBER | Yes | Unique identifier of the configured item | |
| ORGANIZATION_ID | NUMBER | Yes | ORGANIZATION_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_API_WD_OP_MATERIALS_U1 | Unique | Default | WD_OPERATION_ID, INVENTORY_ITEM_ID, CONFIG_ITEM_ID, ORGANIZATION_ID, EFFECTIVE_FROM_DATE |