| View Name: | MARIProjectPlanningLines |
| Based on table: | MPProjektPlanungsZeilen |
| Group: | Group: ProjectMaster |
| Description: | Planning: Master Planning lines |
| ClassID: | 204. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PlanningLineID | PlanungsZeilenID INT Primary |
Unique ID for details | |
| ConnectingLineID | ZusammenhaengendeZeilenID INT Index |
ID to keep a bar in gantt together | MARIProjectPlanningLines.ConnectingLineID |
| PlanningType | PlanungsTyp SMALLINT |
1=Period Planning, 2=Day Planning, 3=Overall Planning, 4=Reservation Planning (Equipment) | clsImportPlanning_ePlanningType |
| Period | Periode INT Index |
MARIPeriods.Period | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PlanningVersion | Planungsversion INT Index |
MARIProjectPlanningVersions.PlanningVersion | |
| DateFrom | Plantermin Datetime Index |
||
| DateTo | PlanterminBis Datetime Index |
||
| TimeFrom | Beginn Datetime |
||
| TimeTo | Ende Datetime |
||
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT |
MARIContractPositions.ContractPositionID | |
| ServiceNumber | Leistungsnummer NVARCHAR (20) Index |
MARIServices.ServiceNumber | |
| PurchaseProcessID | EKVorgangsID INT |
MARIPurchaseProcess.PurchaseProcessID | |
| PurchaseProcessPositionID | EKVorgangsposition INT |
MARIPurchaseProcessPositions.PurchaseProcessPositionID | |
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| PlanningText | Aktivitaet NVARCHAR (100) |
||
| CostAccount | Ressource NVARCHAR (50) Index |
||
| ResourceType | RessourceTyp SMALLINT Index |
1=Employee, 2=GLAccount, 3=Pool, 4=Item, 5=TravelExpense, 6=MileStone, 7=StandardPool, 8=EquipmentCategoryTime, 9=EquipmentCategoryCost, 10=EquipmentMasterTime, 11=EquipmentMasterCost | clsImportPlanning_ePlanningResourceType |
| Quantity | Menge NUMERIC(19,6) |
||
| WorkingDays | MengeTage NUMERIC(19,6) |
||
| InvQty | MengeFak NUMERIC(19,6) |
||
| QtyDaysInv | MengeTageFak NUMERIC(19,6) |
||
| QtyMonth | MengeMonate NUMERIC(19,6) |
||
| QtyCommited | MengeBestaetigt NUMERIC(19,6) |
||
| Costs | Kosten NUMERIC(19,6) |
||
| TargetedRevenues | Erloese NUMERIC(19,6) |
||
| NumberOfEmployees | MengeRessourcen NUMERIC(19,6) |
||
| ReferenceLineID | ReferenzZeilenID INT Index |
||
| CalendarMode | KalenderMode SMALLINT |
clsImportPlanning_eCalendarMode | |
| AcknowledgeUser | BestaetigtID NVARCHAR (4) |
MARIUser.AcknowledgeUser (WHERE BenutzerTyp=1) | |
| AcknowledgeDate | BestaetigtDatum Datetime |
||
| ReferenceResource | ReferenzRessource NVARCHAR (50) |
||
| ReferenceResourceType | ReferenzRessourcenTyp INT |
See RessourceType | clsImportPlanning_ePlanningResourceType |
| SourceType | QuellTyp INT |
0=Normal, 1=DeltaPlanning, 2=FromDeltaPlanning, 3=PurchaseOrder, 4=WorkItem | |
| SourceKey | QuellPlanungsVersion INT |
Source Key based on the SourceType | |
| CreateMode | ErfassMode SMALLINT |
||
| SpreadMode | VerteilMode INT |
||
| PartOfTheDay | AnteilVomTag NUMERIC(19,6) |
||
| 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) | |
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIEmployeeVacationRequest | Vacation Management: Vacation Request and Approval |
| MARIProjectPlanningLines | Planning: Master Planning lines |
| MARIMPExchangeSyncLine | MS Exchange Server Link Planning Line |
| MARIProjectPlanningLinesLog | Planning: Master Planning lines History |