PM
PMRevenuePercentageCalculationRule
A rule that defines how to calculate revenue completion percentages for project tasks. The rule specifies grouping options and a formula used to determine the completion percentage based on cost budget and projection data. The rule is referenced by PMTask records through the PMTask.RevenuePercentageCalculationRule field.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
Description | nvarchar(255) | Description | - | |
Description:The description of the revenue percentage calculation rule. | ||||
Formula | nvarchar | Formula | - | |
Description:The formula used to calculate the revenue percentage. The formula can reference fields from PMCostBudget, PMCostProjectionByDate, PMCostProjectionByDateLine, and PMProgressWorksheetLine DACs. | ||||
GroupByCostCode | bit | Group by Cost Code | - | |
Description:A Boolean value that indicates (if set to true) that revenue percentage calculation should be grouped by cost code. If the value is set to false, the calculation is not grouped by cost code. | ||||
GroupByItem | bit | Group by Item | - | |
Description:A Boolean value that indicates (if set to true) that revenue percentage calculation should be grouped by item. If the value is set to false, the calculation is not grouped by item. | ||||
GroupByTask | char(1) | Group by Task | - | |
Description:The type of task grouping used for revenue percentage calculation. The field can have one of the values described in RevenueCompletionTaskGroupType.ListAttribute. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
RuleID | nvarchar(15) | Rule ID | - | |
Description:The unique identifier of the revenue percentage calculation rule. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||