CST_WO_OP_COST_GT
This transaction temporary table will be populated with existing operation level costs from the cst_work_order_costs table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Surrogate ID identifying the cost organization associated to the plant where the work order is executed. | |
| COST_BOOK_ID | NUMBER | 18 | Surrogate ID identifying the cost book associated to the cost organization. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying the work order in costing. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying the work order operation in costing. | |
| OPERATION_SEQ_NUMBER | NUMBER | Indicates a number that identifies the operation sequence within this work order. | ||
| COST_ELEMENT_ID | NUMBER | 18 | Surrogate ID identifying the cost element for the cost. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Surrogate ID identifying the expense pool for the cost. | |
| WIP_COST_TYPE | VARCHAR2 | 30 | Identifies the type of cost e.g. COMPONENT/RESOURCE/PRODUCT/SCRAP | |
| AMOUNT | NUMBER | Total sum of work order cost at the cost element, expense pool level for the work order operation. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Indicates the currency code of the cost. |