PM
PMForecastDetailInfo
The projection DAC that represents a project budget forecast line connected with the associated account group.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:The project account group of the budget line. The value of this field corresponds to the value of the PMAccountGroup.GroupID field. | ||||
AccountGroupType | nvarchar(1) | - | ||
Description:The type of the account group, which can be one of the following: Asset, Liability, Expense, Income, and Off-Balance. | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:The project cost code of the budget line. The value of this field corresponds to the value of the PMCostCode.CostCodeID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryAmount | decimal | Original Budgeted Amount | - | |
Description:The original budgeted amount. | ||||
CuryRevisedAmount | decimal | Revised Budgeted Amount | - | |
Description:The revised budgeted amount. | ||||
Description | nvarchar(256) | Description | - | |
Description:The description of the budget line. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:The inventory item of the budget line. The value of this field corresponds to the value of the InventoryItem.InventoryID field. | ||||
IsExpense | bit | - | ||
Description:A Boolean value that indicates whether the account group is an expense account group and can be selected on the Cost Budget tab of the Projects (PM301000) form. | ||||
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 | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PeriodID | string | Financial Period | MasterFinPeriod | |
Description:The financial period. The value of this field corresponds to the value of the FinPeriod.FinPeriodID field. | ||||
ProjectID | int | PMProject | ||
Description:The project of the project budget forecast. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
ProjectTaskID | int | Project Task | PMProject | |
Description:The project task of the budget line. The value of this field corresponds to the value of the PMTask.taskID field. | ||||
Qty | decimal | Original Budgeted Quantity | - | |
Description:The original budgeted quantity. | ||||
RevisedQty | decimal | Revised Budgeted Quantity | - | |
Description:The revised budgeted quantity. | ||||
RevisionID | nvarchar(15) | Revision | PMForecast | |
Description:The identifier of the project budget forecast revision. The value of this field corresponds to the value of the PMForecast.RevisionID field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||