---
title: "Calendar"
slug: "calendar-view"
description: "Snowflake data share view: fiscal calendar mapping dates to fiscal periods, quarters, weeks, and years per legal entity."
updated: 2026-04-29T00:02:56Z
published: 2026-04-29T00:02:56Z
canonical: "docs.restaurant365.com/calendar-view"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Calendar

The Calendar view is the fiscal calendar configuration dataset for R365. It contains date mappings that align calendar dates to each legal entity's fiscal periods, quarters, weeks, and years.

## Calendar Columns

| Column Name | Data Type | Description |
| --- | --- | --- |
| tenant_id | integer | Customer's account identifier within the R365 platform. |
| legal_entity_id | UUID | Unique identifier for the legal entity whose fiscal calendar this record belongs to. |
| calendar_type | integer | The type of fiscal calendar used by this legal entity (e.g., Monthly, 4-4-5 Weekly, Period-based). |
| date | date | Calendar date for this fiscal calendar record. |
| fiscal_period | integer | The fiscal period number within the fiscal year to which this date belongs. |
| fiscal_year | integer | The fiscal year to which this date belongs. |
| fiscal_quarter | integer | The fiscal quarter number (1–4) within the fiscal year to which this date belongs. |
| fiscal_week | integer | The fiscal week number within the fiscal year to which this date belongs. |
| day_number_of_the_week | integer | The number of the day within the week (e.g., 1–7 representing the day of the week) for this calendar date. |