opportunity
Stores information about sales opportunities, including potential revenue and deal details.
Columns
| Name | Type | References | Description |
| actionitem | String | The specific action item related to the transaction or record. | |
| altsalesrangehigh | Decimal | The upper range of the alternative sales amount. | |
| altsalesrangelow | Decimal | The lower range of the alternative sales amount. | |
| altsalestotal | String | The total alternative sales amount. | |
| balance | Decimal | The current balance associated with the entity or transaction. | |
| billaddress | String | The billing address for the transaction or entity. | |
| billaddresslist | String | A list of available billing addresses for selection. | |
| billingaddress | String | The primary billing address associated with the record. | |
| billisresidential | String | Indicates whether the billing address is residential. | |
| buyingreason | String | The reason provided for making a purchase. | |
| buyingtimeframe | String | The timeframe in which a purchase is expected to occur. | |
| class | String | The classification category assigned to the record or transaction. | |
| consolidatebalance | Decimal | The consolidated balance for an entity or account. | |
| createddate | Datetime | The date and time when the record was created. | |
| currency | String | The currency used for the transaction or record. | |
| currencyname | String | The name of the currency used in the transaction. | |
| currencysymbol | String | The symbol of the currency used in the transaction. | |
| customform | String | The custom form template used for this record. | |
| department | String | The department associated with the transaction or entity. | |
| documentstatus | String | The current status of the document, such as pending or approved. | |
| entity | String | The entity associated with the record, such as a customer or vendor. | |
| entitynexus | String | The tax nexus applicable to the entity. | |
| entitystatus | String | The status of the entity, such as lead, prospect, or customer. | |
| entitytaxregnum | String | The tax registration number associated with the entity. | |
| estgrossprofit | Decimal | The estimated gross profit from the transaction. | |
| estgrossprofitpercent | String | The estimated gross profit percentage. | |
| estimatedbudget | Decimal | The estimated budget for the transaction or project. | |
| exchangerate | Decimal | The exchange rate applied to the transaction. | |
| expectedclosedate | Date | The expected closing date for the transaction or opportunity. | |
| externalid | String | An external identifier used for integrations with other systems. | |
| forecasttype | String | The type of forecast applied to the transaction. | |
| isbasecurrency | Boolean | Indicates whether the currency is the base currency. | |
| isbudgetapproved | Boolean | Indicates whether the budget has been approved. | |
| job | String | The job or project associated with the transaction. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified. | |
| leadsource | String | The source from which the lead originated. | |
| location | String | The physical location associated with the transaction. | |
| memo | String | A memo or note related to the transaction. | |
| nexus | String | The tax jurisdiction or nexus applicable to the transaction. | |
| onetime | Decimal | The one-time revenue or cost associated with the transaction. | |
| partner | String | The partner associated with the transaction or entity. | |
| probability | String | The probability percentage of closing a deal or transaction. | |
| projaltsalesamt | Decimal | The projected alternative sales amount. | |
| projectedtotal | Decimal | The projected total amount for the transaction. | |
| rangehigh | Decimal | The high-end value of a specified range. | |
| rangelow | Decimal | The low-end value of a specified range. | |
| recurannually | Decimal | The recurring annual revenue or cost. | |
| recurmonthly | Decimal | The recurring monthly revenue or cost. | |
| recurquarterly | Decimal | The recurring quarterly revenue or cost. | |
| recurweekly | Decimal | The recurring weekly revenue or cost. | |
| salesgroup | String | The sales group responsible for the transaction. | |
| salesreadiness | String | The readiness level of the sales opportunity. | |
| salesrep | String | The sales representative assigned to the transaction. | |
| shipaddress | String | The shipping address for the transaction or entity. | |
| shipaddresslist | String | A list of available shipping addresses for selection. | |
| shipisresidential | String | Indicates whether the shipping address is residential. | |
| shipoverride | String | Indicates whether the shipping method has been overridden. | |
| shippingaddress | String | The primary shipping address associated with the record. | |
| source | String | The source from which the transaction or record originated. | |
| status | String | The current status of the transaction or opportunity. | |
| statusref | String | A reference code for the transaction status. | |
| subsidiary | String | The subsidiary company associated with the record. | |
| subsidiarytaxregnum | String | The tax registration number of the subsidiary. | |
| syncpartnerteams | Boolean | Indicates whether partner teams are synchronized. | |
| syncsalesteams | Boolean | Indicates whether sales teams are synchronized. | |
| taxdetailsoverride | Boolean | Indicates whether tax details have been manually overridden. | |
| taxpointdate | Date | The tax point date used for tax reporting. | |
| taxpointdateoverride | Boolean | Indicates whether the tax point date has been overridden. | |
| taxregoverride | Boolean | Indicates whether the tax registration has been overridden. | |
| title | String | The title or designation associated with the record. | |
| total | String | The total amount for the transaction. | |
| totalcostestimate | Decimal | The estimated total cost of the transaction. | |
| trandate | Date | The date of the transaction. | |
| tranid | String | The transaction identifier or reference number. | |
| unbilledorders | Decimal | The total value of unbilled orders. | |
| weightedtotal | Decimal | The weighted total amount based on probability. | |
| winlossreason | String | The reason provided for winning or losing a deal. |