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 38 0   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
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
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, 2024, Oracle and/or its affiliates.