DW_FA_MC_SLA_TRX_DEPRN_CF

This view contains information about fixed asset transactions and depreciation accounting

Details

Module: Assets

Key Columns

ADJUSTMENT_LINE_ID, DEPRN_RUN_ID, ASSET_ID, REF_AE_HEADER_ID, BOOK_TYPE_CODE, TRANSACTION_HEADER_ID, DISTRIBUTION_ID, TEMP_LINE_NUM, LEDGER_ID, AE_HEADER_ID, PERIOD_COUNTER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEDGER_ID NUMBER 38 0 True Identifier of the accounting ledger    
BOOK_TYPE_CODE VARCHAR2 32   True Unique book identification name.    
ASSET_ID NUMBER 38 0 True Identifier of the asset number.    
PERIOD_COUNTER NUMBER 38 0 True Identifier of the asset transaction.    
DEPRN_RUN_ID NUMBER 38 0 True Identifier of the asset accounting line.    
TRANSACTION_HEADER_ID NUMBER 38 0 True Identifier of the asset transaction.    
ADJUSTMENT_LINE_ID NUMBER 38 0 True Identifier of the asset accounting line.    
DISTRIBUTION_ID NUMBER 38 0 True Identifier of the asset distribution.    
REF_AE_HEADER_ID NUMBER 38 0 True Subledger journal entry identifier.    
TEMP_LINE_NUM NUMBER 38 0 True Intermediary line number generated by the accounting engine when the entries are in most detail form.    
AE_HEADER_ID NUMBER 38 0 True Subledger journal entry identifier.    
SOURCE_RECORD_ID VARCHAR2 256          
SUBLEDGER_FACT_LINKAGE_ID VARCHAR2 256     Subledger Fact Linkage Identifier    
MC_FLAG VARCHAR2 16     Flag to indicate the source of data is MC or Regular dataset    
ASSET_NUMBER VARCHAR2 32     User-defined asset identification number.    
ASSET_DESCRIPTION VARCHAR2 128     Asset description    
PARENT_ASSET_ID NUMBER 38 0   Identifier of the parent asset for the child or component asset.    
GROUP_ASSET_ID NUMBER 38 0   Identification number of the group asset.    
SOURCE_LINE_ID NUMBER 38 0   Identifier of the asset source line.    
CATEGORY_ID NUMBER 38 0   Identifier of the asset category.    
LOCATION_ID NUMBER 38 0   Location flexfield identification number.    
ASSIGNED_TO_ID NUMBER 38 0   Identifier of the employee to whom the asset is assigned.    
ASSET_KEY_CCID NUMBER 38 0   Asset Keyword identifier.    
RETIREMENT_ID NUMBER 38 0   Identifier of the asset retirement transaction.    
IMPAIRMENT_ID NUMBER 38 0   Identifier of the asset Impairment transaction.    
METHOD_ID NUMBER 38 0   Identifier of the depreciation method.    
CONVENTION_TYPE_ID NUMBER 38 0   Identifier of the prorate convention    
CASH_GENERATING_UNIT_ID NUMBER 38 0   Identifier of the cash generating unit.    
CEILING_TYPE_ID NUMBER 38 0   Identifier of the depreciation ceiling.    
TRANSACTION_TYPE_CODE VARCHAR2 32     Identifier of the asset transaction type.    
SOURCE_TYPE_CODE VARCHAR2 16     Asset transaction type of the accounting line.    
ADJUSTMENT_TYPE VARCHAR2 16     The type of account this row affects.    
TRANSACTION_DATE_ENTERED DATE       Date when the transaction occurred.    
TXN_HDR_DATE_EFFECTIVE TIMESTAMP       Date when the row became effective.    
DATE_PLACED_IN_SERVICE DATE       Date on which the asset was placed in service.    
PRORATE_DATE DATE       Date used to calculate the annual depreciation for assets.    
AMORTIZATION_START_DATE DATE       Date to start amortizing the net book value for an asset .    
CALENDAR_TYPE VARCHAR2 16     Name of the depreciation calendar.    
PERIOD_NAME VARCHAR2 16     Asset book depreciation calendar period name.    
PERIOD_COUNTER_CREATED NUMBER 38 0   Identifier of the depreciation period in which the transaction was performed.    
PERIOD_COUNTER_CAPITALIZED NUMBER 38 0   Identifier of the depreciation period in which asset is capitalized.    
PERIOD_COUNTER_FULLY_RESERVED NUMBER 38 0   Identifier of the depreciation period in which the asset was fully reserved.    
PERIOD_COUNTER_FULLY_RETIRED NUMBER 38 0   Identifier of the depreciation period in which the asset was fully retired.    
ACTIVE_ASSET_FLAG VARCHAR2 16          
ACTIVE_ASSIGNMENT_FLAG VARCHAR2 16          
ACTIVE_FINANCIAL_FLAG VARCHAR2 16          
DEPRN_OVERRIDE_FLAG VARCHAR2 16     Indicator as to whether the depreciation amount for the transaction is overridden or not.    
DEPRECIATE_FLAG VARCHAR2 16     Option indicating whether the asset is depreciating or not.    
LOW_VALUE_ASSET_FLAG VARCHAR2 16     Indicates whether this line is a low value asset.    
AMORTIZE_FLAG VARCHAR2 16          
UNITS_ASSIGNED NUMBER       Number of units assigned to the distribution.    
TRANSACTION_UNITS NUMBER       Number of units involved in the transaction. Negative value for the row from which the units were transferred away or retired. Positive value for the row to which the units were transferred to or added.    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency conversion rate.    
XLA_TRANSACTION_CURRENCY_CODE VARCHAR2 16     Entered currency for the transaction data.    
XLA_LEDGER_CURRENCY_CODE VARCHAR2 16     Functional currency of the ledger.    
XLA_TRANSACTION_AMOUNT NUMBER            
XLA_LEDGER_AMOUNT NUMBER            
XLA_ENTERED_DR_AMOUNT NUMBER       Unrounded entered debit amount for the journal line.    
XLA_ENTERED_CR_AMOUNT NUMBER       Unrounded entered credit amount for the journal line.    
XLA_ACCOUNTED_DR_AMOUNT NUMBER       Unrounded accounted debit amount of the journal entry line.    
XLA_ACCOUNTED_CR_AMOUNT NUMBER       Unrounded accounted credit amount of the journal entry line.    
XLA_GLOBAL_AMOUNT NUMBER            
XLA_GLOBAL_DR_AMOUNT NUMBER            
XLA_GLOBAL_CR_AMOUNT NUMBER            
XLA_MANUAL_OVERRIDE_FLAG VARCHAR2 32     Indicates a manual override. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO.    
SOURCE_DISTRIBUTION_TYPE VARCHAR2 32     Classification of transaction source distribution.    
ACCOUNTING_LINE_CODE VARCHAR2 32     Short name of a rule to convert transactional data into a journal entry line.    
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 16     Type of journal line rule: Debit, Credit, Gain or Loss.    
AE_LINE_NUM NUMBER 38 0   Number that is associated with each subledger journal entry line.    
ACCOUNTING_CLASS_CODE VARCHAR2 32     Short name of a lookup type that is shared across application used to classify journal entry lines.    
XLA_LINE_TRANSACTION_AMOUNT NUMBER            
XLA_LINE_ENTERED_DR_AMOUNT NUMBER            
XLA_LINE_ENTERED_CR_AMOUNT NUMBER            
XLA_LINE_LEDGER_AMOUNT NUMBER            
XLA_LINE_ACCOUNTED_DR_AMOUNT NUMBER            
XLA_LINE_ACCOUNTED_CR_AMOUNT NUMBER            
XLA_LINE_GLOBAL_AMOUNT NUMBER            
XLA_LINE_GLOBAL_DR_AMOUNT NUMBER            
XLA_LINE_GLOBAL_CR_AMOUNT NUMBER            
XLA_EVENT_ID NUMBER 38 0   Identifier of the categorization of accounting events that is unique within an application and event class.    
XLA_EVENT_CLASS_CODE VARCHAR2 32     Unique abbreviated name assigned to an event class and used for reporting or in reference to an option.    
XLA_EVENT_TYPE_CODE VARCHAR2 32     Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.    
XLA_ACCOUNTING_DATE DATE       Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions.    
XLA_LEDGER_ID NUMBER 38 0   Identifier of a self-contained accounting information set for single or multiple legal or management entities.    
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name.    
FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type.    
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
GL_CODE_COMBINATION_ID NUMBER 38 0   GL account identifier.    
COST_CENTER_SEGMENT VARCHAR2 32     Cost center segment.    
COST_CENTER_VALUESET_CODE VARCHAR2 64     Cost center value set code.    
GL_BALANCING_SEGMENT VARCHAR2 32     Balancing segment.    
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64     Balancing segment value set code.    
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32     Natural account segment.    
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64     Natural account value set code.    
GL_SEGMENT1 VARCHAR2 32     Accounting segment 1.    
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64     Accounting segment 1 value set code.    
GL_SEGMENT2 VARCHAR2 32     Accounting segment 2.    
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64     Accounting segment 2 value set code.    
GL_SEGMENT3 VARCHAR2 32     Accounting segment 3.    
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64     Accounting segment 3 value set code.    
GL_SEGMENT4 VARCHAR2 32     Accounting segment 4.    
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64     Accounting segment 4 value set code.    
GL_SEGMENT5 VARCHAR2 32     Accounting segment 5.    
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64     Accounting segment 5 value set code.    
GL_SEGMENT6 VARCHAR2 32     Accounting segment 6.    
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64     Accounting segment 6 value set code.    
GL_SEGMENT7 VARCHAR2 32     Accounting segment 7.    
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64     Accounting segment 7 value set code.    
GL_SEGMENT8 VARCHAR2 32     Accounting segment 8.    
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64     Accounting segment 8 value set code.    
GL_SEGMENT9 VARCHAR2 32     Accounting segment 9.    
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64     Accounting segment 9 value set code.    
GL_SEGMENT10 VARCHAR2 32     Accounting segment 10.    
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 10 value set code.    
TRANSACTION_SUBTYPE VARCHAR2 64     Further detail of transaction type.    
FISCAL_PERIOD_NAME VARCHAR2 64     Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
TRANSACTION_PERIOD_NAME VARCHAR2 64     Asset transaction calendar period name.    
IS_TRX_FLAG VARCHAR2 16     Flag to indicate the source of data is transactions or Depreciation dataset