| Table Name: | MPProjektstammWIP |
| View Name: | MARIProjectMasterWorkInProgess |
| Group: | Group: ProjectMaster |
| Description: | Project Master: Save degree of compleation for each month |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ProjectNumber | ProjectNumber NVARCHAR (20) Primary |
MPProjektstamm.Projektnummer | |
| StatusDate | StatusDate Datetime Primary |
||
| WIPMethod | AssessmentMethod INT Primary |
||
| StatusPeriod | Period INT Index |
MPPerioden.PeriodeJahr | |
| StatusApproved | ApprovalMode INT Index |
||
| DegreeOfCompleation | DegreeOfCompletion Single |
||
| Factor1 | Factor1 NUMERIC(19,6) |
||
| Factor2 | Factor2 NUMERIC(19,6) |
||
| Factor3 | Factor3 NUMERIC(19,6) |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |