| Table Name: | MPEquipmentDetailsSerial |
| View Name: | MARIEquipmentDetailsSerial |
| Group: | Group: Equipment |
| Description: | Equipment: Master Data "Date from" based serial numbers |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentCodeDetailSerialID | EquipmentCodeDetailSerialID INT Primary |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) Index |
MPEquipment.EquipmentCode | |
| ValidFrom | ValidFrom Datetime Index |
||
| SysNumber | SysNumber INT |
||
| MnfSerial | MnfSerial NVARCHAR (36) Index |
||
| DistNumber | DistNumber NVARCHAR (36) |
||
| BatchID | BatchID NVARCHAR (36) |
||
| LotNumber | LotNumber NVARCHAR (36) |
||
| ExpDate | ExpDate Datetime |
||
| MnfDate | MnfDate Datetime |
||
| InDate | InDate Datetime |
||
| GrntStart | GrntStart Datetime |
||
| GrntExp | GrntExp Datetime |