DW_CST_TRANSACTIONS_CF

This table stores the Cost Transaction details

Details

Module: Cost Management

Key Columns

TRANSACTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TRANSACTION_ID NUMBER 38 0 True Transaction identifier which uniquely identifies a transaction in costing
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System identifier
BASE_TXN_ACTION_ID NUMBER 38 0 Transaction action identifier DW_CST_TRANSACTION_TYPES_D_TL BASE_TXN_ACTION_ID
BASE_TXN_SOURCE_TYPE_ID NUMBER 38 0 Transaction source type identifier DW_CST_TRANSACTION_TYPES_D_TL BASE_TXN_SOURCE_TYPE_ID
BASE_TXN_TYPE_ID NUMBER 38 0 Transaction type identifier DW_CST_TRANSACTION_TYPES_D_TL BASE_TXN_TYPE_ID
COST_ORG_ID NUMBER 38 0 Cost Org identifier DW_CST_COST_ORG_BOOKS_D COST_ORG_ID
COST_BOOK_ID NUMBER 38 0 Cost Book identifier DW_CST_COST_ORG_BOOKS_D COST_BOOK_ID
COST_DATE DATE Date to be used for transaction sequencing DW_DAY_D CALENDAR_DATE
COST_TIMESTAMP TIMESTAMP Timestamp to be used for transaction sequencing
COST_METHOD_CODE VARCHAR2 32 The cost method code like PERPETUAL AVERAGE etc. DW_CST_COST_METHODS_LKP_TL CST_COST_METHODS_CODE
COST_PROFILE_ID NUMBER 38 0 Single column FK: Identifies Cost Profile associated with the transaction DW_CST_COST_PROFILES_D COST_PROFILE_ID
COST_STATUS_CODE VARCHAR2 16 Current costing status of the transaction for display: N-Not Processed, P-Partially Processed, C-Fully Costed, E-Error, X-Excluded from Costing DW_CST_COST_STATUS_LKP_TL CST_COST_STATUS_CODE
COSTED_QTY NUMBER Quantity that has been processed in costing.
COSTED_UOM VARCHAR2 32 Costed Unit of Measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
CST_COGS_CST_TRANSACTION_ID NUMBER 38 0 Stores the reference to the parent costing Inventory transaction for the Cogs and RMA Recognition transactions
CST_COGS_RECOGNITION_PERCENTAGE NUMBER Indicates COGS or RMA recognition percentage.
CST_COGS_REVENUE_LINES_INVOICE_NUMBER VARCHAR2 32 The invoice or contract number associated with the revenue line for the Cogs recognition transaction
CST_COGS_TRANSACTION_ID NUMBER 38 0 Stores the value of the Costing Cogs Transaction if the cost transaction is of the type COGS or RMA recognition
CST_RESOURCE_TRANSACTION_ID NUMBER 38 0 Identifies a resource transaction. It shares the same sequence as the one used for Transaction ID in the Cost Transaction entity. This ensures that the transaction_id is uniques across all transactions tables.
CST_WO_UPDATE_EVENT_TXN_ID NUMBER 38 0 Identifies a work order update event in costing. This column will reuse the CST_TRANSACTIONS sequence to maintain the uniqueness of transactions at the distribution level.
CST_ACCTG_ONLY_TXNS_ID NUMBER 38 0 Identifies accounting only transactions created by the cost preprocessors for events with no physical movement of items such as invoices to expense.
CST_OPERATION_TRANSACTION_ID NUMBER 38 0 identifies the operation transaction in costing. This column will use the existing sequence for CST_TRANSACTION to avoid id duplicating across the tables.
CST_INV_TXN_EXTERNAL_SYSTEM_REF_ID NUMBER 38 0 Stores a value that uniquely identifies a certain instance of an object within the external system.
CST_INV_TXN_EXTERNAL_SYSTEM_REFERENCE VARCHAR2 64 Identifies the external source system. In case of inventory transfers it is CST with parent transaction identifier relating to original row.
CST_INV_TXN_ID NUMBER 38 0 The identifier for costing's inventory transaction table, populated for Inventort Cost Transactions
CST_TRANSACTION_ID NUMBER 38 0 Stores the value of the Costing Inventory Transaction if the cost transaction is Inventory Cost Transaction
PJC_EXPENDITURE_ITEM_DATE DATE Project Item Expenditure Date DW_DAY_D CALENDAR_DATE
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0 Project Expenditure Type Identifier DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
PJC_ORGANIZATION_ID NUMBER 38 0 Project Oranization Identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
PJC_PROJECT_ID NUMBER 38 0 Project Identifier DW_PROJECT_D PROJECT_ID
PJC_TASK_ID NUMBER 38 0 Project Task Identifier DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
INVENTORY_ITEM_ID NUMBER 38 0 Inventory Item Identifier #2 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
INVENTORY_ORG_BU_ID NUMBER 38 0 Business Unit Id of the Inventory Organization. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
INVENTORY_ORG_PROFIT_CENTER_BU_ID NUMBER 38 0 Profit Center Business Unit Id of the Inventory Organization. DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
INVENTORY_ORG_ID NUMBER 38 0 Indicates The Inventory Org To Which The Item Belongs #2 DW_INTERNAL_ORG_D ORGANIZATION_ID
LE_TIMEZONE_CODE VARCHAR2 64 Indicates Legal Entity Timezone for transaction.
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier.Derived from the Cost Book DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
LEDGER_ID NUMBER 38 0 Primary ledger id. Derived from the Cost Book DW_LEDGER_D LEDGER_ID
TRANSACTION_DATE DATE Transaction date for the Costing Transaction DW_DAY_D CALENDAR_DATE
TRANSACTION_TIMESTAMP TIMESTAMP Transaction datetime for the Costing Transaction
TRANSACTION_QTY NUMBER Transaction quantity of the Costing transaction.
TRANSACTION_SOURCE_TABLE VARCHAR2 128 Source Table for the Transaction using which TRANSACTION_ID can be identified. Will hold the below values:- 1. CST_TRANSACTIONS:- For Inventory Costing Transactions 2. CST_COGS_TRANSACTIONS:- For Cogs/RMA Recognition Costing Transactions 3. CST_RESOURCE_TRANSACTIONS:- For Work In Process Resource Charging Transactions 4. CST_WO_UPDATE_EVENT_TXNS:- For Work in Process Job Close Transactions 5. CST_ACCTG_ONLY_TXNS :- For Invoice Variance Clearing Transactions 6. CST_OPERATION_TRANSACTIONS:- For Work Order Scrap Transactions
TRANSACTION_UOM_CODE VARCHAR2 16 The unit of measure code in which transaction quantity is specified DW_UNIT_OF_MEASURE_D_TL UOM_CODE
TXN_SOURCE_DOC_NUMBER VARCHAR2 256 Transactions Source Document Number
TXN_SOURCE_DOC_TYPE_CODE VARCHAR2 64 Transactions Source Document Type DW_ORA_CST_DOC_FLOW_TYPES_LKP_TL ORA_CST_DOC_FLOW_TYPES_CODE
TXN_SOURCE_REF_DOC_NUMBER VARCHAR2 256 Transactions Source Documents Reference Document Number
TXN_SOURCE_REF_DOC_TYPE_CODE VARCHAR2 64 Transactions Source Documents Reference Document Type DW_ORA_CST_DOC_FLOW_TYPES_LKP_TL ORA_CST_DOC_FLOW_TYPES_CODE
VAL_UNIT_ID NUMBER 38 0 Valuation Unit Identifier DW_CST_VALUATION_UNITS_D VAL_UNIT_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Fiscal Period Set Name. #1 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Period type. Examples are Weekly, Monthly, Quarterly. #1 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
CREATED_BY VARCHAR2 128 Created by user DW_USER_D USERNAME
CREATION_DATE DATE Creation Date DW_DAY_D CALENDAR_DATE
CREATION_TIMESTAMP TIMESTAMP Creation datetime
LAST_UPDATE_DATE DATE Last updat date DW_DAY_D CALENDAR_DATE
LAST_UPDATE_TIMESTAMP TIMESTAMP Last update datetime
LAST_UPDATED_BY VARCHAR2 128 Last updated by DW_USER_D USERNAME

Notes

#1 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on TRANSACTION_DATE column #2 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column INVENTORY_ORG_ID