| View Name: | MARIProjectPlanningVersions |
| Based on table: | MPProjektPlanungsversion |
| Group: | Group: ProjectMaster |
| Description: | Project Master: Planning versions linked to a project |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ProjectNumber | Projektnummer NVARCHAR (20) Primary |
MARIProjectMaster.ProjectNumber | |
| PlanningVersion | Planungsversion INT Primary |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| LineOrder | Reihenfolge INT Index |
||
| RevisionName | RevisionName NVARCHAR (50) |
||
| GroupId | Gruppe INT |
MARIGroups.GroupId (WHERE GruppenArt=10300) clsImportGroups_eGroupType |
|
| PlanningVersionType | PlanungsversionsTyp INT |
||
| BudgetMethod | BudgetMethode INT |
||
| BudgetBase | Budgetbezug INT |
||
| ReferencePlanningVersion | ReferencePV INT |
MARIProjectPlanningVersions.ReferencePlanningVersion | |
| WorkInProgressMode | WorkInProgressMode INT |
||
| PlanningSchema | PlanungsSchema INT |
MARIInfoScreenManagementBreakEven.PlanningSchema | |
| BasePeriod | Bezugsperiode INT |
MARIPeriods.BasePeriod | |
| DegreeOfCompletion | Fertigstellungsgrad Single |
||
| AutoPlanningMode | AutoPlanungsMode INT |
||
| ApprovalCreateUser | FreigabeErsteller NVARCHAR (20) |
MARIEmployeeMaster.ApprovalCreateUser | |
| ApprovalType | FreigabeTyp INT |
See RuleTypes in MPDocApprovalRessource | |
| Approver1 | Freigebender NVARCHAR (20) Index |
MARIEmployeeMaster.Approver1 | |
| ApprovalMode | Freigabe SMALLINT Index |
||
| ApprovedDate | FreigegebenAm Datetime |
||
| ApprovedUser | FreigegebenID NVARCHAR (4) |
MARIUser.ApprovedUser (WHERE BenutzerTyp=1) | |
| ApprovalText | Freigabetext 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) | |
| Memo | Memo NTEXT |
||
| Inactive | InAktiv SMALLINT Index |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseProcess | Purchase Process: Header |
| MARIMSProjectDatabases | MS Project Interface: Database Link (MSP Server) |
| MARIMSProjectImports | MS Project Interface: Import log |
| MARIMSProjectPhases | MS Project Interface: Phase/task link |
| MARIProjectPhases | Project Phases Master: Master Data (linked to project and planning version) |
| MARIProjectPhasePredecessor | Project Phases Phase Predecessors |
| MARIProjectPlanningVersions | Project Master: Planning versions linked to a project |
| MARIProjectPlanningLines | Planning: Master Planning lines |
| MARIProjectMaster | Project Master: Master Data |
| MARIContract | Contract Management: Contract Master Data + Service Master Data |
| MARIProjectPlanningLinesLog | Planning: Master Planning lines History |
| MARIProjectPhaseDegreeOfCompletion | Project Phases Master: Degree OF Completion History |
| MARIProjectPlanningLog | Planning: Log Phase dependency changes |