| Table Name: | MPHotlineProduktKunde |
| View Name: | MARISupportProductCustomer |
| Group: | Group: SupportProduct |
| Description: | Support Module: Support Product: Customer Product Link |
| ClassID: | 109. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| KundeProduktID | CustomerProductID INT Primary |
||
| Mandant | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| ProduktID | ProductID INT Index |
MPHotlineProdukt.ProduktID | |
| ProduktVersionID | ProductVersionID INT Index |
MPHotlineProduktVersion.ProduktVersionID | |
| ProduktVariante | ProductVariant NVARCHAR (50) |
||
| ProduktAktuell | ProductCurrent SMALLINT |
||
| InstClients | InstalledClients INT |
||
| InstDatum | InstallationDate Datetime |
||
| InstInfo | InstallationInfo NTEXT |
||
| LizenzKey | LicenseKey NVARCHAR (240) |
||
| LicenseDocumentID | LicenseDocumentID INT Index |
MPDokumente.DocID | |
| Module | Modules INT |
||
| AnzahlMitarbeiter | NumberEmployees INT |
||
| AnzahlClients | NumberClients INT |
||
| AnzahlProjekte | NumberProjects INT |
||
| Projekt | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| PhasenID | PhaseID INT |
MPProjektPhasen.PhasenID | |
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| VertragsPos | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| ProductResponsibleResourceTyp | ProductResponsibleResourceTyp INT |
||
| ProductResponsibleResource | ProductResponsibleResource NVARCHAR (20) |
||
| ProduktVerantwortlicher | ProductResponsible NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| VerantwortlicherKundeTyp | CustomerResponsibleType INT |
||
| VerantwortlicherKunde | CustomerResponsible NVARCHAR (250) |
||
| VerantwortlicherKundeNotific | CustomerResponsibleNotification INT |
||
| OINSInsID | OINSInsID INT |
OINS.InsID | |
| SLA_ID | SLA_ID INT |
MPHotlineSLA.SLA_ID | |
| SLAComment | SLAComment NVARCHAR (100) |
||
| SLAStartDate | SLAStartDate Datetime |
||
| SLAEndDate | SLAEndDate Datetime |
||
| BenutzerBetrachterMode | UserViewMode INT |
||
| SysInstNo | SysInstNo NVARCHAR (50) |
||
| ValidFrom | ValidFrom Datetime |
||
| ValidTo | ValidTo Datetime |
||
| WartungsKennzeichen | MaintenanceMode INT |
||
| WorkFlowID | WorkFlowID INT |
MPHotlineWorkFlow.WorkFlowID | |
| MPinsID | MPinsID INT Index |
MPCustomerEquipmentCard.MPinsID | |
| EquipmentCode | EquipmentCode NVARCHAR (20) Unique |
MPEquipment.EquipmentCode | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| 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.
|
||||||||||||
| MPHotlineProduktKundeModul | Support Module: Support Product: Customer Product Link: Modules |