| Table Name: | MPTimeBookingAddOnCategoryLine |
| View Name: | MARITimeBookingAddOnCategoryLine |
| Group: | |
| Description: | Time Keeping: Add On Items Sales Rule Details |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| AddOnCategoryLine | AddOnCategoryLine INT Primary |
||
| AddOnCategory | AddOnCategory INT Index |
MPTimeBookingAddOnCategory.AddOnCategory | |
| AddOnType | AddOnType INT |
||
| Matchcode | Matchcode NVARCHAR (100) Index |
||
| SortOrder | SortOrder INT |
||
| StartTime | StartTime Datetime |
||
| EndTime | EndTime Datetime |
||
| Percentage | Percentage NUMERIC(19,6) |
||
| EditFlag | EditFlag INT |
||
| HandlingFlag | HandlingFlag INT |
||
| CostType | CostType INT |
||
| CostPercentage | CostPercentage NUMERIC(19,6) |
||
| CostRate | CostRate NUMERIC(19,6) |
||
| DayOfWeekMode | DayOfWeekMode INT |
||
| DayType | DayType INT |
||
| Threshold | Threshold INT |
||
| Active | Active SMALLINT |
||
| ReferenceDay | ReferenceDay INT |
||
| DayType2 | DayType2 INT |
||
| ReferenceDay2 | ReferenceDay2 INT |
||
| PayrollTypeGroup | PayrollTypeGroup NVARCHAR (20) |
MPLohnArtenKategorie.Lohnkategorie | |
| FormularHours | FormularHours NTEXT |
||
| FormularCost | FormularCost NTEXT |
||
| FormularSalesPrice | FormularSalesPrice NTEXT |
||
| Option1 | Option1 INT |
||
| Option2 | Option2 INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPPersonenZeitenAktionen | Attendance: Actions "in the door" (Lines per day) |
| MPPersonenZeitenAktionenArchiv | Attendance: Actions "in the door" (Lines per day) History |
| MPPersonenZeitenVorerfassung | Table to store activities, before they are linked to time bookings |
| MPProjektBuchungserfassungZuschlaege | Time Keeping: AddOnCategoryDetails |
| MPProjektLeistungserfassung | 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 |