| Table Name: | MPVKVertraegePos2EKPos |
| View Name: | MARIContractPosition2POPosition |
| Group: | Group: Contract |
| Description: | Contract Management: Contract position to PO position link |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EKVKID | PO2SalesPosID INT Primary |
||
| VKVertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| VKPosID | ContractPositionID INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| EKVertragsID | POProcessID INT Index |
MPEKVertraege.VertragsID | |
| EKPosID | POProcessPosID INT Index |
MPEKVertraegePositionen.Vertragsposition | |
| Projektnummer | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| PhasenID | PhaseID INT Index |
MPProjektPhasen.PhasenID | |
| WorkItemID | WorkItemID INT Index |
Link to production service position | MPWorkItem.WorkItemID |
| WorkItemPosID | WorkItemPosID INT |
MPWorkItemPosition.WorkItemPosID | |
| MengeBestellt | QuantityOrdered NUMERIC(19,6) |
||
| MengeGeliefert | QuantityDeliverd NUMERIC(19,6) |
||
| MengeBerechnet | QuantityInvoiced NUMERIC(19,6) |
||
| Status | Status SMALLINT |
||
| UpdateStamp | UpdateStamp INT |