| View Name: | MARIContractPosition2POPosition |
| Based on table: | MPVKVertraegePos2EKPos |
| Group: | Group: Contract |
| Description: | Contract Management: Contract position to PO position link |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PO2SalesPosID | EKVKID INT Primary |
||
| ContractID | VKVertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | VKPosID INT Index |
MARIContractPositions.ContractPositionID | |
| POProcessID | EKVertragsID INT Index |
MARIPurchaseProcess.POProcessID | |
| POProcessPosID | EKPosID INT Index |
MARIPurchaseProcessPositions.POProcessPosID | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| WorkItemID | WorkItemID INT Index |
Link to production service position | MARIWorkItem.WorkItemID |
| WorkItemPosID | WorkItemPosID INT |
MARIWorkItemPosition.WorkItemPosID | |
| QuantityOrdered | MengeBestellt NUMERIC(19,6) |
||
| QuantityDeliverd | MengeGeliefert NUMERIC(19,6) |
||
| QuantityInvoiced | MengeBerechnet NUMERIC(19,6) |
||
| Status | Status SMALLINT |
||
| UpdateStamp | UpdateStamp INT |