MARIProject Database Structure

Table Name:MPHotlineSLA
View Name:MARISupportSLA
Group:Group: SupportProduct
Description:Support Module: Service Level Agreement Master
ClassID: 319. See Overview of ClassIDs by table.

Field View(engl.field)/Type Description Related
SLA_ID SLA_ID

INT Primary

Matchcode Matchcode

NVARCHAR (100) Index

Description Description

NVARCHAR (100)

SLACalendar SLACalendar

INT

MPKalender.KalenderID
SLAOffHourMode SLAOffHourMode

INT

SLALink SLALink

INT

SLAOption1 SLAOption1

INT

SLAOption2 SLAOption2

NVARCHAR (50)

InAktiv Inactive

SMALLINT Index

Hide dataset
WorkFlowID WorkFlowID

INT Index

MPHotlineWorkFlow.WorkFlowID
ErstanlageID CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Erstanlage CreateDate

Datetime

AenderungID ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung ChangeDate

Datetime

UpdateStamp UpdateStamp

INT

Memo Memo

NTEXT


Linked by

Table Description
MPCustomerEquipmentCard Advanced table to sbo standard customer equipment card
MPEquipmentCategory EquipmentCategory: Cagetory Master
MPEquipmentDetails Equipment: Master Data "date from" based
MPHotlineAnfrage Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks The type of ticket is defined by the field HotlineClassType.
DimensionHotlineClassType
Support Ticket17
Task676
Idea677
Development Task678
HR Task679
MPHotlineProdukt Support Module: Support Product: Master Data
MPHotlineProduktKunde Support Module: Support Product: Customer Product Link
MPHotlineSLANotification Support Module: Service Level Agreement Notifications
MPHotlineSLASettings Support Module: Service Level Agreement Settings


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany