| View Name: | MARISupportProductCustomer |
| Based on table: | MPHotlineProduktKunde |
| Group: | Group: SupportProduct |
| Description: | Support Module: Support Product: Customer Product Link |
| ClassID: | 109. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| CustomerProductID | KundeProduktID INT Primary |
||
| Company | Mandant SMALLINT Index |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| ProductID | ProduktID INT Index |
MARISupportProduct.ProductID | |
| ProductVersionID | ProduktVersionID INT Index |
MARISupportProductVersions.ProductVersionID | |
| ProductVariant | ProduktVariante NVARCHAR (50) |
||
| ProductCurrent | ProduktAktuell SMALLINT |
||
| InstalledClients | InstClients INT |
||
| InstallationDate | InstDatum Datetime |
||
| InstallationInfo | InstInfo NTEXT |
||
| LicenseKey | LizenzKey NVARCHAR (240) |
||
| LicenseDocumentID | LicenseDocumentID INT Index |
MARIDocuments.LicenseDocumentID | |
| Modules | Module INT |
||
| NumberEmployees | AnzahlMitarbeiter INT |
||
| NumberClients | AnzahlClients INT |
||
| NumberProjects | AnzahlProjekte INT |
||
| ProjectNumber | Projekt NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | PhasenID INT |
MARIProjectPhases.PhaseID | |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | VertragsPos INT |
MARIContractPositions.ContractPositionID | |
| ProductResponsibleResourceTyp | ProductResponsibleResourceTyp INT |
||
| ProductResponsibleResource | ProductResponsibleResource NVARCHAR (20) |
||
| ProductResponsible | ProduktVerantwortlicher NVARCHAR (20) |
MARIEmployeeMaster.ProductResponsible | |
| CustomerResponsibleType | VerantwortlicherKundeTyp INT |
||
| CustomerResponsible | VerantwortlicherKunde NVARCHAR (250) |
||
| CustomerResponsibleNotification | VerantwortlicherKundeNotific INT |
||
| OINSInsID | OINSInsID INT |
OINS.InsID | |
| SLA_ID | SLA_ID INT |
MARISupportSLA.SLA_ID | |
| SLAComment | SLAComment NVARCHAR (100) |
||
| SLAStartDate | SLAStartDate Datetime |
||
| SLAEndDate | SLAEndDate Datetime |
||
| UserViewMode | BenutzerBetrachterMode INT |
||
| SysInstNo | SysInstNo NVARCHAR (50) |
||
| ValidFrom | ValidFrom Datetime |
||
| ValidTo | ValidTo Datetime |
||
| MaintenanceMode | WartungsKennzeichen INT |
||
| WorkFlowID | WorkFlowID INT |
MARISupportWorkflow.WorkFlowID | |
| MPinsID | MPinsID INT Index |
MARICustomerServiceObject.MPinsID | |
| EquipmentCode | EquipmentCode NVARCHAR (20) Unique |
MARIEquipmentMaster.EquipmentCode | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| 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.
|
||||||||||||
| MARISupportProductCustomerModules | Support Module: Support Product: Customer Product Link: Modules |