PMRevenueBudget

PX.Objects.PMRelease 2025.2

Represents a project budget line with the Income type. The records of this type are created and edited through the Revenue Budget tab of the Projects (PM301000) form (which corresponds to the ProjectEntry graph) and through the Revenue Budget tab of the Projects Templates (PM208000) form (which corresponds to the TemplateMaint graph). The DAC is based on the PMBudget DAC and extends it with the fields relevant to the lines of this type.

Select a row for its description 118 of 118 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountGroupID`Default Navigation	`int`	Account Group	PMAccountGroup
Description:The identifier of the Account Group associated with the budget line. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
	`ActualAmount`	`decimal`	Hist. Actual Amount in Base Currency	-
Description:The actual amount in the base currency of the tenant.
	`ActualPlusOpenCommittedAmount`Nonexistent in DB	`decimal?`	Actual + Open Committed Amount in Base Currency	-
Description:The sum of the ActualAmount and CommittedOpenAmount values.
	`ActualQty`	`decimal`	Actual Quantity	-
Description:The total quantity of the lines of the released accounts receivable invoices that correspond to the budget line.
	`Amount`	`decimal`	Original Budgeted Amount in Base Currency	-
Description:The budgeted amount of the budget line in the base currency of the tenant.
	`AmountToInvoice`	`decimal`	Pending Invoice Amount in Base Currency	-
Description:The amount for which the customer will be billed during the next billing in the base currency of the tenant.
	`BaseActualAmount`Nonexistent in DB	`decimal?`	Actual Amount in Base Currency	-
Description:The total amount of the lines of the released accounts receivable invoices that correspond to the budget line in the base currency of the tenant.
	`CapAmount`Nonexistent in DB	`decimal?`		-
Description:Retainage Cap Amount (in Base Currency)
	`ChangeOrderAmount`	`decimal`	Budgeted CO Amount in Base Currency	-
Description:The total amount of the lines of released change orders in the base currency of the tenant.
	`ChangeOrderQty`	`decimal`	Budgeted CO Quantity	-
Description:The total quantity of the lines of released change orders.
	`CommittedAmount`	`decimal`	Revised Committed Amount in Base Currency	-
Description:The total amount of the commitments in the base currency of the tenant.
	`CommittedCOAmount`Nonexistent in DB	`decimal?`	Committed CO Amount in Base Currency	-
Description:The total amount of the commitment lines of released change orders in the base currency of the tenant.
	`CommittedCOQty`Nonexistent in DB	`decimal?`	Committed CO Quantity	-
Description:The total quantity of the commitment lines of released change orders. The quantity is the difference between the Revised Committed Quantity and the Original Committed Quantity.
	`CommittedInvoicedAmount`	`decimal`	Committed Invoiced Amount in Base Currency	-
Description:The total invoiced amount of the commitments in the base currency of the tenant.
	`CommittedInvoicedQty`	`decimal`	Committed Invoiced Quantity	-
Description:The total invoiced quantity of the commitments.
	`CommittedOpenAmount`	`decimal`	Committed Open Amount in Base Currency	-
Description:The total open amount of the commitments in the base currency of the tenant.
	`CommittedOpenQty`	`decimal`	Committed Open Quantity	-
Description:The total open quantity of the commitments.
	`CommittedOrigAmount`	`decimal`	Original Committed Amount in Base Currency	-
Description:The total original amount of the commitments in the base currency of the tenant.
	`CommittedOrigQty`	`decimal`	Original Committed Quantity	-
Description:The total original quantity of the commitments.
	`CommittedQty`	`decimal`	Revised Committed Quantity	-
Description:The total quantity of the commitments.
	`CommittedReceivedQty`	`decimal`	Committed Received Quantity	-
Description:The total received quantity of the commitments.
	`CompletedPct`	`decimal`	Completed (%)	-
Description:The percentage of the work that has been completed on the revenue budget line.
	`CostAtCompletion`	`decimal`	Cost at Completion	-
Description:The current projected total cost amount of the cost budget line in the base currency of the tenant.
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The identifier of the Cost Code associated with the budget line. The value of this field corresponds to the value of the PMCostCode.costCodeID field.
	`CostProjectionCompletedPct`	`decimal`	Projected Completed (%)	-
Description:The projected percentage of completion for the cost budget line in the last released revision of the cost projection for this line.
	`CostProjectionCostAtCompletion`	`decimal`	Projected Cost at Completion in Base Currency	-
Description:The projected final cost at project completion for the cost budget line in the last released revision of the cost projection for this line in the base currency of the tenant.
	`CostProjectionCostToComplete`	`decimal`	Projected Cost To Complete in Base Currency	-
Description:The remainder of the budgeted cost for the cost budget line in the last released revision of the cost projection for this line in the base currency of the tenant.
	`CostProjectionQtyAtCompletion`	`decimal`	Projected Quantity at Completion	-
Description:The projected final quantity at project completion for the cost budget line in the last released revision of the cost projection for this line.
	`CostProjectionQtyToComplete`	`decimal`	Projected Quantity to Complete	-
Description:The remainder of the budgeted quantity for the cost budget line in the last released revision of the cost projection for this line.
	`CostToComplete`	`decimal`	Cost To Complete in Base Currency	-
Description:The current projected amount that is required to complete the cost budget line in the base currency of the tenant.
	`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 Amount	-
