# DW_FA_MC_BOOKS_D

This is the Dimension table for Fixed asset books details

## Details

Module: Assets

## Key Columns

MC_FLAG, TRANSACTION_HEADER_ID_IN, ASSET_ID, LEDGER_ID, BOOK_TYPE_CODE

## 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 |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.