PMCostProjectionByDateLine

PX.Objects.PMRelease 2026.1

Represents a line of a date-sensitive cost projection. The records of this type are created and edited through the Cost Projection By Date (PM305500) form (which corresponds to the ProjectCostProjectionByDateEntry graph).

Select a row for its description 80 of 80 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountGroupID`Default Navigation	`int`	Account Group	PMAccountGroup
Description:The identifier of the project account group. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
	`ActualAmount`	`decimal`		-
Description:The total amount of the released project cost transactions for particular date in base currency.
	`ActualQty`	`decimal`	Actual Quantity to Date	-
Description:The actual quantity of the released project cost transactions for the cost projection line as of the projection date.
	`ActualUnitRate`	`decimal`		-
Description:The actual unit rate calculated by dividing ActualAmount by ActualQty. The rate is in the base currency of the tenant.
	`AmountToComplete`	`decimal`		-
Description:The projected remainder of the budgeted cost for the cost budget line in base currency.
	`AnticipatedPerformance`Nonexistent in DB	`decimal?`	Anticipated Performance (%)	-
Description:The anticipated performance percent, which is the result of dividing CuryCompletedAmount by CuryBudgetedAmount, multiplied by 100%.
	`AnticipatedQty`Nonexistent in DB	`decimal?`	Anticipated Quantity	-
Description:The anticipated total quantity, which is the sum of ActualQty, OpenCommittedQty, and PendingCOCommittedQty.
	`AnticipatedQtyPerformance`Nonexistent in DB	`decimal?`	Anticipated Quantity Performance (%)	-
Description:The anticipated quantity performance percentage, calculated by dividing AnticipatedQty by the sum of RevisedBudgetedQty and PendingCOQty, multiplied by 100%.
	`AnticipatedUnitRate`Nonexistent in DB	`decimal?`		-
Description:The anticipated unit rate in the base currency of the tenant.
	`BudgetBacklogAmount`Nonexistent in DB	`decimal?`		-
Description:The difference between BudgetedAmount and ActualAmount.
	`BudgetRevisedQty`	`decimal`		-
Description:The revised budgeted quantity from the corresponding cost budget line, which consists of the original budgeted quantity and the quantity from all released change orders with the date before PMCostProjectionByDate.ProjectionDate. If change order workflow is not activated, this field contains the revised budget quantity from the corresponding line of the project cost budget.
	`BudgetedAmount`	`decimal`		-
Description:The revised budgeted cost, which consists of the original budgeted cost and the cost of all released change orders with the date before ProjectionDate that corresponds to the line. If change order workflow is not activated, the field contains the revised budget from the corresponding line of the project cost budget. The revised budget cost is in the base currency.
	`CalculateByQuantity`	`bit`	Calculate by Quantity	-
Description:A Boolean value that indicates (if set to true) that the projected cost is calculated based on the quantity multiplied by the unit cost. If the value is set to false, the projected cost is calculated using the amount values directly.
	`ChangeOrderAmount`	`decimal`		-
Description:The total amount of the project cost in the lines of a change order for particular date. The amount is in the base currency.
	`ChangeOrderQty`	`decimal`		-
Description:The total quantity from all released change orders with the date before PMCostProjectionByDate.ProjectionDate.
	`CommitmentOpenAmount`	`decimal`		-
Description:The total amount of the project open commitments for particular date in base currency.
	`CompletedAmount`Nonexistent in DB	`decimal?`		-
Description:The sum of ActualAmount and CommitmentOpenAmount.
	`CompletedPct`	`decimal`	Completed (%)	-
Description:The projected percentage of completion for the cost budget line.
	`CompletedQtyPct`	`decimal`	Completed by Quantity (%)	-
Description:The percentage of completion based on quantity, calculated by dividing ActualQty by RevisedBudgetedQty, multiplied by 100%.
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The identifier of the project cost code. The value of this field corresponds to the value of the PMCostCode.CostCodeID field.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CuryActualAmount`	`decimal`	Actual Cost to Date	-
Description:The total amount of the released project cost transactions for particular date.
	`CuryActualUnitRate`	`decimal`	Actual Unit Rate to Date	-
Description:The actual unit rate calculated by dividing CuryActualAmount by ActualQty. The rate is in the project currency.
	`CuryAmountToComplete`	`decimal`	Projected Cost to Complete	-
