DW_FA_CALENDAR_PERIODS_D

This is the Dimension table for Fixed asset Calendar Periods details

Details

Module: Assets

Key Columns

PERIOD_NAME, CALENDAR_TYPE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CALENDAR_TYPE VARCHAR2 16   True Name of the asset depreciation calendar.    
PERIOD_NAME VARCHAR2 16   True Asset book depreciation calendar period name.    
SOURCE_RECORD_ID VARCHAR2 32     Source record identifier. Value is derived from a combination of Calender Type and Period Name.    
DESCRIPTION VARCHAR2 64     Description of the depreciation calendar.    
PERIOD_SUFFIX_TYPE VARCHAR2 64     Indicates whether the fiscal year or calendar year is used as the default when generating the calendar period name.    
NUMBER_PER_FISCAL_YEAR NUMBER 38 0   Number of accounting periods for the fiscal year.    
PERIOD_NUM NUMBER 38 0   Period number of depreciation period in the fiscal year.    
PERIOD_START_DATE DATE       Start date of the calendar period.    
PERIOD_END_DATE DATE       Ending date of the calendar period.    
FISCAL_YEAR_NAME VARCHAR2 32     Fiscal year identification name.    
FISCAL_YEAR NUMBER 38 0   Name of the accounting fiscal year.    
FY_START_DATE DATE       Starting date of the fiscal year.    
FY_END_DATE DATE       Ending date of the fiscal year.    
MID_YEAR_DATE DATE       Starting date of the second half of the fiscal year.    
TRAILING_PERIOD_NUMBER NUMBER 38 0   Indicates the trailing period number    
TRAILING_YEAR_NUMBER NUMBER 38 0   Indicates the trailing year number    

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