CST_WO_OP_EXEC_DTLS_GT
Temporary table used to hold the work order operation quantities for calculation of scrap or product value.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Yes | Cost organization identifier. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Cost book identifier. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate identifying a work orer in costing. | ||
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate identifying a work order operation in costing. | |
| OPERATION_SEQ_NUMBER | NUMBER | Yes | Operation sequence of the work order operation. | ||
| SCRAP_QUANTITY | NUMBER | Total scrap quantity reported on the work order operation. | |||
| COMPLETED_QUANTITY | NUMBER | Total completion quantity reported on the work order operation. | |||
| TOTAL_OUTPUT_PERCENTAGE | NUMBER | Sum of allocation percent of all outputs reported on the prcess manufacturing operation. | |||
| CONTAINS_OUTPUT_FLAG | VARCHAR2 | 1 | Indicates if this operation has output items. Valid values are Y - Yes, Null - No and L - Last operation. | ||
| PLANNED_START_QUANTITY | NUMBER | Indicates the planned start quantity/batch quantity on the work order. |