PM
PMProgressWorksheet
Contains the main properties of a progress worksheet. The records of this type are created and edited through the Progress Worksheets (PM303000) form (which corresponds to the ProgressWorksheetEntry graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Approved | bit | - | ||
Description:Specifies (if set to true) that the document is approved. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DailyFieldReportCDNonexistent in DB | string | Daily Field Report | - | |
Description:The reference number of the linked daily field report. | ||||
Date | datetime | 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 true) that the document is hidden on the Progress Worksheets (PM303000) form. | ||||
HiddenRefNbrNonexistent in DB | string | 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. | ||||
HiddenStatusNonexistent in DB | string | 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 true) that the document is on hold. | ||||
LastModifiedByID | 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 | 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. | ||||
RefNbr | nvarchar(15) | Worksheet Nbr. | - | |
Description:The reference number of the progress worksheet. The number is generated from the numbering sequence, which is specified on the Projects Preferences (PM101000) form. | ||||
Rejected | bit | - | ||
Description:Specifies (if set to true) that the document is rejected. | ||||
Released | bit | Released | - | |
Description:Specifies (if set to true) 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 | ||||
WorkgroupID | 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. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||