DW_CST_TRANSACTION_LAYERS_CF

This table provides transaction Layer information

Details

Module: Cost Management

Key Columns

REC_TRXN_ID , TRANSACTION_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