| View Name: | MARISupportProduct |
| Based on table: | MPHotlineProdukt |
| Group: | Group: SupportProduct |
| Description: | Support Module: Support Product: Master Data |
| ClassID: | 16. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ProductID | ProduktID INT Primary |
||
| ProductName | Produkt NVARCHAR (50) Index |
||
| ItemCode | Artikel NVARCHAR (50) |
OITM.ItemCode | |
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| BriefDescription | KurzBezeichnung NVARCHAR (20) |
||
| ProductDescription | ProduktBeschreibung NTEXT |
||
| Homepage | Homepage NVARCHAR (50) |
||
| ProjectNumber | Projekt NVARCHAR (20) |
MARIProjectMaster.ProjectNumber | |
| ContractID | VertragsID INT |
MARIContract.ContractID | |
| ContractPositionID | VertragsPos INT |
MARIContractPositions.ContractPositionID | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) |
Hide dataset | |
| Memo | Memo NTEXT |
||
| SupportDesk | SupportGroup INT |
MARISupportGroup.SupportDesk | |
| SupportGroup2 | SupportGroup2 INT |
||
| SupportGroup3 | SupportGroup3 INT |
||
| SupportGroup4 | SupportGroup4 INT |
||
| SupportGroup5 | SupportGroup5 INT |
||
| EmployeeSuperior | ProductManager NVARCHAR (20) |
MARIEmployeeMaster.EmployeeSuperior | |
| EmployeeSuperior2 | ProductManager2 NVARCHAR (20) |
MARIEmployeeMaster.EmployeeSuperior2 | |
| ProductGroup1 | Gruppe1 INT |
MARIGroups.ProductGroup1 (WHERE GruppenArt=10040) | |
| ProductGroup2 | Gruppe2 INT |
MARIGroups.ProductGroup2 (WHERE GruppenArt=10041) | |
| ProductGroup3 | Gruppe3 INT |
MARIGroups.ProductGroup3 (WHERE GruppenArt=10042) | |
| StandardSLAContract | StandardSLA_ID INT |
MARISupportSLA.StandardSLAContract | |
| WorkFlowID | WorkFlowID INT |
MARISupportWorkflow.WorkFlowID | |
| IndexFormID | IndexFormID INT Index |
MARIFolderIndexForms.IndexFormID | |
| TextAnalysisOptions | TextAnalysisOptions NTEXT |
||
| NewsletterID | NewsletterID INT Index |
MARINewsletterMaster.NewsletterID | |
| FilterSetID | FilterSetID INT Index |
MARINewsletterFilterSet.FilterSetID | |
| 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 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MARIPurchaseProcessPositions | Purchase Process: PO Process Position (equivilant to contract position) | ||||||||||||
| MARISupportIssue | Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks
The type of ticket is defined by the field HotlineClassType.
|
||||||||||||
| MARISupportGroup | Support Module: Support Group: Header | ||||||||||||
| MARISupportProductCustomer | Support Module: Support Product: Customer Product Link | ||||||||||||
| MARISupportProductCustomerLicenses | Support Module: Support Product: License files by customer | ||||||||||||
| MARISupportProductModules | Support Module: Support Product: Master Data Modules | ||||||||||||
| MARISupportProductVersions | Support Module: Support Product: Master Data Versions | ||||||||||||
| MARISupportContracts | Support Module: Support Contracts (not used) | ||||||||||||
| MARIContractPositions | Contract Management: Contract positions (also service master positions) | ||||||||||||
| MARIEquipmentMaster | Equipment: Master Data for each individual Equipment | ||||||||||||
| MARIEquipmentCategory | EquipmentCategory: Cagetory Master | ||||||||||||
| MARISupportProductListener | Support Module: Customers/Users to be informed for changes | ||||||||||||
| MARISupportProductModuleVersions | Support Module: Support Product: Master Data Versions for Modules | ||||||||||||
| MARICustomerServiceObject | Advanced table to sbo standard customer equipment card | ||||||||||||
| MARICustomerServiceObjectCategory | Group to manage properties by group |