CST_WO_OPERATION_OUTPUTS
This will store the output items and their definitions from manufacturing. It will be persisted at the time of close and we will need to be synchronized in case of reopen and close of work orders.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_OPERATION_OUTPUTS_PK |
CST_WO_OPERATION_OUTPUT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_WO_OPERATION_OUTPUT_ID | NUMBER | 18 | Yes | Surrogate column identifying a row in this table. Values come from sequence. CST_WO_OUTPUT_ITEMS_S. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Cost accounting work order identifier. Identifies the work order. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Cost accounting work order operation identifier. | |
| OUTPUT_SEQ_NUMBER | NUMBER | Yes | Indicates the sequence of this output line within this operation. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifier of the item produced. | |
| 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. | |
| PRIMARY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this is the primary output for the work order. Valid values are Y or N. | |
| OUTPUT_QUANTITY | NUMBER | Yes | This is the output quantity produced in this operation. | ||
| COMPLETED_QUANTITY | NUMBER | Represents the quantity completed so far, since partial completions are possible. | |||
| UOM_CODE | VARCHAR2 | 3 | Yes | Represents the unit of measure code of the output quantity. | |
| COST_ALLOCATION_BASIS | VARCHAR2 | 30 | Yes | The basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. This is displayed from a lookup ORA_WIS_COST_ALLOC_BASIS. | |
| 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. | ||
| COST_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost percentage share of this output across all outputs. Will be Null for manually entered costs. | |||
| WD_OPERATION_OUTPUT_ID | NUMBER | 18 | Surrogate foreign key identifying the work definition operation output. | ||
| CST_WO_UPDATE_EVENT_ID | NUMBER | 18 | Surrogate identifying the work order update event for which the output values are saved. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WO_OPERATION_OUTPUTS_PK | Unique | Default | CST_WO_OPERATION_OUTPUT_ID |
| CST_WO_OPERATION_OUTPUTS_U1 | Unique | Default | CST_WORK_ORDER_ID, INVENTORY_ITEM_ID |
| CST_WO_OPERATION_OUTPUTS_U2 | Unique | Default | CST_WORK_ORDER_OPERATION_ID, INVENTORY_ITEM_ID |