PM
PMChangeOrderLine
PX.Objects.PM37 of 37 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. | PMChangeOrder | |
Description:The reference number of the parent change order. | ||||
AccountID | int | Account | Account | |
Description:The expense account associated with the commitment. The value of this field corresponds to the value of the Account.AccountID field. | ||||
Amount | decimal(19, 4) | Amount | - | |
Description:The amount of the commitment. The value can be manually modified. | ||||
AmountInProjectCury | decimal(19, 4) | Amount in Project Currency | - | |
Description:The amount of the commitment in the project currency. | ||||
ChangeRequestLineNbr | int | Change Request Line Nbr. | - | |
Description:The number of the corresponding change request line. | ||||
ChangeRequestRefNbr | nvarchar(15) | Change Request Ref. Nbr. | - | |
Description:The reference number of the corresponding change request if the commitment line has been created based on this change request. | ||||
CostCodeID | int | Cost Code | PMCostCode | |
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 | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:The identifier of the commitment currency. The value of this field corresponds to the value of the Currency.CuryID field. | ||||
Description | nvarchar(256) | Description | - | |
Description:The description of the commitment. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:The identifier of the inventory item associated with the commitment. The value of this field corresponds to the value of the InventoryItem.InventoryID field. | ||||
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 | ||||
LineType | char(1) | Status | - | |
Description:The status of the commitment line of the change order. The field can have one of the following values: ""U"": Update, ""L"": New Document, ""D"": New Line, ""R"": Reopen | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | POLine | |
Description:No description available | ||||
POOrderNbr | nvarchar(15) | PO Nbr. | POLine | |
Description:No description available | ||||
POOrderType | char(2) | PO Type | - | |
Description:The type of the purchase order associated with the commitment. The field can have one of the values described in POOrderType.RBDSListAttribute. | ||||
PotentialRevisedAmountNonexistent in DB | decimal | - | ||
Description:The sum of the amount and the original amount of the purchase order line associated with the commitment. | ||||
PotentialRevisedQtyNonexistent in DB | decimal | - | ||
Description:The sum of the quantity and original quantity of the purchase order line associated with the commitment. | ||||
ProjectID | int | PMProject | ||
Description:The identifier of the project associated with the commitment. Defaults to the project of the parent change order. The value of this field corresponds to the value of the PMProject.ContractID field. | ||||
Qty | decimal(19, 6) | Quantity | - | |
Description:The quantity of the commitment. | ||||
Released | bit | Released | - | |
Description:Specifies (if set to ) that the parent change order has been released. | ||||
RetainageAmt | decimal(19, 4) | Retainage Amount | - | |
Description:The line retainage amount in base currency | ||||
RetainageAmtInProjectCury | decimal(19, 4) | Retainage Amount in Project Currency | - | |
Description:The line retainage amount in project currency | ||||
RetainagePct | decimal(19, 6) | Retainage Percent | - | |
Description:The line retainage percentage | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:The identifier of the Task associated with the commitment. The value of this field corresponds to the value of the PMTask.TaskID field. | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 4) | Unit Cost | - | |
Description:The cost of the specified unit of the commitment. The value can be manually modified. | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:The unit of measure of the commitment. | ||||
VendorID | int | Vendor | BAccount | |
Description:No description available | ||||