dbo.DialogCalendar
Calendar
TableType TUsage CONFIGURATIONRows 3653SizeMB 2.152
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogCalendar | varchar(38) | no | Date | PKUID |
CalendarYear | int(4) | yes | Calendar year | |
CalendarQuarter | int(4) | yes | Calendar quarter | |
CalendarMonth | int(4) | yes | Month of the year | |
CalendarDay | int(4) | yes | Day in calendar month | |
isYear | bit(1) | yes | Beginning of year | |
isQuarter | bit(1) | yes | Start of quarter | |
isMonth | bit(1) | yes | Beginning of month | |
DayOfWeek | nvarchar(64) | yes | Weekday | limited |
DayOfYear | int(4) | yes | Current day in calendar year | |
WeekOfYear | int(4) | yes | Calendar week | |
isWeek | bit(1) | yes | Start of week | |
CustomProperty01 | nvarchar(128) | yes | Spare field no. 01 | |
CustomProperty02 | nvarchar(128) | yes | Spare field no. 02 | |
CustomProperty03 | nvarchar(128) | yes | Spare field no. 03 | |
CustomProperty04 | nvarchar(128) | yes | Spare field no. 04 | |
CustomProperty05 | nvarchar(128) | yes | Spare field no. 05 | |
IsoDate | nvarchar(20) | yes | Date (ISO format) | |
DisplayMonth | nvarchar(64) | yes | Name of month | limited |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T2B6432365442C073FA3BEE939 SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QBM_FCVDatetimeToNextWork | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIScheduleNextRun | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZCalendarFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FCVDatetimeToNextWork | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIScheduleNextRun | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_ZCalendarFill | source text reference | uses session context values, has TRY/CATCH error handling |
| cs-common-customizer-vi-common-customizer-dialogtable.cs | decompiled C# reference | classes DialogTable, _003C_003Ec__DisplayClass4_0; methods _003C_ConfigureColumns_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _ConfigureColumns, OnSavedAsync; references DialogCalendar, DialogColumn, DialogDBQueue, DialogMultiLanguage, DialogNotification, DialogProcess; markers reads entity values, references DB/Dialog objects, Job/process related markers |