CST_WD_OPERATION_OUTPUTS
This table is used to identify a list of expected outputs at each operation when manufacturing the specified product.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WD_OPERATION_OUTPUTS_PK |
WD_OPERATION_OUTPUT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WD_OPERATION_OUTPUT_ID | NUMBER | 18 | Yes | Unique Identifier to identify a work definition operation output. | |
| SCENARIO_ID | NUMBER | 18 | Yes | Identifies the scenario for which the work definition operation outputs are derived. | |
| WORK_DEFINITION_ITEM_ID | NUMBER | 18 | Yes | Identifies the work definition item for which the work definition operation outputs are derived. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier that represents the manufacturing plant to which this operation output item belongs. | |
| WORK_DEFINITION_ID | NUMBER | 18 | Yes | The unique identifier of a work definition. This is used in order to enforce uniqueness of an output item across the work definition operations. | |
| WORK_DEFINITION_VERSION_ID | NUMBER | 18 | Indicates the work definition version identifier. | ||
| WIS_WD_OPERATION_OUTPUT_ID | NUMBER | 18 | Yes | The unique identifier of a work definition operation output. | |
| WD_OPERATION_ID | NUMBER | 18 | Yes | Reference to the operation to which this operation output item is assigned. | |
| CST_OPERATION_ID | NUMBER | 18 | Identifies the costing work definition reference for which the work definition operation outputs are derived. | ||
| OUTPUT_SEQ_NUMBER | NUMBER | Yes | Indicates the sequence of this output line within this operation. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Represents the unique identifier of the output item for this operation. | |
| OUTPUT_TYPE | VARCHAR2 | 30 | Yes | Type of output produced by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_OUTPUT_MATERIAL. | |
| OUTPUT_QUANTITY | NUMBER | Yes | Represents the output quantity expected to be produced at this operation. | ||
| UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the output quantity. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Represents the primary unit of measure code of the item. | ||
| PRIMARY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this is the primary output for the work definition. Valid values are Y or N. | |
| COST_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost percentage share of this output across all outputs. This column will be null for manually entered costs. | |||
| COSTING_PRIORITY | NUMBER | Costing uses the highest priority work definition to calculate the standard cost using the cost rollup. Upon exploding the BOM the child work definitions are threaded using the priority number chosen at the very top. | |||
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Identifies the scenario roll-up header record created for the output item. | ||
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Identifies the item cost profile reference for the output item. | ||
| ASSET_COST_PROFILE_ID | NUMBER | 18 | Identifies the asset cost profile reference for the output item. | ||
| EXPENSE_COST_PROFILE_ID | NUMBER | 18 | Identifies the expense cost profile reference for the output item. | ||
| ASSET_VAL_UNIT_ID | NUMBER | 18 | Identifies the asset valuation unit reference for the output item. | ||
| EXPENSE_VAL_UNIT_ID | NUMBER | 18 | Identifies the expense valuation unit reference for the output item. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| OUTPUT_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor between the output item's UOM to its primary UOM. | |||
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the work definition operation output. | ||
| SCENARIO_EVENT_ID | NUMBER | 18 | Identifies the scenario event that created the snapshot of the work definition operation output. | ||
| CST_MSC_SRC_RULE_ID | NUMBER | 18 | Indicates the costing identifier for the sourcing rule. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CST_WD_OPERATION_OUTPUTS_N1 | Non Unique | Default | SCENARIO_ID, WORK_DEFINITION_ITEM_ID, SCENARIO_ROLLUP_HEADER_ID | Obsolete |
| CST_WD_OPERATION_OUTPUTS_N2 | Non Unique | Default | SCENARIO_ID, STATUS_CODE, WORK_DEFINITION_ITEM_ID | |
| CST_WD_OPERATION_OUTPUTS_N3 | Non Unique | Default | SCENARIO_ROLLUP_HEADER_ID | |
| CST_WD_OPERATION_OUTPUTS_U1 | Unique | Default | WD_OPERATION_OUTPUT_ID | |
| CST_WD_OPERATION_OUTPUTS_U2 | Unique | Default | SCENARIO_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, WD_OPERATION_ID | |
| CST_WD_OPERATION_OUTPUTS_U3 | Unique | Default | SCENARIO_ID, WORK_DEFINITION_ITEM_ID, WD_OPERATION_ID, OUTPUT_SEQ_NUMBER |