| View Name: | MARIProjectTimeKeepingLinesServices |
| Based on table: | MPProjektLeistungserfassung |
| 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 | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| TimeSheetEntryID | BuchungserfassungID INT Primary |
MARIProjectTimeKeepingLines.TimeSheetEntryID | |
| TimeKeepingHeaderID | BuchungsKopfID INT Primary |
MARIProjectTimeKeepingHeader.TimeKeepingHeaderID | |
| PositionID | Position SMALLINT Primary |
0=ContractPosition;>0=AddOnItems | |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT Index |
MARIContractPositions.ContractPositionID | |
| Quantity | Menge NUMERIC(19,6) |
||
| InvQty | MengeFAK NUMERIC(19,6) |
||
| Surcharge | Zuschlag NUMERIC(19,6) |
||
| PurchasePrice | EKPreis NUMERIC(19,6) |
||
| PurchasePriceLoc | EKPreisLoc NUMERIC(19,6) |
||
| PurchasePriceLocRate | EKPreisLocKurs Float |
||
| PurchasePriceFC | EKPreisFW NUMERIC(19,6) |
||
| PurchasePriceFCRate | EKPreisFWKurs Float |
||
| PurchasePriceFCCurr | EKPreisFWWKZ NVARCHAR (3) |
||
| SalesPrice | VKPreis NUMERIC(19,6) |
||
| SalesPriceLoc | VKPreisLoc NUMERIC(19,6) |
||
| SalesPriceLocRate | VKPreisLocKurs Float |
||
| SalesPriceFC | VKPreisFW NUMERIC(19,6) |
||
| SalesPriceFCRate | VKPreisFWKurs Float |
||
| LocCurrency | LocWKZ NVARCHAR (3) |
||
| Currency | WKZ NVARCHAR (3) |
ISO Currency Code | |
| ParentContractPos | ParentVKPos INT |
MARIContract.ParentContractPos | |
| ParentContractIndexPos | IndexVKPos INT |
MARIContractPositions.ParentContractIndexPos | |
| IndexText | IndexText NVARCHAR (50) |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MARIEquipmentMaster.EquipmentCode | |
| POProcessPos | ERVertragsposition INT |
MARIPurchaseProcessPositions.POProcessPos | |
| POPriceManual | EinzelPreisManuell SMALLINT |
||
| InvoiceID | FakturaID INT Index |
MARIContractDocumentPositions.InvoiceID | |
| POInvoiceID | EKFakturaID INT Index |
MARIPurchaseProcessDocumentPositions.POInvoiceID | |
| SurchargeID | ZuschlagID INT Index |
MARITimeBookingAddOnCategoryLine.SurchargeID | |
| CostHandling | Kostenbehandlung INT |
||
| CostPercentage | KostenProzent NUMERIC(19,6) |
||
| CostReduction | KostenAbschlag NUMERIC(19,6) |
||
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |