Skip to main content
PM

PMProfitHistoryByDate

PX.Objects.PMRelease 2025.2

A projection DAC with formulas for profit calculation.

Field NameTypeDisplay NameForeign 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.