This table provides transaction Layer information
Module: Cost Management
REC_TRXN_ID , TRANSACTION_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.