CR
CROpportunity
PX.Objects.CRView API Entity: Opportunity
/entity/Default/24.200.001/Opportunity109 of 109 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
OpportunityID API | nvarchar(15) | Opportunity ID | - | |
Description:No description available | ||||
AllowOverrideBillingContactAddressNonexistent in DB | bit | - | ||
Description:Virtual field used to set CRBillingContact.IsDefaultContact and CRBillingAddress.IsDefaultAddress by the workflow. The behavior is controlled by CROpportunityContactAddress.CROpportunityContactAddressExt{TGraph}. | ||||
AllowOverrideContactAddress | 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 API | 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. | ||||
unspecified | - | |||
Description:No description available | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:No description available | ||||
BAccountID | int | Business Account | BAccount | |
Description:No description available | ||||
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 | int | Branch | - | |
Description:No description available | ||||
CampaignSourceID | nvarchar(15) | Source Campaign | CRCampaign | |
Description:No description available | ||||
CarrierID | nvarchar(15) | Ship Via | Carrier | |
Description:No description available | ||||
ClassID API | nvarchar(10) | Opportunity Class | CROpportunityClass | |
Description:No description available | ||||
CloseDate | datetime2 | Estimated Close Date | - | |
Description:The estimated date of closing the deal. Date value. | ||||
CloseDateMonth | int | Month of Estimated Close Date | - | |
Description:No description available | ||||
CloseDateQuarter | int | Quarter of Estimated Close Date | - | |
Description:No description available | ||||
CloseDateYear | int | Year of Estimated Close Date | - | |
Description:No description available | ||||
ClosingDate | datetime2 | Actual Close Date | - | |
Description:The date of closing the opportunity. | ||||
ContactID API | int | Contact | Contact | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Date Created | - | |
Description:No description available | ||||
CuryAmount | decimal | Detail Total | - | |
Description:No description available | ||||
CuryDiscTot | decimal | Document Discounts | - | |
Description:No description available | ||||
CuryExtPriceTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryID | 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 | CuryLineDocDiscountTotal | - | |
Description:No description available | ||||
CuryLineTotal | decimal | Detail Total | - | |
Description:No description available | ||||
CuryOrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
CuryProductsAmount | decimal | Total | - | |
Description:No description available | ||||
CuryRawAmount | 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:No description available | ||||
CuryVatTaxableTotal | decimal | VAT Taxable Total | - | |
Description:No description available | ||||
CuryViewStateNonexistent in DBObsolete | bit | - | ||
Description:No description available | ||||
CuryWgtAmountNonexistent in DB | decimal | Weight Total | - | |
Description:No description available | ||||
DefQuoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Details API | nvarchar(MAX) | 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 | datetime2 | Document Date | - | |
Description:The document date. Date without time. After the opportunity is closed, this field is equal to CloseDate. | ||||
ExternalRef | char(255) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:No description available | ||||
ExtPriceTotal | decimal | - | ||
Description:No description available | ||||
FOBPointID | nvarchar(15) | FOB Point | FOBPoint | |
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 . | ||||
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 | nvarchar(10) | Language/Locale | Locale | |
Description:No description available | ||||
LastModifiedByID | 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 | uniqueidentifier | Source Lead | Contact | |
Description:No description available | ||||
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 | int | Account Location | Location | |
Description:No description available | ||||
ManualTotalEntry | bit | Manual Amount | - | |
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 | int | CRContact | ||
Description:The identifier of the CRContact object linked with the current document. Corresponds to the value of the CRContact.contactID field. | ||||
OrderDiscTotal | decimal | Discount Total | - | |
Description:No description available | ||||
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 | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Parent 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 | ||||
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 | int | Project | - | |
Description:No description available | ||||
QuoteNbrNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
QuoteNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
QuoteOpportunityID | nvarchar(15) | - | ||
Description:No description available | ||||
RawAmount | decimal | - | ||
Description:No description available | ||||
RCreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
RCreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
RCreatedDateTime | datetime | - | ||
Description:No description available | ||||
Resedential | bit | Residential Delivery | - | |
Description:No description available | ||||
Resolution | 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. | ||||
RLastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
RLastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
RLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
SalesTerritoryID | nvarchar(15) | Sales Territory | SalesTerritory | |
Description:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is 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 | ||||
SelectedNonexistent in DB | bit | Selected | - | |
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 | nvarchar(10) | Shipping Terms | ShipTerms | |
Description:No description available | ||||
ShipZoneID | nvarchar(15) | Shipping Zone | ShippingZone | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
Source API | char(1) | Source | - | |
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 | varchar(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:No description available | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
TaxTotal | decimal | - | ||
Description:No description available | ||||
TaxZoneID | nvarchar(10) | Tax Zone | TaxZone | |
Description:No description available | ||||
TermsID | nvarchar(10) | Credit Terms | Terms | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VatExemptTotal | decimal | - | ||
Description:No description available | ||||
VatTaxableTotal | decimal | - | ||
Description:No description available | ||||
WorkgroupID API | int | Workgroup | EPCompanyTree | |
Description:The workgroup associated with the opportunity. Corresponds to the EPCompanyTree.WorkGroupID field. | ||||