| Table Name: | MPProjektBuchungserfassungZuschlaege |
| View Name: | MARIProjectTimeKeepingLinesAddOnCategory |
| Group: | |
| Description: | Time Keeping: AddOnCategoryDetails |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| BuchungsErfassungZuschlagID | TimeSheetEntryTimeSheetEntryAddOnID INTEGER IDENTITY Primary |
||
| BuchungsErfassungID | TimeSheetEntryID INT Index |
||
| ZuschlagsTyp | AddOnType INT |
||
| Personalnummer | EmployeeNumber NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| Periode | Period INT |
MPPerioden.PeriodeJahr | |
| KalenderID | CalendarID INT |
MPKalender.KalenderID | |
| Leistungstag | ServiceDate Datetime Index |
||
| MitarbeiterMandant | EmployeeCompanyID SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Lohnart | PayrollType NVARCHAR (20) |
MPLohnArten.LohnArt | |
| StartZeit | StartTime Datetime |
||
| EndZeit | EndTime Datetime |
||
| AddOnCategoryLine | AddOnCategoryLine INT |
MPTimeBookingAddOnCategoryLine.AddOnCategoryLine | |
| Menge | Quantity NUMERIC(19,6) |
||
| KostenStundeSys | CostByHourSys NUMERIC(19,6) |
||
| KostenStundeLoc | CostByHourLoc NUMERIC(19,6) |
||
| KostenSys | CostSys NUMERIC(19,6) |
||
| KostenLoc | CostLoc NUMERIC(19,6) |
||
| WKZSys | CurrencySys NVARCHAR (3) |
||
| WKZLoc | CurrencyCompany NVARCHAR (3) |
||
| WkzMaKurs | ExchangeRateCompany Float |
||
| OptionMemo | OptionMemo NTEXT |