prospect
The prospect table.
Columns
| Name | Type | References | Description |
| accessrole | String | Accessrole | |
| accountnumber | String | Accountnumber | |
| altemail | String | Altemail | |
| altphone | String | Altphone | |
| assignedwebsite | String | Assignedwebsite | |
| autoname | Boolean | Autoname | |
| balance | Decimal | Balance | |
| billpay | Boolean | Billpay | |
| buyingreason | String | Buyingreason | |
| buyingtimeframe | String | Buyingtimeframe | |
| campaigncategory | String | Campaigncategory | |
| category | String | Category | |
| clickstream | String | Clickstream | |
| comments | String | Comments | |
| companyname | String | Companyname | |
| consolbalance | Decimal | Consolbalance | |
| consoldaysoverdue | Integer | Consoldaysoverdue | |
| consoldepositbalance | Decimal | Consoldepositbalance | |
| consoloverduebalance | Decimal | Consoloverduebalance | |
| consolunbilledorders | Decimal | Consolunbilledorders | |
| contact | String | Contact | |
| creditholdoverride | String | Creditholdoverride | |
| creditlimit | String | Creditlimit | |
| currency | String | Currency | |
| currencyprecision | String | Currencyprecision | |
| customform | String | Customform | |
| datecreated | Datetime | Datecreated | |
| daysoverdue | Integer | Daysoverdue | |
| defaultaddress | String | Defaultaddress | |
| defaultbankaccount | String | Defaultbankaccount | |
| depositbalance | Decimal | Depositbalance | |
| draccount | String | Draccount | |
| String | |||
| emailpreference | String | Emailpreference | |
| emailtransactions | Boolean | Emailtransactions | |
| entityid | String | Entityid | |
| entitystatus | String | Entitystatus | |
| estimatedbudget | Decimal | Estimatedbudget | |
| externalid | String | Externalid | |
| fax | String | Fax | |
| faxtransactions | Boolean | Faxtransactions | |
| firstname | String | Firstname | |
| firstvisit | Datetime | Firstvisit | |
| fxaccount | String | Fxaccount | |
| giveaccess | Boolean | Giveaccess | |
| globalsubscriptionstatus | String | Globalsubscriptionstatus | |
| homephone | String | Homephone | |
| image | String | Image | |
| isbudgetapproved | Boolean | Isbudgetapproved | |
| isinactive | Boolean | Isinactive | |
| isjob | String | Isjob | |
| isperson | String | Isperson | |
| keywords | String | Keywords | |
| language | String | Language | |
| lastmodifieddate | Datetime | Lastmodifieddate | |
| lastname | String | Lastname | |
| lastpagevisited | String | Lastpagevisited | |
| lastvisit | Datetime | Lastvisit | |
| leadsource | String | Leadsource | |
| middlename | String | Middlename | |
| mobilephone | String | Mobilephone | |
| monthlyclosing | String | Monthlyclosing | |
| negativenumberformat | String | Negativenumberformat | |
| numberformat | String | Numberformat | |
| openingbalance | Decimal | Openingbalance | |
| openingbalanceaccount | String | Openingbalanceaccount | |
| openingbalancedate | Date | Openingbalancedate | |
| otherrelationships | String | Otherrelationships | |
| overduebalance | Decimal | Overduebalance | |
| parent | String | Parent | |
| partner | String | Partner | |
| phone | String | Phone | |
| phoneticname | String | Phoneticname | |
| prefccprocessor | String | Prefccprocessor | |
| pricelevel | String | Pricelevel | |
| printoncheckas | String | Printoncheckas | |
| printtransactions | Boolean | Printtransactions | |
| probability | String | Probability | |
| receivablesaccount | String | Receivablesaccount | |
| referrer | String | Referrer | |
| resalenumber | String | Resalenumber | |
| salesreadiness | String | Salesreadiness | |
| salesrep | Integer | Salesrep | |
| salutation | String | Salutation | |
| sendemail | Boolean | Sendemail | |
| sourcewebsite | String | Sourcewebsite | |
| stage | String | Stage | |
| startdate | Date | Startdate | |
| strength | String | Strength | |
| subsidiary | String | Subsidiary | |
| syncpartnerteams | Boolean | Syncpartnerteams | |
| syncsalesteams | Boolean | Syncsalesteams | |
| taxable | Boolean | Taxable | |
| taxfractionunit | String | Taxfractionunit | |
| taxitem | String | Taxitem | |
| taxrounding | String | Taxrounding | |
| terms | String | Terms | |
| territory | String | Territory | |
| title | String | Title | |
| unbilledorders | Decimal | Unbilledorders | |
| unsubscribe | String | Unsubscribe | |
| url | String | Url | |
| vatregnumber | String | Vatregnumber | |
| visits | Integer | Visits | |
| weblead | String | Weblead |