DW_CST_TRANSACTION_LAYERS_CF (Preview)

This table requires activation of Cost Accounting functional area. This table provides transaction Layer information

Details

Module: Cost Management

Key Columns

TRANSACTION_ID , DEP_TRXN_ID , REC_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, 2023, Oracle and/or its affiliates.