# DW_CST_DISTRIBUTION_LINES_CF

This fact table stores Cost Distribution and Cost Distribution line level details

## Details

Module: Cost Management

## Key Columns

COST_DISTRIBUTION_LINE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
COST_DISTRIBUTION_LINE_ID | NUMBER | 38 | 0 | True | Cost distribution line identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System |  |
COST_DISTRIBUTION_ID | NUMBER | 38 | 0 |  | Cost distribution identifier |  |
COST_DISTRIBUTION_LAYER_TRXN_ID | NUMBER | 38 | 0 |  | Layer transaction identifier |  |
COST_DISTRIBUTION_COSTED_QTY | NUMBER |  |  |  | Layer quantity in the costing UOM. |  |
COST_DISTRIBUTION_COSTING_UOM_CODE | VARCHAR2 | 32 |  |  | Costing UOM | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
COST_DISTRIBUTION_ACCOUNTING_STATUS_CODE | VARCHAR2 | 16 |  |  | Indicates if the distribution has been accounted by the SLA. N - Not accounted, D - Draft Accounted, F - Final Accounted | DW_CST_ACCOUNTED_FLAG_LKP_TL | CST_ACCOUNTED_FLAG_CODE
COST_DISTRIBUTION_LINE_NUMBER | NUMBER | 38 | 0 |  | Distribution line number |  |
COST_DISTRIBUTION_LINE_ACC_LINE_TYPE | VARCHAR2 | 32 |  |  | Accounting line type of the distribution line #1 | DW_XLA_ACCNT_LINE_TYPES_LKP_TL | ACCOUNTING_LINE_CODE
COST_DISTRIBUTION_ENTITY_CODE | VARCHAR2 | 32 |  |  | Entity of the event for distribution. #5 | DW_XLA_EVENT_CLASSES_LKP_TL | ENTITY_CODE
COST_DISTRIBUTION_EVENT_CLASS_CODE | VARCHAR2 | 32 |  |  | Reference to accounting event class #5 | DW_XLA_EVENT_CLASSES_LKP_TL | EVENT_CLASS_CODE
COST_DISTRIBUTION_EVENT_TYPE_CODE | VARCHAR2 | 32 |  |  | Reference to accounting event type #2 | DW_XLA_EVENT_TYPES_LKP_TL | EVENT_TYPE_CODE
COST_DISTRIBUTION_LINE_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Transaction currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
COST_DISTRIBUTION_LINE_TRANSACTION_AMOUNT | NUMBER |  |  |  | Distribution line amount in the transaction currency |  |
COST_DISTRIBUTION_LEDGER_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Base currency of the legal entity. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
COST_DISTRIBUTION_LINE_LEDGER_AMOUNT | NUMBER |  |  |  | Distribution line amount in the base currency. |  |
COST_DISTRIBUTION_LINE_DR_CR_SIGN | VARCHAR2 | 16 |  |  | Debit or Credit for the amount. |  |
COST_DISTRIBUTION_LINE_SOURCE_CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Contains the Code combination of the account entered by the users while creating the transctions | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
SOURCE_ACCOUNT_GL_BALANCING_SEGMENT | VARCHAR2 | 32 |  |  | Balancing segment for the ledger. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT
SOURCE_ACCOUNT_GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE
SOURCE_ACCOUNT_COST_CENTER_SEGMENT | VARCHAR2 | 32 |  |  | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT
SOURCE_ACCOUNT_COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 |  |  | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE
SOURCE_ACCOUNT_NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 |  |  | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT
SOURCE_ACCOUNT_NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT1 | VARCHAR2 | 32 |  |  | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SOURCE_ACCOUNT_GL_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SOURCE_ACCOUNT_GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
COST_DISTRIBUTION_LINE_SLA_CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Accounting code combination identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
SLA_ACCOUNT_GL_BALANCING_SEGMENT | VARCHAR2 | 32 |  |  | Balancing segment for the ledger. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT
SLA_ACCOUNT_GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE
SLA_ACCOUNT_COST_CENTER_SEGMENT | VARCHAR2 | 32 |  |  | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT
SLA_ACCOUNT_COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 |  |  | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE
SLA_ACCOUNT_NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 |  |  | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT
SLA_ACCOUNT_NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT1 | VARCHAR2 | 32 |  |  | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
SLA_ACCOUNT_GL_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
SLA_ACCOUNT_GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
COST_DISTRIBUTION_LINE_COST_ELEMENT_ID | NUMBER | 38 | 0 |  | Cost element corresponding to the cost of the transaction. | DW_CST_COST_ELEMENTS_D | COST_ELEMENT_ID
COST_DISTRIBUTION_GL_DATE | DATE |  |  |  | Accounting date | DW_DAY_D | CALENDAR_DATE
COST_DISTRIBUTION_LINE_INTERFACED_TO_PROJECTS_FLAG | VARCHAR2 | 16 |  |  | Indicates the status of transactions that have been transferred to projects | DW_ORA_CST_PJC_TXN_STATUS_CODE_LKP_TL | ORA_CST_PJC_TXN_STATUS_CODE
COST_DISTRIBUTION_CREATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the distribution record. | DW_USER_D | USERNAME
COST_DISTRIBUTION_CREATION_DATE | DATE |  |  |  | Who column: indicates the date of the creation of the distribution record. | DW_DAY_D | CALENDAR_DATE
COST_DISTRIBUTION_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the distribution record. |  |
COST_DISTRIBUTION_LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the distribution record. | DW_USER_D | USERNAME
COST_DISTRIBUTION_LAST_UPDATE_DATE | DATE |  |  |  | Who column: indicates the date of the last update of the distribution record. | DW_DAY_D | CALENDAR_DATE
COST_DISTRIBUTION_LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the distribution record. |  |
COST_DISTRIBUTION_LINE_CREATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the distribution line. | DW_USER_D | USERNAME
COST_DISTRIBUTION_LINE_CREATION_DATE | DATE |  |  |  | Who column: indicates the date of the creation of the distribution line. | DW_DAY_D | CALENDAR_DATE
COST_DISTRIBUTION_LINE_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the distribution line. |  |
COST_DISTRIBUTION_LINE_LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the distribution line. | DW_USER_D | USERNAME
COST_DISTRIBUTION_LINE_LAST_UPDATE_DATE | DATE |  |  |  | Who column: indicates the date of the last update of the distribution line | DW_DAY_D | CALENDAR_DATE
COST_DISTRIBUTION_LINE_LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the distribution line. |  |
COST_DISTRIBUTION_LINE_AE_HEADER_ID | NUMBER | 38 | 0 |  | Subledger journal entry identifier. |  |
COST_DISTRIBUTION_LINE_AE_LINE_NUM | NUMBER |  |  |  | Subledger journal entry line number. |  |
TRANSACTION_ID | NUMBER | 38 | 0 |  | Transaction identifier which uniquely identifies a cost transaction in costing |  |
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_DISTRIBUTION_COST_ORG_ID | NUMBER | 38 | 0 |  | Cost Org identifier | DW_CST_COST_ORG_BOOKS_D | COST_ORG_ID
COST_DISTRIBUTION_COST_BOOK_ID | NUMBER | 38 | 0 |  | Cost Book identifier | DW_CST_COST_ORG_BOOKS_D | COST_BOOK_ID
SUBINVENTORY_CODE | VARCHAR2 | 16 |  |  | Subinventory Code | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME
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 |  | 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 |  |  | Costing 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
PJC_CONTRACT_ID | NUMBER | 38 | 0 |  | Project contract identifier | DW_CONTRACT_HEADER_D | CONTRACT_HEADER_ID
PJC_FUNDING_SOURCE_ID | NUMBER | 38 | 0 |  | Project Funding source identifier | DW_AWARD_FUNDING_SOURCE_D | FUNDING_SOURCE_ID
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory Item Identifier #4 | 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 #4 | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LE_TIMEZONE_CODE | VARCHAR2 | 64 |  |  | Indicates Legal Entity Timezone for transaction. |  |
COST_DISTRIBUTION_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier.Derived from the Cost Book | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
COST_DISTRIBUTION_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. #3 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Period type. Examples are Weekly, Monthly, Quarterly. #3 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
CREATION_DATE | DATE |  |  |  | Who column: indicates the date and time of the creation of the Cost Transaction. | DW_DAY_D | CALENDAR_DATE
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the Cost Transaction. |  |
LAST_UPDATE_DATE | DATE |  |  |  | Who column: indicates the date and time of the last update of the Cost Transaction. | DW_DAY_D | CALENDAR_DATE
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the Cost Transaction. |  |
LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who last updated the Cost Transaction. | DW_USER_D | USERNAME

## Notes

#1 Apart from COST_DISTRIBUTION_LINE_ACC_LINE_TYPE the join with DW_XLA_ACCNT_LINE_TYPES_LKP_TL should also be done on COST_DISTRIBUTION_ENTITY_CODE and COST_DISTRIBUTION_EVENT_CLASS_CODE and DW_XLA_ACCNT_LINE_TYPES_LKP_TL.APPLICATION_ID=707 and ACCOUNTING_LINE_TYPE_CODE='S' #2 Apart from COST_DISTRIBUTION_EVENT_TYPE_CODE the join with DW_XLA_EVENT_TYPES_LKP_TL should also be done on COST_DISTRIBUTION_EVENT_CLASS_CODE and COST_DISTRIBUTION_ENTITY_CODE and DW_XLA_EVENT_TYPES_LKP_TL.APPLICATION_ID=707 #3 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 #4 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column INVENTORY_ORG_ID #5 Apart from the join conditions for DW_XLA_EVENT_CLASSES_LKP_TL also condition DW_XLA_EVENT_CLASSES_LKP_TL.APPLICATION_ID=707 should be added

Copyright © 2019, 2025, Oracle and/or its affiliates.