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. |