Fiscal calendar definitions for each legal entity, with one row per calendar date per legal entity.
Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions.
Column reference
Column | Type | Description |
|---|---|---|
tenant_id | NUMBER(38,0) | Customer's account identifier within the R365 platform. |
id | VARCHAR | Unique identifier for the calendar record. |
name | VARCHAR | Name for the calendar record. |
calendar_day | NUMBER(38,0) | Day of the month (1 to 31) for the date. Blank on current calendars; filled only for dates from 2006 to 2017. |
calendar_month | NUMBER(38,0) | Month number (1 to 12) for the date. Blank on current calendars; filled only for dates from 2006 to 2017. |
calendar_year | VARCHAR | Calendar year of the date, as text (for example 2012). Blank on current calendars; filled only for dates from 2006 to 2017. |
combined_reporting_day | NUMBER(38,0) | Fiscal day number (1 to 371) of this date in the company's main reporting calendar, so legal entities with different calendars can be reported together. Filled only for dates from 2006 to 2017. |
combined_reporting_day_year | VARCHAR | The combined reporting day and year as text in the form 'day,year' (for example 99,2017). Filled only for dates from 2006 to 2017. |
combined_reporting_period | NUMBER(38,0) | Fiscal period number of this date in the company's main reporting calendar. Filled only for dates from 2006 to 2017. |
combined_reporting_period_name | VARCHAR | The name of the fiscal period in the company's primary reporting calendar for this date, so periods from different legal entities can be lined up. It is only filled for dates from 2006 to 2017 and is blank for later dates. |
combined_reporting_period_year | VARCHAR | The combined reporting period and year as text in the form 'period,year'. Filled only for dates from 2006 to 2017. |
combined_reporting_quarter | NUMBER(38,0) | Fiscal quarter number of this date in the company's main reporting calendar. Filled only for dates from 2006 to 2017. |
combined_reporting_quarter_year | VARCHAR | The combined reporting quarter and year as text in the form 'quarter,year'. Filled only for dates from 2006 to 2017. |
combined_reporting_week | NUMBER(38,0) | Fiscal week number of this date in the company's main reporting calendar. Filled only for dates from 2006 to 2017. |
combined_reporting_week_year | VARCHAR | The combined reporting week and year as text in the form 'week,year'. Filled only for dates from 2006 to 2017. |
combined_reporting_year1 | VARCHAR | Fiscal year of this date in the company's main reporting calendar. Filled only for dates from 2006 to 2017. |
date | DATE | Calendar date for this fiscal calendar record. |
date_text | VARCHAR | The date as text in MM/DD/YYYY format. |
day_name | NUMBER(38,0) | The number of the day within the week, from 1 to 7, for this calendar date. |
days_back | NUMBER(38,0) | Number of days between this date and yesterday as of the last nightly refresh. 0 is yesterday, 1 is the day before. 999999 means the date is today or later; blank means not yet calculated. |
fiscal_date_type | NUMBER(38,0) | The type of fiscal calendar used by this legal entity (such as Monthly, 4-4-5 Weekly, or Period-based). |
fiscal_day | NUMBER(38,0) | Day number within the fiscal year, starting at 1. |
fiscal_day_and_year | VARCHAR | Fiscal day number and fiscal year as text in the form 'day,year' (for example 149,2022). |
fiscal_period | NUMBER(38,0) | The fiscal period number within the fiscal year to which this date belongs. |
fiscal_period_and_year | VARCHAR | Fiscal period number and fiscal year as text in the form 'period,year' (for example 3,2026). |
fiscal_quarter | NUMBER(38,0) | The fiscal quarter number (1-4) within the fiscal year to which this date belongs. |
fiscal_quarter_and_year | VARCHAR | Fiscal quarter number and fiscal year as text in the form 'quarter,year' (for example 4,2026). |
fiscal_week | NUMBER(38,0) | The fiscal week number within the fiscal year to which this date belongs. |
fiscal_week_and_year | VARCHAR | Fiscal week number and fiscal year as text in the form 'week,year' (for example 17,2025). |
fiscal_year1 | VARCHAR | The fiscal year to which this date belongs. |
period_name | VARCHAR | Name for the period. |
periods_back | NUMBER(38,0) | Number of fiscal periods between this date's period and the period containing yesterday, as of the last nightly refresh. 0 is the current period. 999999 means the date is today or later. |
quarters_back | NUMBER(38,0) | Number of fiscal quarters between this date's quarter and the quarter containing yesterday, as of the last nightly refresh. 0 is the current quarter. 999999 means the date is today or later. |
week_name | VARCHAR | Name for the week. |
weeks_back | NUMBER(38,0) | Number of fiscal weeks between this date's week and the week containing yesterday, as of the last nightly refresh. 0 is the current week. 999999 means the date is today or later. |
years_back | NUMBER(38,0) | Number of fiscal years between this date's fiscal year and the fiscal year containing yesterday, as of the last nightly refresh. 0 is the current fiscal year. 999999 means the date is today or later. |
legal_entity_id | VARCHAR | Unique identifier for the legal entity whose fiscal calendar this record belongs to. |
created_on | TIMESTAMP_NTZ | Timestamp when the record was created. |
created_by_id | VARCHAR | Identifier for the user who created the record. |
modified_on | TIMESTAMP_NTZ | Timestamp when the record was last modified. |
modified_by_id | VARCHAR | Identifier for the user who last modified the record. |
is_deleted | BOOLEAN | Flag indicating whether the record is currently deleted. Derived from the latest event for the entity. |