| Table Name: | MPProjektLeistungserfassung |
| View Name: | MARIProjectTimeKeepingLinesServices |
| Group: | Group: ProjectTimeKeepingHeader |
| Description: | Time Keeping: ProjectTimeKeepingLinesServices: additional lines for the MPProjectBuchungserfassung for the project types: customer project and internal project with contract. This table stores the link to the contract and contract position |
| ClassID: | 130. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| BuchungserfassungID | TimeSheetEntryID INT Primary |
MPProjektBuchungserfassung.BuchungsErfassungID | |
| BuchungsKopfID | TimeKeepingHeaderID INT Primary |
MPProjektBuchungskopf.BuchungsKopfID | |
| Position | PositionID SMALLINT Primary |
0=ContractPosition;>0=AddOnItems | |
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| Vertragsposition | ContractPositionID INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| Menge | Quantity NUMERIC(19,6) |
||
| MengeFAK | InvQty NUMERIC(19,6) |
||
| Zuschlag | Surcharge NUMERIC(19,6) |
||
| EKPreis | PurchasePrice NUMERIC(19,6) |
||
| EKPreisLoc | PurchasePriceLoc NUMERIC(19,6) |
||
| EKPreisLocKurs | PurchasePriceLocRate Float |
||
| EKPreisFW | PurchasePriceFC NUMERIC(19,6) |
||
| EKPreisFWKurs | PurchasePriceFCRate Float |
||
| EKPreisFWWKZ | PurchasePriceFCCurr NVARCHAR (3) |
||
| VKPreis | SalesPrice NUMERIC(19,6) |
||
| VKPreisLoc | SalesPriceLoc NUMERIC(19,6) |
||
| VKPreisLocKurs | SalesPriceLocRate Float |
||
| VKPreisFW | SalesPriceFC NUMERIC(19,6) |
||
| VKPreisFWKurs | SalesPriceFCRate Float |
||
| LocWKZ | LocCurrency NVARCHAR (3) |
||
| WKZ | Currency NVARCHAR (3) |
ISO Currency Code | |
| ParentVKPos | ParentContractPos INT |
MPVKVertraege.Vertragsposition | |
| IndexVKPos | ParentContractIndexPos INT |
MPVKVertraegePositionen.Vertragsposition | |
| IndexText | IndexText NVARCHAR (50) |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MPEquipment.EquipmentCode | |
| ERVertragsposition | POProcessPos INT |
MPEKVertraegePositionen.Vertragsposition | |
| EinzelPreisManuell | POPriceManual SMALLINT |
||
| FakturaID | InvoiceID INT Index |
MPVKVertraegeBelegePositionen.MPBelPosID | |
| EKFakturaID | POInvoiceID INT Index |
MPEKVertraegeBelegePositionen.MPBelPosID | |
| ZuschlagID | SurchargeID INT Index |
MPTimeBookingAddOnCategoryLine.AddOnCategoryLine | |
| Kostenbehandlung | CostHandling INT |
||
| KostenProzent | CostPercentage NUMERIC(19,6) |
||
| KostenAbschlag | CostReduction NUMERIC(19,6) |
||
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |