| Table Name: | MPProjektArbeitskreis |
| View Name: | MARIProjectWorkGroup |
| Group: | Group: ProjectMaster |
| Description: | Project Master: Work group |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Projektnummer | ProjectNumber NVARCHAR (20) Primary |
MPProjektstamm.Projektnummer | |
| Ressource | Groups NVARCHAR (20) Primary |
MPPersonenstamm.Personalnummer | |
| Mandant | Company SMALLINT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Herkunft | Source SMALLINT Primary |
1=Employee, 100=ContactPerson | |
| Position | PositionID INT |
||
| Status | Status NVARCHAR (20) |
||
| Funktion | GroupFunction NVARCHAR (40) |
||
| BerechtigungsFlagge | AuthorizationFlagg INT |
||
| Gruppe | Group INT |
MPGruppen.GruppenID (WHERE GruppenArt=10115) clsImportGroups_eGroupType |
|
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |