| View Name: | MARIPurchaseProcessDocumentPositionsBatches |
| Based on table: | MPEKVertraegeBelegePositionenCharge |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Purchase Document (Positions+Batches) |
| ClassID: | 535. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocPosSeriesID | MPBelPosChargeID INT Primary |
||
| DocPosID | MPBelPosID INT Index |
MARIPurchaseProcessDocumentPositions.DocPosID | |
| MARIDocID | MPBelID INT Index |
MARIPurchaseProcessDocumentPositions.MARIDocID | |
| MPBatchID | MPChargeID INT Index |
MARIBatchnumbers.MPBatchID | |
| AbsEntry | AbsEntry INT |
OBTN.AbsEntry | |
| SysNumber | SysNumber INT |
OBTN.AbsEntry | |
| DistNumber | DistNumber NVARCHAR (36) |
OBTN.SysNumber | |
| MnfSerial | MnfSerial NVARCHAR (36) |
OBTN.MnfSerial | |
| LotNumber | LotNumber NVARCHAR (36) |
OBTN.LotNumber | |
| Quantity | Quantity NUMERIC(19,6) |
OBTN.Quantity | |
| ExpDate | ExpDate Datetime |
OBTN.ExpDate | |
| MnfDate | MnfDate Datetime |
OBTN.MnfDate | |
| InDate | InDate Datetime |
OBTN.InDate | |
| GrntStart | GrntStart Datetime |
OBTN.GrntStart | |
| GrntExp | GrntExp Datetime |
OBTN.GrntExp | |
| Notes | Notes NTEXT |
OBTN.Notes | |
| BinLocations | BinLocations NTEXT |
||
| ContainerBins | ContainerBins NTEXT |
||
| FromBinLocations | FromBinLocations NTEXT |
||
| FromContainerBins | FromContainerBins NTEXT |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MARIEquipmentMaster.EquipmentCode | |
| UpdateStamp | UpdateStamp INT |