DW_FA_DEPRN_DETAIL_EN

This is the Enity table for Fixed asset depreciation details

Details

Module: Assets

Key Columns

SET_OF_BOOKS_ID, DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DISTRIBUTION_ID NUMBER 38 0 True Identifier of the asset distribution.    
BOOK_TYPE_CODE VARCHAR2 128   True Unique book identification name.    
PERIOD_COUNTER NUMBER 38 0 True Identifier of the depreciation period.    
SET_OF_BOOKS_ID NUMBER 38 0 True Identifier of the accounting ledger    
SOURCE_RECORD_ID VARCHAR2 256     Source record identifier. Value is derived from a combination of DISTRIBUTION_ID,BOOK_TYPE_CODE and PERIOD_COUNTER.    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 256     Subledger Linkage Distribution Entity Identifier    
DEPRN_RESERVE NUMBER       Total depreciation expense including the bonus depreciation recognized for the asset.    
IMPAIRMENT_RESERVE NUMBER       Total impairment loss recognized for the asset.    
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.    
CURRENT_COST NUMBER       Total recorded cost of the asset.    
YTD_DEPRN NUMBER       Year-to-date depreciation expense.    
DEPRN_AMOUNT NUMBER       Asset depreciation expense amount.    
YTD_IMPAIRMENT NUMBER       Year-to-date impairment amount.    
COST NUMBER       Total recorded cost of the asset.    
ASSET_ID NUMBER 38 0   Identifier of the asset number.    
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.    
DEPRN_SOURCE_CODE VARCHAR2 16     Source from where the depreciation record was created. Possible values are BOOKS, DEPRN, and TRACK.    
DEPRN_RUN_ID NUMBER 38 0   Identifier of the depreciation submission.    
MC_FLAG VARCHAR2 16     Flag to indicate the source of data is MC or Regular dataset    
H_ASSET_NUMBER VARCHAR2 32     User-defined asset identification number.    
H_ASSET_KEY_CCID NUMBER 38 0   Identifier of the asset key flexfield combination.    
H_ASSET_CATEGORY_ID NUMBER 38 0   Identifier of the asset category.    
H_DESCRIPTION VARCHAR2 128     Asset description    
H_ASSET_TYPE VARCHAR2 16     Type of the asset allowed in the Oracle Fusion Assets. The asset types allowed are Capitalized, Construction-in-Process, Expensed, and Group.    
H_TAG_NUMBER VARCHAR2 16     Unique user-defined tracking number for an asset.    
H_SERIAL_NUMBER VARCHAR2 64     Serial number assigned to the asset.    
H_IN_USE_FLAG VARCHAR2 16     Indicator used to determine whether the asset is in use.    
H_OWNED_LEASED VARCHAR2 16     Indicates whether asset is owned or leased.    
H_COMMITMENT VARCHAR2 32     Financial liability or commitment assigned to the asset.    
H_PARENT_ASSET_ID NUMBER 38 0   Identifier of the parent asset for the child or component asset.    
H_INVENTORIAL VARCHAR2 16     Indicates whether the asset should be included in physical inventory.    
H_PROPERTY_1245_1250_CODE VARCHAR2 16     Indicates whether the asset belongs to the 1245 property class or 1250 property class.    
H_PROPERTY_TYPE_CODE VARCHAR2 32     Option indicating whether the asset is considered personal, real, or residential property.    
H_INTANGIBLE_ASSET_FLAG VARCHAR2 16     Indicates whether the asset is an intangible asset.    
H_MANUFACTURER_NAME VARCHAR2 512     Name of the manufacturer of the asset.    
H_MODEL_NUMBER VARCHAR2 64     Model number assigned to the asset.    
H_NEW_USED VARCHAR2 16     Option indicating whether asset is new or used.    
H_INVESTMENT_LAW VARCHAR2 32     Benefit incentives applied to the asset.    
H_CURRENT_UNITS NUMBER       Current number of units for an asset.