CST_SCENARIO_BUILD_WDO_GT
This table is used during the cost rollup background job process to create the Costing work definition snapshot.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Indicates the scenario identifier based on which the request to create the snapshot for the item is created from. | |
| CST_OPERATION_ID | NUMBER | 18 | Indicates the Fusion costing operation identifier and is used to model the BOM structure of all assemblies in the snapshot as it uniquely identifies an operation for every assembly structure. | |
| WORK_DEFINITION_ITEM_ID | NUMBER | 18 | Surrogate key and unique identifier for costing work definition items for which snapshot is to be created. | |
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | Identifies the fusion manufacturing work definition version identifier from which the work definition snapshot is created. | |
| WORK_DEFINITION_ID | NUMBER | 18 | Identifies the fusion manufacturing work definition identifier from which the work definition snapshot is created. | |
| VERSION_NUMBER | VARCHAR2 | 10 | Indicates the work definition version number based on which the work definition snapshot is created. | |
| WD_EFFECTIVE_FROM_DATE | TIMESTAMP | Indicates the date from which the work definition for which the snapshot is being created is effective. | ||
| WD_EFFECTIVE_TO_DATE | TIMESTAMP | Indicates the date till which the work definition for which the snapshot is being created is effective. | ||
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | Indicates the costing batch output size for work definition for which the snapshot is created. | ||
| WORK_DEFINITION_TYPE | VARCHAR2 | 30 | Indicates the type of work definition for which the snapshot is being created for. | |
| WORK_DEFINITION_NAME_ID | NUMBER | 18 | Indicates the name of the work definition for which the snapshot is being created for. | |
| PRODUCTION_PRIORITY | NUMBER | Indicates the production priority of the work definition snapshot. | ||
| COSTING_PRIORITY | NUMBER | Indicates the costing priority of the work definition snapshot. | ||
| ORGANIZATION_ID | NUMBER | 18 | Indicates the plant under which the work definition snapshot is created. | |
| WORK_CENTER_ID | NUMBER | 18 | Indicates the work center identifier for the resource under the work definition operation. | |
| WORK_CENTER_CODE | VARCHAR2 | 30 | Indicates the work center code for the resource under the work definition operation. | |
| WORK_METHOD_ID | NUMBER | 18 | Indicates the work method identifier of the work definition snapshot. | |
| WORK_METHOD_CODE | VARCHAR2 | 30 | Indicates the work method code of the work definition snapshot. | |
| OUTPUT_INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the primary output item of the work definition snapshot. | |
| OUTPUT_INVENTORY_ORG_ID | NUMBER | 18 | Indicates the organization identifier of the primary output item of the work definition snapshot. | |
| BATCH_QUANTITY | NUMBER | Represents the quantity produced for the work definition. In process manufacturing, this is the batch quantity. | ||
| BATCH_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the batch quantity. | |
| BATCH_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Represents the primary unit of measure code of the batch quantity. | |
| BATCH_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor between the batch UOM to its primary UOM. | ||
| WD_OPERATION_ID | NUMBER | 18 | Indicates the Fusion manufacturing operation identifier as stored in WIS_WD_OPERATIONS_VL. For CTO snapshot data, this identifier can be shared across different assemblies and therefore should only be used to reference the data stored in WIS_WD_OPERATIONS_VL. | |
| OPERATION_SEQ_NUMBER | NUMBER | Indicates the sequence of the operation in the work definition snapshot. | ||
| OP_EFFECTIVE_FROM_DATE | TIMESTAMP | Indicates the date from which the work definition operation is effective. | ||
| OP_EFFECTIVE_TO_DATE | TIMESTAMP | Indicates the date till which the work definition operation is effective. | ||
| OPERATION_TYPE | VARCHAR2 | 30 | Indicates the type of operation. Valid options are: (1) In-House (2) Supplier. | |
| OSP_ITEM_ID | NUMBER | 18 | Identifies the outside processing item reference associated with the operation. | |
| SUPPLIER_ID | NUMBER | 18 | Identifies the supplier reference of the outside processing operation. | |
| SUPPLIER_SITE_ID | NUMBER | 18 | Identifies the supplier site reference of the outside processing operation. | |
| WD_CRITERION_DETAIL_ID | NUMBER | 18 | Indicates the criterion details from the scenario reference based on which the snapshot request is required. | |
| SCENARIO_EVENT_ID | NUMBER | 18 | Indicates the scenario event identifier based on which the request to create the snapshot for the item is created from. | |
| SUPPLY_TYPE | VARCHAR2 | 30 | Indicates the supply type of the item. Used for identifying an item as supplier sources or phantom. | |
| PHANTOM_OPERATION_INHERIT_FLAG | VARCHAR2 | 30 | Indicates whether the operation to which the phantom item is assigned, inherits only the input components / input components and resources. | |
| EFFECTIVE_START_DATE | DATE | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| COST_ORG_ID | NUMBER | 18 | Indicates the cost organization identifier for which the scenario was created. | |
| THIS_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost allocation percentage for this item in the operation. | ||
| OTHER_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost allocation percentage for other items in the operation. | ||
| CST_WD_RESOURCE_INSERT_FLAG | VARCHAR2 | 1 | Indicates whether to insert resource records into the costing work definition snapshot. | |
| OP_YIELD_FACTOR | NUMBER | Indicates the yield factor for the operation. Default value is 1 (100%). | ||
| OP_REV_YIELD_FACTOR | NUMBER | Indicates the reverse cumulative yield factor for the operation. Default value is 1 (100%). |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_BUILD_WDO_GT_N1 | Non Unique | WD_OPERATION_ID, SCENARIO_ID |
| CST_SCN_BUILD_WDO_GT_N2 | Non Unique | OSP_ITEM_ID, ORGANIZATION_ID |