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