Description:The total amount of the lines of the released accounts receivable invoices that correspond to the budget line. The amount is shown in the project currency.
	`CuryActualPlusOpenCommittedAmount`Nonexistent in DB	`decimal?`	Actual + Open Committed Amount	-
Description:The sum of the Actual Amount and Committed Open Amount values. The amount is shown in the project currency.
	`CuryAmount`	`decimal`	Original Budgeted Amount	-
Description:The budgeted amount of the budget line in the project currency.
	`CuryAmountToInvoice`	`decimal`	Pending Invoice Amount	-
Description:The amount for which the customer will be billed during the next billing. The amount is shown in the project currency.
	`CuryCapAmount`Nonexistent in DB	`decimal?`	Retainage Cap Amount	-
Description:Retainage Cap Amount in the project currency.
	`CuryChangeOrderAmount`	`decimal`	Budgeted CO Amount	-
Description:The total amount of the lines of released change orders. The amount is shown in the project currency.
	`CuryCommittedAmount`	`decimal`	Revised Committed Amount	-
Description:The total amount of the commitments in the project currency.
	`CuryCommittedCOAmount`Nonexistent in DB	`decimal?`	Committed CO Amount	-
Description:The total amount of the commitment lines of released change orders. The amount is shown in the project currency. The amount is the difference between the Revised Committed Amount and the Original Committed Amount.
	`CuryCommittedInvoicedAmount`	`decimal`	Committed Invoiced Amount	-
Description:The total invoiced amount of the commitments in the project currency.
	`CuryCommittedOpenAmount`	`decimal`	Committed Open Amount	-
Description:The total open amount of the commitments in the project currency.
	`CuryCommittedOrigAmount`	`decimal`	Original Committed Amount	-
Description:The total original amount of the commitments in the project currency.
	`CuryCostAtCompletion`	`decimal`	Cost At Completion	-
Description:The current projected total cost amount of the cost budget line in the project currency.
	`CuryCostProjectionCostAtCompletion`	`decimal`	Projected Cost at Completion	-
Description:The projected final cost at project completion for the cost budget line in the last released revision of the cost projection for this line. The value is shown in the project currency.
	`CuryCostProjectionCostToComplete`	`decimal`	Projected Cost to Complete	-
Description:The remainder of the budgeted cost for the cost budget line in the last released revision of the cost projection for this line. The value is shown in the project currency.
	`CuryCostToComplete`	`decimal`	Cost To Complete	-
Description:The current projected amount that is required to complete the cost budget line. The amount is shown in the project currency.
	`CuryDraftChangeOrderAmount`	`decimal`	Potential CO Amount	-
Description:The total amount of the estimation lines of open change requests plus the total amount of the budget lines of non-closed change orders. The amount is shown in the project currency.
	`CuryDraftRetainedAmount`	`decimal`	Draft Retained Amount	-
Description:The draft retained amount in the project currency.
	`CuryInclTaxAmount`	`decimal`	Inclusive Tax Amount	-
Description:The inclusive tax amount in project currency calculated from the data of ARTran.CuryTaxAmt and from the data of ARTax.CuryRetainedTaxAmt.
	`CuryInfoID`	`bigint`		-
Description:The identifier of the currency info object associated with the budget line.
	`CuryInvoicedAmount`	`decimal`	Draft Invoice Amount	-
Description:The total amount of unreleased invoices that correspond to the revenue budget line. The amount is shown in the project currency.
	`CuryLastCostAtCompletion`	`decimal`	Last Cost At Completion	-
