DW_FA_DEPRN_PERIODS_D

This is the Dimension table for Fixed asset depreciation period details

Details

Module: Assets

Key Columns

BOOK_TYPE_CODE, PERIOD_COUNTER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BOOK_TYPE_CODE VARCHAR2 32   True Unique book identification name.    
PERIOD_COUNTER NUMBER 38 0 True Identifier of the depreciation period.    
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier. Value is derived from a combination of BOOK_TYPE_CODE and PERIOD_COUNTER.    
PERIOD_NAME VARCHAR2 16     Asset book depreciation calendar period name.    
PERIOD_NUM NUMBER 38 0   Period number of depreciation period in the fiscal year.    
FISCAL_YEAR NUMBER 38 0   Name of the accounting fiscal year.    
PERIOD_OPEN_DATE TIMESTAMP       System date when the depreciation period is opened.    
PERIOD_CLOSE_DATE TIMESTAMP       System date when the depreciation period was closed.    
CALENDAR_PERIOD_OPEN_DATE DATE       Start date of the calendar period.    
CALENDAR_PERIOD_CLOSE_DATE DATE       End date of the calendar period.    
DEPRN_RUN_FLAG VARCHAR2 16     Indicator used to determine whether depreciation has been run for a period.