This is the Fact table for Fixed asset Financial details
Module: Assets
PERIOD_COUNTER, LEDGER_ID, DISTRIBUTION_ID, PERIOD_NAME, PERIOD_NUM, CALENDAR_TYPE, ASSET_ID, FISCAL_YEAR, BOOK_TYPE_CODE
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. | ||
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 | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Fixed Asset book identifier. | ||||
MC_FLAG | VARCHAR2 | 16 | Flag to indicate the source of data is MC or Regular dataset | ||||
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. | |||
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. | |||||
BO_CURRENT_COST | NUMBER | Total recorded cost of the asset from Books | |||||
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. | |||||
BACKLOG_DEPRN_RESERVE | NUMBER | Life-to-date backlog depreciation amount. | |||||
YTD_BACKLOG_DEPRN | NUMBER | Year-to-date backlog depreciation amount. | |||||
REVAL_AMORT_BALANCE | NUMBER | Accumulated revaluation amortization. | |||||
REVAL_AMORTIZATION_ADJUSTMENT | NUMBER | Revaluation reserve amortization amount calculated for the period by the adjustment transaction. | |||||
YTD_REVAL_AMORTIZATION | NUMBER | Year-to-date revaluation reserve amortization amount. | |||||
GLOBAL_CURRENT_COST | NUMBER | ||||||
GLOBAL_BO_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 | ||||||
GLOBAL_BACKLOG_DEPRN_RESERVE | NUMBER | ||||||
GLOBAL_YTD_BACKLOG_DEPRN | NUMBER | ||||||
GLOBAL_REVAL_AMORT_BALANCE | NUMBER | ||||||
GLOBAL_REVAL_AMORTIZATION_ADJUSTMENT | NUMBER | ||||||
GLOBAL_YTD_REVAL_AMORTIZATION | NUMBER | ||||||
DEPRN_PERIODS_CREATION_DATE | TIMESTAMP | creationDateColumnName |
Copyright © 2019, 2024, Oracle and/or its affiliates.