Description:The value of the Cost at Completion column before the most recent change was made to it. The value is shown in the project currency.
	`CuryLastCostToComplete`	`decimal`	Last Cost To Complete	-
Description:The value of the Cost to Complete column before the most recent change was made to it. The value is shown in the project currency.
	`CuryMaxAmount`	`decimal`	Maximum Amount	-
Description:The maximum billable amount for the revenue budget line in the project currency.
	`CuryPrepaymentAmount`	`decimal`	Prepaid Amount	-
Description:The field is reserved for a feature that is currently not supported.
	`CuryPrepaymentAvailable`	`decimal`	Prepaid Available	-
Description:The field is reserved for a feature that is currently not supported.
	`CuryPrepaymentInvoiced`	`decimal`	Prepaid Invoiced	-
Description:The field is reserved for a feature that is currently not supported.
	`CuryRetainedAmount`	`decimal`	Retained Amount	-
Description:The retained amount in the project currency.
	`CuryRevisedAmount`	`decimal`	Revised Budgeted Amount	-
Description:The revised budgeted amount in the project currency.
	`CuryTotalRetainedAmount`	`decimal`	Total Retained Amount	-
Description:The total retained amount in the project currency.
	`CuryUnitPrice`	`decimal`	Unit Price	-
Description:The price of the specified unit of the budget line in the project currency.
	`CuryUnitRate`	`decimal`	Unit Rate	-
Description:The price of the specified unit of the revenue budget line in the project currency.
	`CuryVarianceAmount`Nonexistent in DB	`decimal?`	Variance Amount	-
Description:The difference between the Revised Budgeted Amount and Actual values. The amount is shown in the project currency.
	`Description`	`nvarchar(256)`	Description	-
Description:The description of the budget line.
	`DraftChangeOrderAmount`	`decimal`	Potential CO Amount in Base Currency	-
Description:The total amount of the estimation lines of open change requests plus the total amount of the budget lines of non-closed change orders in the base currency of the tenant.
	`DraftChangeOrderQty`	`decimal`	Potential CO Quantity	-
Description:The total quantity of the estimation lines of open change requests plus the total quantity of the budget lines of non-closed change orders.
	`DraftRetainedAmount`	`decimal`	Draft Retained Amount	-
Description:Draft Retained Amount (in Base Currency)
	`InclTaxAmount`	`decimal`	Inclusive Tax Amount in Base Currency	-
Description:The inclusive tax amount in base currency calculated from the data of ARTran.TaxAmt and from the data of ARTax.RetainedTaxAmt.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:The identifier of the inventory item associated with the budget line. The value of this field corresponds to the value of the InventoryItem.InventoryID field.
	`InvoicedAmount`	`decimal`	Draft Invoices Amount in Base Currency	-
Description:The total amount of unreleased invoices that correspond to the revenue budget line in the base currency of the tenant.
	`InvoicedQty`	`decimal`	Draft Invoice Quantity	-
Description:The total quantity of unreleased invoices that correspond to the revenue budget line.
	`IsProduction`	`bit`	Auto Completed (%)	-
Description:Specifies (if set to true) that the Completed (%) of the corresponding task is calculated automatically, based on the completion method of the task.
	`LastCostAtCompletion`	`decimal`	Last Cost at Completion in Base Currency	-
Description:The value of the Cost at Completion column before the most recent change was made to it in the base currency of the tenant.
	`LastCostToComplete`	`decimal`	Last Cost to Complete in Base Currency	-
