| Table Name: | MPEKVertraegeBelegePositionenSerie |
| View Name: | MARIPurchaseProcessDocumentPositionsSerialNumbers |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Purchase Document (Positions+Serial) |
| ClassID: | 536. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPBelPosSerieID | DocPosSeriesID INT Primary |
||
| MPBelPosID | DocPosID INT Index |
MPEKVertraegeBelegePositionen.MPBelPosID | |
| MPBelID | MARIDocID INT Index |
MPEKVertraegeBelege.MPBelID | |
| MPChargeID | MPBatchID INT Index |
MPChargennummern.MPChargeID | |
| AbsEntry | AbsEntry INT |
OSRN.AbsEntry | |
| SysNumber | SysNumber INT |
OSRN.SysNumber | |
| MnfSerial | MnfSerial NVARCHAR (36) |
||
| DistNumber | DistNumber NVARCHAR (36) |
||
| BatchID | BatchID NVARCHAR (36) Index |
||
| LotNumber | LotNumber NVARCHAR (36) |
||
| ExpDate | ExpDate Datetime |
||
| MnfDate | MnfDate Datetime |
||
| InDate | InDate Datetime |
||
| GrntStart | GrntStart Datetime |
||
| GrntExp | GrntExp Datetime |
||
| BinLocationAbsID | BinLocationAbsID INT |
||
| FromBinLocationAbsID | FromBinLocationAbsID INT |
||
| ContainerBinID | ContainerBinID INT Index |
||
| SourceContainerBinID | SourceContainerBinID INT Index |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MPEquipment.EquipmentCode | |
| MPInsID | MPInsID INT Index |
MPCustomerEquipmentCard.MPinsID | |
| BinLocationMode | BinLocationMode INT |
||
| FromBinLocationMode | FromBinLocationMode INT |
||
| Notes | Notes NTEXT |
||
| UpdateStamp | UpdateStamp INT |