| Table Name: | MPEquipmentReminder |
| View Name: | MARIEquipmentReminder |
| Group: | Group: Equipment |
| Description: | Equipment: recurrent dates for each equipment |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentReminderCode | EquipmentReminderCode INT Primary |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) Index |
MPEquipment.EquipmentCode | |
| ReminderType | ReminderType INT |
||
| ReminderDate | ReminderDate Datetime |
||
| ReminderGroup | ReminderGroup INT |
||
| OpenCloseStatus | OpenCloseStatus INT |
||
| ClosedBy | ClosedBy NVARCHAR (20) |
||
| ClosedDate | ClosedDate Datetime |
||
| IntervalMode | IntervalMode INT |
||
| IntervalQty | IntervalQty INT |
||
| Description | Description NVARCHAR (50) |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |