This is the Dimension table for Fixed asset Calendar Periods details
Module: Assets
PERIOD_NAME, CALENDAR_TYPE
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 |