| Table Name: | MPProjektPlanungsZeilen |
| View Name: | MARIProjectPlanningLines |
| Group: | Group: ProjectMaster |
| Description: | Planning: Master Planning lines |
| ClassID: | 204. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| PlanungsZeilenID | PlanningLineID INT Primary |
Unique ID for details | |
| ZusammenhaengendeZeilenID | ConnectingLineID INT Index |
ID to keep a bar in gantt together | MPProjektPlanungsZeilen.PlanungsZeilenID |
| PlanungsTyp | PlanningType SMALLINT |
1=Period Planning, 2=Day Planning, 3=Overall Planning, 4=Reservation Planning (Equipment) | clsImportPlanning_ePlanningType |
| Periode | Period INT Index |
MPPerioden.PeriodeJahr | |
| Projektnummer | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| Planungsversion | PlanningVersion INT Index |
MPProjektPlanungsversion.Planungsversion | |
| Plantermin | DateFrom Datetime Index |
||
| PlanterminBis | DateTo Datetime Index |
||
| Beginn | TimeFrom Datetime |
||
| Ende | TimeTo Datetime |
||
| PhasenID | PhaseID INT Index |
MPProjektPhasen.PhasenID | |
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| Vertragsposition | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| Leistungsnummer | ServiceNumber NVARCHAR (20) Index |
MPLeistung.Leistungsnummer | |
| EKVorgangsID | PurchaseProcessID INT |
MPEKVertraege.VertragsID | |
| EKVorgangsposition | PurchaseProcessPositionID INT |
MPEKVertraegePositionen.Vertragsposition | |
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Aktivitaet | PlanningText NVARCHAR (100) |
||
| Ressource | CostAccount NVARCHAR (50) Index |
||
| RessourceTyp | ResourceType 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 |
| Menge | Quantity NUMERIC(19,6) |
||
| MengeTage | WorkingDays NUMERIC(19,6) |
||
| MengeFak | InvQty NUMERIC(19,6) |
||
| MengeTageFak | QtyDaysInv NUMERIC(19,6) |
||
| MengeMonate | QtyMonth NUMERIC(19,6) |
||
| MengeBestaetigt | QtyCommited NUMERIC(19,6) |
||
| Kosten | Costs NUMERIC(19,6) |
||
| Erloese | TargetedRevenues NUMERIC(19,6) |
||
| MengeRessourcen | NumberOfEmployees NUMERIC(19,6) |
||
| ReferenzZeilenID | ReferenceLineID INT Index |
||
| KalenderMode | CalendarMode SMALLINT |
clsImportPlanning_eCalendarMode | |
| BestaetigtID | AcknowledgeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| BestaetigtDatum | AcknowledgeDate Datetime |
||
| ReferenzRessource | ReferenceResource NVARCHAR (50) |
||
| ReferenzRessourcenTyp | ReferenceResourceType INT |
See RessourceType | clsImportPlanning_ePlanningResourceType |
| QuellTyp | SourceType INT |
0=Normal, 1=DeltaPlanning, 2=FromDeltaPlanning, 3=PurchaseOrder, 4=WorkItem | |
| QuellPlanungsVersion | SourceKey INT |
Source Key based on the SourceType | |
| ErfassMode | CreateMode SMALLINT |
||
| VerteilMode | SpreadMode INT |
||
| AnteilVomTag | PartOfTheDay NUMERIC(19,6) |
||
| Memo | Memo NTEXT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPExchangeSyncLine | MS Exchange Server Link Planning Line |
| MPPersonenUrlaubsAntrag | Vacation Management: Vacation Request and Approval |
| MPProjektPlanungsZeilen | Planning: Master Planning lines |
| MPProjektPlanungsZeilenLog | Planning: Master Planning lines History |