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