| View Name: | MARIAttendanceAction |
| Based on table: | MPPersonenZeitenAktionen |
| Group: | Group: AttandenceRuleHead |
| Description: | Attendance: Actions "in the door" (Lines per day) |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| Activity | Aktion INT Primary |
||
| EmployeeNumber | Personalnummer NVARCHAR (20) Index |
MARIEmployeeMaster.EmployeeNumber | |
| WorkingDay | Arbeitstag Datetime Index |
||
| TimeValueRounded | AktionsZeit Datetime Index |
||
| TimeValueExact | AktionsZeitExakt Datetime |
||
| ActionOrder | Reihenfolge SMALLINT Index |
||
| ActivityType | AktionsTyp INT |
clsImportAttendanceDayActivity_eAttendanceActivityType | |
| ActionDetail | AktionsTypDetail INT |
MARIGroups.ActionDetail (WHERE GruppenArt BETWEEN 50000 AND 50005) | |
| ActivityText | AktionsText NVARCHAR (50) |
||
| Memo | Bemerkung NVARCHAR (255) |
||
| Source | Quelle INT |
clsImportAttendanceDayActivity_eSourceTypes | |
| SourceText | QuelleHinweis NVARCHAR (50) |
||
| ErrorCode | FehlerCode INT Index |
clsImportAttendanceDayActivity_eActivityErrorCodes | |
| ApprovalMode | Freigabe SMALLINT (0=false,-1=true) Index |
||
| ApprovedDate | FreigegebenAm Datetime |
||
| ApprovedUser | FreigegebenID NVARCHAR (4) |
MARIUser.ApprovedUser (WHERE BenutzerTyp=1) | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | Phase INT |
MARIProjectPhases.PhaseID | |
| ContractID | Vertrag INT |
MARIContract.ContractID | |
| ContractPositionID | VertragsPos INT |
MARIContractPositions.ContractPositionID | |
| LinkClassID | LinkClassID INT |
ClassID | |
| LinkClassKey | LinkClassKey NVARCHAR (20) |
||
| AddOnCategoryLine | AddOnCategoryLine INT |
MARITimeBookingAddOnCategoryLine.AddOnCategoryLine | |
| TripID | ReiseID INT Index |
MARITravelTrip.TripID | |
| TimeSheetEntryID | BuchungsErfassungID INT Index |
MARIProjectTimeKeepingLines.TimeSheetEntryID | |
| TimeSheetMemo | Memo NTEXT |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIAttendanceActionArchive | Attendance: Actions "in the door" (Lines per day) History |