PM
PMCommitment
PX.Objects.PM34 of 34 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CommitmentID | uniqueidentifier | - | ||
Description:The identifier of the commitment. | ||||
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:The account group of the commitment. The value of this field corresponds to the value of the PMAccountGroup.accountID field. | ||||
Amount | decimal(19, 4) | Revised Committed Amount | - | |
Description:The revised amount of the commitment. | ||||
BranchID | int | Branch | Branch | |
Description:The branch of the commitment. The value of this field corresponds to the value of the Branch.branchID field. | ||||
CommittedCOAmountNonexistent in DB | decimal | Committed CO Amount | - | |
Description:The total amount of the cost commitment lines of released change orders that are associated with the commitment. | ||||
CommittedCOQtyNonexistent in DB | decimal | Committed CO Quantity | - | |
Description:The total quantity of the cost commitment lines of released change orders that are associated with the commitment. | ||||
CommittedVarianceAmountNonexistent in DB | decimal | Committed Variance Amount | - | |
Description:The difference between the values of Amount and InvoicedAmount. | ||||
CommittedVarianceQtyNonexistent in DB | decimal | Committed Variance Quantity | - | |
Description:The difference between the values of Qty and InvoicedQty. | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:The cost code of the commitment. The value of this field corresponds to the value of the PMCostCode.costCodeID 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 | ||||
ExtRefNbr | nvarchar(15) | External Ref. Nbr | - | |
Description:The reference number of the commitment of the external type. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:The inventory item of the commitment. The value of this field corresponds to the value of the InventoryItem.inventoryID field. | ||||
InvoicedAmount | decimal(19, 4) | Committed Invoiced Amount | - | |
Description:The invoiced amount of the commitment. | ||||
InvoicedQty | decimal(19, 6) | Committed Invoiced Quantity | - | |
Description:The invoiced quantity of the commitment. | ||||
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 | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenAmount | decimal(19, 4) | Committed Open Amount | - | |
Description:The open amount of the commitment that has not been received yet. | ||||
OpenQty | decimal(19, 6) | Committed Open Quantity | - | |
Description:The open quantity of the commitment that has not been received yet. | ||||
OrigAmount | decimal(19, 4) | Original Committed Amount | - | |
Description:The original amount of the commitment. | ||||
OrigQty | decimal(19, 6) | Original Committed Quantity | - | |
Description:The original quantity of the commitment. | ||||
ProjectCuryID | nvarchar(5) | Project Currency | - | |
Description:The project currency. | ||||
ProjectID | int | Project | PMProject | |
Description:The project associated with the commitment. The value of this field corresponds to the value of the PMProject.contractID field. | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:The project task associated with the commitment. The value of this field corresponds to the value of the PMTask.taskID field. | ||||
Qty | decimal(19, 6) | Revised Committed Quantity | - | |
Description:The revised quantity of the commitment. | ||||
ReceivedQty | decimal(19, 6) | Committed Received Quantity | - | |
Description:The received quantity of the commitment. | ||||
RefNoteID | uniqueidentifier | Related Document | - | |
Description:The document from which the commitment originates. | ||||
Status | char(1) | Status | - | |
Description:The status of the commitment. The field can have one of the values described in PMCommitmentStatus.ListAttribute. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(1) | Type | - | |
Description:The type of the commitment. The field can have one of the values described in PMCommitmentType.ListAttribute. | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:The unit of measure of the commitment. | ||||