| View Name: | MARIEmployeesProjectLinks |
| Based on table: | MPPersonenProjektVorlagen |
| Group: | Group: EmployeeMaster |
| Description: | Employee Master: Project link (standard vacation project...) |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| EmployeeNumber | Personalnummer NVARCHAR (20) Primary |
MARIEmployeeMaster.EmployeeNumber | |
| ProjectTemplates | VorlagenTyp SMALLINT Primary |
clsImportEmployeeProjectLink_eProjectTemplateType | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT Index |
MARIContractPositions.ContractPositionID | |
| UpdateStamp | UpdateStamp INT |