MARIProject Database Structure

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

Field Table(Germ.field)/Type Description Related
SLA_ID SLA_ID

INT Primary

Matchcode Matchcode

NVARCHAR (100) Index

Description Description

NVARCHAR (100)

SLACalendar SLACalendar

INT

MARICalendar.SLACalendar
SLAOffHourMode SLAOffHourMode

INT

SLALink SLALink

INT

SLAOption1 SLAOption1

INT

SLAOption2 SLAOption2

NVARCHAR (50)

Inactive InAktiv

SMALLINT Index

Hide dataset
WorkFlowID WorkFlowID

INT Index

MARISupportWorkflow.WorkFlowID
CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
CreateDate Erstanlage

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

UpdateStamp UpdateStamp

INT

Memo Memo

NTEXT


Linked by

Table Description
MARISupportIssue 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
MARISupportProduct Support Module: Support Product: Master Data
MARISupportProductCustomer Support Module: Support Product: Customer Product Link
MARIEquipmentCategory EquipmentCategory: Cagetory Master
MARIEquipmentDetails Equipment: Master Data "date from" based
MARISupportSLANotification Support Module: Service Level Agreement Notifications
MARISupportSLASettings Support Module: Service Level Agreement Settings
MARICustomerServiceObject Advanced table to sbo standard customer equipment card


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany