PM
PMProfitHistoryByDate
A projection DAC with formulas for profit calculation.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | - | ||
Description:The project account group of the project transaction. The value of this field corresponds to the value of the PMAccountGroup.GroupID field. | ||||
AccountGroupType | nvarchar | - | ||
Description:The type of the account group, which can be one of the following: Asset, Liability, Expense, Income, and Off-Balance. | ||||
CuryActualAmount | decimal | - | ||
Description:The total amount of the corresponding project transactions. | ||||
CuryContractToDateNonexistent in DB | decimal? | Billed Amount to Date | - | |
Description:The contract to date. | ||||
CuryCostToDateNonexistent in DB | decimal? | Actual Costs to Date | - | |
Description:The cost to date. | ||||
CuryProfitToDateNonexistent in DB | decimal? | Profit to Date | - | |
Description:The profit to date. The value is calculated by the formula: CuryContractToDate - CuryCostToDate. | ||||
Date | datetime | - | ||
Description:The project transaction date. The value of this field corresponds to the value of the PMTran.Date field. | ||||
ProjectID | int | - | ||
Description:The project of the project transaction. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
ReportGroup | nvarchar | - | ||
Description:The type of the reporting group. The field can have one of the following values: - L: Labor - M: Material - S: Subcontract - E: Equipment - O: Other - R: Revenue | ||||
TaskID | int | - | ||
Description:The project task of the project transaction. The value of this field corresponds to the value of the PMTask.taskID field. | ||||