PMCostProjectionLine

PX.Objects.PM

35 of 35 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`	Line Nbr.	-
Description:The number of the cost projection line.
	`ProjectID`	`int`		PMProject
Description:The project for which the cost projection revision line is created. The value of this field corresponds to the value of the PMProject.ContractID field.
	`RevisionID`	`nvarchar(30)`	Revision	PMCostProjection
Description:The revision identifier of the cost projection. The value of this field corresponds to the value of the PMCostProjection.revisionID field.
	`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)`	Actual Cost	-
Description:The total amount of the released project transactions that correspond to the cost budget line.
	`ActualQuantity`	`decimal(19, 6)`	Actual Quantity	-
Description:The total quantity of the released project transactions that correspond to the cost budget line.
	`Amount`	`decimal(19, 4)`	Projected Cost to Complete	-
Description:The projected remainder of the budgeted cost for the cost budget line.
	`AmountToComplete`Nonexistent in DB	`decimal`	Cost to Complete	-
Description:The remainder of the budgeted cost of the cost budget line that is currently available for completion.
	`BudgetedAmount`	`decimal(19, 4)`	Budgeted Cost	-
Description:The budgeted cost of the cost budget line specified in the project.
	`BudgetedQuantity`	`decimal(19, 6)`	Budgeted Quantity	-
Description:The budgeted quantity of the cost budget line specified in the project.
	`CompletedAmount`Nonexistent in DB	`decimal`	Actual + Committed Open Cost	-
Description:The sum of the actual cost and committed open cost of the cost budget line specified in the project.
	`CompletedPct`	`decimal(19, 4)`	Projected Completed (%)	-
Description:The projected percentage of completion for the cost budget line.
	`CompletedQuantity`Nonexistent in DB	`decimal`	Actual + Committed Open Quantity	-
Description:The sum of the actual quantity and committed open quantity of the cost budget line specified in the project.
	`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
	`Description`	`nvarchar(256)`	Description	-
Description:The description of the cost budget 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.
	`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
	`Mode`	`char(1)`	Mode	-
Description:The mode that specifies how the amounts and quantities are recalculated for the cost budget line. The field can have one of the values described in ProjectionMode.ListAttribute.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`ProjectedAmount`	`decimal(19, 4)`	Projected Cost at Completion	-
Description:The projected final cost at the moment of project completion for the cost budget line.
	`ProjectedQuantity`	`decimal(19, 6)`	Projected Quantity at Completion	-
Description:The projected final quantity at the moment of project completion for the cost budget line.
	`Quantity`	`decimal(19, 6)`	Projected Quantity to Complete	-
Description:The projected remainder of the budgeted quantity for the cost budget line.
	`QuantityToComplete`Nonexistent in DB	`decimal`	Quantity to Complete	-
Description:The remainder of the budgeted quantity of the cost budget line that is currently available for completion.
	`TaskID`Default Navigation	`int`	Cost Task	PMTask
Description:The identifier of the project task. The value of this field corresponds to the value of the PMTask.taskID field.
	`tstamp`	`timestamp`		-
Description:No description available
	`UnbilledAmount`	`decimal(19, 4)`	Committed Open Cost	-
Description:The committed open cost of the cost budget line.
	`UnbilledQuantity`	`decimal(19, 6)`	Committed Open Quantity	-
Description:The committed open quantity of the cost budget line.
	`UOM`	`nvarchar(6)`	UOM	-
Description:The unit of measure of the cost budget line.
	`VarianceAmount`	`decimal(19, 4)`	Projected Variance Cost	-
Description:The difference between the projected cost at completion and the budgetedAmount.
	`VarianceQuantity`	`decimal(19, 6)`	Projected Variance Quantity	-
Description:The difference between ProjectedQuantity and BudgetedQuantity.