CROpportunity

PX.Objects.CRScreensCR304000CR503110Release 2025.2

An opportunity represents a potential, ongoing, or closed deal with a prospective or existing customer.

View API Entity: Opportunity/entity/Default/25.200.001/Opportunity

Select a row for its description 123 of 123 fields

	Field Name	Type	Display Name	Foreign Key
	`AMCuryEstimateTotal`	`decimal`	Est. Amount	-
Description:Pointer to CROpportunityRevisionExt.AMCuryEstimateTotal
	`AMEstimateQty`	`decimal`	Estimate Qty	-
Description:Pointer to CROpportunityRevisionExt.AMEstimateQty
	`AMEstimateTotal`	`decimal`	Estimate Total	-
Description:Pointer to CROpportunityRevisionExt.AMEstimateTotal
	`AllowOverrideBillingContactAddress`Nonexistent in DB	`bool?`		-
Description:Virtual field used to set CRBillingContact.IsDefaultContact and CRBillingAddress.IsDefaultAddress by the workflow. The behavior is controlled by CROpportunityContactAddress.CROpportunityContactAddressExt{TGraph}.
	`AllowOverrideContactAddress` API	`bit`	Override	-
Description:Specifies whether the contact and address information of this opportunity differs from the contact and address information of the business account associated with this opportunity. The behavior is controlled by the OpportunityMaint.ContactAddress graph extension derived from the CROpportunityContactAddress.CROpportunityContactAddressExt{TGraph} graph extension.
	`AllowOverrideShippingContactAddress`	`bit`	Override Shipping Info	-
Description:Specifies whether the shipping contact of this opportunity differs from the contact information of the business account associated with this opportunity. The behavior is controlled by the OpportunityMaint.ContactAddress graph extension derived from the CROpportunityContactAddress.CROpportunityContactAddressExt{TGraph} graph extension.
	`Amount`	`decimal`		-
Description:No description available
	`AssignDate`	`datetime`	Assignment Date	-
Description:The date of the assignment of the owner. The date when OwnerID was assigned to the opportunity.
	`Attributes`Nonexistent in DB	`string`		-
Description:No description available
	`AvalaraCustomerUsageType`	`char(1)`	Tax Exemption Type	-
Description:The customer entity type for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled. The field can have one of the values described in . Defaults to the customer entity type that is specified for the location of the customer.
	`BAccountID` API Default Navigation	`int`	Business Account	BAccount
Description:The identifier of the related business account. Corresponds to the value of the BAccount.BAccountID field.
	`BillAddressID`	`int`		CRAddress
Description:The identifier of the billing address that is associated with this opportunity. Corresponds to the value of the CRAddress.AddressID field.
	`BillContactID`	`int`		CRContact
Description:The identifier of the billing contact that is associated with this opportunity. Corresponds to the value of the CRContact.ContactID field.
	`BranchID` API Default Navigation	`int`	Branch	-
Description:The identifier of the Branch that will be used to ship the goods to the customer. The value of this field corresponds to the value of the Branch.BranchID field.
	`BranchLocationID`Default Navigation	`int`	Branch Location	FSBranchLocation
Description:No description available
	`CampaignSourceID` API Default Navigation	`nvarchar(15)`	Source Campaign	CRCampaign
Description:The marketing campaign that resulted in the creation of the opportunity. Corresponds to the value of the CRCampaign.CampaignID field.
	`CarrierID`Default Navigation	`nvarchar(15)`	Ship Via	Carrier
Description:No description available
	`ClassID` API Default Navigation	`nvarchar(10)`	Opportunity Class	CROpportunityClass
Description:The identifier of the CROpportunityClass. Corresponds to the value of the CROpportunityClass.CROpportunityClassID field.
	`CloseDate` API	`datetime`	Estimated Close Date	-
Description:The estimated date of closing the deal. Date value.
	`CloseDateMonth`Nonexistent in DB	`int?`	Month of Estimated Close Date	-
Description:The estimated date of closing the deal (month part) Month
	`CloseDateQuarter`Nonexistent in DB	`int?`	Quarter of Estimated Close Date	-
