CN
PMWipChangeOrderBudget
A projection over the PMChangeOrderBudget class joined with the PMChangeOrder class. The projection is used in WIP reports.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | - | ||
Description:The identifier of the account group associated with the change order line. The value of this field corresponds to the value of the PMAccountGroup.GroupID field. | ||||
CompletionDate | datetime | - | ||
Description:The date that has been communicated to the customer as the approval date of the agreed-upon changes. Defaults to the current business date. | ||||
ContractAmountNonexistent in DB | decimal? | - | ||
Description:The amount of the change order line in the base currency for the revenue budget. The value is 0 for the cost budget. | ||||
CostAmountNonexistent in DB | decimal? | - | ||
Description:The amount of the change order line in the base currency for the cost budget. The value is 0 for the revenue budget. | ||||
CostCodeID | int | - | ||
Description:The identifier of the cost code associated with the change order line. The value of this field corresponds to the value of the PMCostCode.costCodeID field. | ||||
Date | datetime | - | ||
Description:The date on which the changes made with the change order should be recorded in the project balances. Defaults to the current business date. | ||||
InventoryID | int | - | ||
Description:The identifier of the inventory item associated with the change order line. The value of this field corresponds to the value of the InventoryItem.InventoryID field. | ||||
ProjectID | int | - | ||
Description:The identifier of the project associated with the change order line. Defaults to the project of the parent change order. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
ProjectTaskID | int | - | ||
Description:No description available | ||||
RefNbr | nvarchar | - | ||
Description:The reference number of the parent change order. | ||||
Status | nvarchar(1) | - | ||
Description:The status of the change order. The field can have one of the following values: ""H"": On Hold, ""A"": Pending Approval, ""O"": Open, ""C"": Closed, ""R"": Rejected | ||||
Type | nvarchar(1) | - | ||
Description:The type of the change order line. The field can have one of the following values: ""A"": Asset, ""L"": Liability, ""I"": Income, ""E"": Expense, ""O"": Off-Balance | ||||