PMRevenueBudget

PX.Objects.PM

117 of 117 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountGroupID`Default Navigation	`int`	Account Group	PMAccountGroup
Description:No description available
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:No description available
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:No description available
	`ProjectID`	`int`		PMProject
Description:No description available
	`ProjectTaskID`Default Navigation	`int`	Project Task	PMTask
Description:No description available
	`ActualAmount`	`decimal`	Hist. Actual Amount in Base Currency	-
Description:No description available
	`ActualPlusOpenCommittedAmount`Nonexistent in DB	`decimal`	Actual + Open Committed Amount in Base Currency	-
Description:No description available
	`ActualQty`	`decimal(19, 6)`	Actual Quantity	-
Description:No description available
	`Amount`	`decimal(19, 4)`	Original Budgeted Amount in Base Currency	-
Description:No description available
	`AmountToInvoice`	`decimal`	Pending Invoice Amount in Base Currency	-
Description:No description available
	`BaseActualAmount`Nonexistent in DB	`decimal`	Actual Amount in Base Currency	-
Description:No description available
	`CapAmount`Nonexistent in DB	`decimal`		-
Description:Retainage Cap Amount (in Base Currency)
	`ChangeOrderAmount`	`decimal`	Budgeted CO Amount in Base Currency	-
Description:No description available
	`ChangeOrderQty`	`decimal(19, 6)`	Budgeted CO Quantity	-
Description:No description available
	`CommittedAmount`	`decimal(19, 4)`	Revised Committed Amount in Base Currency	-
Description:No description available
	`CommittedCOAmount`Nonexistent in DB	`decimal`	Committed CO Amount in Base Currency	-
Description:No description available
	`CommittedCOQty`Nonexistent in DB	`decimal`	Committed CO Quantity	-
Description:No description available
	`CommittedInvoicedAmount`	`decimal(19, 4)`	Committed Invoiced Amount in Base Currency	-
Description:No description available
	`CommittedInvoicedQty`	`decimal(19, 6)`	Committed Invoiced Quantity	-
Description:No description available
	`CommittedOpenAmount`	`decimal(19, 4)`	Committed Open Amount in Base Currency	-
Description:No description available
	`CommittedOpenQty`	`decimal(19, 6)`	Committed Open Quantity	-
Description:No description available
	`CommittedOrigAmount`	`decimal`	Original Committed Amount in Base Currency	-
Description:No description available
	`CommittedOrigQty`	`decimal`	Original Committed Quantity	-
Description:No description available
	`CommittedQty`	`decimal(19, 6)`	Revised Committed Quantity	-
Description:No description available
	`CommittedReceivedQty`	`decimal(19, 6)`	Committed Received Quantity	-
Description:No description available
	`CompletedPct`	`decimal(19, 4)`	Completed (%)	-
Description:No description available
	`CostAtCompletion`	`decimal`	Cost at Completion	-
Description:No description available
	`CostProjectionCompletedPct`	`decimal`	Projected Completed (%)	-
Description:No description available
	`CostProjectionCostAtCompletion`	`decimal`	Projected Cost at Completion in Base Currency	-
Description:No description available
	`CostProjectionCostToComplete`	`decimal`	Projected Cost To Complete in Base Currency	-
Description:No description available
	`CostProjectionQtyAtCompletion`	`decimal`	Projected Quantity at Completion	-
Description:No description available
	`CostProjectionQtyToComplete`	`decimal`	Projected Quantity to Complete	-
Description:No description available
	`CostToComplete`	`decimal`	Cost To Complete in Base Currency	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`varchar(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CuryActualAmount`	`decimal(19, 4)`	Actual Amount	-
Description:No description available
	`CuryActualPlusOpenCommittedAmount`Nonexistent in DB	`decimal`	Actual + Open Committed Amount	-
Description:No description available
	`CuryAmount`	`decimal(19, 4)`	Original Budgeted Amount	-
Description:No description available
	`CuryAmountToInvoice`	`decimal(19, 4)`	Pending Invoice Amount	-
Description:No description available
	`CuryCapAmount`Nonexistent in DB	`decimal`	Retainage Cap Amount	-
Description:No description available
	`CuryChangeOrderAmount`	`decimal(19, 4)`	Budgeted CO Amount	-
Description:No description available
	`CuryCommittedAmount`	`decimal`	Revised Committed Amount	-
Description:No description available
	`CuryCommittedCOAmount`Nonexistent in DB	`decimal`	Committed CO Amount	-
Description:No description available
	`CuryCommittedInvoicedAmount`	`decimal`	Committed Invoiced Amount	-
Description:No description available
	`CuryCommittedOpenAmount`	`decimal`	Committed Open Amount	-
Description:No description available
	`CuryCommittedOrigAmount`	`decimal`	Original Committed Amount	-
Description:No description available
	`CuryCostAtCompletion`	`decimal(19, 4)`	Cost At Completion	-
Description:No description available
	`CuryCostProjectionCostAtCompletion`	`decimal`	Projected Cost at Completion	-
Description:No description available
	`CuryCostProjectionCostToComplete`	`decimal`	Projected Cost to Complete	-
Description:No description available
	`CuryCostToComplete`	`decimal(19, 4)`	Cost To Complete	-
Description:No description available
	`CuryDraftChangeOrderAmount`	`decimal(19, 4)`	Potential CO Amount	-
Description:No description available
	`CuryDraftRetainedAmount`	`decimal`	Draft Retained Amount	-
Description:No description available
	`CuryInclTaxAmount`	`decimal(19, 4)`	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:No description available
	`CuryInvoicedAmount`	`decimal(19, 4)`	Draft Invoice Amount	-
Description:No description available
	`CuryLastCostAtCompletion`	`decimal(19, 4)`	Last Cost At Completion	-
Description:No description available
	`CuryLastCostToComplete`	`decimal(19, 4)`	Last Cost To Complete	-
Description:No description available
	`CuryMaxAmount`	`decimal(19, 4)`	Maximum Amount	-
Description:No description available
	`CuryPrepaymentAmount`	`decimal(19, 4)`	Prepaid Amount	-
Description:No description available
	`CuryPrepaymentAvailable`	`decimal(19, 4)`	Prepaid Available	-
Description:No description available
	`CuryPrepaymentInvoiced`	`decimal(19, 4)`	Prepaid Invoiced	-
Description:No description available
	`CuryRetainedAmount`	`decimal`	Retained Amount	-
Description:No description available
	`CuryRevisedAmount`	`decimal(19, 4)`	Revised Budgeted Amount	-
Description:No description available
	`CuryTotalRetainedAmount`	`decimal`	Total Retained Amount	-
Description:No description available
	`CuryUnitPrice`	`decimal(19, 6)`	Unit Price	-
Description:No description available
	`CuryUnitRate`	`decimal(19, 6)`	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:No description available
	`DraftChangeOrderAmount`	`decimal`	Potential CO Amount in Base Currency	-
Description:No description available
	`DraftChangeOrderQty`	`decimal(19, 6)`	Potential CO Quantity	-
Description:No description available
	`DraftRetainedAmount`	`decimal`	Draft Retained Amount	-
Description:No description available
	`InclTaxAmount`	`decimal(19, 4)`	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.
	`InvoicedAmount`	`decimal(19, 4)`	Draft Invoices Amount in Base Currency	-
Description:No description available
	`InvoicedQty`	`decimal(19, 6)`	Draft Invoice Quantity	-
Description:No description available
	`IsProduction`	`bit`		-
Description:No description available
	`LastCostAtCompletion`	`decimal`	Last Cost at Completion in Base Currency	-
Description:No description available
	`LastCostToComplete`	`decimal`	Last Cost to Complete in Base Currency	-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`varchar(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LastPercentCompleted`	`decimal(19, 4)`	Last % Completed	-
Description:No description available
	`LimitAmount`	`bit`	Limit Amount	-
Description:No description available
	`LimitQty`	`bit`	Limit Quantity	-
Description:No description available
	`LineCntr`	`int`		-
Description:No description available
	`MaxAmount`	`decimal`	Maximum Amount in Base Currency	-
Description:No description available
	`MaxQty`	`decimal(19, 6)`	Maximum Quantity	-
Description:No description available
	`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(19, 4)`	% Completed	-
Description:No description available
	`Performance`Nonexistent in DB	`decimal`	Performance (%)	-
Description:No description available
	`PrepaymentAmount`	`decimal`	Prepaid Amount in Base Currency	-
Description:No description available
	`PrepaymentAvailable`	`decimal`	Prepaid Available in Base Currency	-
Description:No description available
	`PrepaymentInvoiced`	`decimal`	Prepaid Invoiced in Base Currency	-
Description:No description available
	`PrepaymentPct`Nonexistent in DB	`decimal`	Prepaid (%)	-
Description:No description available
	`ProductivityTracking`	`varchar(1)`	Productivity Tracking	-
Description:No description available
	`ProgressBillingBase`	`nvarchar(1)`	Progress Billing Basis	-
Description:No description available
	`Qty`	`decimal(19, 6)`	Original Budgeted Quantity	-
Description:No description available
	`QtyToInvoice`	`decimal(19, 6)`	Pending Invoice Quantity	-
Description:No description available
	`Rate`	`decimal(19, 6)`		-
Description:The price of the specified unit of the revenue budget line in the base currency of the tenant.
	`RetainageMaxPct`	`decimal`	Cap (%)	-
Description:No description available
	`RetainagePct`	`decimal(19, 6)`	Retainage (%)	-
Description:No description available
	`RetainedAmount`	`decimal`	Retained Amount	-
Description:No description available
	`RevenueInventoryID`Obsolete	`int`		-
Description:The identifier of the revenue inventory item associated with the budget line.
	`RevenueTaskID`	`int`		PMTask
Description:The identifier of the revenue project task associated with the budget line.
	`RevenueTaskIDApiEndPoint`Nonexistent in DB	`int`		-
Description:No description available
	`RevisedAmount`	`decimal(19, 4)`	Revised Budgeted Amount in Base Currency	-
Description:No description available
	`RevisedQty`	`decimal(19, 6)`	Revised Budgeted Quantity	-
Description:No description available
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`SortOrder`Nonexistent in DB	`int`		-
Description:No description available
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:No description available
	`TotalRetainedAmount`	`decimal`	Total Retained Amount in Base Currency	-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`Type`	`char(1)`	Budget Type	-
Description:The type of the budget line. By default, its value is Income.
	`UnitPrice`	`decimal(19, 6)`	Unit Price in Base Currency	-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:No description available
	`VarianceAmount`Nonexistent in DB	`decimal`	Variance Amount in Base Currency	-
Description:The difference between the RevisedAmount and PMBudget.ActualAmount values.