| View Name: | MARITimeBookingAddOnCategory |
| Based on table: | MPTimeBookingAddOnCategory |
| Group: | |
| Description: | Time Keeping: Add On Items Sales Rules Valid From |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| AddOnCategory | AddOnCategory INT Primary |
||
| AddOnCategoryHeadID | AddOnCategoryHeadID INT Index |
MARITimeBookingAddOnCategoryHead.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) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseProcessPositions | Purchase Process: PO Process Position (equivilant to contract position) |
| MARICalendarDays | Calendar Management: Calendar Day Definition |
| MARIEmployeesPeriod | Employee Master: One line per employee and valid from period and business unit |
| MARIAttendanceRuleDays | Attandence: Actions "in the door" (Day header) |
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MARIContractPositions | Contract Management: Contract positions (also service master positions) |
| MARITimeBookingAddOnCategoryLine | Time Keeping: Add On Items Sales Rule Details |
| MARITempTimeBookingAddOn | Reporting: Temporary Table: Time Booking Add On |
| MARICalendarDayPresets | Calendar Management: Stadard for Monday,Tuesday.. |
| MARIAttendanceShiftRule | Shift: Rule Definition |