| View Name: | MARIAttendanceActionArchive |
| Based on table: | MPPersonenZeitenAktionenArchiv |
| Group: | Group: AttandenceRuleHead |
| Description: | Attendance: Actions "in the door" (Lines per day) History |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| Activity | Aktion INT Primary |
MARIAttendanceAction.Activity | |
| LogID | LogID INT Primary |
||
| LogMode | LogMode SMALLINT |
||
| LogProgInfo | LogProgInfo NVARCHAR (255) |
||
| EmployeeNumber | Personalnummer NVARCHAR (20) |
MARIEmployeeMaster.EmployeeNumber | |
| WorkingDay | Arbeitstag Datetime |
||
| TimeValueRounded | AktionsZeit Datetime |
||
| TimeValueExact | AktionsZeitExakt Datetime |
||
| SortOrder | Reihenfolge SMALLINT |
||
| ActivityType | AktionsTyp INT |
||
| ActionDetail | AktionsTypDetail INT |
||
| ActivityText | AktionsText NVARCHAR (50) |
||
| Memo | Bemerkung NVARCHAR (255) |
||
| Source | Quelle INT |
||
| SourceText | QuelleHinweis NVARCHAR (50) |
||
| ErrorCode | FehlerCode INT |
||
| ApprovalMode | Freigabe SMALLINT (0=false,-1=true) |
||
| ApprovedDate | FreigegebenAm Datetime |
||
| ApprovedUser | FreigegebenID NVARCHAR (4) |
MARIUser.ApprovedUser (WHERE BenutzerTyp=1) | |
| ProjectNumber | Projektnummer NVARCHAR (20) |
MARIProjectMaster.ProjectNumber | |
| PhaseID | Phase INT |
MARIProjectPhases.PhaseID | |
| Contract | Vertrag INT |
MARIContract.Contract | |
| 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 |