PM
PMChangeRequestLine
PX.Objects.PM32 of 32 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
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. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | PMChangeRequest | |
Description:The reference number of the parent change request. | ||||
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:No description available | ||||
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(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. | ||||
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 ) 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(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. | ||||
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:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
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. | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:The unit of measure associated with the cost part of the estimation line. | ||||
VendorID | int | Vendor | BAccount | |
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. | ||||