DW_FA_MC_BOOK_CONTROLS_D

This is the Dimension table for Fixed asset Book Control details

Details

Module: Assets

Key Columns

LEDGER_ID, MC_FLAG, 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.