Description:The estimated date of closing the deal (quarter part) Quarter
	`CloseDateYear`Nonexistent in DB	`int?`	Year of Estimated Close Date	-
Description:The estimated date of closing the deal (year part) Year
	`ClosingDate`	`datetime`	Actual Close Date	-
Description:The date of closing the opportunity.
	`ContactID` API Default Navigation	`int`	Contact	Contact
Description:The identifier of the CR.Contact, the representative to be contacted about the opportunity. Corresponds to the value of the Contact.ContactID field.
	`Cost`	`decimal`	Cost	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Date Created	-
Description:No description available
	`CuryAmount` API	`decimal`	Detail Total	-
Description:No description available
	`CuryDiscTot` API	`decimal`	Document Discounts	-
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of all group, document of the opportunity(line discounts are not included).
	`CuryExtPriceTotal`	`decimal`	Detail Total	-
Description:No description available
	`CuryID` API Default Navigation	`nvarchar(5)`	Currency	Currency
Description:The currency of the opportunity. Corresponds to the Currency.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:Identifier of the CurrencyInfo object associated with the transaction. Generated automatically. Corresponds to the CurrencyInfo.CuryInfoID field.
	`CuryLineDiscountTotal`	`decimal`	Line Discounts	-
Description:No description available
	`CuryLineDocDiscountTotal`	`decimal`		-
Description:No description available
	`CuryLineTotal`	`decimal`	Detail Total	-
Description:No description available
	`CuryOrderDiscTotal`Nonexistent in DB	`decimal?`	Discount Total	-
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of all group, document and line discounts of the opportunity.
	`CuryProductsAmount` API	`decimal`	Total	-
Description:No description available
	`CuryRawAmount`Nonexistent in DB	`decimal?`		-
Description:No description available
	`CuryTaxTotal`	`decimal`	Tax Total	-
Description:The total amount of tax paid on the document in the selected currency.
	`CuryVatExemptTotal`	`decimal`	VAT Exempt Total	-
Description:The document total that is exempt from VAT in the selected currency. This total is calculated as the taxable amount for the tax with the Tax.ExemptTax field set to "true" (that is, the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form).
	`CuryVatTaxableTotal`	`decimal`	VAT Taxable Total	-
Description:The document total that is subjected to VAT in the selected currency. The field is displayed only if the Tax.IncludeInTaxable field is set to "true" (that is, the Include in VAT Exempt Total check box is selected on the Taxes (TX205000) form).
	`CuryViewState` API Nonexistent in DBObsolete	`bool?`		-
Description:No description available
	`CuryWgtAmount` API Nonexistent in DB	`decimal?`	Weight Total	-
Description:No description available
	`DefQuoteID`	`uniqueidentifier`		-
Description:No description available
	`Details` API	`nvarchar`	Details	-
Description:The detailed description or any relevant notes of the opportunity The value is in rich text format.
	`DiscTot`	`decimal`		-
Description:No description available
	`DocumentDate`	`datetime`	Document Date	-
Description:The document date. Date without time. After the opportunity is closed, this field is equal to CloseDate.
	`ExtPriceTotal`	`decimal`		-
Description:No description available
	`ExternalRef`	`char(255)`	Ext. Ref. Nbr.	-
Description:No description available
	`ExternalTaxExemptionNumber`	`nvarchar(30)`	Tax Exemption Number	-
Description:The tax exemption number for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled on the Enable/Disable Features (CS100000) form.
	`FOBPointID`Default Navigation	`nvarchar(15)`	FOB Point	FOBPoint
Description:No description available
	`GrossMarginAbsolute`Nonexistent in DB	`decimal?`	Gross Margin	-
Description:No description available
	`GrossMarginPercentage`Nonexistent in DB	`decimal?`	Gross Margin %	-
Description:No description available
	`Insurance`	`bit`	Insurance	-
Description:No description available
	`IsActive`	`bit`	Active	-
Description:Indicates whether the opportunity is active. The default value is true.
	`IsTaxValid`	`bit`	Tax Is Up to Date	-
