DW_FA_BOOK_CONTROLS_D

This is the Dimension table for Fixed asset Book Control details

Details

Module: Assets

Key Columns

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.    
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.    
LEDGER_ID NUMBER 38 0   Identifier of the accounting ledger.    
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.    

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