PMWipAdjustmentLine

PX.Objects.PMRelease 2025.2

Represents a line of a project WIP adjustment transaction. The records of this type are created and edited on the WIP Adjustment (PM305600) form (which corresponds to the ProjectWipAdjustmentEntry graph).

Select a row for its description 78 of 78 fields

	Field Name	Type	Display Name	Foreign Key
	`ActualAmount`	`decimal`		-
Description:The Actual Cost to Date of the corresponding cost projection in the transaction's base currency.
	`ApprovedCommitmentAmount`	`decimal`		-
Description:The sum of all approved project commitments with approval date the same as or earlier than the transaction's projected date in the transaction's base currency.
	`BilledRevenueAmount`	`decimal`		-
Description:The Billed Revenue of the corresponding cost projection in the transaction's base currency.
	`BudgetUsedPct`Nonexistent in DB	`decimal?`	% Budget Used	-
Description:The percentage of the budget used.
	`BudgetedCostChangeOrderAmount`Nonexistent in DB	`decimal?`		-
Description:The difference between RevisedCostBudgetedAmount and OriginalCostAmount.
	`BudgetedRevenueChangeOrderAmount`Nonexistent in DB	`decimal?`		-
Description:The difference between RevisedRevenueBudgetedAmount and OriginalRevenueAmount.
	`CompletedPct`	`decimal`	Completed (%)	-
Description:The Completed (%) of the corresponding cost projection.
	`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`	Costs to Period	-
Description:The Actual Cost to Date of the corresponding cost projection.
	`CuryApprovedCommitmentAmount`	`decimal`	Approved Commitment Change Total	-
Description:The sum of all approved project commitments with approval date the same as or earlier than the transaction's projected date.
	`CuryBilledRevenueAmount`	`decimal`	Billings to Period	-
Description:The Billed Revenue of the corresponding cost projection.
	`CuryBudgetedCostChangeOrderAmount`Nonexistent in DB	`decimal?`	Budgeted CO Cost	-
Description:The difference between CuryRevisedCostBudgetedAmount and CuryOriginalCostAmount.
	`CuryBudgetedRevenueChangeOrderAmount`Nonexistent in DB	`decimal?`	Budgeted CO Revenue	-
Description:The difference between CuryRevisedRevenueBudgetedAmount and CuryOriginalRevenueAmount.
	`CuryGrossProfitAmount`Nonexistent in DB	`decimal?`	Gross Profit	-
Description:The sum of CuryBilledRevenueAmount and CuryActualAmount.
	`CuryGrossProfitBacklogAmount`Nonexistent in DB	`decimal?`	Gross Profit Backlog	-
Description:The sum of CuryProjectedMarginAmount and CuryGrossProfitAmount.
	`CuryOriginalCommitmentAmount`	`decimal`	Original Commitment Total	-
Description:The sum of all project commitments with the date the same as or earlier than the transaction's projected date.
	`CuryOriginalCostAmount`	`decimal`	Original Budgeted Cost	-
Description:The sum of the Original Budgeted Amount of the project cost budget.
	`CuryOriginalRevenueAmount`	`decimal`	Original Contract Amount	-
Description:The sum of the Original Budgeted Amount of the project revenue budget.
	`CuryOverbillingAdjustmentAmount`	`decimal`	Overbilling Adjustment	-
Description:The resulting overbilling adjustment that is used in the GL adjusting transactions.
	`CuryOverbillingAmount`	`decimal`	Overbilling Amount	-
Description:The Overbilling or Underbilling of the corresponding cost projection if it is greater than 0; otherwise, 0.
	`CuryPendingCommitmentAmount`	`decimal`	Pending Commitment Change Total	-
Description:The Pending CO Commitments of the corresponding cost projection.
	`CuryPendingCostChangeOrderAmount`	`decimal`	Pending CO Cost	-
Description:The Pending CO Cost of the corresponding cost projection.
	`CuryPendingRevenueChangeOrderAmount`	`decimal`	Pending CO Revenue	-
Description:The Pending CO Revenue of the corresponding cost projection.
	`CuryPeriodBillingAmount`	`decimal`	Period Billings	-
Description:The sum of all project transaction amounts of the AR functional area for the transaction's financial period.
	`CuryPeriodCostAmount`	`decimal`	Actual Period Costs	-
Description:The sum of the expense project transaction amount for the transaction's financial period.
	`CuryProjectedAmount`	`decimal`	Projected Cost at Completion	-
Description:The Projected Cost at Completion of the corresponding cost projection.
	`CuryProjectedMarginAmount`	`decimal`	Est. Gross Profit	-
Description:The Projected Margin of the corresponding cost projection.
	`CuryRemainingContractgAmount`Nonexistent in DB	`decimal?`	Remaining Contract	-
Description:The sum of CuryRevisedRevenueBudgetedAmount and CuryBilledRevenueAmount.
	`CuryRevenueBacklogAmount`Nonexistent in DB	`decimal?`	Revenue Backlog	-
Description:The sum of CuryRevisedRevenueBudgetedAmount and CuryRevenueExpectedAmount.
	`CuryRevenueExpectedAmount`	`decimal`	Earned Revenue	-
Description:The Expected Current Revenue of the corresponding cost projection.
	`CuryRevisedCommitmentAmount`Nonexistent in DB	`decimal?`	Revised Commitment Total	-
Description:The sum of CuryOriginalCommitmentAmount and CuryApprovedCommitmentAmount.
	`CuryRevisedCostBudgetedAmount`	`decimal`	Revised Budgeted Cost	-
