| Table Name: | MPKalenderTemplate |
| View Name: | MARICalendarTemplates |
| Group: | Group: Calender |
| Description: | Calendar Management: Public Holiday Rules |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| KalenderTemplateID | CalendarTemplateID INT Primary |
||
| KalenderTemplateBezeichnung | TemplateDescription NVARCHAR (50) Index |
||
| CountryID | CountryID NVARCHAR (2) |
ISO Code Country | |
| State | State NVARCHAR (3) |
USA/CA State code | |
| County | County NVARCHAR (100) |
USA/CA County code | |
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Erstanlage | CreateDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPKalender | Calendar Management: Calendar Header |
| MPKalenderTemplateTage | Calendar Management: Public Holiday Rules per Day |