PM
PMProjectBudgetProfitHistory
A projection DAC with formulas for profit calculation in the project budget.
| 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. | ||||
ChangeOrderRefNbr | nvarchar | - | ||
Description:The reference number of the related change order. The value of this field corresponds to the value of the PMChangeOrder.RefNbr field. | ||||
CuryOriginalBudgetNonexistent in DB | decimal? | Original Cost Amount | - | |
Description:The original budget. | ||||
CuryOriginalContractNonexistent in DB | decimal? | Original Contract Amount | - | |
Description:The original contract. | ||||
CuryOriginalProfitNonexistent in DB | decimal? | Original Profit | - | |
Description:The original profit. The value is calculated by the formula: CuryOriginalContract - CuryOriginalBudget. | ||||
CuryRevisedBudgetNonexistent in DB | decimal? | Revised Cost Amount | - | |
Description:The revised budget. | ||||
CuryRevisedBudgetAmt | decimal | - | ||
Description:Revised budget amount in the project currency. | ||||
CuryRevisedContractNonexistent in DB | decimal? | Revised Contract Amount | - | |
Description:The revised contract. | ||||
CuryRevisedProfitNonexistent in DB | decimal? | Revised Profit | - | |
Description:The revised profit. The value is calculated by the formula: CuryRevisedContract - CuryRevisedBudget. | ||||
Date | datetime | - | ||
Description:The project transaction date. | ||||
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. | ||||