| View Name: | MARIProjectPlanningLinesLog |
| Based on table: | MPProjektPlanungsZeilenLog |
| Group: | Group: ProjectMaster |
| Description: | Planning: Master Planning lines History |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PlanningLineLogID | PlanungsZeilenLogID INT Primary |
||
| AppID | AppID INT |
||
| PlanningLineID | PlanungsZeilenID INT |
MARIProjectPlanningLines.PlanningLineID | |
| ConnectingLineID | ZusammenhaengendeZeilenID INT |
MARIProjectPlanningLines.ConnectingLineID | |
| PlanningType | PlanungsTyp SMALLINT |
||
| Period | Periode INT Index |
MARIPeriods.Period | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PlanningVersion | Planungsversion INT Index |
MARIProjectPlanningVersions.PlanningVersion | |
| DateFrom | Plantermin Datetime |
||
| DateTo | PlanterminBis Datetime |
||
| TimeFrom | Beginn Datetime |
||
| TimeTo | Ende Datetime |
||
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| ContractID | VertragsID INT |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT |
MARIContractPositions.ContractPositionID | |
| PurchaseProcessID | EKVorgangsID INT |
MARIPurchaseProcess.PurchaseProcessID | |
| PurchaseProcessPositionID | EKVorgangsposition INT |
MARIPurchaseProcessPositions.PurchaseProcessPositionID | |
| ServiceNumber | Leistungsnummer NVARCHAR (20) Index |
MARIServices.ServiceNumber | |
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| PlanningText | Aktivitaet NVARCHAR (100) |
||
| CostAccount | Ressource NVARCHAR (50) Index |
||
| ResourceType | RessourceTyp SMALLINT Index |
||
| 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 |
||
| CalendarMode | KalenderMode SMALLINT |
||
| AcknowledgeUser | BestaetigtID NVARCHAR (4) |
MARIUser.AcknowledgeUser | |
| AcknowledgeDate | BestaetigtDatum Datetime |
||
| ReferenceResource | ReferenzRessource NVARCHAR (50) |
||
| ReferenceResourceType | ReferenzRessourcenTyp INT |
||
| SourceType | QuellTyp INT |
||
| SourceKey | QuellPlanungsVersion INT |
||
| 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 |