| View Name: | MARITimeBookingActivityTracker |
| Based on table: | MPPersonenZeitenVorerfassung |
| Group: | |
| Description: | Table to store activities, before they are linked to time bookings |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ActionCode | Aktion INT Primary |
||
| EmployeeNumber | Personalnummer NVARCHAR (20) Index |
MARIEmployeeMaster.EmployeeNumber | |
| WorkingDay | Arbeitstag Datetime Index |
||
| StartTime | StartZeit Datetime Index |
||
| EndTime | EndZeit Datetime |
||
| ActionType | AktionsTyp INT |
||
| ActionDetail | AktionsTypDetail INT |
||
| ActionText | AktionsText NVARCHAR (50) |
||
| ActionRemark | Bemerkung NVARCHAR (255) |
||
| Source | Quelle INT |
ClassID | |
| SourceText | QuelleHinweis NVARCHAR (50) |
||
| ErrorCode | FehlerCode INT Index |
||
| ApprovalMode | Freigabe SMALLINT Index |
||
| ApprovedDate | FreigegebenAm Datetime |
||
| ApprovedUser | FreigegebenID NVARCHAR (4) |
MARIUser.ApprovedUser (WHERE BenutzerTyp=1) | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | Phase INT |
||
| 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 | |
| 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 |