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