CST_WO_NEW_OP_TXN_COSTS_GT
This transaction temporary table will be populated with new operation transaction costs as they are calculated within the process. This table will finally be used to create cost rows in cst_operation_txn_costs.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OPERATION_TRANSACTION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the operation transaction. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost organization associated to the plant where the work order is executed. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book associated to the cost organization. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order in costing. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order operation in costing. | |
| OPERATION_SEQ_NUMBER | NUMBER | Yes | Indicates a number that identifies the operation sequence within this work order. | ||
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost element for the cost. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Yes | Surrogate ID identifying the expense pool for the cost. | |
| COST_DATE | TIMESTAMP | Yes | Indicates the cost date of the operation transaction. | ||
| COST_TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Indicates the cost transaction type e.g. RECIEPT/ISSUE. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Indicates the base transaction type of the operation transaction. | |
| QUANTITY | NUMBER | Yes | Indicates the quantity of the operation transaction. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Indicates the unit of measure. Primary unit of measure. | |
| UNIT_COST | NUMBER | Yes | Indicates the per unit cost for the operation transaction at cost element, expense pool level. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Indicates the cost book currency. | |
| ABSORPTION_TYPE | VARCHAR2 | 30 | Absorption type of the transaction. Include in Inventory or Expense. | ||
| NET_SCRAP_QTY | NUMBER | Indicates the net scrap quantity at this operation. | |||
| NET_COMPLETION_QTY | NUMBER | Indicates the net completion quantity at this operation. | |||
| NEW_SCRAP_QTY | NUMBER | Indicates the new scrap transaction quantity. | |||
| NEW_SCRAP_RETURN_QTY | NUMBER | Indicates the new scrap return transaction quantity. |