1. Tables and Views for Financials
  2. FA_DEPRN_EXTRACT

FA_DEPRN_EXTRACT

FA_DEPRN_EXTRACT contains a denormalized and flattened representation of fixed assets and their depreciation accounting. The contents are available for simplied reporting, in particular for OTBI real time subject areas.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FA_DEPRN_EXTRACT_PK

DEPRN_EXTRACT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DEPRN_EXTRACT_ID NUMBER 18 Yes Unique sequence generated identifier for the row in the depreciation extract. Active
BOOK_TYPE_CODE VARCHAR2 30 Unique book identification name.
PERIOD_COUNTER NUMBER 18 Identifier of the depreciation period.
PERIOD_NAME VARCHAR2 15 Name of the period for which data is extracted.
SOURCE_TABLE VARCHAR2 30 Indicates the table from which each row was extracted.
SOURCE_DISTRIBUTION_TYPE VARCHAR2 30 Indicates the whether the row was extracted for a transaction or periodic depreciation row.
LEDGER_ID NUMBER 18 Ledger unique identifier.
LEDGER_SET_ID NUMBER 18 Ledget set identifer. Foreign key to GL_LEDGERS.
CURRENCY_CODE VARCHAR2 15 Identifies the currency of the extracted line.
ASSET_ID NUMBER 18 Identifier of the asset number.
ASSET_TYPE VARCHAR2 30 Type of the asset allowed in the Oracle Fusion Assets. The asset types allowed are Capitalized, Construction-in-Process (CIP), Expensed, and Group.
CATEGORY_ID NUMBER 18 Asset category identifier
CATEGORY_BOOK_DEFAULT_ID NUMBER 18 Identifier of the default depreciation rules for the category in the book.
UNITS_ASSIGNED NUMBER Number of units assigned to the distribution.
TOTAL_UNITS NUMBER Total number of units assigned to the asset.
UNIT_RATIO NUMBER Ratio of the units to total units.
DISTRIBUTION_ID NUMBER 18 Identifier of the asset distribution.
CODE_COMBINATION_ID NUMBER 18 Depreciation expense account identifier.
LOCATION_ID NUMBER 18 Location flexfield identification number.
EMPLOYEE_ID NUMBER 18 Identifier of the employee to whom the asset is assigned.
TRANSACTION_HEADER_ID NUMBER 18 Identifier of the asset distribution.
BOOKS_TRANSACTION_HEADER_ID NUMBER 18 Identifier of the associated row in FA_BOOKS for this extracted line.
GROUP_ASSET_ID NUMBER 18 Identifier of the group asset number.
METHOD_ID NUMBER 18 Identifier of the depreciation method.
FLAT_RATE_ID NUMBER 18 Identifier of the rates for the flat rate depreciation method.
BONUS_RULE_ID NUMBER 18 Identifier of the bonus depreciation rule.
CEILING_TYPE_ID NUMBER 18 Identifier of the depreciation ceiling.
CONVENTION_TYPE_ID NUMBER 18 Identifier of the prorate convention.
DEPRN_RUN_ID NUMBER 18 Identifier of the depreciation submission.
DEPRN_RUN_DATE DATE System date when depreciation was run.
DEPRN_SOURCE_CODE VARCHAR2 1 The source from where the depreciation record was created. Possible values are B(BOOKS), D(DEPRN), and T(TRACK).
COST NUMBER Prorated cost of the asset for this row.
DEPRN_AMOUNT NUMBER Prorated depreciation amount of the asset for this row.
YTD_DEPRN NUMBER Prorated YTD depreciation of the asset for this row.
DEPRN_RESERVE NUMBER Prorated historical accumulated depreciation of the asset for this row.
TOTAL_DEPRN_RESERVE NUMBER Prorated accumulated depreciation of the asset for this row.
DEPRN_ADJUSTMENT_AMOUNT NUMBER Prorated catch-up depreciation amount of the asset for this row.
BONUS_DEPRN_AMOUNT NUMBER Prorated bonus depreciation amount of the asset for this row.
BONUS_YTD_DEPRN NUMBER Prorated YTD bonus depreciation of the asset for this row.
BONUS_DEPRN_RESERVE NUMBER Prorated historical bonus accumulated depreciation of the asset for this row.
TOTAL_BONUS_DEPRN_RESERVE NUMBER Prorated accumulated bonus depreciation of the asset for this row.
BONUS_DEPRN_ADJUSTMENT_AMOUNT NUMBER Prorated catch-up bonus depreciation amount of the asset for this row.
ACCELERATED_DEPRN_AMOUNT NUMBER Prorated accelerated bonus depreciation amount of the asset for this row.
ACCELERATED_YTD_DEPRN NUMBER Prorated YTD accelerated bonus depreciation of the asset for this row.
ACCELERATED_DEPRN_RESERVE NUMBER Prorated historical accelerated bonus accumulated depreciation of the asset for this row.
TOTAL_ACC_DEPRN_RESERVE NUMBER Prorated accelerated accumulated bonus depreciation of the asset for this row.
ACC_DEPRN_ADJUSTMENT_AMOUNT NUMBER Prorated catch-up accelerated bonus depreciation amount of the asset for this row.
IMPAIRMENT_AMOUNT NUMBER Prorated impairment amount of the asset for this row.
YTD_IMPAIRMENT NUMBER Prorated YTD impairment amount of the asset for this row.
IMPAIRMENT_RESERVE NUMBER Prorated historical accumulated impairment amount of the asset for this row.
REVAL_AMORTIZATION NUMBER Prorated amortized revaluation amount of the asset for this row.
REVAL_DEPRN_EXPENSE NUMBER Prorated revaluation expense amount of the asset for this row.
REVAL_RESERVE NUMBER Prorated accumulated revaluation amount of the asset for this row.
YTD_REVAL_DEPRN_EXPENSE NUMBER Prorated YTD revaluation expense amount of the asset for this row.
PRODUCTION NUMBER Prorated periodic production amount of the asset for this row.
YTD_PRODUCTION NUMBER Prorated YTD production amount of the asset for this row.
LTD_PRODUCTION NUMBER Prorated accumulated production amount of the asset for this row.
ADJUSTED_COST NUMBER Prorated adjusted cost of the asset for this row.
BONUS_ADJUSTED_COST NUMBER Prorated bonus adjusted cost of the asset for this row.
ACCELERATED_ADJUSTED_COST NUMBER Prorated accelerated bonus cost of the asset for this row.
NET_BOOK_VALUE NUMBER Prorated net book value of the asset for this row.
ORIGINAL_COST NUMBER Prorated original cost of the asset for this row.
RECOVERABLE_COST NUMBER Prorated recoverable cost of the asset for this row.
SALVAGE_VALUE NUMBER Prorated salvage value of the asset for this row.
YTD_LATEST_FLAG VARCHAR2 1 YTD_LATEST_FLAG
LATEST_FLAG VARCHAR2 1 LATEST_FLAG
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CAPITAL_ADJUSTMENT NUMBER Value of capital adjustment after considering impairment transaction.
GENERAL_FUND NUMBER Value of general fund after considering impairment effect.
AH_TRANSACTION_HEADER_ID NUMBER 18 Identifier of the associated row in FA_ASSET_HISTORY for this extracted line.
TOTAL_IMPAIRMENT_RESERVE NUMBER Prorated accumulated impairment amount of the asset for this row.

Indexes

Index Uniqueness Tablespace Columns Status
FA_DEPRN_EXTRACT_U1 Unique FUSION_TS_TX_IDX DEPRN_EXTRACT_ID Active
FA_DEPRN_EXTRACT_N1 Non Unique FUSION_TS_TX_IDX BOOK_TYPE_CODE, PERIOD_NAME Active
FA_DEPRN_EXTRACT_N2 Non Unique FUSION_TS_TX_IDX BOOK_TYPE_CODE, ASSET_ID Active