Description:Indicates whether the tax amount calculated with the External Tax Provider is actual and does not require recalculation.
	`LanguageID`Default Navigation	`nvarchar(10)`	Language/Locale	Locale
Description:The language in which the contact prefers to communicate. By default, the system fills in the box with the locale specified for the contact's country. This field is displayed on the form only if there are multiple active locales configured on the System Locales (SM200550) form (corresponds to the LocaleMaintenance graph).
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime` API	`datetime`	Last Modified Date	-
Description:No description available
	`LeadID`Default Navigation	`uniqueidentifier`	Source Lead	Contact
Description:The identifier of the lead that has been converted to this opportunity. Corresponds to the value of the CRLead.NoteID field.
	`LineCntr`	`int`		-
Description:No description available
	`LineDiscountTotal`	`decimal`		-
Description:No description available
	`LineDocDiscountTotal`	`decimal`		-
Description:No description available
	`LineTotal`	`decimal`		-
Description:No description available
	`LocationID` API Default Navigation	`int`	Account Location	Location
Description:The identifier of the default location Location object linked with the prospective or existing customer selected in the Business Account box. If no location is selected in this box, the settings on the Shipping tab are empty and available for editing. Corresponds to the value of the Location.LocationID field. Also, the Location.BAccountID value must be equal to the CROpportunity.BAccountID value of the current opportunity.
	`ManualTotalEntry` API	`bit`	Manual Amount	-
Description:No description available
	`MultipleAccounts`	`bit`	Multiple Customers	-
Description:No description available
	`NoteID` API	`uniqueidentifier`		-
Description:No description available
	`OpportunityAddressID`	`int`		CRAddress
Description:The identifier of the CRAddress object linked with the current document. Corresponds to the value of the CRAddress.addressID field.
	`OpportunityContactID`Default Navigation	`int`		CRContact
Description:The identifier of the CRContact object linked with the current document. Corresponds to the value of the CRContact.contactID field.
	`OpportunityID` API Default Navigation	`nvarchar(15)`	Opportunity ID	-
Description:The identifier of the opportunity. This field depends on CRSetup.opportunityNumberingID.
	`OrderDiscTotal`Nonexistent in DB	`decimal?`	Discount Total	-
Description:The total discount of the document, which is calculated as the sum of document and line discounts of the opportunity.
	`OverrideSalesTerritory`	`bit`	Override Territory	-
Description:The flag identified that the salesTerritoryID is filled automatically based on Address.state and Address.countryID or can be assigned manually.
	`OwnerID` API Default Navigation	`int`	Owner	Contact
Description:No description available
	`ParentBAccountID` API Default Navigation	`int`	Business Account	BAccount
Description:The identifier of the parent business account. Corresponds to the value of the BAccount.BAccountID field of the parent account. This field is used for consolidating customer account balances on the parent account from child accounts.
	`PrimaryQuoteID`	`uniqueidentifier`		-
Description:No description available
	`PrimaryQuoteNbr`	`nvarchar(15)`	Primary Quote Nbr.	-
Description:No description available
	`PrimaryQuoteType`	`char(1)`	Primary Quote Type	-
Description:No description available
	`ProductCntr`	`int`		-
Description:No description available
	`ProductsAmount`	`decimal`	Products Amount	-
Description:No description available
	`ProjectID` API Default Navigation	`int`	Project	PMProject
Description:The project with which the item is associated. Corresponds to the PMProject.contractID field.
	`QuoteNoteID`	`uniqueidentifier`		-
Description:No description available
	`QuoteOpportunityID`	`nvarchar(15)`		-
Description:No description available
	`QuotedAmount`Obsolete	`decimal`	Amount	-
Description:No description available
	`RCreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`RCreatedByScreenID`	`char(8)`		-
Description:No description available
	`RCreatedDateTime`	`datetime`		-
Description:No description available
	`RLastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`RLastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`RLastModifiedDateTime`	`datetime`		-
Description:No description available
	`RawAmount`Nonexistent in DB	`decimal?`		-
