PMCostProjectionByDate

PX.Objects.PM

71 of 71 fields

	Field Name	Type	Display Name	Foreign Key
	`RefNbr`Default Navigation	`nvarchar(30)`	Reference Nbr.	-
Description:No description available
	`ActualAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.ActualAmount.
	`ActualTillDate`	`datetime2`		-
Description:The date the cost projection document is actual till.
	`AmountToCompleteTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.AmountToComplete.
	`AnticipatedPerformanceTotal`Nonexistent in DB	`decimal`	Anticipated Performance (%)	-
Description:The anticipated performance percent, which is the result of dividing CuryCompletedAmountTotal by CuryBudgetedAmountTotal, multiplied by 100%.
	`Approved`	`bit`		-
Description:A Boolean value that indicates (if set to ) that the document is approved.
	`BilledRevenueAmountTotal`	`decimal(19, 4)`		-
Description:The total amount of released project transactions with AR module and the date before or equal to ProjectionDate. The amount is in the base currency.
	`BudgetBacklogAmountTotal`Nonexistent in DB	`decimal`		-
Description:The difference between BudgetedAmountTotal and ActualAmountTotal.
	`BudgetedAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.BudgetedAmount.
	`ChangeOrderAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.ChangeOrderAmount.
	`CommitmentOpenAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.CommitmentOpenAmount.
	`CompletedAmountTotal`Nonexistent in DB	`decimal`		-
Description:The sum of ActualAmountTotal and CommitmentOpenAmountTotal.
	`CompletedPctTotal`Nonexistent in DB	`decimal`	Completed (%)	-
Description:The percent of project completion.
	`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
	`CuryActualAmountTotal`	`decimal(19, 4)`	Actual Cost to Date	-
Description:The sum of PMCostProjectionByDateLine.CuryActualAmount.
	`CuryAmountToCompleteTotal`	`decimal(19, 4)`	Projected Cost to Complete	-
Description:The sum of PMCostProjectionByDateLine.CuryAmountToComplete.
	`CuryBilledRevenueAmountTotal`	`decimal(19, 4)`	Billed Revenue	-
Description:The total amount of released project transactions with AR module and the date before or equal to ProjectionDate. The amount is in the project currency.
	`CuryBudgetBacklogAmountTotal`Nonexistent in DB	`decimal`	Cost Budget Backlog	-
Description:The difference between CuryBudgetedAmountTotal and CuryActualAmountTotal.
	`CuryBudgetedAmountTotal`	`decimal(19, 4)`	Revised Budgeted Cost	-
Description:The sum of PMCostProjectionByDateLine.CuryBudgetedAmount.
	`CuryChangeOrderAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.CuryChangeOrderAmount.
	`CuryCommitmentOpenAmountTotal`	`decimal(19, 4)`	Committed Open Cost	-
Description:The sum of PMCostProjectionByDateLine.CuryCommitmentOpenAmount.
	`CuryCompletedAmountTotal`Nonexistent in DB	`decimal`	Anticipated Cost	-
Description:The sum of CuryActualAmountTotal and CuryCommitmentOpenAmountTotal.
	`CuryExpectedAmountTotal`Nonexistent in DB	`decimal`		-
Description:The product of CompletedPctTotal and CuryRevisedBudgetedAmountTotal.
	`CuryOriginalBudgetedAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.CuryOriginalBudgetedAmount.
	`CuryOverbillingAmountTotal`Nonexistent in DB	`decimal`	Overbilling or Underbilling	-
Description:The difference between CuryBilledRevenueAmountTotal and CuryRevenueExpectedAmountTotal.
	`CuryPendingChangeOrderAmountTotal`	`decimal(19, 4)`	Pending CO Cost	-
Description:The sum of PMCostProjectionByDateLine.CuryPendingChangeOrderAmount.
	`CuryPendingCommitmentAmountTotal`	`decimal(19, 4)`	Pending CO Commitments	-
Description:The sum of PMCostProjectionByDateLine.CuryPendingCommitmentAmount.
	`CuryPendingRevenueChangeOrderAmountTotal`	`decimal(19, 4)`	Pending CO Revenue	-
Description:The total amount of the pending project revenue of change orders.
	`CuryProjectedAmountTotal`	`decimal(19, 4)`	Projected Cost at Completion	-
Description:The sum of PMCostProjectionByDateLine.CuryProjectedAmount.
	`CuryProjectedMarginTotal`Nonexistent in DB	`decimal`	Projected Margin	-
Description:The difference between CuryRevisedRevenueBudgetedAmountTotal and CuryProjectedAmountTotal.
	`CuryRevenueBudgetBacklogAmountTotal`Nonexistent in DB	`decimal`	Revenue Budget Backlog	-
Description:The difference between CuryRevisedRevenueBudgetedAmountTotal and CuryBilledRevenueAmountTotal.
	`CuryRevenueExpectedAmountTotal`Nonexistent in DB	`decimal`	Expected Current Revenue	-
