PM
PMCostProjection
Contains the main properties of a cost projection revision. Cost projections are used for tracking the project costs during project completion in comparison to the initially estimated costs. The records of this type are created and edited through the Cost Projection (PM305000) form (which corresponds to the CostProjectionEntry graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Approved | bit | - | ||
Description:A Boolean value that indicates (if set to true) that the cost projection revision is approved. | ||||
ClassID | nvarchar(30) | Cost Projection Class | PMCostProjectionClass | |
Description:The cost projection class of the cost projection revision. The value of this field corresponds to the value of the PMCostProjectionClass.ClassID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
Date | datetime | Revision Date | - | |
Description:The date when the cost projection revision was created. | ||||
Description | nvarchar(255) | Description | - | |
Description:The description of the cost projection revision. | ||||
FormCaptionDescriptionNonexistent in DB | string | - | ||
Description:The description of the corresponding project. | ||||
Hold | bit | Hold | - | |
Description:A Boolean value that indicates (if set to true) that the cost projection revision is on hold. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:The number of lines in the cost projection revision which is used to set the default value of the PMCostProjectionLine.LineNbr field. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:The Employee responsible for the document. The value of this field corresponds to the BAccount.BAccountID field. | ||||
ProjectID | int | Project | PMProject | |
Description:The project for which the cost projection revision is created. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
Rejected | bit | - | ||
Description:A Boolean value that indicates (if set to true) that the cost projection revision is rejected. | ||||
Released | bit | Released | - | |
Description:A Boolean value that indicates (if set to true) that the cost projection revision is released. | ||||
RevisionID | nvarchar(30) | Revision | - | |
Description:The revision identifier of the cost projection. | ||||
Status | char(1) | Status | - | |
Description:The status of the cost projection revision. The field can have one of the values described in CostProjectionStatus.ListAttribute. | ||||
TotalActualAmount | decimal | Total Actual Amount | - | |
Description:The sum of PMCostProjectionLine.ActualAmount. | ||||
TotalActualQuantity | decimal | Total Actual Quantity | - | |
Description:The sum of PMCostProjectionLine.ActualQuantity. | ||||
TotalAmount | decimal | Projected Cost to Complete | - | |
Description:The sum of PMCostProjectionLine.Amount. | ||||
TotalAmountToComplete | decimal | Budgeted Cost to Complete | - | |
Description:The sum of PMCostProjectionLine.AmountToComplete. | ||||
TotalBudgetedAmount | decimal | Budgeted Cost at Completion | - | |
Description:The sum of PMCostProjectionLine.BudgetedAmount. | ||||
TotalBudgetedQuantity | decimal | Total Budgeted Quantity | - | |
Description:The sum of PMCostProjectionLine.BudgetedQuantity. | ||||
TotalProjectedAmount | decimal | Projected Cost at Completion | - | |
Description:The sum of PMCostProjectionLine.ProjectedAmount. | ||||
TotalProjectedQuantity | decimal | Total Projected Quantity at Completion | - | |
Description:The sum of PMCostProjectionLine.ProjectedQuantity. | ||||
TotalQuantity | decimal | Total Projected Quantity to Complete | - | |
Description:The sum of PMCostProjectionLine.Quantity. | ||||
TotalQuantityToComplete | decimal | Quantity to Complete | - | |
Description:The sum of PMCostProjectionLine.QuantityToComplete. | ||||
TotalUnbilledAmount | decimal | Total Unbilled Amount | - | |
Description:The sum of PMCostProjectionLine.UnbilledAmount. | ||||
TotalUnbilledQuantity | decimal | Total Unbilled Quantity | - | |
Description:The sum of PMCostProjectionLine.UnbilledQuantity. | ||||
TotalVarianceAmount | decimal | Cost Variance | - | |
Description:The sum of PMCostProjectionLine.VarianceAmount. | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:The workgroup that is responsible for the document. The value of this field corresponds to the EPCompanyTree.WorkGroupID field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||