| View Name: | MARIPurchaseImportDocumentPos2POProcessPos |
| Based on table: | MPEKFremdBelegErfassungPos2EKPos |
| Group: | |
| Description: | Purchase Order: Import external documents (Link to PO Process lines) |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ImportDocPosID | FremdBelPosID INT Primary |
MARIPurchaseImportDocumentPos.ImportDocPosID | |
| PurchaseProcessPosition | EKPosID INT Primary |
MARIPurchaseProcessPositions.PurchaseProcessPosition | |
| PurchaseProcessID | EKVertragsID INT Index |
MARIPurchaseProcess.PurchaseProcessID | |
| Quantity | Menge NUMERIC(19,6) |
||
| NetUnitPriceFC | EinzelPreis NUMERIC(19,6) |
||
| Total | Summe NUMERIC(19,6) |
||
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| ProjectCode | Kostentraeger NVARCHAR (20) |
OPRJ.PrjCode | |
| Company | Mandant INT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| UpdateStamp | UpdateStamp INT |