| Table Name: | MPPersonenProjektVorlagen |
| View Name: | MARIEmployeesProjectLinks |
| Group: | Group: EmployeeMaster |
| Description: | Employee Master: Project link (standard vacation project...) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
MPPersonenstamm.Personalnummer | |
| VorlagenTyp | ProjectTemplates SMALLINT Primary |
clsImportEmployeeProjectLink_eProjectTemplateType | |
| Projektnummer | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| PhasenID | PhaseID INT Index |
MPProjektPhasen.PhasenID | |
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| Vertragsposition | ContractPositionID INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| UpdateStamp | UpdateStamp INT |