Description:The Revised Budgeted Cost of the corresponding cost projection.
	`CuryRevisedRevenueBudgetedAmount`	`decimal`	Revised Contract Amount	-
Description:The Revised Budget Revenue of the corresponding cost projection.
	`CuryUnderbillingAdjustmentAmount`	`decimal`	Underbilling Adjustment	-
Description:The resulting underbilling adjustment that is used in the GL adjusting transactions.
	`CuryUnderbillingAmount`	`decimal`	Underbilling Amount	-
Description:The Overbilling or Underbilling of the corresponding cost projection multiplied by –1, if it is less than 0; otherwise, 0.
	`GrossProfitAmount`Nonexistent in DB	`decimal?`		-
Description:The sum of BilledRevenueAmount and ActualAmount.
	`GrossProfitBacklogAmount`Nonexistent in DB	`decimal?`		-
Description:The sum of ProjectedMarginAmount and GrossProfitAmount.
	`IncludePendingChangeOrders`	`bit`	Pending CO Included	-
Description:A Boolean value that indicates (if set to true) that change orders with the Pending Approval status 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
	`LineNbr`	`int`	Line Nbr.	-
Description:The number of the transaction line.
	`MarginPct`Nonexistent in DB	`decimal?`	Margin (%)	-
Description:The percentage of margin.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OriginalCommitmentAmount`	`decimal`		-
Description:The sum of all project commitments with the date the same as or earlier than the transaction's projected date in the transaction's base currency.
	`OriginalCostAmount`	`decimal`		-
Description:The sum of the Original Budgeted Amount of the project cost budget in the transaction's base currency.
	`OriginalRevenueAmount`	`decimal`		-
Description:The sum of the Original Budgeted Amount of the project revenue budget in the transaction's base currency.
	`OverbillingAccountID`Default Navigation	`int`	Overbilling Account	Account
Description:The overbilling account.
	`OverbillingAdjustmentAmount`	`decimal`		-
Description:The overbilling adjustment in the transaction's base currency.
	`OverbillingAmount`	`decimal`		-
Description:Overbilling in the transaction's base currency.
	`OverbillingSubID`Default Navigation	`int`	Overbilling Subaccount	Sub
Description:The overbilling subaccount.
	`PendingCommitmentAmount`	`decimal`		-
Description:The Pending CO Commitments of the corresponding cost projection in the transaction's base currency.
	`PendingCostChangeOrderAmount`	`decimal`		-
Description:The Pending CO Cost of the corresponding cost projection in the transaction's base currency.
	`PendingRevenueChangeOrderAmount`	`decimal`		-
Description:The Pending CO Revenue of the corresponding cost projection in the transaction's base currency.
	`PeriodBillingAmount`	`decimal`		-
Description:Period billings in the transaction's base currency.
	`PeriodCostAmount`	`decimal`		-
Description:Period costs in the transaction's base currency.
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:The project for which the WIP adjustment line is created. The value of this field corresponds to the value of the PMProject.ContractID field.
	`ProjectTaskID`Default Navigation	`int`	Project Task	PMProject
Description:The task of the project which will be linked to the GL transactions. The value of this field corresponds to the value of the PMTask.TaskID field.
	`ProjectedAmount`	`decimal`		-
Description:The Projected Cost at Completion of the corresponding cost projection in the transaction's base currency.
	`ProjectedMarginAmount`	`decimal`		-
Description:The Projected Margin of the corresponding cost projection in the transaction's base currency.
	`ProjectedMarginPct`	`decimal`	Est. Margin (%)	-
Description:The Projected Margin (%) of the corresponding cost projection.
	`ProjectionRefNbr`Default Navigation	`nvarchar(30)`	Last Cost Projection	PMCostProjectionByDate
Description:The project cost projection that the WIP adjustment line is based on. The value of this field corresponds to the value of the PMCostProjectionByDate.RefNbr field.
	`RefNbr`	`nvarchar(30)`	Reference Nbr.	PMWipAdjustment
Description:The transaction identifier.
	`RemainingContractgAmount`Nonexistent in DB	`decimal?`		-
Description:The sum of RevisedRevenueBudgetedAmount and BilledRevenueAmount.
	`RevenueAccountID`Default Navigation	`int`	Revenue Account	Account
Description:The revenue account.
	`RevenueBacklogAmount`Nonexistent in DB	`decimal?`		-
Description:The sum of RevisedRevenueBudgetedAmount and RevenueExpectedAmount.
	`RevenueExpectedAmount`	`decimal`		-
Description:The Expected Current Revenue of the corresponding cost projection in the transaction's base currency.
	`RevenueSubID`Default Navigation	`int`	Revenue Subaccount	Sub
Description:The revenue subaccount.
	`RevisedCommitmentAmount`Nonexistent in DB	`decimal?`		-
Description:The sum of OriginalCommitmentAmount and ApprovedCommitmentAmount.
	`RevisedCostBudgetedAmount`	`decimal`		-
Description:The Revised Budgeted Cost of the corresponding cost projection in the transaction's base currency.
	`RevisedRevenueBudgetedAmount`	`decimal`		-
Description:The Revised Budget Revenue of the corresponding cost projection in the transaction's base currency.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`UnderbillingAccountID`Default Navigation	`int`	Underbilling Account	Account
Description:The underbilling account.
	`UnderbillingAdjustmentAmount`	`decimal`		-
Description:The underbilling adjustment in the transaction's base currency.
	`UnderbillingAmount`	`decimal`		-
Description:Underbilling in the transaction's base currency.
	`UnderbillingSubID`Default Navigation	`int`	Underbilling Subaccount	Sub
Description:The underbilling subaccount.