| Table Name: | MPHotlineGruppe |
| View Name: | MARISupportGroup |
| Group: | Group: SupportIssue |
| Description: | Support Module: Support Group: Header |
| ClassID: | 107. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| HotlineGruppenID | GroupId INT Primary |
||
| HotlineClassType | HotlineClassType INT Index |
MPHotlineClassType.HotlineClassType | |
| Bezeichnung | Description NVARCHAR (50) |
||
| Geschaeftsbereich | BusinessUnitID SMALLINT |
MPSetupGeschaeftsbereich.GeschaeftsbereichID | |
| Leiter | EmployeeSuperior NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| Vertreter | EmployeeSuperior2 NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| DefaultProduct | DefaultProduct INT |
MPHotlineProdukt.ProduktID | |
| DefaultPriority | DefaultPriority INT |
MPHotlineSettings.ID (WHERE Setting=3) | |
| DefaultStatus | DefaultStatus INT |
MPHotlineSettings.ID (WHERE Setting=1) | |
| DefaultIssueType | DefaultSupportType INT |
MPHotlineSettings.ID (WHERE Setting=2) | |
| DefaultMedium | DefaultMedium INT |
||
| DefaultSolutionMethod | DefaultSolutionMethod INT |
||
| UploadSizeLimit | UploadSizeLimit INT |
in Kbytes | |
| MailInMode | MailInMode INT |
||
| MailInLogMode | MailInLogMode INT |
||
| MailInAddress | MailInAddress NVARCHAR (100) |
||
| MailInFallBack | MailInFallBack NVARCHAR (100) |
||
| MailInFirstResponsibleMode | MailInFirstResponsibleMode INT |
||
| MailInFirstResponsible | MailInFirstResponsible NVARCHAR (20) |
||
| MailOutMode | EmailOutMode INT |
||
| AutoResponsibleReceipient | AutoResponsibleRecipient INT |
||
| MailOutAddress | MailOutAddress NVARCHAR (100) |
||
| GruppenTyp | GroupType INT |
||
| StatusAfterFirstAction | StatusAfterFirstAction INT |
||
| StatusAfterFirstMail | StatusAfterFirstMail INT |
||
| WorkflowID | WorkFlowID INT Index |
MPHotlineWorkFlow.WorkFlowID | |
| SichtbarkeitAufTeilnehmer | ViewMode2GroupMembers INT |
||
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| InAktiv | Inactive SMALLINT (0=false,-1=true) |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MPHotlineAnfrage | Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks
The type of ticket is defined by the field HotlineClassType.
|
||||||||||||
| MPHotlineGruppeMandant | Support Module: Support Group: E-Mail settings by company | ||||||||||||
| MPHotlineGruppeMitarbeiter | Support Module: Support Group: Linked employees | ||||||||||||
| MPHotlineProdukt | Support Module: Support Product: Master Data |