dbo.DialogReport
Reports
TableType TUsage CONFIGURATIONRows 82SizeMB 29.08
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogReport | varchar(38) | no | Report | PKUID |
ReportName | nvarchar(128) | no | Name | |
Description | nvarchar(510) | yes | Description | |
ReportDefinition | nvarchar(-1) | yes | Definition | |
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 | |
CustomProperty06 | nvarchar(128) | yes | Spare field no. 06 | |
CustomProperty07 | nvarchar(128) | yes | Spare field no. 07 | |
CustomProperty08 | nvarchar(128) | yes | Spare field no. 08 | |
CustomProperty09 | nvarchar(128) | yes | Spare field no. 09 | |
CustomProperty10 | nvarchar(128) | yes | Spare field no. 10 | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
DisplayName | nvarchar(510) | yes | Display name | |
XObjectKey | varchar(138) | no | Object key | |
FilterCriteria | nvarchar(510) | yes | Filter criteria | |
ReportClass | nvarchar(32) | yes | Category | limited |
PreProcessorCondition | nvarchar(510) | yes | Preprocessor condition | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
UID_DialogTableBase | varchar(38) | yes | Base table | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
MaxSecondsRuntime | int(4) | yes | Max. runtime [sec] |
Relations
| FK | From | To |
|---|---|---|
| POL_RFRL2700 | QERPolicy.UID_DialogReport | DialogReport.UID_DialogReport |
| QBM_RFRL196 | DialogReportQuery.UID_DialogReport | DialogReport.UID_DialogReport |
| QBM_RFRL275 | DialogReport.UID_DialogTableBase | DialogTable.UID_DialogTable |
| RPS_RFRL4167 | RPSReport.UID_DialogReport | DialogReport.UID_DialogReport |
Triggers
GEN_T29A3D694C94F191D6D9C71184 SQL_TRIGGER
GEN_T33F73515070914EB71741A6E6 SQL_TRIGGER
GEN_T51C574E2DB33A7259E3F7D49C SQL_TRIGGER
QBM_TIDialogReport SQL_TRIGGER
QBM_TUDialogReport 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_ZPrePropReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C3D78466F05DE84C333B3E26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C2630021CB14906358C7D203 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T51C574E2DB33A7259E3F7D49C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUDialogReport | SQL expression dependency | OBJECT_OR_COLUMN |
| QERPolicy | foreign key references table | POL_RFRL2700: QERPolicy.UID_DialogReport -> DialogReport.UID_DialogReport |
| DialogReportQuery | foreign key references table | QBM_RFRL196: DialogReportQuery.UID_DialogReport -> DialogReport.UID_DialogReport |
| DialogTable | referenced by foreign key from table | QBM_RFRL275: DialogReport.UID_DialogTableBase -> DialogTable.UID_DialogTable |
| RPSReport | foreign key references table | RPS_RFRL4167: RPSReport.UID_DialogReport -> DialogReport.UID_DialogReport |
| dbo.QBM_ZPrePropReport | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUDialogReport | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-att-customizer-att-customizer-attestationpolicy.cs | decompiled C# reference | classes AttestationPolicy, ReportEngine, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass18_0; methods _003CCreateAttestation_003Eb__0, _003CPrepareAttestations_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__2, _003C_GetGrantedCases_003Eb__0, _003C_CreateAttestations_003Eb__0; references AttestationCase, AttestationHelper, AttestationObject, AttestationObjectHasPWODM, AttestationPolicy, AttestationPolicyGroup; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-pol-forms-pol-forms-formqerpolicymasterdata.cs | decompiled C# reference | classes FormQERPolicyMasterData; methods OnInit, InitializeComponent, OnFormSizeChanged, OnFormLoad, OnFormUnload, _DisconnectUIEngineUserSettings; references AERole, DialogDashboardDef, DialogReport, DialogRichMail, DialogSchedule, DialogTable; markers reads entity values, references DB/Dialog objects |
| cs-qbm-forms-vi-common-forms-frmdialogrichmailstammdaten.cs | decompiled C# reference | classes FrmDialogRichMailStammdaten; methods OnInit, OnDispose, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged; references DialogCountry, DialogCountryHasCulture, DialogParameter, DialogParameterSet, DialogReport, DialogRichMail; markers reads entity values, references DB/Dialog objects |
| cs-rps-customizer-rps-customizer-rpsreport.cs | decompiled C# reference | classes RPSReport; methods MoveNext, SetStateMachine, _CreateParameterSet, OnSavedAsync; references DialogParameter, DialogParameterSet, DialogReport, RPSReport; markers reads entity values, references DB/Dialog objects |
| cs-rps-forms-rps-forms-formrpsreportmasterdata.cs | decompiled C# reference | classes FormRPSReportMasterData; methods OnInit, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged, Task_Preview; references AccProduct, DialogParameter, DialogParameterSet, DialogReport, Person, RPSReport; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers |