| View Name: | MARISupportGroup |
| Based on table: | MPHotlineGruppe |
| Group: | Group: SupportIssue |
| Description: | Support Module: Support Group: Header |
| ClassID: | 107. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| GroupId | HotlineGruppenID INT Primary |
||
| HotlineClassType | HotlineClassType INT Index |
MARISupportClassType.HotlineClassType | |
| Description | Bezeichnung NVARCHAR (50) |
||
| BusinessUnitID | Geschaeftsbereich SMALLINT |
MARIBusinessUnitMaster.BusinessUnitID | |
| EmployeeSuperior | Leiter NVARCHAR (20) |
MARIEmployeeMaster.EmployeeSuperior | |
| EmployeeSuperior2 | Vertreter NVARCHAR (20) |
MARIEmployeeMaster.EmployeeSuperior2 | |
| DefaultProduct | DefaultProduct INT |
MARISupportProduct.DefaultProduct | |
| DefaultPriority | DefaultPriority INT |
MARISupportSettings.DefaultPriority (WHERE Setting=3) | |
| DefaultStatus | DefaultStatus INT |
MARISupportSettings.DefaultStatus (WHERE Setting=1) | |
| DefaultSupportType | DefaultIssueType INT |
MARISupportSettings.DefaultSupportType (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) |
||
| EmailOutMode | MailOutMode INT |
||
| AutoResponsibleRecipient | AutoResponsibleReceipient INT |
||
| MailOutAddress | MailOutAddress NVARCHAR (100) |
||
| GroupType | GruppenTyp INT |
||
| StatusAfterFirstAction | StatusAfterFirstAction INT |
||
| StatusAfterFirstMail | StatusAfterFirstMail INT |
||
| WorkFlowID | WorkflowID INT Index |
MARISupportWorkflow.WorkFlowID | |
| ViewMode2GroupMembers | SichtbarkeitAufTeilnehmer INT |
||
| CreateDate | Erstanlage Datetime |
||
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MARISupportIssue | Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks
The type of ticket is defined by the field HotlineClassType.
|
||||||||||||
| MARISupportGroupEmployee | Support Module: Support Group: Linked employees | ||||||||||||
| MARISupportProduct | Support Module: Support Product: Master Data | ||||||||||||
| MARISupportGroupCompany | Support Module: Support Group: E-Mail settings by company |