| Table Name: | MPWorkItemScheduleDates |
| View Name: | MARIWorkItemScheduleDates |
| Group: | Group: WorkItem |
| Description: | Recurring service tasks |
| ClassID: | 380. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| WorkItemScheduleID | WorkItemScheduleID INT Primary |
||
| WorkItemID | WorkItemID INT Index |
MPWorkItem.WorkItemID (WHERE WorkItemType=379) | |
| ScheduleOrder | ScheduleOrder INT Index |
||
| Description | Description NVARCHAR (50) |
||
| LineType | LineType INT |
||
| LineStatus | LineStatus INT Index |
MPHotlineSettings.ID (WHERE Setting=11) | |
| PlanDate | PlanDate Datetime Index |
||
| FullFillDate | FullFillDate Datetime |
||
| FullFillSource | FullFillSource INT Index |
||
| FullFillReference | FullFillReference NVARCHAR (20) Index |
||
| QualityProcess | QualityProcess INT |
MPQualityProcess.QualityProcess | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |