| Table Name: | MPChefInfoDashboard |
| View Name: | MARIChefInfoDashboard |
| Group: | |
| Description: | Project Dash Board Settings |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DashboardID | DashboardID INT Primary |
||
| DashboardType | DashboardType INT Index |
||
| DashboardClassID | DashboardClassID INT Index |
||
| DashboardClassKey | DashboardClassKey NVARCHAR (20) Index |
||
| DashboardOrder | DashboardOrder INT |
Visible Order | |
| DashboardOrderBehind | DashboardOrderBehind INT |
Order behind Parent | MPChefInfoDashboard.DashboardID |
| UserMode | UserMode INT Index |
||
| UserID | UserID NVARCHAR (4) Index |
||
| DashboardName | DashboardName NVARCHAR (100) Index |
||
| PeriodFrom | PeriodFrom INT |
MPPerioden.PeriodeJahr | |
| PeriodTo | PeriodTo INT |
MPPerioden.PeriodeJahr | |
| PeriodCurrent | PeriodCurrent INT |
MPPerioden.PeriodeJahr | |
| PlanPeriodFrom | PlanPeriodFrom INT |
MPPerioden.PeriodeJahr | |
| PlanPeriodTo | PlanPeriodTo INT |
MPPerioden.PeriodeJahr | |
| CWFrom | CWFrom INT |
Calendar Week | MPPeriodenKW.KW |
| CWTo | CWTo INT |
Calendar Week | MPPeriodenKW.KW |
| CWCurrent | CWCurrent INT |
Calendar Week | MPPeriodenKW.KW |
| PlanCWFrom | PlanCWFrom INT |
Calendar Week | MPPeriodenKW.KW |
| PlanCWTo | PlanCWTo INT |
Calendar Week | MPPeriodenKW.KW |
| RightsMainApp | RightsMainApp BIGINT |
bit flag | MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) |
| RightsLAN | RightsLAN BIGINT |
bit flag | MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) |
| RightsWAN | RightsWAN BIGINT |
bit flag | MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) |
| PictureID | PictureID INT |
MPBilder.BildID | |
| FilterStore | FilterStore NTEXT |
||
| MenuOption | MenuOption INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MPChefInfoDashboard | Project Dash Board Settings |
| MPChefInfoDashboardTiles | Project Dash Board Settings Tiles |