Skip to main content
PM

PMChangeRequestLine

PX.Objects.PM
Field NameTypeDisplay NameForeign Key
LineNbr
intLine Nbr.-
Description:The original sequence number of the line. The sequence of line numbers that belongs to a single document can include gaps.
RefNbr
nvarchar(15)Reference Nbr.PMChangeRequest
Description:The reference number of the parent change request.
CostAccountGroupIDDefault Navigation
intAccount GroupPMAccountGroup
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.
CostCodeIDDefault Navigation
intCost Code-
Description:The identifier of the cost code associated with the cost part of the estimation line.
CostTaskIDDefault Navigation
intProject TaskPMTask
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
Description
nvarchar(256)Description-
Description:The description of the estimation line.
ExtCost
decimal(19, 4)Ext. Cost-
Description:No description available
ExtPrice
decimal(19, 4)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.
InventoryIDDefault Navigation
intInventory IDInventoryItem
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
bitCreate Commitment-
Description:Specifies (if set to ) that the system produces a commitment line based on this estimation line when the change request is linked to a change order.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
LineAmount
decimal(19, 4)Line Amount-
Description:No description available
LineMarkupPct
decimal(19, 6)Line Markup (%)-
Description:The line markup percentage of the estimation line.
NoteID
uniqueidentifier-
Description:No description available
PriceMarkupPct
decimal(19, 6)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(19, 6)Quantity-
Description:The quantity of the estimation line.
RevenueAccountGroupIDDefault Navigation
intRevenue Account GroupPMAccountGroup
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.
RevenueCodeIDDefault Navigation
intRevenue Code-
Description:The identifier of the cost code associated with the revenue part of the estimation line.
RevenueInventoryIDDefault Navigation
intRevenue Inventory IDInventoryItem
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.
RevenueTaskIDDefault Navigation
intRevenue TaskPMTask
Description:No description available
SubItemIDDefault Navigation
intSubitemINSubItem
Description:No description available
tstamp
timestamp-
Description:No description available
UnitCost
decimal(19, 4)Unit Cost-
Description:The cost of the estimation line.
UnitPrice
decimal(19, 4)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.
UOMDefault Navigation
nvarchar(6)UOMINUnit
Description:The unit of measure associated with the cost part of the estimation line.
VendorIDDefault Navigation
intVendorBAccount
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.