This table requires activation of Cost Accounting functional area. This table stores the Cost Transaction details
Module: Cost Management
TRANSACTION_ID
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 | 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 |
#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
Copyright © 2019, 2023, Oracle and/or its affiliates.