This table contains year-level information of fiscal calendars.
Module:
FISCAL_PERIOD_SET_NAME, FISCAL_PERIOD_TYPE, FISCAL_YEAR_NUMBER
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | True | Accounting calendar name. | |||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | True | Accounting period type. | |||
FISCAL_YEAR_NUMBER | NUMBER | 38 | 0 | True | Fiscal Year in YYYY format. | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Source record identifier of a fiscal year. | ||||
FISCAL_YEAR_START_DATE | DATE | Start date of the fiscal year. | |||||
FISCAL_YEAR_START_DATE_ID | NUMBER | 38 | 0 | First day of fiscal year in YYYYMMDD format. | |||
FISCAL_YEAR_END_DATE | DATE | End date of the fiscal year. | |||||
FISCAL_YEAR_END_DATE_ID | NUMBER | 38 | 0 | Last day of fiscal year in YYYYMMDD format. | |||
FISCAL_YEAR_TOTAL_WEEKS | NUMBER | 38 | 0 | Number of weeks in this fiscal year. | |||
FISCAL_YEAR_TOTAL_DAYS | NUMBER | 38 | 0 | Number of days in this fiscal year. | |||
CURRENT_FISCAL_YEAR_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current fiscal year. Possible value is Current. | ||||
FISCAL_TRAILING_YEAR_NUMBER | NUMBER | 38 | 0 | Indicates the trailing fiscal year number | |||
YEAR_END_OR_PRV_CRNT_DATE | DATE | For current fiscal year, day before current date else fiscal year end date | |||||
NUMBER_PER_FISCAL_YEAR | NUMBER | 38 | 0 | Number of periods per fiscal year. | |||
YEAR_END_OR_PRV_CRNT_DATE_ALT | DATE | For current year,if current year start then year end date else day before current date else year end date |