| Table Name: | MPHotlineProdukt |
| View Name: | MARISupportProduct |
| Group: | Group: SupportProduct |
| Description: | Support Module: Support Product: Master Data |
| ClassID: | 16. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ProduktID | ProductID INT Primary |
||
| Produkt | ProductName NVARCHAR (50) Index |
||
| Artikel | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| KurzBezeichnung | BriefDescription NVARCHAR (20) |
||
| ProduktBeschreibung | ProductDescription NTEXT |
||
| Homepage | Homepage NVARCHAR (50) |
||
| Projekt | ProjectNumber NVARCHAR (20) |
MPProjektstamm.Projektnummer | |
| VertragsID | ContractID INT |
MPVKVertraege.VertragsID | |
| VertragsPos | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| InAktiv | Inactive SMALLINT (0=false,-1=true) |
Hide dataset | |
| Memo | Memo NTEXT |
||
| SupportGroup | SupportDesk INT |
MPHotlineGruppe.HotlineGruppenID | |
| SupportGroup2 | SupportGroup2 INT |
||
| SupportGroup3 | SupportGroup3 INT |
||
| SupportGroup4 | SupportGroup4 INT |
||
| SupportGroup5 | SupportGroup5 INT |
||
| ProductManager | EmployeeSuperior NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| ProductManager2 | EmployeeSuperior2 NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| Gruppe1 | ProductGroup1 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10040) | |
| Gruppe2 | ProductGroup2 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10041) | |
| Gruppe3 | ProductGroup3 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10042) | |
| StandardSLA_ID | StandardSLAContract INT |
MPHotlineSLA.SLA_ID | |
| WorkFlowID | WorkFlowID INT |
MPHotlineWorkFlow.WorkFlowID | |
| IndexFormID | IndexFormID INT Index |
MPSammelmappeIndexForms.IndexFormID | |
| TextAnalysisOptions | TextAnalysisOptions NTEXT |
||
| NewsletterID | NewsletterID INT Index |
MPNewsletterMaster.NewsletterID | |
| FilterSetID | FilterSetID INT Index |
MPNewsletterFilterSet.FilterSetID | |
| 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 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MPCustomerEquipmentCard | Advanced table to sbo standard customer equipment card | ||||||||||||
| MPCustomerEquipmentCardCategory | Group to manage properties by group | ||||||||||||
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) | ||||||||||||
| MPEquipment | Equipment: Master Data for each individual Equipment | ||||||||||||
| MPEquipmentCategory | EquipmentCategory: Cagetory Master | ||||||||||||
| MPHotlineAnfrage | Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks
The type of ticket is defined by the field HotlineClassType.
|
||||||||||||
| MPHotlineGruppe | Support Module: Support Group: Header | ||||||||||||
| MPHotlineProduktBetrachter | Support Module: Customers/Users to be informed for changes | ||||||||||||
| MPHotlineProduktKunde | Support Module: Support Product: Customer Product Link | ||||||||||||
| MPHotlineProduktKundeLizenz | Support Module: Support Product: License files by customer | ||||||||||||
| MPHotlineProduktModul | Support Module: Support Product: Master Data Modules | ||||||||||||
| MPHotlineProduktModulVersion | Support Module: Support Product: Master Data Versions for Modules | ||||||||||||
| MPHotlineProduktVersion | Support Module: Support Product: Master Data Versions | ||||||||||||
| MPHotlineVertraege | Support Module: Support Contracts (not used) | ||||||||||||
| MPVKVertraegePositionen | Contract Management: Contract positions (also service master positions) |