| View Name: | MARIProjectStatus |
| Based on table: | MPProjektstatus |
| Group: | Group: ProjectMaster |
| Description: | Project Master: status history |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ProjectStatusID | ProjektStatusID INT Primary |
Unique ID | |
| ProjectNumber | Projektnummer NVARCHAR (50) Index |
Reference to Project | MARIProjectMaster.ProjectNumber |
| PositionID | Position SMALLINT Index |
Position in the status list | |
| Status | Status NVARCHAR (20) Index |
Status text | |
| StatusType | StatusTyp SMALLINT Index |
1=Preliminary,2=Running, 3=Closed, 4=Project Canceld/Aborted | clsImportProject_eProjectStatus |
| EffectiveFrom | Wirksamkeit INT |
Effectife date | |
| Movement | Verschiebung SMALLINT |
old status if moved | |
| PeriodDiff | PeriodeDiff SMALLINT |
number of monthes when moved | MARIPeriods.PeriodDiff |
| Reason | Begruendung NTEXT |
Description of the reason | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIProjectMaster | Project Master: Master Data |