DW_FA_MC_BOOKS_D

This is the Dimension table for Fixed asset books details

Details

Module: Assets

Key Columns

TRANSACTION_HEADER_ID_IN, LEDGER_ID, BOOK_TYPE_CODE, MC_FLAG, ASSET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BOOK_TYPE_CODE VARCHAR2 32 True Unique book identification name.
ASSET_ID NUMBER 38 0 True Identifier of the asset number.
TRANSACTION_HEADER_ID_IN NUMBER 38 0 True Identifier of the transaction that created the row.
LEDGER_ID NUMBER 38 0 True Identifier of the accounting ledger
MC_FLAG VARCHAR2 16 True Flag to indicate the source of data is MC or Regular dataset
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Fixed Asset book identifier.
TRANSACTION_HEADER_ID_OUT NUMBER 38 0 Identifier of the transaction that terminated the row.
DATE_EFFECTIVE TIMESTAMP Date when the row became effective.
DATE_INEFFECTIVE TIMESTAMP Date when the row became inactive.
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.
DATE_PLACED_IN_SERVICE DATE Date on which the asset was placed in service.
PRORATE_DATE DATE Date used to calculate the annual depreciation for assets.
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.
CASH_GENERATING_UNIT_ID NUMBER 38 0 Identifier of the cash generating unit.
CEILING_TYPE_ID NUMBER 38 0 Identifier of the depreciation ceiling.
GROUP_ASSET_ID NUMBER 38 0 Identification number of the group asset.
CONVENTION_TYPE_ID NUMBER 38 0 Identifier of the prorate convention
METHOD_ID NUMBER 38 0 Identifier of the depreciation method.
COST NUMBER Total recorded cost of the asset.
ORIGINAL_COST NUMBER Original cost of the asset at the time of its addition.
RECOVERABLE_COST NUMBER Cost minus salvage value, or depreciation ceiling, whichever is lower.
SALVAGE_VALUE NUMBER Salvage value amount for the asset.
ADJUSTED_RECOVERABLE_COST NUMBER Adjusted recoverable cost with special depreciation limits taken into account.
LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency of the ledger
CREATION_DATE TIMESTAMP Creation Date