Skip to main content
PM

PMCostProjection

PX.Objects.PM
Field NameTypeDisplay NameForeign Key
ProjectIDDefault Navigation
intProjectPMProject
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.
RevisionIDDefault Navigation
nvarchar(30)Revision-
Description:The revision identifier of the cost projection.
Approved
bit-
Description:A Boolean value that indicates (if set to ) that the cost projection revision is approved.
ClassIDDefault Navigation
nvarchar(30)Cost Projection ClassPMCostProjectionClass
Description:The cost projection class of the cost projection revision. The value of this field corresponds to the value of the PMCostProjectionClass.ClassID field.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
Date
datetimeRevision Date-
Description:The date when the cost projection revision was created.
Description
nvarchar(255)Description-
Description:The description of the cost projection revision.
Hold
bitHold-
Description:A Boolean value that indicates (if set to ) that the cost projection revision is on hold.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast 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
OwnerIDDefault Navigation
intOwnerContact
Description:The Employee responsible for the document. The value of this field corresponds to the BAccount.BAccountID field.
Rejected
bit-
Description:A Boolean value that indicates (if set to ) that the cost projection revision is rejected.
Released
bitReleased-
Description:A Boolean value that indicates (if set to ) that the cost projection revision is released.
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(19, 4)Total Actual Amount-
Description:The sum of PMCostProjectionLine.ActualAmount.
TotalActualQuantity
decimal(19, 6)Total Actual Quantity-
Description:The sum of PMCostProjectionLine.ActualQuantity.
TotalAmount
decimal(19, 4)Projected Cost to Complete-
Description:The sum of PMCostProjectionLine.Amount.
TotalAmountToComplete
decimal(19, 4)Budgeted Cost to Complete-
Description:The sum of PMCostProjectionLine.AmountToComplete.
TotalBudgetedAmount
decimal(19, 4)Budgeted Cost at Completion-
Description:The sum of PMCostProjectionLine.BudgetedAmount.
TotalBudgetedQuantity
decimal(19, 6)Total Budgeted Quantity-
Description:The sum of PMCostProjectionLine.BudgetedQuantity.
TotalProjectedAmount
decimal(19, 4)Projected Cost at Completion-
Description:The sum of PMCostProjectionLine.ProjectedAmount.
TotalProjectedQuantity
decimal(19, 6)Total Projected Quantity at Completion-
Description:The sum of PMCostProjectionLine.ProjectedQuantity.
TotalQuantity
decimal(19, 6)Total Projected Quantity to Complete-
Description:The sum of PMCostProjectionLine.Quantity.
TotalQuantityToComplete
decimal(19, 6)Quantity to Complete-
Description:The sum of PMCostProjectionLine.QuantityToComplete.
TotalUnbilledAmount
decimal(19, 4)Total Unbilled Amount-
Description:The sum of PMCostProjectionLine.UnbilledAmount.
TotalUnbilledQuantity
decimal(19, 6)Total Unbilled Quantity-
Description:The sum of PMCostProjectionLine.UnbilledQuantity.
TotalVarianceAmount
decimal(19, 4)Cost Variance-
Description:The sum of PMCostProjectionLine.VarianceAmount.
tstamp
timestamp-
Description:No description available
WorkgroupIDDefault Navigation
intWorkgroupEPCompanyTree
Description:The workgroup that is responsible for the document. The value of this field corresponds to the EPCompanyTree.WorkGroupID field.