DW_FA_MC_BOOKS_D

This is the Dimension table for Fixed asset books details

Details

Module: Assets

Key Columns

ASSET_ID, TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE, LEDGER_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    
SOURCE_RECORD_ID VARCHAR2 64     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    
MC_FLAG VARCHAR2 16     Flag to indicate the source of data is MC or Regular dataset