| Table Name: | MPKalender |
| View Name: | MARICalendar |
| Group: | Group: Calender |
| Description: | Calendar Management: Calendar Header |
| ClassID: | 19. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| KalenderID | CalendarID INT Primary |
||
| KalenderTyp | CalendarType INT Index |
||
| Bezeichnung | CalendarName NVARCHAR (50) Index |
||
| StundeProWoche | HoursPerWeek NUMERIC(19,6) |
Default value | |
| BeginnDerWoche | BeginOfTheWeek INT |
Default value | |
| StdPlantag | WorkingTime NUMERIC(19,6) |
Default value | |
| PlantagBeginn | PlanDayStart Datetime |
Default value | |
| PlantagEnde | PlanDayEnd Datetime |
Default value | |
| Template | Template INT |
Link to public holiday template | MPKalenderTemplate.KalenderTemplateID |
| UeberstundenAbschlagTyp | UeberstundenAbschlagTyp INT |
||
| UeberstundenAbschlag | OvertimeReduction NUMERIC(19,6) |
Default value | |
| ArbeitstageKZ | WorkDayFlag INT |
||
| Gruppe1 | Group1 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10110) clsImportGroups_eGroupType |
|
| Gruppe2 | Group2 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10111) clsImportGroups_eGroupType |
|
| Gruppe3 | Group3 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10112) clsImportGroups_eGroupType |
|
| Verantwortlicher | Responsible NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| Schwelle1 | Threshold1 NUMERIC(19,6) |
||
| Schwelle2 | Threshold2 NUMERIC(19,6) |
||
| Schwelle3 | Threshold3 NUMERIC(19,6) |
||
| KalenderMemo | CalendarMemo NTEXT |
||
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPEquipmentDetails | Equipment: Master Data "date from" based |
| MPHotlineSLA | Support Module: Service Level Agreement Master |
| MPKalenderPeriode | Calendar Management: Calendar Month (Period) |
| MPKalenderTage | Calendar Management: Calendar Day Definition |
| MPKalenderTagesVorlagen | Calendar Management: Stadard for Monday,Tuesday.. |
| MPPersonenPeriode | Employee Master: One line per employee and valid from period and business unit |
| MPPersonenZeitenTage | Attandence: Actions "in the door" (Day header) |
| MPProjektBuchungserfassungZuschlaege | Time Keeping: AddOnCategoryDetails |
| MPProjektPlanungRessourcen | Planning: Filter list for plannable resources (ex. G/L Accounts) |
| MPProjektstamm | Project Master: Master Data |
| MPRessourcenPool | Resource Pool: Master Data |
| MPTmpRptKalender | Reporting: Temporary Table: Calendar |