| Table Name: | MPTmpTimeBookingAddOn |
| View Name: | MARITempTimeBookingAddOn |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: Temporary Table: Time Booking Add On |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ConnectionID | ConnectionID INT Primary |
MPTmpRptProjektPhaseLeistung.ConnectionID | |
| TimeSheetEntryID | TimeSheetEntryID INT Primary |
MPTmpRptProjektPhaseLeistung.BuchungsErfassungID | |
| PositionID | PositionID INT Primary |
MPTmpRptProjektPhaseLeistung.ZeilenID | |
| SubLineID | SubLineID INT Primary |
||
| AddOnCategory | AddOnCategory INT |
MPTimeBookingAddOnCategory.AddOnCategory | |
| AddOnCategoryType | AddOnCategoryType INT |
||
| Matchcode | Matchcode NVARCHAR (100) |
||
| Description | Description NVARCHAR (100) |
||
| AddOnType | AddOnType INT |
||
| AddOnCategoryLine | AddOnCategoryLine INT |
||
| MatchcodeLine | MatchcodeLine NVARCHAR (100) Index |
||
| StartTimeLine | StartTimeLine Datetime |
||
| EndTimeLine | EndTimeLine Datetime |
||
| StartTime | StartTime Datetime |
||
| EndTime | EndTime Datetime |
||
| Quantity | Quantity NUMERIC(19,6) |
||
| QuantityInv | QuantityInv NUMERIC(19,6) |
||
| PriceCost | PriceCost NUMERIC(19,6) |
||
| PriceRev | PriceRev NUMERIC(19,6) |
||
| Percentage | Percentage NUMERIC(19,6) |
||
| Threshold | Threshold INT |
||
| Payroll | Payroll NVARCHAR (20) |
||
| PayrollCategory | PayrollCategory NVARCHAR (20) |