PM
PMBudgetInfo
The projection DAC that represents a project budget line connected with the project task and the account group associated with it.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | PMAccountGroup | ||
Description:The identifier of the Account Group associated with 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. | ||||
ActualAmount | decimal | Actual Amount in Base Currency | - | |
Description:The actual amount in the base currency of the tenant. | ||||
ActualQty | decimal | Actual Quantity | - | |
Description:The total quantity of the lines of the released accounts receivable invoices that correspond to the budget line. | ||||
Amount | decimal | Original Budgeted Amount in Base Currency | - | |
Description:The budgeted amount of the budget line in the base currency of the tenant. | ||||
ChangeOrderAmount | decimal | Budgeted CO Amount in Base Currency | - | |
Description:The total amount of the lines of released change orders in the base currency of the tenant. | ||||
ChangeOrderQty | decimal | Budgeted CO Quantity | - | |
Description:The total quantity of the lines of released change orders. | ||||
CostCodeID | int | PMCostCode | ||
Description:The identifier of the Cost Code associated with 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 | ||||
CuryActualAmount | decimal | Actual Amount | - | |
Description:The total amount of the lines of the released accounts receivable invoices that correspond to the budget line. The amount is shown in the project currency. | ||||
CuryAmount | decimal | Original Budgeted Amount | - | |
Description:The budgeted amount of the budget line in the project currency. | ||||
CuryChangeOrderAmount | decimal | Budgeted CO Amount | - | |
Description:The total amount of the lines of released change orders. The amount is shown in the project currency. | ||||
CuryDraftChangeOrderAmount | decimal | Potential CO Amount | - | |
Description:The total amount of the estimation lines of open change requests plus the total amount of the budget lines of non-closed change orders. The amount is shown in the project currency. | ||||
CuryInfoID | bigint | - | ||
Description:The identifier of the currency info object associated with the budget line. | ||||
CuryRevisedAmount | decimal | Revised Budgeted Amount | - | |
Description:The revised budgeted amount in the project currency. | ||||
Description | nvarchar(256) | Description | - | |
Description:The description of the budget line. | ||||
DraftChangeOrderAmount | decimal | Potential CO Amount in Base Currency | - | |
Description:The total amount of the estimation lines of open change requests plus the total amount of the budget lines of non-closed change orders in the base currency of the tenant. | ||||
DraftChangeOrderQty | decimal | Potential CO Quantity | - | |
Description:The total quantity of the estimation lines of open change requests plus the total quantity of the budget lines of non-closed change orders. | ||||
InventoryID | int | InventoryItem | ||
Description:The identifier of the inventory item associated with 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 | ||||
PlannedEndDate | datetime | Planned End Date | - | |
Description:The date when the task is supposed to be finished. | ||||
PlannedStartDate | datetime | Planned Start Date | - | |
Description:The date when the task is supposed to be started. | ||||
ProjectID | int | - | ||
Description:The identifier of the project associated with the budget line. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
ProjectTaskID | int | PMTask | ||
Description:The identifier of the project task associated with the budget line. The value of this field corresponds to the value of the PMTask.TaskID field. | ||||
Qty | decimal | Original Budgeted Quantity | - | |
Description:The budgeted quantity of the budget line. | ||||
RevisedAmount | decimal | Revised Budgeted Amount in Base Currency | - | |
Description:The revised budgeted amount in the base currency of the tenant. | ||||
RevisedQty | decimal | Revised Budgeted Quantity | - | |
Description:The revised budgeted quantity. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||