Calendar (DueDate)
Dimension table for due date calendar
DE: Kalender (Fälligkeitsdatum)
Columns
| Column (EN) | Column (DE) | Type | Description |
|---|---|---|---|
| DateSK | DateSK | int64 | |
| Due Date | Fälligkeitsdatum | dateTime | Due Date of Sales Order |
| Time BK | Time BK | dateTime | Shows the time part of the date for a calendar entry. Used to track when a calendar event is booked or scheduled in the system. |
| Date | Datum (display) | string | Shows the specific date for each calendar entry. This is useful for tracking and organizing business activities by day. |
| Date | Datum (lang) | string | Shows the full date in a long format, such as "Monday, January 1, 2024." This is useful for displaying clear and detailed date information in calendar views. |
| Date (Short) | Datum (kurz) | string | Shows a shortened version of the date, typically used for displaying calendar entries or events in a compact format for quick reference. This helps users view important dates at a glance without full date details. |
| Year | Jahr | int64 | Shows the calendar year related to each record, helping users organize and analyze data by year for financial or reporting purposes. This is useful for tracking yearly trends or results. |
| Half Year | Halbjahr | string | Shows which half of the year a date belongs to, helping to group or analyze data by the first or second six months of the year. This is useful for reporting and comparing performance across the two halves of a year. |
| Year Halfyear | Jahr-Halbjahr | string | Shows whether a date falls in the first or second half of the year, helping to group or analyze data by half-year periods in reports. This can be useful for tracking performance or trends over six-month intervals. |
| Quarter | Quartal | string | Shows which quarter of the year (such as Q1, Q2, Q3, or Q4) a date belongs to. This helps group and analyze data by three-month periods within a year. |
| Year Quarter | Jahr-Quartal | string | Shows the year and quarter together, such as "2023 Q1". This is useful for grouping and analyzing business data by quarter within each year, like tracking sales or expenses over time. |
| Quarter | Quartal (lang) | string | Shows the full name of the fiscal quarter for a given date, such as "Quarter 1" or "Quarter 2." Useful for grouping and analyzing data by quarter in business reports. |
| Quarter | Quartal (kurz) | string | Shows the quarter of the year for a given date, such as Q1, Q2, Q3, or Q4. Useful for grouping financial or business data by quarters in reports and analysis. |
| Month | Monat | int64 | Shows the month number (such as 1 for January, 2 for February) for each calendar entry. Useful for organizing or filtering data by month in reports and analysis. |
| Month | Monat (display) | string | Shows the name or number of the month for each record in the calendar. Useful for organizing or analyzing data by month, such as tracking sales or activities over time. |
| Month | Monat (lang) | string | Shows the full name of the month, such as "January" or "February," to help identify and organize data by month in calendar reports or analyses. Useful for grouping or filtering financial or operational data by month. |
| Month Date | Monat (Datum) | dateTime | Shows the specific date that represents the start of a month in the calendar. Useful for organizing and grouping data by month for reporting and analysis. |
| Year Month | Jahr-Monat | string | Shows the year and month for each calendar entry, making it easier to organize and analyze data by specific months within a year. Commonly used for monthly reporting or trend analysis in financial and business records. |
| Week | Woche | int64 | Shows the week number in the calendar, which helps organize and analyze data by specific weeks throughout the year. This is useful for tracking activities, transactions, or trends on a weekly basis. |
| Week | Woche (display) | string | Shows the week number within the calendar year. Useful for tracking and analyzing data by week in reports or schedules. |
| Year Week | Jahr-Woche (display) | string | Shows the year and week number for each calendar entry. Useful for grouping and analyzing data by week within a specific year. |
| ISO Week | ISO Woche | int64 | Shows the week number of the year following the international ISO standard. This helps track and organize business activities or reports by standard weekly periods. |
| ISO Week | ISO Woche (display) | string | Shows the week number based on the international ISO standard, which helps organize and analyze data by week across different years. Useful for reporting and comparing weekly trends in your business calendar. |
| Day of Month | Tag im Monat | int64 | Shows the specific day (from 1 to 31) within a month for each calendar entry. Useful for sorting or grouping data by the day in business reports and schedules. |
| Day of Year | Tag im Jahr | int64 | Shows the number for the day within the year, from 1 to 365 (or 366 in a leap year). Useful for tracking and analyzing data based on the specific day of the year. |
| Weekday | Wochentag | int64 | Shows the day of the week for each calendar date, such as Monday or Tuesday. This helps with scheduling and analyzing data by day within the calendar. |
| Weekday | Wochentag (display) | string | Shows the day of the week (such as Monday or Tuesday) for a calendar date. This helps users identify and work with specific days when scheduling or reviewing transactions. |
| Weekday | Wochentag (lang) | string | Shows the full name of the day of the week, such as Monday or Tuesday. Useful for understanding or grouping data by specific days in calendar-related reports. |
| Week Start Date | Wochenbeginn | dateTime | Shows the first day of the week for each calendar entry. This helps group data or analyze activities by week in business reports. |
| FY Date BK | Datum (Fiskaljahr) | dateTime | Identifies the unique key for each fiscal year date in the calendar, helping to organize and track financial periods for reporting and analysis in Business Central. |
| Current Date | Aktuelles Datum | int64 | Shows today’s date based on the system calendar. Useful for comparing or filtering records by the current date in reports or dashboards. |
| Current Month | Aktueller Monat | int64 | Shows the month for the current date in the calendar. Useful for filtering or analyzing data based on the present month. |
| Prev. Month | Vormonat | int64 | Shows the previous month related to the current calendar entry. This can help compare or analyze data trends from one month to the next in business reports. |
| Current Year | Aktuelles Jahr | int64 | Shows whether a date falls within the current fiscal year. Useful for filtering or analyzing data relevant to the current business period. |
| DayOffset | DayOffset | int64 | |
| MonthOffset | MonthOffset | int64 | |
| YearOffset | YearOffset | int64 | |
| IsLastDateOfMonth | IsLastDateOfMonth | int64 |