DW_FA_MC_ASSET_FINANCIALS_CF

This is the Fact table for Fixed asset Financial details

Details

Module: Assets

Key Columns

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

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.
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.
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.
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
ACTIVE_ASSIGNMENT_FLAG VARCHAR2 16 Active assignment flag for an asset based on its DATE_INEFFECTIVE in FA_DISTRIBUTION_HISTORY