Calendar
Dimension table for the default calendar
DE: Kalender
Columns
| Column (EN) | Column (DE) | Type | Description |
|---|---|---|---|
| Date | Datum | dateTime | Shows the specific date for each entry in the calendar, often used to organize and filter data by day in reports or financial analysis. This is useful for tracking transactions or activities on particular dates. |
| Time BK | Time BK | dateTime | Shows the time when a transaction or entry was posted in the calendar. This helps track when business activities occurred for reporting and analysis. |
| Date | Datum (display) | string | Shows the date for each entry in the calendar table. This helps identify when specific events or records are scheduled or recorded. |
| Date | Datum (lang) | string | Shows the full date in a long format, such as "Monday, January 1, 2024." Useful for displaying detailed calendar dates in reports or schedules. |
| Date | Datum (kurz) | string | Shows the date for each entry in the calendar. Used to identify when specific events or activities are scheduled. |
| Year | Jahr | int64 | Shows the calendar year for each record, helping users organize and analyze data by year for reporting and planning purposes. Typically used to filter or group information by year in financial and business reports. |
| Half Year | Halbjahr | string | Shows which half of the year a date falls into (either the first or second half). Useful for reporting and analyzing data over six-month periods. |
| Year Half Year | Jahr-Halbjahr | string | Shows whether a date falls in the first half or second half of the year, useful for reporting and comparing business activity over different six-month periods. |
| Quarter | Quartal | string | Shows the calendar quarter (such as Q1, Q2, Q3, or Q4) for each date. This helps group and analyze financial or business activities by quarter. |
| Year Quarter | Jahr-Quartal | string | Shows the year and quarter for each calendar entry, helping to organize and analyze data by business periods such as Q1, Q2, etc. Useful for financial or operational reports that require grouping by quarter within a specific year. |
| Quarter | Quartal (lang) | string | Shows the full name of the quarter (such as "Q1", "Q2", etc.) for each date in the calendar. Useful for grouping and analyzing business data by quarter in reports and dashboards. |
| Quarter | Quartal (kurz) | string | Shows the quarter of the year (such as Q1, Q2, Q3, or Q4) for a specific date. This helps group and analyze data by business quarters for reporting and financial reviews. |
| Month | Monat | int64 | Shows the month related to a specific calendar entry. This helps identify the time period for scheduling or reporting activities. |
| Month | Monat (display) | string | Shows the name or number of the month for each entry in the calendar. Useful for grouping or filtering data by month in reports or analyses. |
| Month | Monat (lang) | string | Shows the full name of the month (like "January" or "February") for each calendar entry. Useful for organizing or grouping data by month in reports and financial analysis. |
| Month Date | Monat (Datum) | dateTime | Shows the date representing the first day of each month in the calendar. Useful for grouping or analyzing data by month in business reports. |
| Year Month | Jahr-Monat | string | Shows the year and month for each record in the calendar, helping to organize and group data by specific time periods. Useful for tracking and analyzing trends over different months and years. |
| Week | Woche | int64 | Shows the week number within the calendar year. Useful for organizing and analyzing data by week in reports or schedules. |
| Week | Woche (display) | string | Shows the week number within the calendar. Useful for tracking and organizing activities, tasks, or data by week. |
| Year Week | Jahr-Woche (display) | string | Shows the year and week number together, helping users identify and group data by specific weeks within a year. Useful for analyzing trends or activities on a weekly basis in reports. |
| ISO Week | ISO Woche | int64 | Shows the week number of the year based on the ISO standard. This helps organize and report data by standardized weekly periods, often used for financial and operational planning. |
| ISO Week | ISO Woche (display) | string | Shows the week number of the year based on the ISO standard. Useful for organizing and analyzing data by week, especially for international or standardized reporting. |
| Day of Month | Tag im Monat | int64 | Shows the specific day number within a month (from 1 to 31) for each calendar entry. Useful for tracking or analyzing data based on particular days of the month, such as scheduling or reporting activities. |
| Day of Year | Tag im Jahr | int64 | Shows the day’s number within the year, from 1 (January 1st) to 365 or 366 (December 31st). Useful for tracking dates or calculating periods in reports and analysis. |
| Weekday | Wochentag | int64 | Shows the day of the week for each date in the calendar, such as Monday or Tuesday. Useful for analyzing business activities by specific weekdays. |
| Weekday | Wochentag (display) | string | Shows the day of the week, such as Monday or Tuesday, for each date in the calendar. This helps users identify and group records by weekdays for scheduling or reporting purposes. |
| Weekday | Wochentag (lang) | string | Shows the full name of the day of the week (such as Monday or Tuesday) for each calendar date. Useful for reports or schedules that need to display which day of the week a specific date falls on. |
| FY Date BK | Datum (Fiskaljahr) | dateTime | This column holds a unique identifier for each fiscal year date in the calendar. It helps link transactions or records to specific fiscal periods for financial reporting and analysis in Business Central. |
| Current Date | Aktuelles Datum | int64 | Shows today’s date as per the system calendar. Useful for comparing other dates or for filtering data based on the current day. |
| Current Month | Aktueller Monat | int64 | Shows the current month in the calendar, which can be used to filter or display data specific to this month for reporting or analysis purposes. |
| Prev. Month | Vormonat | int64 | Shows the previous month related to each date in the calendar. Useful for comparing business data month-over-month or tracking changes from one month to the next. |
| Current Year | Aktuelles Jahr | int64 | Shows if the year is the current year in the calendar. This helps identify data related to the ongoing fiscal or calendar year for reporting and analysis. |
| CT Operation | CT Vorgang | string | Shows the type of operation scheduled or performed in the calendar, such as production steps or maintenance tasks. Useful for tracking and managing different activities within the calendar. |
| Week Start Date | Wochenstart Dat. | dateTime | Shows the first date of the week for each calendar entry. Useful for organizing and viewing data by weekly periods, such as in reports or schedules. |
| 'Sequential Day Number' = 'Calendar'[DateBK] | 'Sequential Day Number' = 'Calendar'[DateBK] | int64 | |
| DateWithSales = | DateWithSales = | ||
| DayOffset | DayOffset | int64 | |
| MonthOffset | MonthOffset | int64 | |
| YearOffset | YearOffset | int64 | |
| IsLastDateOfMonth | IsLastDateOfMonth | int64 |