| Table Name: | MPTimeBookingAddOnCategory |
| View Name: | MARITimeBookingAddOnCategory |
| Group: | |
| Description: | Time Keeping: Add On Items Sales Rules Valid From |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| AddOnCategory | AddOnCategory INT Primary |
||
| AddOnCategoryHeadID | AddOnCategoryHeadID INT Index |
MPTimeBookingAddOnCategoryHead.AddOnCategoryHeadID | |
| ValidFrom | ValidFrom Datetime Index |
||
| ValidTo | ValidTo Datetime Index |
||
| AddOnCategoryType | AddOnCategoryType INT |
||
| Matchcode | Matchcode NVARCHAR (100) Index |
||
| Description | Description NVARCHAR (100) |
||
| CalendarMode | CalendarMode INT |
||
| CalenderID | CalenderID INT Index |
||
| CategoryGroup | CategoryGroup INT |
||
| 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 |
|---|---|
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) |
| MPKalenderTage | Calendar Management: Calendar Day Definition |
| MPKalenderTagesVorlagen | Calendar Management: Stadard for Monday,Tuesday.. |
| MPPersonenPeriode | Employee Master: One line per employee and valid from period and business unit |
| MPPersonenZeitenSchicht | Shift: Rule Definition |
| MPPersonenZeitenTage | Attandence: Actions "in the door" (Day header) |
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MPTimeBookingAddOnCategoryLine | Time Keeping: Add On Items Sales Rule Details |
| MPTmpTimeBookingAddOn | Reporting: Temporary Table: Time Booking Add On |
| MPVKVertraegePositionen | Contract Management: Contract positions (also service master positions) |