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