| Table Name: | MPEKFremdBelegErfassungPos2EKPos |
| View Name: | MARIPurchaseImportDocumentPos2POProcessPos |
| Group: | |
| Description: | Purchase Order: Import external documents (Link to PO Process lines) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| FremdBelPosID | ImportDocPosID INT Primary |
MPEKFremdBelegErfassungPos.FremdBelPosID | |
| EKPosID | PurchaseProcessPosition INT Primary |
MPEKVertraegePositionen.Vertragsposition | |
| EKVertragsID | PurchaseProcessID INT Index |
MPEKVertraege.VertragsID | |
| Menge | Quantity NUMERIC(19,6) |
||
| EinzelPreis | NetUnitPriceFC NUMERIC(19,6) |
||
| Summe | Total NUMERIC(19,6) |
||
| Projektnummer | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| Kostentraeger | ProjectCode NVARCHAR (20) |
OPRJ.PrjCode | |
| Mandant | Company INT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| UpdateStamp | UpdateStamp INT |