| View Name: | MARICalendarTemplates |
| Based on table: | MPKalenderTemplate |
| Group: | Group: Calender |
| Description: | Calendar Management: Public Holiday Rules |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| CalendarTemplateID | KalenderTemplateID INT Primary |
||
| TemplateDescription | KalenderTemplateBezeichnung 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 | |
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| CreateDate | Erstanlage Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARICalendar | Calendar Management: Calendar Header |
| MARICalendarTemplateDays | Calendar Management: Public Holiday Rules per Day |