DW_FA_ASSET_FINANCIALS_CF

This is the Fact table for Fixed asset Financial details

Details

Module: Assets

Key Columns

ASSET_ID, PERIOD_COUNTER, FISCAL_YEAR, BOOK_TYPE_CODE, PERIOD_NUM, DISTRIBUTION_ID, CALENDAR_TYPE, PERIOD_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BOOK_TYPE_CODE VARCHAR2 32   True Unique book identification name.    
ASSET_ID NUMBER 38 0 True Identifier of the asset number.    
DISTRIBUTION_ID NUMBER 38 0 True Identifier of the asset distribution.    
CALENDAR_TYPE VARCHAR2 16   True Name of the depreciation calendar.    
PERIOD_COUNTER NUMBER 38 0 True Identifier of the depreciation period.    
PERIOD_NAME VARCHAR2 16   True Asset book depreciation calendar period name.    
PERIOD_NUM NUMBER 38 0 True Period number of depreciation period in the fiscal year.    
FISCAL_YEAR NUMBER 38 0 True Name of the accounting fiscal year.    
SOURCE_RECORD_ID VARCHAR2 256     Source record identifier. Value is derived from a combination of Fixed Asset book identifier.    
BO_TRANSACTION_HEADER_ID_IN NUMBER 38 0   Identifier of the transaction that created the row.    
BO_TRANSACTION_HEADER_ID_OUT NUMBER 38 0   Identifier of the transaction that terminated the row.    
DH_TRANSACTION_HEADER_ID_IN NUMBER 38 0   Identifier of the transaction that created the row.    
DH_TRANSACTION_HEADER_ID_OUT NUMBER 38 0   Identifier of the transaction that terminated the row.    
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.    
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   Identifier of the asset key flexfield combination.    
LEDGER_ID NUMBER 38 0   Identifier of the accounting ledger    
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
DEPRN_EXPENSE_CCID NUMBER 38 0   Identifier of the account code combination for the depreciation expense account.    
CONVENTION_TYPE_ID NUMBER 38 0   Identifier of the prorate convention    
METHOD_ID NUMBER 38 0   Identifier of the depreciation method.    
CASH_GENERATING_UNIT_ID NUMBER 38 0   Identifier of the cash generating unit.    
CEILING_TYPE_ID NUMBER 38 0   Identifier of the depreciation ceiling.    
DATE_PLACED_IN_SERVICE DATE       Date on which the asset was placed in service.    
BO_DATE_EFFECTIVE TIMESTAMP       Date when the row became effective.    
BO_DATE_INEFFECTIVE TIMESTAMP       Date when the row became inactive.    
PRORATE_DATE DATE       Date used to calculate the annual depreciation for assets.    
INVENTORY_DATE_TAKEN DATE       User-defined inventory taken date.    
LIFE_IN_MONTHS NUMBER 38 0   Life in months for the investment tax credit.    
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.    
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.    
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.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Functional currency of the ledger.    
CURRENT_COST NUMBER       Total recorded cost of the asset.    
DEPRN_RESERVE NUMBER       Total depreciation expense including the bonus depreciation recognized for the asset.    
YTD_DEPRN NUMBER       Year-to-date depreciation expense.    
DEPRN_AMOUNT NUMBER       Asset depreciation expense amount.    
NET_BOOK_VALUE NUMBER            
IMPAIRMENT_RESERVE NUMBER       Total impairment loss recognized for the asset.    
YTD_IMPAIRMENT NUMBER       Year-to-date impairment amount.    
REVAL_RESERVE NUMBER       Change in net book value due to revaluation of asset cost and sometimes also revaluation of depreciation reserve for revaluation period. For all other periods, the revaluation reserve amount after depreciation run.    
ACC_DEPRN_ADJUSTMENT_AMOUNT NUMBER       The adjustment amount calculated for retroactive adjustments included in the accelerated depreciation for the period.    
ACCELERATED_DEPRN_AMOUNT NUMBER       The accelerated depreciation amount calculated for the period.    
ACCELERATED_DEPRN_RESERVE NUMBER       The accelerated depreciation reserve balance for the period.    
ACCELERATED_YTD_DEPRN NUMBER       The accelerated depreciation YTD balance for the period.    
ADDITION_COST_TO_CLEAR NUMBER       Asset cost in row for period before period you added the asset.    
BONUS_DEPRN_ADJUSTMENT_AMOUNT NUMBER       Bonus depreciation adjustment amount.    
BONUS_DEPRN_AMOUNT NUMBER       Bonus depreciation expense. Amount included in DEPRN_AMOUNT.    
BONUS_DEPRN_RESERVE NUMBER       Total bonus depreciation taken since the beginning of the asset life. Amount included in DEPRN_RESERVE.    
BONUS_YTD_DEPRN NUMBER       Bonus depreciation expense. Amount included in DEPRN_AMOUNT.    
CAPITAL_ADJUSTMENT NUMBER       Value of capital adjustment after considering impairment transaction.    
DEPRN_ADJUSTMENT_AMOUNT NUMBER       Depreciation expense adjustment amount for the period.    
GENERAL_FUND NUMBER       Value of general fund after considering impairment effect.    
IMPAIRMENT_AMOUNT NUMBER       Impairment loss amount of the asset.    
REVAL_AMORTIZATION NUMBER       Amount of revaluation reserve amortized during this period.    
REVAL_DEPRN_EXPENSE NUMBER       Portion of depreciation expense generated due to revaluation of the asset cost. Oracle Fusion Assets does not create any journal entries for this amount. It is for reporting only.    
YTD_REVAL_DEPRN_EXPENSE NUMBER       Year-to-date depreciation expense due to revaluation. Oracle Fusion Assets does not create any journal entries for this amount. It is for reporting only.    
ORIGINAL_COST NUMBER       Original cost of the asset at the time of its addition.    
SALVAGE_VALUE NUMBER       Salvage value amount for the asset.    
RECOVERABLE_COST NUMBER       Cost minus salvage value, or depreciation ceiling, whichever is lower.    
ADJUSTED_RECOVERABLE_COST NUMBER       Adjusted recoverable cost with special depreciation limits taken into account.    
GLOBAL_CURRENT_COST NUMBER            
GLOBAL_DEPRN_RESERVE NUMBER            
GLOBAL_YTD_DEPRN NUMBER            
GLOBAL_DEPRN_AMOUNT NUMBER            
GLOBAL_NET_BOOK_VALUE NUMBER            
GLOBAL_IMPAIRMENT_RESERVE NUMBER            
GLOBAL_YTD_IMPAIRMENT NUMBER            
GLOBAL_REVAL_RESERVE NUMBER            
GLOBAL_ACC_DEPRN_ADJUSTMENT_AMOUNT NUMBER            
GLOBAL_ACCELERATED_DEPRN_AMOUNT NUMBER            
GLOBAL_ACCELERATED_DEPRN_RESERVE NUMBER            
GLOBAL_ACCELERATED_YTD_DEPRN NUMBER            
GLOBAL_ADDITION_COST_TO_CLEAR NUMBER            
GLOBAL_BONUS_DEPRN_ADJUSTMENT_AMOUNT NUMBER            
GLOBAL_BONUS_DEPRN_AMOUNT NUMBER            
GLOBAL_BONUS_DEPRN_RESERVE NUMBER            
GLOBAL_BONUS_YTD_DEPRN NUMBER            
GLOBAL_CAPITAL_ADJUSTMENT NUMBER            
GLOBAL_DEPRN_ADJUSTMENT_AMOUNT NUMBER            
GLOBAL_GENERAL_FUND NUMBER            
GLOBAL_IMPAIRMENT_AMOUNT NUMBER            
GLOBAL_REVAL_AMORTIZATION NUMBER            
GLOBAL_REVAL_DEPRN_EXPENSE NUMBER            
GLOBAL_YTD_REVAL_DEPRN_EXPENSE NUMBER            
GLOBAL_ORIGINAL_COST NUMBER            
GLOBAL_SALVAGE_VALUE NUMBER            
GLOBAL_RECOVERABLE_COST NUMBER            
GLOBAL_ADJUSTED_RECOVERABLE_COST NUMBER            

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