| View Name: | MARIServiceJobs |
| Based on table: | MPServiceJob |
| Group: | Group: ServiceJob |
| Description: | MARIService: Service Job header |
| ClassID: | 133. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ServiceJob | ServiceJob INT Primary |
||
| ServiceType | ServiceType INT Index |
||
| ServiceName | ServiceName NVARCHAR (50) |
||
| ServicePriority | ServicePriority INT Index |
||
| NotificationMode | NotificationMode INT |
||
| NotificationEMail1 | NotificationEMail1 NVARCHAR (200) |
||
| NotificationEMail2 | NotificationEMail2 NVARCHAR (200) |
||
| NotificationTextID | NotificationTextID INT |
MARIClassNotificationText.NotificationTextID | |
| NotificationText2ID | NotificationText2ID INT Index |
MARIClassNotificationText.NotificationText2ID | |
| LogLevel | LogLevel INT |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIServiceJobParameter | MARIService: Service Job settings |
| MARIServiceJobSchedule | MARIService: Service Job timing |
| MARIServiceJournal | MARIService: Service Job log header |