This is the Dimension table for Fixed asset Calendar Periods details
Module: Assets
CALENDAR_TYPE, PERIOD_NAME
| 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 | This column is for Oracle Internal use only. 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 | |||
| CREATION_DATE | TIMESTAMP | Creation Date |
Copyright © 2019, 2024, Oracle and/or its affiliates.