PM
PMChangeRequestLine
Represents an estimation line of a change request. The records of this type are created and edited through the Estimation tab of the Change Requests (PM308500) form (which corresponds to the ChangeRequestEntry graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CostAccountGroupID | int | Account Group | PMAccountGroup | |
Description:The identifier of the expense account group associated with the cost part of the estimation line. The value of this field corresponds to the value of the PMAccountGroup.GroupID field. | ||||
CostCodeID | int | Cost Code | - | |
Description:The identifier of the cost code associated with the cost part of the estimation line. | ||||
CostTaskID | int | Project Task | PMTask | |
Description:The identifier of the task associated with the cost part of the estimation line. The value of this field corresponds to the value of the PMTask.TaskID 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 | ||||
Description | nvarchar(256) | Description | - | |
Description:The description of the estimation line. | ||||
ExtCost | decimal | Ext. Cost | - | |
Description:The extended cost of the estimation line, which the system calculates by multiplying the Quantity and Unit Cost values of the line. | ||||
ExtPrice | decimal | Ext. Price | - | |
Description:The extended price of the estimation line, which the system calculates by multiplying the Quantity and Unit Price values of the line. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:The identifier of the inventory item associated with the cost part of the estimation line. The value of this field corresponds to the value of the InventoryItem.InventoryID field. | ||||
IsCommitment | bit | Create Commitment | - | |
Description:Specifies (if set to true) that the system produces a commitment line based on this estimation line when the change request is linked to a change order. | ||||
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 | ||||
LineAmount | decimal | Line Amount | - | |
Description:The total amount of the revenue part of the estimation line. | ||||
LineMarkupPct | decimal | Line Markup (%) | - | |
Description:The line markup percentage of the estimation line. | ||||
LineNbr | int | Line Nbr. | - | |
Description:The original sequence number of the line. The sequence of line numbers that belongs to a single document can include gaps. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PriceMarkupPct | decimal | Price Markup (%) | - | |
Description:The markup percentage that the system uses to calculate Unit Price based on Ext. Cost. | ||||
ProjectID | int | - | ||
Description:The identifier of the project associated with the estimation line. Defaults to the project of the parent change request. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
Qty | decimal | Quantity | - | |
Description:The quantity of the estimation line. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | PMChangeRequest | |
Description:The reference number of the parent change request. | ||||
RevenueAccountGroupID | int | Revenue Account Group | PMAccountGroup | |
Description:The identifier of the income account group associated with the revenue part of the estimation line. The value of this field corresponds to the value of the PMAccountGroup.GroupID field. | ||||
RevenueCodeID | int | Revenue Code | - | |
Description:The identifier of the cost code associated with the revenue part of the estimation line. | ||||
RevenueInventoryID | int | Revenue Inventory ID | InventoryItem | |
Description:The identifier of the inventory item associated with the revenue part of the estimation line. The value of this field corresponds to the value of the InventoryItem.InventoryID field. | ||||
RevenueTaskID | int | Revenue Task | PMTask | |
Description:The identifier of the task associated with the revenue part of the estimation line. The value of this field corresponds to the value of the PMTask.TaskID field. | ||||
SubItemID | int | Subitem | INSubItem | |
Description:The identifier of the subitem associated with the estimation line. The value of this field corresponds to the value of the INSubItem.SubItemID field. | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:The unit of measure associated with the cost part of the estimation line. | ||||
UnitCost | decimal | Unit Cost | - | |
Description:The cost of the estimation line. | ||||
UnitPrice | decimal | Unit Price | - | |
Description:The price of the estimation line, which the system calculates by multiplying the Unit Cost and Price Markup (%) values for the line. | ||||
VendorID | int | Vendor | BAccountR | |
Description:The identifier of the vendor associated with the estimation line. The value of this field corresponds to the value of the BAccount.BAccountID field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||