Skip to main content
PM

PMChangeOrder

PX.Objects.PM
Field NameTypeDisplay NameForeign Key
RefNbrDefault Navigation
nvarchar(15)Reference Nbr.-
Description:No description available
Approved
bit-
Description:Specifies (if set to ) that the document has been approved.
AttributesNonexistent in DB
unspecified-
Description:A service field, which is necessary for the dynamically added attributes defined at the change order class level to function correctly.
BudgetLineCntr
int-
Description:No description available
ChangeRequestCostTotal
decimal(19, 4)Change Request Cost Total-
Description:The cost total of all the change requests linked to the change order.
ChangeRequestLineTotal
decimal(19, 4)Change Request Line Total-
Description:The line total of all the change requests linked to the change order.
ChangeRequestMarkupTotal
decimal(19, 4)Change Request Markup Total-
Description:The markup total of all the change requests linked to the change order.
ChangeRequestPriceTotal
decimal(19, 4)Change Request Price Total-
Description:The price total of all the change requests linked to the change order.
ClassIDDefault Navigation
nvarchar(15)ClassPMChangeOrderClass
Description:The identifier of the GL change order class that provides default settings for the change order. The value of this field corresponds to the value of the PMChangeOrderClass.ClassID field.
CommitmentTotal
decimal(19, 4)Commitment Change Total-
Description:The total amount in project currency of the commitments lines of the document.
CompletionDate
datetime2Approval Date-
Description:The date that has been communicated to the customer as the approval date of the agreed-upon changes. Defaults to the current business date.
CostTotal
decimal(19, 4)Cost Budget Change Total-
Description:The total amount of the cost budget lines of the document.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CustomerIDDefault Navigation
intCustomerCustomer
Description:The identifier of the customer associated with the project. The value of this field corresponds to the value of the BAccount.BAccountID field.
Date
datetime2Change Date-
Description:The date on which the changes made with the change order should be recorded in the project balances. Defaults to the current business date.
DelayDays
intContract Change (Days)-
Description:A positive or negative number of days that represents the delay of the contract.
Description
nvarchar(256)Description-
Description:The description of the change order.
DescriptionAsPlainTextNonexistent in DB
nvarchar(MAX)DescriptionAsPlainText-
Description:No description available
ExtRefNbr
nvarchar(30)External Ref. Nbr.-
Description:The external reference number (such as an identifier required by the customer or a number from an external system integrated with Acumatica ERP) entered manually.
GrossMarginAmountNonexistent in DB
decimalGross Margin Amount-
Description:The difference between the Revenue Budget Change Total and the Cost Budget Change Total values.
GrossMarginPctNonexistent in DB
decimalGross Margin (%)-
Description:The gross margin percent.
Hold
bitHold-
Description:Specifies (if set to ) that the document is on hold.
IsChangeRequestVisibleNonexistent in DB
bit2-Tier Change Management-
Description:Specifies (if set to ) that the Change Requests tab is visible in the change order.
IsCostVisibleNonexistent in DB
bitVisible Cost-
Description:Specifies (if set to ) that the Cost Budget tab is visible in the change order.
IsDetailsVisibleNonexistent in DB
bitVisible Details-
Description:Specifies (if set to ) that the Commitments tab is visible in the change order.
IsRevenueVisibleNonexistent in DB
bitVisible Revenue-
Description:Specifies (if set to ) that the Revenue Budget tab is visible in the 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
LineCntr
int-
Description:A counter of the document lines, which is used internally to assign numbers to newly created lines. We do not recommend that you rely on this field to determine the exact number of lines because it might not reflect this number under various conditions.
NoteID
uniqueidentifier-
Description:No description available
OrigRefNbr
nvarchar(15)Original CO Nbr.-
Description:The reference number of the original change order whose changes the currently selected change order reverses.
OwnerIDDefault Navigation
intOwnerContact
Description:The contact responsible for the document. Corresponds to the Contact.ContactID field.
ProjectIDDefault Navigation
intProjectPMProject
Description:The identifier of the project associated with the change order. The value of this field corresponds to the value of the PMProject.contractID field.
ProjectNbr
nvarchar(15)Revenue Change Nbr.-
Description:The change number.
Rejected
bit-
Description:Specifies (if set to ) that the document has been rejected.
Released
bitReleased-
Description:Specifies (if set to ) that the document has been released.
RevenueTotal
decimal(19, 4)Revenue Budget Change Total-
Description:The total amount of the revenue budget lines of the document.
ReverseStatus
char(1)Reverse Status-
Description:The reverse status of the change order. The field can have one of the following values: ""N"": None, ""X"": Reversed, ""R"": Reversing
ReversingRefNbrNonexistent in DB
nvarchar(15)Reversing CO Nbr.-
Description:The list of reference number of the change orders which reverse currently selected change order.
Status
char(1)Status-
Description:The status of the change order. The field can have one of the following values: ""H"": On Hold, ""A"": Pending Approval, ""O"": Open, ""C"": Closed, ""R"": Rejected
Text
nvarchar(MAX)Details-
Description:A detailed description of the change order.
tstamp
timestamp-
Description:No description available
WorkgroupIDDefault Navigation
intWorkgroupEPCompanyTree
Description:The workgroup that is responsible for the document. Corresponds to the EPCompanyTree.WorkGroupID field.