| Table Name: | MPWorkItemPositionSerial |
| View Name: | MARIWorkItemPositionSerial |
| Group: | Group: WorkItem |
| Description: | Serialnumbers, Batchnumbers for work item positions |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| WorkItemPosSerialID | WorkItemPosSerialID INT Primary |
||
| WorkItemPosID | WorkItemPosID INT Index |
MPWorkItemPosition.WorkItemPosID | |
| SysNumber | SysNumber INT |
||
| MnfSerial | MnfSerial NVARCHAR (36) |
||
| DistNumber | DistNumber NVARCHAR (36) |
||
| BatchID | BatchID NVARCHAR (36) |
||
| LotNumber | LotNumber NVARCHAR (36) |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MPEquipment.EquipmentCode | |
| MPInsID | MPInsID INT Index |
MPCustomerEquipmentCard.MPinsID | |
| Quantity | Quantity NUMERIC(19,6) |
||
| ExpDate | ExpDate Datetime |
||
| MnfDate | MnfDate Datetime |
||
| InDate | InDate Datetime |
||
| GrntStart | GrntStart Datetime |
||
| GrntExp | GrntExp Datetime |
||
| BinLocations | BinLocations NTEXT |
||
| ContainerBins | ContainerBins NTEXT |
||
| UpdateStamp | UpdateStamp INT |