# DW_CST_TRANSACTION_LAYERS_CF

This table provides transaction Layer information

## Details

Module: Cost Management

## Key Columns

TRANSACTION_ID , REC_TRXN_ID , DEP_TRXN_ID

## Columns

Columns
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, 2025, Oracle and/or its affiliates.