PMProgressWorksheetLine

PX.Objects.PMRelease 2025.2

Contains the main properties of a progress worksheet line. The records of this type are created and edited through the Details tab of the Progress Worksheets (PM303000) form (which corresponds to the ProgressWorksheetEntry graph).

Select a row for its description 26 of 26 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 progress worksheet line. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
	`CompletedPercentTotalQuantity`Nonexistent in DB	`decimal?`	Completed (%), Total	-
Description:The total dompleted quantity devided by the total budgeted quantity.
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The identifier of the cost code associated with the cost part of the estimation line.
	`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
	`CurrentPeriodQuantity`Nonexistent in DB	`decimal?`	Current Period Quantity	-
Description:The sum of the values of the Completed Quantity fields for the released progress worksheets with the dates that start from the first day of the current financial period and that end with the current date of the document. (The date that is specified in a progress worksheet should be a part of the current period.)
	`Description`Nonexistent in DB	`string`	Description	-
Description:The description of the progress worksheet line.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:The identifier of the inventory item associated with the progress worksheet line. 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
	`LineNbr`	`int`	Line Number	-
Description:The original sequence number of the line among all the progress worksheet lines. The sequence of line numbers of the progress worksheet lines that belong to a single document can include gaps.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OwnerID`Default Navigation	`int`	Employee	EPEmployee
Description:The employee associated with the progress worksheet line. The value of this field corresponds the value of the EPEmployee.PK field.
	`PreviouslyCompletedQuantity`Nonexistent in DB	`decimal?`	Previously Completed Quantity	-
Description:/// The sum of the values of the Completed Quantity fields (for the lines with the same project key) of the progress worksheets that are released up to and including the current progress worksheet date. (The values of the current document are not included in the sum.)
	`PriorPeriodQuantity`Nonexistent in DB	`decimal?`	Prior Period Quantity	-
Description:The sum of the values of the Completed Quantity fields for the released progress worksheets with dates within the previous financial period.
	`ProjectID`	`int`		-
Description:The identifier of the project associated with the progress worksheet line. By default, the value of this field is set to the project ID of the parent progress worksheet. The value of this field corresponds to the value of the PMProject.ContractID field.
	`Qty`	`decimal`	Completed Quantity	-
Description:The completed quantity for the units that are produced or installed from the previous progress worksheet date.
	`RefNbr`Default Navigation	`nvarchar(15)`	Worksheet Nbr.	PMProgressWorksheet
Description:The reference number of the parent progress worksheet.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:The identifier of the task associated with the progress worksheet line. The value of this field corresponds to the value of the PMTask.TaskID field.
	`TotalBudgetedQuantity`Nonexistent in DB	`decimal?`	Total Budgeted Quantity	-
Description:The total budgeted quantity. The value of this field is equal to the revised budgeted quantity, which is specified on the Cost Budget tab of the Projects (PM301000) form for the project specified for this progress worksheet.
	`TotalCompletedQuantity`Nonexistent in DB	`decimal?`	Total Completed Quantity	-
Description:The sum of PMProgressWorksheetLine.PreviouslyCompletedQuantity and PMProgressWorksheetLine.Qty.
	`UOM`Nonexistent in DB	`string`	UOM	-
Description:The UOM of the progress worksheet line.
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The workgroup associated with the progress worksheet line. The value of this field corresponds to the value of the EPCompanyTree.WorkGroupID field.
	`tstamp`	`timestamp`		-
Description:No description available