| Table Name: | MPVKVertraegeEKPositionen |
| View Name: | MARIContractPOPositionLink |
| Group: | Group: Contract |
| Description: | Contract Management: Contract link to PO Process by position |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EKVertragsPosition | POProcessPosID INT Primary |
||
| VertragsPosition | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| ParentID | ParentID INT Index |
||
| VKPosIndex | SalesContractPosition INT |
||
| Lieferant | Supplier NVARCHAR (20) |
OCRD.CardCode | |
| LieferArt | PurchaseType SMALLINT |
||
| Lieferdatum | DeliveryDate Datetime |
||
| Matchcode | Matchcode NVARCHAR (50) Index |
||
| Menge | Quantity NUMERIC(19,6) |
||
| EKEinzelpreis | POUnitPrice NUMERIC(19,6) |
||
| EKPreiseberechnung | POPriceMode SMALLINT |
||
| KHKMandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| EKPositionErfuellt | POPosClosed SMALLINT Index |
||
| KHKEKVorPosID | ERPPOSourcePosID INT Index |
||
| UpdateStamp | UpdateStamp INT |