Description:The projected remainder of the budgeted cost for the cost budget line.
	`CuryAnticipatedUnitRate`Nonexistent in DB	`decimal?`	Anticipated Unit Rate	-
Description:The anticipated unit rate, calculated by dividing CuryCompletedAmount by AnticipatedQty. The rate is in the project currency.
	`CuryBudgetBacklogAmount`Nonexistent in DB	`decimal?`	Cost Budget Backlog	-
Description:The difference between CuryBudgetedAmount and CuryActualAmount.
	`CuryBudgetedAmount`	`decimal`	Revised Budgeted Cost	-
Description:The revised budgeted cost, which consists of the original budgeted cost and the cost of all released change orders with the date before ProjectionDate that corresponds to the line. If change order workflow is not activated, the field contains the revised budget from the corresponding line of the project cost budget. The revised budget cost is in the project currency.
	`CuryChangeOrderAmount`	`decimal`		-
Description:The total amount of the project cost in the lines of a change order for particular date.
	`CuryCommitmentOpenAmount`	`decimal`	Open Commitments	-
Description:The total amount of the project open commitments for particular date.
	`CuryCompletedAmount`Nonexistent in DB	`decimal?`	Anticipated Cost	-
Description:The sum of CuryActualAmount and CuryCommitmentOpenAmount.
	`CuryOpenCommittedUnitRate`	`decimal`	Open Committed Unit Rate	-
Description:The unit rate for open commitments, calculated by dividing CuryCommitmentOpenAmount by OpenCommittedQty. The rate is in the project currency.
	`CuryOriginalBudgetedAmount`	`decimal`		-
Description:The original budgeted cost of the corresponding cost budget line specified in the project.
	`CuryPendingCOCommittedUnitRate`	`decimal`	Pending CO Committed Unit Rate	-
Description:The committed unit rate for pending change orders, calculated by dividing CuryPendingCommitmentAmount by PendingCOCommittedQty. The rate is in the project currency.
	`CuryPendingCOUnitRate`	`decimal`	Pending CO Unit Rate	-
Description:The unit rate for pending change orders, calculated by dividing CuryPendingChangeOrderAmount by PendingCOQty. The rate is in the project currency.
	`CuryPendingChangeOrderAmount`	`decimal`	Pending CO Cost	-
Description:The total amount of the pending project cost in the lines of a change order for particular date.
	`CuryPendingCommitmentAmount`	`decimal`	Pending CO Commitments	-
Description:The total amount of the project pending commitments for particular date.
	`CuryProjectedAmount`	`decimal`	Projected Cost at Completion	-
Description:The projected final cost at the moment of project completion for the cost budget line.
	`CuryProjectedCostVariance`Nonexistent in DB	`decimal?`	Projected Cost Variance	-
Description:The projected cost variance, calculated as the difference between CuryProjectedAmount and CuryBudgetedAmount. A positive value indicates that the projected cost at completion exceeds the budgeted cost. The variance is in the project currency.
	`CuryProjectedUnitRate`	`decimal`	Projected Unit Rate at Completion	-
Description:The projected unit rate at completion, calculated by dividing CuryProjectedAmount by ProjectedQty. The rate is in the project currency.
	`CuryRevisedBudgetedAmount`	`decimal`		-
Description:The revised budgeted cost of the corresponding cost budget line specified in the project.
	`CuryRevisedBudgetedUnitRate`	`decimal`	Revised Budgeted Unit Rate	-
Description:The revised budgeted unit rate, calculated by dividing CuryRevisedBudgetedAmount by RevisedBudgetedQty. The rate is in the project currency.
	`CuryToCompleteUnitRate`	`decimal`	Projected Unit Rate to Complete	-
Description:The projected unit rate for the remaining quantity to complete the cost budget line. The rate is in the project currency.
	`Description`	`nvarchar(256)`	Description	-
Description:The description of the cost projection line.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:The identifier of the inventory item. The value of this field corresponds to the value of the InventoryItem.InventoryID field.
	`IsHeader`Nonexistent in DB	`bool?`		-
Description:A Boolean value that indicates (if set to true) that the line represents a totals row rather than an actual cost projection line. The value of this field is set by the ProjectCostProjectionByDateEntry graph.
	`LastModifiedByID`Default Navigation	`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
	`LineNbr`	`int`	Line Nbr.	-
Description:The number of the cost projection line.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OpenCommittedQty`	`decimal`	Open Committed Quantity	-
Description:The total quantity from open commitments for the cost projection line.
	`OpenCommittedUnitRate`	`decimal`		-
