CST_WD_OPERATION_MATERIALS_GT
This table contains the material information consumed / produced in the operation information obtained by calling the manufacturing api to get the work definition information for configured item work definitions.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WD_OPERATION_MATERIAL_ID | NUMBER | 18 | Indicates the work definition operation material identifier for the work definition input component. | ||
| OPERATION_SEQ_NUMBER | NUMBER | Indicates the operation sequence number of the operation. | |||
| MATERIAL_SEQ_NUMBER | NUMBER | Yes | Indicates the material sequence number of the material consumed in the operation performed. | ||
| MATERIAL_TYPE | VARCHAR2 | 30 | Yes | Indicates the material type of the material. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the item identifier of the material. | ||
| DESCRIPTION | VARCHAR2 | 240 | Indicates the description of the material. | ||
| QUANTITY | NUMBER | Indicates the quantity of the material. | |||
| MATERIAL_QUANTITY | NUMBER | Yes | Indicates the material quantity of the material consumed in the operation performed. | ||
| INVERSE_MATERIAL_QUANTITY | NUMBER | Indicates the material quantity in inverse of the material consumed in the operation performed. | |||
| UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure of the material quantity of the material consumed in the operation performed. | ||
| BASIS_TYPE | VARCHAR2 | 30 | Indicates the basis type of the material consumed in the operation performed. | ||
| SUPPLY_TYPE | VARCHAR2 | 30 | Yes | Indicates the supply type of the material consumed in the operation performed. | |
| SUPPLY_SUBINVENTORY_NAME | VARCHAR2 | 30 | Indicates the sub-inventory which supplied the material consumed in the operation performed. | ||
| SUPPLY_LOCATOR_ID | NUMBER | 18 | Indicates the locator which supplied the material consumed in the operation performed. | ||
| YIELD_FACTOR | NUMBER | Indicates the yield factor of the material consumed in the operation performed. | |||
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | Indicates the component sequence identifier of the material consumed in the operation performed. | ||
| WD_OPERATION_ID | NUMBER | 18 | Yes | Indicates the operation identifier of the material consumed in the operation performed. | |
| LEVEL_NUMBER | NUMBER | Indicates the level number. | |||
| EFFECTIVE_FROM_DATE | TIMESTAMP | Indicates the date from which the material consumed is effective. | |||
| EFFECTIVE_TO_DATE | DATE | Indicates the date till which the material consumed is effective. | |||
| COMPONENT_SEQUENCE_ID_PATH | VARCHAR2 | 4000 | Indicates the component sequence path. | ||
| OPTIONAL_COMPONENT | VARCHAR2 | 1 | Indicates whether the material consumed in an optional component or not. | ||
| CHECK_ATP | NUMBER | Indicates the available to promise indicator. | |||
| ROUNDING_DIRECTION | NUMBER | Indicates the rounding direction of the quantity consumed | |||
| ADHOC_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the material consumed is adhoc in nature. | |
| 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. |