| View Name: | MARIProjectMasterWorkInProgess |
| Based on table: | MPProjektstammWIP |
| Group: | Group: ProjectMaster |
| Description: | Project Master: Save degree of compleation for each month |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ProjectNumber | ProjectNumber NVARCHAR (20) Primary |
MARIProjectMaster.ProjectNumber | |
| StatusDate | StatusDate Datetime Primary |
||
| AssessmentMethod | WIPMethod INT Primary |
||
| Period | StatusPeriod INT Index |
MARIPeriods.Period | |
| ApprovalMode | StatusApproved INT Index |
||
| DegreeOfCompletion | DegreeOfCompleation Single |
||
| Factor1 | Factor1 NUMERIC(19,6) |
||
| Factor2 | Factor2 NUMERIC(19,6) |
||
| Factor3 | Factor3 NUMERIC(19,6) |
||
| 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 |