This table provides transaction Layer information
Module: Cost Management
TRANSACTION_ID , REC_TRXN_ID , DEP_TRXN_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 38 | 0 | True | Identifies the cost transaction. | ||
| REC_TRXN_ID | NUMBER | 38 | 0 | True | Receipt Transaction Identifier for transaction layer. | ||
| DEP_TRXN_ID | NUMBER | 38 | 0 | True | Indicates Deplete Transaction Identifier for layers. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | System | ||||
| LAYER_TRXN_ID | NUMBER | 38 | 0 | Identifier that can be used to associate with the cost transaction for the layer | |||
| COST_TRANSACTION_TYPE | VARCHAR2 | 16 | Costing transaction types are ISSUE or RECEIPT. | DW_CST_QUANTITY_FLOW_LKP_TL | CST_QUANTITY_FLOW_CODE | ||
| COST_DATE | DATE | Indicates Transaction layers Cost Date. | DW_DAY_D | CALENDAR_DATE | |||
| COST_TIMESTAMP | TIMESTAMP | Indicates Transaction layers Cost in Timestamp | |||||
| QUANTITY | NUMBER | Layer Quantity | |||||
| UOM_CODE | VARCHAR2 | 32 | Unit of Measure code for transaction layer. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| LAYER_SOURCE_TABLE | VARCHAR2 | 32 | This indicates the source table for the source table for the layer i.e CST_TRANSACTION_LAYERS or CST_TRANSFERS depending upon whether the cost transaction for which the layer is defined is a regular or intrasit transaction | ||||
| CREATION_DATE | TIMESTAMP | Creation Date |
Copyright © 2019, 2024, Oracle and/or its affiliates.