| View Name: | MARIProjectMaster |
| Based on table: | MPProjektstamm |
| Group: | Group: ProjectMaster |
| Description: | Project Master: Master Data |
| ClassID: | 40. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ProjectNumber | Projektnummer NVARCHAR (20) Primary |
Unique Primary Key | |
| ProjectTitle | Projektname NVARCHAR (100) |
Project Name (For customer) | |
| Matchcode | Matchcode NVARCHAR (100) Index |
Internal name for search and listings | |
| BusinessUnitID | Geschaeftsbereich SMALLINT Index |
Business Untis | MARIBusinessUnitMaster.BusinessUnitID |
| ProjectType | Projekttyp SMALLINT Index |
CustomerProjects=1, Internal Projects=2, Vacation Projects=3, Template Projects=4, Internal Projects with Contracts=5, Preliminary projects=6, Flextime Projects=7, Absense, Illness=8 | MARISettingTypes.ProjectType (WHERE TypTyp=4) clsImportProject_eProjectType |
| InternalProject | ProjektIntern SMALLINT |
1=Vacation, 2=Illness, 3=Flextime, 10=Others | clsImportProject_eProjectAbsenseType |
| ProjectGroup2 | Projektgruppe INT |
Project Group (GruppenArt=10000) | MARIProjectGroups.ProjectGroup2 (WHERE GruppenArt=10000) clsImportGroups_eGroupType |
| ProjectGroup3 | Umsatzgruppe INT |
Project Group (GruppenArt=10003) | MARIProjectGroups.ProjectGroup3 (WHERE GruppenArt=10003) clsImportGroups_eGroupType |
| ProjectGroup1 | StratGeschFeld INT |
Project Group (GruppenArt=1) | MARIProjectGroups.ProjectGroup1 (WHERE GruppenArt=1) clsImportGroups_eGroupType |
| ProjectGroup5 | Bundesland INT |
Project Group (GruppenArt=2) | MARIProjectGroups.ProjectGroup5 (WHERE GruppenArt=2) clsImportGroups_eGroupType |
| ProjectGroup4 | Groessenklasse INT |
Project Group (GruppenArt=3) | MARIProjectGroups.ProjectGroup4 (WHERE GruppenArt=3) clsImportGroups_eGroupType |
| GroupLink | Gruppenzuordnung INT |
Not used | |
| ProjectCode | Kostentraeger NVARCHAR (20) |
SBO Project Code | OPRJ.PrjCode |
| OcrCode1 | OcrCode1 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| ActiveType | AktivTyp TINYINT Index |
Open for time bookings, 1=Active, 10=blocked | clsImportProject_eProjektActiveType |
| OrderProbability | AuftragsWahrscheinlichkeit Single |
Percentage for preliminary projects | |
| WorkgroupHandling | BuchungsTeilnahme SMALLINT |
0=All employees, 1=Only employees from workgroup | |
| BoockingBlockUntil | ErfassungsSperreBis Datetime |
Additional booking block date | |
| ProjectStatus | ProjektStatus SMALLINT |
Last Project Status | MARIProjectStatus.ProjectStatus clsImportProject_eProjectStatus |
| PlanningVersion | Planungsversion INT Index |
Last Planning Version | MARIProjectPlanningVersions.PlanningVersion |
| PlanningMethod | Planungsmethode INT |
Planning Method: 0=Fixed Three Planning versions, 1=Delta Planning, 2=MSProject | |
| PlanningVersionForApproval | PlanningVersionForApproval INT |
||
| DegreeOfCompletion | Fertigstellungsgrad Single |
Degree of Compleation | |
| ProjectGroup6 | Gruppe6 INT |
Project Group (GruppenArt=6) | MARIProjectGroups.ProjectGroup6 (WHERE GruppenArt=6) clsImportGroups_eGroupType |
| ProjectGroup7 | Gruppe7 INT |
Project Group (GruppenArt=7) | MARIProjectGroups.ProjectGroup7 (WHERE GruppenArt=7) clsImportGroups_eGroupType |
| ProjectGroup8 | Gruppe8 INT |
Project Group (GruppenArt=8) | MARIProjectGroups.ProjectGroup8 (WHERE GruppenArt=8) clsImportGroups_eGroupType |
| ProjectGroup9 | Gruppe9 INT |
Project Group (GruppenArt=9) | MARIProjectGroups.ProjectGroup9 (WHERE GruppenArt=9) clsImportGroups_eGroupType |
| ProjectGroup10 | Gruppe10 INT |
Project Group (GruppenArt=10) | MARIProjectGroups.ProjectGroup10 (WHERE GruppenArt=10) clsImportGroups_eGroupType |
| StartDate | Startdatum Datetime |
Start date of the project | |
| EndDate | Enddatum Datetime |
End date of the project | |
| Validity | BebuchbarBis INT |
Maximum time booking period | |
| PlanningCalendar | PlanungsKalender INT |
Planning calendar, if not based on business unit | MARICalendar.PlanningCalendar |
| ProjectMemo | ProjektMemo NTEXT |
Memo for the project | |
| ProjektMemoLevel | ProjektMemoLevel SMALLINT |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| ProjectPhaseStatus | ProjectPhaseStatus INT |
||
| ReferencePhase | ReferenzPhase INT |
Reference Phase for the internal akquisition project | MARIProjectPhases.ReferencePhase |
| Assessment | BewertungsMode INT |
Work In Progress Assessment Method | MARIWorkInProgressDefinition.Assessment |
| DocumentPath | Sammelmappenverzeichnis NVARCHAR (255) |
Standard path for project documents | |
| ProjectHomePage | ProjektHomePage NVARCHAR (255) |
Homepage for the project | |
| LocationID | LocationID INT |
MARILocation.LocationID | |
| ApprovalMode | FreigabeMode INT |
||
| PlanningWorkflowID | PlanungsWorkflowID INT |
MARISupportWorkflow.PlanningWorkflowID | |
| PhaseWorkFlowID | PhasenWorkFlowID INT Index |
MARISupportWorkflow.PhaseWorkFlowID | |
| ProjectStatusWorkFlowID | ProjektStatusWorkFlowID INT |
MARISupportWorkflow.ProjectStatusWorkFlowID | |
| EmployeeLinkMode | EmployeeLinkMode INT |
||
| EmployeeLinkDefault | EmployeeLinkDefault INT |
||
| MSTeamsLink | MSTeamsLink 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) | |
| HidePageFlag | HidePageFlag BIGINT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MARIPurchaseImportDocumentPos2POProcessPos | Purchase Order: Import external documents (Link to PO Process lines) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIPurchaseProcess | Purchase Process: Header | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportIssue | Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks
The type of ticket is defined by the field HotlineClassType.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportProduct | Support Module: Support Product: Master Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportProductCustomer | Support Module: Support Product: Customer Product Link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportContracts | Support Module: Support Contracts (not used) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIMSProjectDatabases | MS Project Interface: Database Link (MSP Server) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIMSProjectImports | MS Project Interface: Import log | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIMSProjectPhases | MS Project Interface: Phase/task link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEmployeesProjectLinks | Employee Master: Project link (standard vacation project...) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEmployeeVacationRequest | Vacation Management: Vacation Request and Approval | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEmployeeCostRatesProject | Employee Master: Cost Rates per project for freelancers | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIAttendanceAction | Attendance: Actions "in the door" (Lines per day) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectWorkGroup | Project Master: Work group | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectCustomerLink | Project Master: Customer Link | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPlanningResource | Planning: Filter list for plannable resources (ex. G/L Accounts) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPlanningVersions | Project Master: Planning versions linked to a project | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPlanningLines | Planning: Master Planning lines | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectTravelExpenseRules | Travel Expenses Module: Properties by Project | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectTravelExpenseTemplates | Travel Expenses Module: Properties by Project | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectManager | Project Master: Linked project manager | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectStatus | Project Master: status history | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITravelTripProjectLink | Travel Expenses Module: Business Trip Project Link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITravelTripLineProject | Travel Expenses Module: Trip receipt project line for invoice | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITempReportDocumentHeader | Reporting: Temporary Table: Document Header | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITempReportDocumentPos | Reporting: Temporary Table: Document Positions | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITempReportProjectPhaseService | Reporting: Temporary Table: Project Phase Service | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITempReportProjectPhase | Reporting: Temporary Table: Project Phase Report | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContract | Contract Management: Contract Master Data + Service Master Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContractPosition2POPosition | Contract Management: Contract position to PO position link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEquipmentCategory | EquipmentCategory: Cagetory Master | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEquipmentDetails | Equipment: Master Data "date from" based | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectMasterWorkInProgess | Project Master: Save degree of compleation for each month | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIAttendanceActionArchive | Attendance: Actions "in the door" (Lines per day) History | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingExams | Training Module: List of exams | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingRegistration | Training Module: Registratrion to training cources | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPhaseStatusHistory | Stores the phase stauts of a project | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEquipmentLocation | Equipment: Current Location of this equipment | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIChefInfoCashFlowRunLine | Info Screen Management: Stored line data per run | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIChefInfoCashFlowRunProject | Info Screen Management: Status of a project | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIDocumentDraftHeadLink | Linked contracts and purchase processes | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIDocumentInvoiceFlow | InvoicePaymentReportStore | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingRegistrationTeam | Training Module: Team for the training | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITimeBookingActivityTracker | Table to store activities, before they are linked to time bookings | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPlanningLinesLog | Planning: Master Planning lines History | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPhaseDegreeOfCompletion | Project Phases Master: Degree OF Completion History | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectPlanningLog | Planning: Log Phase dependency changes | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectMeasurementStructureProject | Measurement strucutre definition: Link to project | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContainer | Definition of a container carrying other goods | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContainerLocation | Current location of a container | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContractCustomerDocuments | Drawings to be created for the customer |