# DW_FA_MC_BOOK_CONTROLS_D

This is the Dimension table for Fixed asset Book Control details

## Details

Module: Assets

## Key Columns

MC_FLAG, 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. |  |
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 Book Control identifiers. |  |
BOOK_TYPE_NAME | VARCHAR2 | 32 |  |  | General description for the asset book. |  |
BOOK_CLASS | VARCHAR2 | 16 |  |  | Type of the asset book. Possible values can be Corporate or Tax. |  |
MASS_COPY_SOURCE_BOOK | VARCHAR2 | 32 |  |  | Associated corporate book from which transactions are to be copied. |  |
FISCAL_YEAR_NAME | VARCHAR2 | 32 |  |  | Fiscal year in which the current period of the book falls. |  |
LAST_PERIOD_COUNTER | NUMBER | 38 | 0 |  | Identifier of the last period for which depreciation process is run. |  |
CURRENT_FISCAL_YEAR | NUMBER | 38 | 0 |  | Current fiscal year for the book. |  |
DEPRN_CALENDAR | VARCHAR2 | 16 |  |  | Name of the depreciation calendar. |  |
LAST_PURGE_PERIOD_COUNTER | NUMBER | 38 | 0 |  | Identifier of the last period for which purge process is run. |  |
CURRENT_PERIOD_COUNTER | NUMBER | 38 | 0 |  | Identifier of the current period |  |
CURRENT_PERIOD | VARCHAR2 | 16 |  |  | Current period of the book |  |
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Functional currency of the ledger. |  |
NUM_PER_FISCAL_YEAR | NUMBER | 38 | 0 |  | Number of accounting periods for the fiscal year. |  |
PRIMARY_LEDGER_ID | NUMBER | 38 | 0 |  | Functional currency of the ledger |  |
PRIMARY_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Functional currency of the primary ledger |  |
GL_POSTING_ALLOWED_FLAG | VARCHAR2 | 16 |  |  | Option indicating whether the accounting entries can be posted to General Ledger |  |
BOOK_CONTROL_ID | NUMBER | 38 | 0 |  | Identifier of the asset book associated to the row. |  |

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