Description:The product of CompletedPctTotal and CuryRevisedRevenueBudgetedAmountTotal.
	`CuryRevisedBudgetedAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.CuryRevisedBudgetedAmount.
	`CuryRevisedRevenueBudgetedAmountTotal`	`decimal(19, 4)`	Revised Budget Revenue	-
Description:The revised budget revenue, which consists of the original budgeted revenue and the revenue of all released change orders with the date before or equal to ProjectionDate. If change order workflow is not activated, the field contains the revised budget from the project revenue budget. The revised budget revenue is in the project currency.
	`Date`	`datetime2`	Date	-
Description:The date when the cost projection document was created.
	`Description`	`nvarchar(256)`	Description	-
Description:The description of the document.
	`ExpectedAmountTotal`Nonexistent in DB	`decimal`		-
Description:The product of CompletedPctTotal and RevisedBudgetedAmountTotal.
	`GroupByAccountGroupID`	`bit`	Account Group	-
Description:A Boolean value that indicates whether the project budget data should be grouped by an account group.
	`GroupByCostCodeID`	`bit`	Cost Code	-
Description:A Boolean value that indicates whether the project budget data should be grouped by cost code.
	`GroupByInventoryID`	`bit`	Inventory ID	-
Description:A Boolean value that indicates whether the project budget data should be grouped by an inventory item.
	`GroupByProjectTaskID`	`bit`	Project Task	-
Description:A Boolean value that indicates whether the project budget data should be grouped by a project task.
	`Hold`	`bit`	Hold	-
Description:A Boolean value that indicates (if set to ) that the document is on hold.
	`IncludePendingChangeOrders`	`bit`	Include Pending CO in Calculations	-
Description:A Boolean value that indicates whether pending change orders are included in calculations.
	`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
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OriginalBudgetedAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.OriginalBudgetedAmount.
	`OverbillingAmountTotal`Nonexistent in DB	`decimal`		-
Description:The difference between BilledRevenueAmountTotal and RevenueExpectedAmountTotal.
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:The employee responsible for the document. The value of this field corresponds to the BAccount.BAccountID field.
	`PendingChangeOrderAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.PendingChangeOrderAmount.
	`PendingCommitmentAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.PendingCommitmentAmount.
	`PendingRevenueChangeOrderAmountTotal`	`decimal(19, 4)`		-
Description:The total amount of the pending project revenue of change orders. The amount is in base currency.
	`PerformanceTotal`Nonexistent in DB	`decimal`	Performance (%)	-
Description:The performance percent, which is the result of dividing CuryActualAmountTotal by CuryBudgetedAmountTotal, multiplied by 100%.
	`ProjectedAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.ProjectedAmount.
	`ProjectedMarginPctTotal`Nonexistent in DB	`decimal`	Projected Margin (%)	-
Description:The projected margin percent, which is the result of dividing CuryProjectedMarginTotal by CuryRevisedRevenueBudgetedAmountTotal, multiplied by 100%.
	`ProjectedMarginTotal`Nonexistent in DB	`decimal`		-
Description:The difference between RevisedRevenueBudgetedAmountTotal and ProjectedAmountTotal.
	`ProjectID`Default Navigation	`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.
	`ProjectionDate`	`datetime2`	Projection Date	-
Description:The date the cost projection document was projected to.
	`Rejected`	`bit`		-
Description:A Boolean value that indicates (if set to ) that the document is rejected.
	`Released`	`bit`	Released	-
Description:A Boolean value that indicates (if set to ) that the document is released.
	`RevenueBudgetBacklogAmountTotal`Nonexistent in DB	`decimal`		-
Description:The difference between RevisedRevenueBudgetedAmountTotal and BilledRevenueAmountTotal.
	`RevenueExpectedAmountTotal`Nonexistent in DB	`decimal`		-
Description:The product of CompletedPctTotal and RevisedRevenueBudgetedAmountTotal.
	`RevisedBudgetedAmountTotal`	`decimal(19, 4)`		-
Description:The sum of PMCostProjectionByDateLine.RevisedBudgetedAmount.
	`RevisedRevenueBudgetedAmountTotal`	`decimal(19, 4)`		-
Description:The revised budget revenue, which consists of the original budgeted revenue and the revenue of all released change orders with the date before or equal to ProjectionDate. If change order workflow is not activated, the field contains the revised budget from the project revenue budget. The revised budget revenue is in the base currency.
	`Status`	`char(1)`	Status	-
Description:The status of the cost projection revision. The field can have one of the values described in ProjectCostProjectionByDateStatus.ListAttribute.
	`tstamp`	`timestamp`		-
Description:No description available
	`UpdateProjectBudget`	`bit`	Update Project Budget	-
Description:A Boolean value that indicates whether the project budget will be updated when the document is released.
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The workgroup that is responsible for the document. The value of this field corresponds to the EPCompanyTree.WorkGroupID field.