Description:The unit rate for open commitments, calculated by dividing CommitmentOpenAmount by OpenCommittedQty. The rate is in the base currency of the tenant.
	`OriginalBudgetedAmount`	`decimal`		-
Description:The original budgeted cost of the corresponding cost budget line specified in the project in base currency.
	`OriginalBudgetedQty`	`decimal`		-
Description:The original budgeted quantity from the corresponding cost budget line specified in the project.
	`PendingCOCommittedQty`	`decimal`	Pending CO Committed Quantity	-
Description:The pending change order committed quantity for the cost projection line.
	`PendingCOCommittedUnitRate`	`decimal`		-
Description:The committed unit rate for pending change orders, calculated by dividing PendingCommitmentAmount by PendingCOCommittedQty. The rate is in the base currency of the tenant.
	`PendingCOQty`	`decimal`	Pending CO Quantity	-
Description:The pending change order quantity for the cost projection line.
	`PendingCOUnitRate`	`decimal`		-
Description:The unit rate for pending change orders, calculated by dividing PendingChangeOrderAmount by PendingCOQty. The rate is in the base currency of the tenant.
	`PendingChangeOrderAmount`	`decimal`		-
Description:The total amount of the pending project cost in the lines of a change order for particular date. The amount is in the base currency.
	`PendingCommitmentAmount`	`decimal`		-
Description:The total amount of the project pending commitments for particular date in base currency.
	`Performance`Nonexistent in DB	`decimal?`	Performance (%)	-
Description:The performance percent, which is the result of dividing CuryActualAmount by CuryBudgetedAmount, multiplied by 100%.
	`ProjectID`	`int`		PMProject
Description:The project for which the cost projection line is created. The value of this field corresponds to the value of the PMProject.ContractID field.
	`ProjectTaskID`Default Navigation	`int`	Project Task	PMTask
Description:The identifier of the project task. The value of this field corresponds to the value of the PMTask.taskID field.
	`ProjectedAmount`	`decimal`		-
Description:The projected final cost at the moment of project completion for the cost budget line in base currency.
	`ProjectedCostVariance`Nonexistent in DB	`decimal?`		-
Description:The projected cost variance, calculated as the difference between ProjectedAmount and BudgetedAmount. A positive value indicates that the projected cost at completion exceeds the budgeted cost. The variance is in the base currency of the tenant.
	`ProjectedQty`	`decimal`	Projected Quantity at Completion	-
Description:The projected total quantity at completion, which is calculated by summing ActualQty and ToCompleteQty.
	`ProjectedQtyVariance`Nonexistent in DB	`decimal?`	Projected Quantity Variance	-
Description:The projected quantity variance, calculated as the difference between ProjectedQty and RevisedBudgetedQty. A positive value indicates that the projected quantity at completion exceeds the budgeted quantity.
	`ProjectedUnitRate`	`decimal`		-
Description:The projected unit rate at completion, calculated by dividing ProjectedAmount by ProjectedQty. The rate is in the base currency of the tenant.
	`QtyPerformance`Nonexistent in DB	`decimal?`	Quantity Performance (%)	-
Description:The quantity performance percentage, calculated by dividing ActualQty by the sum of RevisedBudgetedQty and PendingCOQty, multiplied by 100%.
	`RefNbr`	`nvarchar(30)`	Number	PMCostProjectionByDate
Description:The projection document identifier.
	`RevisedBudgetedAmount`	`decimal`		-
Description:The revised budgeted cost of the corresponding cost budget line specified in the project in base currency.
	`RevisedBudgetedQty`	`decimal`	Revised Budgeted Quantity	-
Description:The revised budgeted quantity for the cost projection line, which consists of the original budgeted quantity and the quantity from all released change orders.
	`RevisedBudgetedUnitRate`	`decimal`		-
Description:The revised budgeted unit rate, calculated by dividing RevisedBudgetedAmount by RevisedBudgetedQty. The rate is in the base currency of the tenant.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`ToCompleteQty`	`decimal`	Projected Quantity to Complete	-
Description:The projected quantity remaining to complete the cost budget line.
	`ToCompleteUnitRate`	`decimal`		-
Description:The projected unit rate for the remaining quantity to complete the cost budget line. The rate is in the base currency of the tenant.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure of the cost projection line. The value of this field corresponds to the value of the INUnit.FromUnit field.
	`tstamp`	`timestamp`		-
Description:No description available