PMProgressWorksheet

PX.Objects.PM

24 of 24 fields

	Field Name	Type	Display Name	Foreign Key
	`RefNbr`Default Navigation	`nvarchar(15)`	Worksheet Nbr.	-
Description:No description available
	`Approved`	`bit`		-
Description:Specifies (if set to ) that the document is approved.
	`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
	`DailyFieldReportCD`Nonexistent in DB	`nvarchar(10)`	Daily Field Report	-
Description:The reference number of the linked daily field report.
	`Date`	`datetime2`	Date	-
Description:The date on which the progress worksheet was created. By default, the value is set to the current business date.
	`Description`	`nvarchar(256)`	Description	-
Description:The description of the progress worksheet.
	`Hidden`	`bit`		-
Description:Specifies (if set to ) that the document is hidden on the Progress Worksheets (PM303000) form.
	`HiddenRefNbr`Nonexistent in DB	`nvarchar(15)`	Worksheet Nbr.	-
Description:The reference number of the progress worksheet. If the progress worksheet is unhidden, the value of this field contains the reference number. If the progress worksheet is hidden, the value is empty.
	`HiddenStatus`Nonexistent in DB	`nchar(1)`	Status	-
Description:The status of the progress worksheet. If the progress worksheet is unhidden, the value of this field contains the status of the progress worksheet. If the progress worksheet is hidden, the value is empty.
	`Hold`	`bit`	Hold	-
Description:Specifies (if set to ) that the document is on hold.
	`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
	`LineCntr`	`int`		-
Description:A counter of the document lines, which is used internally to assign numbers to new lines. We do not recommend that you rely on this field to determine the exact number of lines because it might not reflect this number under various conditions.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OwnerID`	`int`	Owner	-
Description:The contact responsible for the document. The value of this field corresponds to the value of the Contact.ContactID field.
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:The identifier of the project associated with the progress worksheet. The value of this field corresponds to the value of the PMProject.ContractID field.
	`Rejected`	`bit`		-
Description:Specifies (if set to ) that the document is rejected.
	`Released`	`bit`	Released	-
Description:Specifies (if set to ) that the document has been released.
	`Status`	`char(1)`	Status	-
Description:The status of the progress worksheet. The field can have one of the following values: ""H"": On Hold, ""A"": Pending Approval, ""O"": Open, ""C"": Closed, ""R"": Rejected
	`tstamp`	`timestamp`		-
Description:No description available
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The workgroup that is responsible for the document. The value of this field corresponds to the value of the EPCompanyTree.WorkGroupID field.