This is the Enity table for Fixed asset depreciation details
Module: Assets
SET_OF_BOOKS_ID, DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER
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. |