Prospects
Create, update, delete, and query the Prospects module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| My_Favorite | Bool | False |
Whether the record is a favorite for the user. |
| Following | Bool | False |
Whether the user is following this record. |
| Id [KEY] | String | False |
The unique identifier of the record. |
| Name | String | False |
The name of the prospect. |
| Date_Entered | Datetime | True |
Date the record was created. |
| Date_Modified | Datetime | True |
Date the record was last modified. |
| Modified_User_Id | String | True |
The Id of the user who last modified the record. |
| Modified_By_Name | String | True |
The user name of the user who last modified the record. |
| Created_By | String | True |
The Id of the user who created the record. |
| Created_By_Name | String | True |
The user name of the user who created the record. |
| Doc_Owner | String | False |
The document owner. |
| User_Favorites | String | False |
The user favorites for the prospect. |
| Description | String | False |
Full text of the note. |
| Deleted | Bool | False |
Record deletion indicator. |
| Assigned_User_Id | String | False |
User Id assigned to the record. |
| Assigned_User_Name | String | False |
The user name of the user assigned to the record. |
| Team_Id | String | False |
The Id of the primary team. |
| Team_Set_Id | String | False |
The Id of the team set. |
| Team_Count | String | False |
The count of the team set. |
| Team_Name | String | False |
The name of the primary team. |
| String | False |
The email for the prospect. | |
| Email1 | String | False |
The alternate email for the prospect. |
| Email2 | String | False |
The alternate email for the prospect. |
| Invalid_Email | Bool | False |
Whether the prospect email has been marked as invalid. |
| Email_Opt_Out | Bool | False |
Whether the prospect has opted out of radio. |
| Email_Addresses_Non_Primary | String | False |
The nonprimary email addresses for the prospect. |
| Salutation | String | False |
The prospect salutation (e.g., Mr. or Ms.). |
| First_Name | String | False |
The first name of the prospect. |
| Last_Name | String | False |
The last name of the prospect. |
| Full_Name | String | False |
The full name of hte prospect. |
| Title | String | False |
The title of the prospect. |
| String | False |
The Facebook name of the user. | |
| String | False |
The Twitter name of the user. | |
| Googleplus | String | False |
The Google Plus Id of the user. |
| Department | String | False |
The department of the prospect. |
| Do_Not_Call | Bool | False |
An indicator of whether the prospect can be called. |
| Phone_Home | String | False |
Home phone number of the prospect. |
| Phone_Mobile | String | False |
Mobile phone number of the prospect. |
| Phone_Work | String | False |
Work phone number of the prospect. |
| Phone_Other | String | False |
Other phone number for the prospect. |
| Phone_Fax | String | False |
The prospect fax number. |
| Primary_Address_Street | String | False |
The street address used for the primary address. |
| Primary_Address_Street_2 | String | False |
The second line of the primary address. |
| Primary_Address_Street_3 | String | False |
The third line of the primary addrss. |
| Primary_Address_City | String | False |
The city for the primary address. |
| Primary_Address_State | String | False |
The state for the primary address. |
| Primary_Address_Postalcode | String | False |
The postal code for the primary address. |
| Primary_Address_Country | String | False |
The country for the primary address. |
| Alt_Address_Street | String | False |
The street address for the alternate address. |
| Alt_Address_Street_2 | String | False |
The second line of the alternate address. |
| Alt_Address_Street_3 | String | False |
The third line of the alternate address. |
| Alt_Address_City | String | False |
The city for the alternate address. |
| Alt_Address_State | String | False |
The state for the alternate address. |
| Alt_Address_Postalcode | String | False |
The postal code for the alternate address. |
| Alt_Address_Country | String | False |
The country for the alternate address. |
| Assistant | String | False |
The name of the assistant of the prospect. |
| Assistant_Phone | String | False |
The phone number of the assistant of the prospect. |
| Picture | String | False |
The picture for the prospect. |
| Tracker_Key | Int | True |
The key for the associated tracker. |
| Birthdate | Datetime | False |
The birthdate of the prospect. |
| Lead_Id | String | False |
The Id of the associated lead. |
| Account_Name | String | False |
The name of the associated acocunt. |
| Campaign_Id | String | False |
Campaign that generated the lead. |
| Dnb_Principal_Id | String | False |
The Id for the D. and B. Contact. |