Description:No description available
	`Resedential`	`bit`	Residential Delivery	-
Description:No description available
	`Resolution` API	`char(2)`	Reason	-
Description:The reason why the status of the opportunity has been changed. The possible values of the field are listed in the OpportunityReason class.
	`SDEnabled`	`bit`	Create Service Order	-
Description:No description available
	`SalesTerritoryID`Default Navigation	`nvarchar(15)`	Sales Territory	SalesTerritory
Description:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is false then it's filled automatically based on Address.state and Address.countryID otherwise it's assigned by user.
	`SaturdayDelivery`	`bit`	Saturday Delivery	-
Description:No description available
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`ServiceOrderRefNbr`Default Navigation	`nvarchar(15)`	Service Order Nbr.	FSServiceOrder
Description:No description available
	`ShipAddressID`	`int`		CRAddress
Description:The identifier of the shipping address that is associated with this opportunity. Corresponds to the value of the CRAddress.AddressID field.
	`ShipComplete`	`char(1)`	Shipping Rule	-
Description:No description available
	`ShipContactID`	`int`		CRContact
Description:The identifier of the shipping contact that is associated with this opportunity. Corresponds to the value of the CRContact.ContactID field.
	`ShipTermsID`Default Navigation	`nvarchar(10)`	Shipping Terms	ShipTerms
Description:No description available
	`ShipZoneID`Default Navigation	`nvarchar(15)`	Shipping Zone	ShippingZone
Description:No description available
	`SiteID`Default Navigation	`int`	Warehouse	INSite
Description:No description available
	`Source` API	`char(1)`	Source	-
Description:No description available
	`SrvOrdType`Default Navigation	`char(4)`	Service Order Type	FSSrvOrdType
Description:No description available
	`StageChangedDate`	`datetime`	Stage Change Date	-
Description:The date when the opportunity status or stage was changed. The value is controlled by the CROpportunityStages attribute defined for the StageID property.
	`StageID` API	`nvarchar(2)`	Stage	-
Description:The current stage of the opportunity. Possible values are determined by the settings specified for the ClassID opportunity class. The set of possible values can be changed and extended by using the workflow engine.
	`Status` API	`char(1)`	Status	-
Description:The current status of the opportunity. The set of possible values can be changed and extended by using the workflow engine.
	`Subject` API	`nvarchar(255)`	Description	-
Description:The subject or description of the opportunity. An alphanumeric string of up to 255 characters that describes the opportunity.
	`TaxCalcMode`	`char(1)`	Tax Calculation Mode	-
Description:The tax calculation mode, which defines which amounts (tax-inclusive or tax-exclusive) should be entered in the detail lines of a document. This field is displayed only if the FeaturesSet.NetGrossEntryMode field is set to "true". The field can have one of the following values: ""T"" (Tax Settings): The tax amount for the document is calculated according to the settings of the applicable tax or taxes. ""G"" (Gross): The amount in the document detail line includes a tax or taxes. ""N"" (Net): The amount in the document detail line does not include taxes.
	`TaxRegistrationID`	`nvarchar(50)`	Tax Registration ID	-
Description:The registration ID of the company in the state tax authority.
	`TaxTotal`	`decimal`		-
Description:The total amount of tax paid on the document in the base currency.
	`TaxZoneID` API Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:The tax zone that applies to the bank transaction. Corresponds to the value of the TaxZone.TaxZoneID field.
	`TermsID`Default Navigation	`nvarchar(10)`	Credit Terms	Terms
Description:The identifier of the default terms, which are applied to the documents of the customer.
	`TotalAmount`Obsolete	`decimal`	Total	-
Description:No description available
	`VatExemptTotal`	`decimal`		-
Description:The document total that is exempt from VAT in the base currency.
	`VatTaxableTotal`	`decimal`		-
Description:The document total that is subjected to VAT in the base currency.
	`WorkgroupID` API Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The workgroup associated with the opportunity. Corresponds to the EPCompanyTree.WorkGroupID field.
	`chkServiceManagement`Nonexistent in DB	`bool?`		-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available