| View Name: | MARIProjectPhases |
| Based on table: | MPProjektPhasen |
| Group: | Group: ProjectPhases |
| Description: | Project Phases Master: Master Data (linked to project and planning version) |
| ClassID: | 166. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PhaseID | PhasenID INT Primary |
Unique Idenifier | |
| PhaseIdentifier | PhasenIdentifier INT |
Unique Identifier, for new phases. Copied phase will stay with this identifier | |
| Indent | Indent SMALLINT |
Hierarchy Ident | |
| Parent | Parent INT |
Parent Phase ID | MARIProjectPhases.Parent |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
Link to project | MARIProjectMaster.ProjectNumber |
| PlanningVersion | Planungsversion INT Index |
Link to planning version | MARIProjectPlanningVersions.PlanningVersion |
| PhaseName | Phase NVARCHAR (100) Index |
Text of the phase | |
| PositionID | Position INT Index |
order position | |
| PhaseStatus | PhasenStatus SMALLINT |
0=Not opend, 1=Active Phase, 2=Closed Phase | |
| PhaseType | PhasenTyp SMALLINT |
1=Leaf, 2=Branch | clsImportPhase_ePhaseStatus |
| PhasePredecessor | VorgaengerPhasenID INT Index |
Link to the direct predecessor | MARIProjectPhases.PhasePredecessor |
| DegreeOfCompletion | Fertigstellungsgrad Single |
Percentage | |
| DegreeOCompletionWeight | FertigstellungsgradGewichtung NUMERIC(19,6) |
||
| DegreeOCompletionWeightPercent | FertigstellungsgradGewichtungProzent NUMERIC(19,6) |
100%=100 | |
| SuggestedHoursLeft | RestStundenAbschaetzung NUMERIC(19,6) |
Hours left | |
| PhaseStart | PhasenBeginn Datetime |
Duration start date | |
| PhaseEnd | PhasenEnde Datetime |
Duration end date | |
| PhaseStartTime | StartZeit Datetime |
||
| PhaseEndTime | EndZeit Datetime |
||
| DurationDays | DauerInTagen NUMERIC(19,6) |
Duration in days | |
| DurationHours | DauerInStunden NUMERIC(19,6) |
Duration in hours | |
| GroupID | GruppenID INT Index |
Phase Group (GruppenArt=10200) | MARIGroups.GroupID (WHERE GruppenArt=10200) |
| StatusOnCompleted | StatusOnCompleted INT |
||
| ConstraintType | EinschraenkungsTyp INT |
||
| ConstraintDate | EinschraenkungsTermin Datetime |
||
| PhaseMemo | PhasenMemo NTEXT |
Memo for additional info | |
| ClosingUser | AbschlussBenutzer NVARCHAR (4) |
User who closed the phase | MARIUser.ClosingUser (WHERE BenutzerTyp=1) |
| ClosingDate | AbschlussDatum Datetime |
Close date | |
| ClosingMemo | AbschlussMemo NTEXT |
Close Memo | |
| SourceType | QuellTyp INT |
undefined | |
| SourcePlanningVersion | QuellPlanungsVersion INT |
source planning version | |
| PlanningMode | PlanungsMode INT |
planning mode: 0=undefined; 1=not plannable; 2=Plannable | |
| LocationID | LocationID INT |
MARILocation.LocationID | |
| AutoPlanningMode | AutoPlanungsMode INT |
||
| AutoPlanningOption | AutoPlanungOption INT |
||
| MileStone | Meilenstein SMALLINT (0=false,-1=true) |
||
| 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 |
| Table | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MARIPurchaseProcess | Purchase Process: Header | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIPurchaseProcessDownPayments | Purchase Process: Down Payments | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIPurchaseProcessDocumentPositions | Purchase Process: Purchase Document (Positions) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIPurchaseProcessPositionAccounting | Purchase Process: Accounting lines (due date, phase ...) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIPurchaseProcessPositionPhases | Purchase Process: Phases linked to a position | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportIssue | Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks
The type of ticket is defined by the field HotlineClassType.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportProductCustomer | Support Module: Support Product: Customer Product Link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportContracts | Support Module: Support Contracts (not used) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIServices | Service Master: Master Data Header Line (Without company assignment) The table MPVKVertrage with VertragsArt=6 will be used to store the company link The table MPVKVertragePositionen will be used to store the itemcodes and detailed settings |
||||||||||||||||||||||||||||||||||||||||||||||||
| MARIMSProjectPhases | MS Project Interface: Phase/task link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEmployeesProjectLinks | Employee Master: Project link (standard vacation project...) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEmployeeVacationRequest | Vacation Management: Vacation Request and Approval | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIAttendanceAction | Attendance: Actions "in the door" (Lines per day) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectItemBooking | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectBookingsFavorits | Time Keeping: Favorits | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPhases | Project Phases Master: Master Data (linked to project and planning version) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPhaseBudget | Project Phases Master: Budget | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPhaseEmployeeFeedback | Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPhaseEmployeeLink | Project Phases Master: Employee link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPhasePredecessor | Project Phases Phase Predecessors | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPlanningLines | Planning: Master Planning lines | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectMaster | Project Master: Master Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITravelTripProjectLink | Travel Expenses Module: Business Trip Project Link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITravelTripLineProject | Travel Expenses Module: Trip receipt project line for invoice | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITempReportProjectPhaseService | Reporting: Temporary Table: Project Phase Service | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITempReportProjectPhase | Reporting: Temporary Table: Project Phase Report | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContract | Contract Management: Contract Master Data + Service Master Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContractDownPayments | Contract Management: Contract Down Payments | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContractDocumentPositions | Contract Management: Document Positions | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContractPosition2POPosition | Contract Management: Contract position to PO position link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContractPositionPayment | Contract Management: Contract positions accounting lines (due date, phase ...) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContractPositionPhase | Contract Management: Contract position phase link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEquipmentDetails | Equipment: Master Data "date from" based | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIAttendanceActionArchive | Attendance: Actions "in the door" (Lines per day) History | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingExams | Training Module: List of exams | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingRegistration | Training Module: Registratrion to training cources | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEquipmentLocation | Equipment: Current Location of this equipment | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIChefInfoCashFlowRunLine | Info Screen Management: Stored line data per run | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIDocumentDraftHeadLink | Linked contracts and purchase processes | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItem | The table is used basically for service task and other tasks. For each dimension using this table, special views have been created. See also the description of the field WorkItemType.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MARICustomerServiceObjectLocation | Current location of a CSO at the client/Project | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingRegistrationPhaseLink | Training Module: Selected options=Phases from the project linked to the training cource | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPlanningLinesLog | Planning: Master Planning lines History | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPhaseDegreeOfCompletion | Project Phases Master: Degree OF Completion History | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPlanningLog | Planning: Log Phase dependency changes | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItemPhaseCPosFilter | Training Course: Filter selectable phases or contract positions | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContainerLocation | Current location of a container |