Description:The value of the Cost to Complete column before the most recent change was made to it in the base currency of the tenant.
	`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
	`LastPercentCompleted`	`decimal`	Last % Completed	-
Description:The value of the Percentage of Completion column before the most recent change was made to it.
	`LimitAmount`	`bit`	Limit Amount	-
Description:Indicates (if set to true) that the system controls the amount available to bill the customer based on the billing limit amount.
	`LimitQty`	`bit`	Limit Quantity	-
Description:A Boolean value that indicates whether the system controls the quantity available to bill the customer based on the billing limit quantity.
	`LineCntr`	`int`		-
Description:The counter of budget lines.
	`MaxAmount`	`decimal`	Maximum Amount in Base Currency	-
Description:The maximum billable amount for the revenue budget line in the base currency of the tenant.
	`MaxQty`	`decimal`	Maximum Quantity	-
Description:The maximum billable quantity for the revenue budget line.
	`Mode`	`char(1)`	Mode	-
Description:An internal field that is used to track the calculation source (whether auto or manual) of the completed percentage value of a revenue budget. This field is used internally by the system while a user is working with the revenue budget of a project.The system uses this field to track the completed percentage value for the revenue budget in real-time and determine whether this percentage was calculated automatically or manually. Based on the result of this determination, the system either runs the calculation again or keeps the user’s input. This field is constantly updated while the user processes documents. This is not a field that dictates a setting, but this is an additional internal field that the system uses to support calculations.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`PercentCompleted`	`decimal`	% Completed	-
Description:The current approximate percentage of project completion that corresponds to the cost budget line.
	`Performance`Nonexistent in DB	`decimal?`	Performance (%)	-
Description:The task performance measure.
	`PrepaymentAmount`	`decimal`	Prepaid Amount in Base Currency	-
Description:The field is reserved for a feature that is currently not supported.
	`PrepaymentAvailable`	`decimal`	Prepaid Available in Base Currency	-
Description:The field is reserved for a feature that is currently not supported.
	`PrepaymentInvoiced`	`decimal`	Prepaid Invoiced in Base Currency	-
Description:The field is reserved for a feature that is currently not supported.
	`PrepaymentPct`Nonexistent in DB	`decimal?`	Prepaid (%)	-
Description:The field is reserved for a feature that is currently not supported.
	`ProductivityTracking`	`nvarchar(1)`	Productivity Tracking	-
Description:The type of use of the budget line in the progress worksheet document. The field can have one of the following values: ""N"": Not Allowed, ""D"": On Demand, ""T"": Template
	`ProgressBillingBase`	`nvarchar`	Progress Billing Basis	-
Description:The value that the system uses as the basis for progress billing of the project task. The field can have one of the following values: ""A"": Amount, ""Q"": Quantity
	`ProjectID`	`int`		PMProject
Description:The identifier of the project associated with the budget line. 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 associated with the budget line. The value of this field corresponds to the value of the PMTask.TaskID field.
	`Qty`	`decimal`	Original Budgeted Quantity	-
Description:The budgeted quantity of the budget line.
	`QtyToInvoice`	`decimal`	Pending Invoice Quantity	-
Description:The quantity for which the customer will be billed during the next billing.
	`Rate`	`decimal`		-
Description:The price of the specified unit of the revenue budget line in the base currency of the tenant.
	`RestrictedCoAmount`Nonexistent in DB	`decimal?`	Budgeted CO Amount	-
Description:No description available
	`RetainageMaxPct`	`decimal`	Cap (%)	-
Description:Retainage Cap %
	`RetainagePct`	`decimal`	Retainage (%)	-
Description:The percent of the invoice line amount to be retained by the customer.
	`RetainedAmount`	`decimal`	Retained Amount	-
Description:Retained Amount (In Base Currency)
	`RevenueInventoryID`Obsolete	`int`		-
Description:The identifier of the revenue inventory item associated with the budget line.
	`RevenueTaskID`Default Navigation	`int`	Revenue Task	PMTask
Description:The identifier of the revenue project task associated with the budget line.
	`RevenueTaskIDApiEndPoint`Nonexistent in DB	`int?`		-
Description:The identifier of the revenue project task associated with the budget line. The field is used in the contract-based API endpoints for backward compatibility.
	`RevisedAmount`	`decimal`	Revised Budgeted Amount in Base Currency	-
Description:The revised budgeted amount in the base currency of the tenant.
	`RevisedQty`	`decimal`	Revised Budgeted Quantity	-
Description:The revised budgeted quantity.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`SortOrder`Nonexistent in DB	`int?`		-
Description:An internal field that is used to arrange the records on the Revenue Budget and Cost Budget tabs of the Projects (PM301000) form.
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:The identifier of the tax category associated with the budget line. Corresponds to the TaxCategory.TaxCategoryID field.
	`TotalRetainedAmount`	`decimal`	Total Retained Amount in Base Currency	-
Description:Total Retained Amount in Base Currency
	`Type`	`nvarchar(1)`	Budget Type	PMBudget
Description:The type of the budget line. By default, its value is Income.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure of the budget line.
	`UnitPrice`	`decimal`	Unit Price in Base Currency	-
Description:The price of the specified unit of the budget line in the base currency of the tenant.
	`VarianceAmount`Nonexistent in DB	`decimal?`	Variance Amount in Base Currency	-
Description:The difference between the RevisedAmount and PMBudget.ActualAmount values.
	`tstamp`	`timestamp`		-
Description:No description available