| View Name: | MARIProjectPhasePredecessor |
| Based on table: | MPProjektPhasenVorgaenger |
| Group: | Group: ProjectPhases |
| Description: | Project Phases Phase Predecessors |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PhaseID | PhasenID INT Primary |
Successor Phase | MARIProjectPhases.PhaseID |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
Only reference | MARIProjectMaster.ProjectNumber |
| PlanningVersion | Planungsversion INT Index |
Only reference | MARIProjectPlanningVersions.PlanningVersion |
| Predesessor | VorgaengerID INT Primary |
MARIProjectPhases.Predesessor | |
| Type | Typ INT |
1=FF, 1=FS, 2=SF, 3=SS | clsImportPhasePredecessor_eRelationShipType |
| Difference | Abstand NUMERIC(19,6) |
Distance in days | |
| CheckMethod | PruefMethode INT |
not used | |
| Memo | Memo NTEXT |
||
| 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 |