PMCostProjectionByDateLine

PX.Objects.PM

41 of 41 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`	Line Nbr.	-
Description:The number of the cost projection line.
	`RefNbr`	`nvarchar(30)`	Number	PMCostProjectionByDate
Description:The projection document identifier.
	`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(19, 4)`		-
Description:The total amount of the released project cost transactions for particular date in base currency.
	`AmountToComplete`	`decimal(19, 4)`		-
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%.
	`BudgetBacklogAmount`Nonexistent in DB	`decimal`		-
Description:The difference between BudgetedAmount and ActualAmount.
	`BudgetedAmount`	`decimal(19, 4)`		-
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.
	`ChangeOrderAmount`	`decimal(19, 4)`		-
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.
	`CommitmentOpenAmount`	`decimal(19, 4)`		-
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(19, 4)`	Completed (%)	-
Description:The projected percentage of completion for the cost budget line.
	`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(19, 4)`	Actual Cost to Date	-
Description:The total amount of the released project cost transactions for particular date.
	`CuryAmountToComplete`	`decimal(19, 4)`	Projected Cost to Complete	-
Description:The projected remainder of the budgeted cost for the cost budget line.
	`CuryBudgetBacklogAmount`Nonexistent in DB	`decimal`	Cost Budget Backlog	-
Description:The difference between CuryBudgetedAmount and CuryActualAmount.
	`CuryBudgetedAmount`	`decimal(19, 4)`	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(19, 4)`		-
Description:The total amount of the project cost in the lines of a change order for particular date.
	`CuryCommitmentOpenAmount`	`decimal(19, 4)`	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.
	`CuryOriginalBudgetedAmount`	`decimal(19, 4)`		-
Description:The original budgeted cost of the corresponding cost budget line specified in the project.
	`CuryPendingChangeOrderAmount`	`decimal(19, 4)`	Pending CO Cost	-
Description:The total amount of the pending project cost in the lines of a change order for particular date.
	`CuryPendingCommitmentAmount`	`decimal(19, 4)`	Pending CO Commitments	-
Description:The total amount of the project pending commitments for particular date.
	`CuryProjectedAmount`	`decimal(19, 4)`	Projected Cost at Completion	-
Description:The projected final cost at the moment of project completion for the cost budget line.
	`CuryRevisedBudgetedAmount`	`decimal(19, 4)`		-
Description:The revised budgeted cost of the corresponding cost budget line specified in the project.
	`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.
	`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
	`OriginalBudgetedAmount`	`decimal(19, 4)`		-
Description:The original budgeted cost of the corresponding cost budget line specified in the project in base currency.
	`PendingChangeOrderAmount`	`decimal(19, 4)`		-
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(19, 4)`		-
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%.
	`ProjectedAmount`	`decimal(19, 4)`		-
Description:The projected final cost at the moment of project completion for the cost budget line in base currency.
	`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.
	`RevisedBudgetedAmount`	`decimal(19, 4)`		-
Description:The revised budgeted cost of the corresponding cost budget line specified in the project in base currency.
	`tstamp`	`timestamp`		-
Description:No description available