PMProgressWorksheetLine

PX.Objects.PM

26 of 26 fields

	Field Name	Type	Display Name	Foreign Key
	`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.
	`RefNbr`Default Navigation	`nvarchar(15)`	Worksheet Nbr.	PMProgressWorksheet
Description:The reference number of the parent progress worksheet.
	`AccountGroupID`Default Navigation	`int`	Account Group	PMAccountGroup
Description:No description available
	`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:No description available
	`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	`nvarchar(256)`	Description	-
Description:The description of the progress worksheet line.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:No description available
	`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
	`OwnerID`Default Navigation	`int`	Employee	Vendor
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(19, 6)`	Completed Quantity	-
Description:The completed quantity for the units that are produced or installed from the previous progress worksheet date.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:No description available
	`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.
	`tstamp`	`timestamp`		-
Description:No description available
	`UOM`Nonexistent in DB	`nvarchar(6)`	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.