opportunity
The opportunity table.
Columns
| Name | Type | References | Description |
| actionitem | String | Actionitem | |
| altsalesrangehigh | Decimal | Altsalesrangehigh | |
| altsalesrangelow | Decimal | Altsalesrangelow | |
| altsalestotal | String | Altsalestotal | |
| balance | Decimal | Balance | |
| billaddress | String | Billaddress | |
| billaddresslist | String | Billaddresslist | |
| billingaddress | String | Billingaddress | |
| billisresidential | String | Billisresidential | |
| buyingreason | String | Buyingreason | |
| buyingtimeframe | String | Buyingtimeframe | |
| class | String | Class | |
| consolidatebalance | Decimal | Consolidatebalance | |
| createddate | Datetime | Createddate | |
| currency | String | Currency | |
| currencyname | String | Currencyname | |
| currencysymbol | String | Currencysymbol | |
| customform | String | Customform | |
| department | String | Department | |
| documentstatus | String | Documentstatus | |
| entity | String | Entity | |
| entitynexus | String | Entitynexus | |
| entitystatus | String | Entitystatus | |
| entitytaxregnum | String | Entitytaxregnum | |
| estgrossprofit | Decimal | Estgrossprofit | |
| estgrossprofitpercent | String | Estgrossprofitpercent | |
| estimatedbudget | Decimal | Estimatedbudget | |
| exchangerate | Decimal | Exchangerate | |
| expectedclosedate | Date | Expectedclosedate | |
| externalid | String | Externalid | |
| forecasttype | String | Forecasttype | |
| isbasecurrency | Boolean | Isbasecurrency | |
| isbudgetapproved | Boolean | Isbudgetapproved | |
| job | String | Job | |
| lastmodifieddate | Datetime | Lastmodifieddate | |
| leadsource | String | Leadsource | |
| location | String | Location | |
| memo | String | Memo | |
| nexus | String | Nexus | |
| onetime | Decimal | Onetime | |
| partner | String | Partner | |
| probability | String | Probability | |
| projaltsalesamt | Decimal | Projaltsalesamt | |
| projectedtotal | Decimal | Projectedtotal | |
| rangehigh | Decimal | Rangehigh | |
| rangelow | Decimal | Rangelow | |
| recurannually | Decimal | Recurannually | |
| recurmonthly | Decimal | Recurmonthly | |
| recurquarterly | Decimal | Recurquarterly | |
| recurweekly | Decimal | Recurweekly | |
| salesgroup | String | Salesgroup | |
| salesreadiness | String | Salesreadiness | |
| salesrep | String | Salesrep | |
| shipaddress | String | Shipaddress | |
| shipaddresslist | String | Shipaddresslist | |
| shipisresidential | String | Shipisresidential | |
| shipoverride | String | Shipoverride | |
| shippingaddress | String | Shippingaddress | |
| source | String | Source | |
| status | String | Status | |
| statusref | String | Statusref | |
| subsidiary | String | Subsidiary | |
| subsidiarytaxregnum | String | Subsidiarytaxregnum | |
| syncpartnerteams | Boolean | Syncpartnerteams | |
| syncsalesteams | Boolean | Syncsalesteams | |
| taxdetailsoverride | Boolean | Taxdetailsoverride | |
| taxpointdate | Date | Taxpointdate | |
| taxpointdateoverride | Boolean | Taxpointdateoverride | |
| taxregoverride | Boolean | Taxregoverride | |
| title | String | Title | |
| total | String | Total | |
| totalcostestimate | Decimal | Totalcostestimate | |
| trandate | Date | Trandate | |
| tranid | String | Tranid | |
| unbilledorders | Decimal | Unbilledorders | |
| weightedtotal | Decimal | Weightedtotal | |
| winlossreason | String | Winlossreason |