DW_FA_MC_BOOK_CONTROLS_D

This is the Dimension table for Fixed asset Book Control details

Details

Module: Assets

Key Columns

LEDGER_ID, BOOK_TYPE_CODE, MC_FLAG

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