Leads
Create, update, delete, and query the Leads 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 lead. |
| Date_Entered | Datetime | True |
The date the record was created. |
| Date_Modified | Datetime | True |
The 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 record. |
| Description | String | False |
Full text of the note. |
| Deleted | Bool | False |
The record deletion indicator. |
| Assigned_User_Id | String | False |
The Id of the user 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 address for the Lead. | |
| Email1 | String | False |
The alternate email address for the Lead. |
| Email2 | String | False |
The alternate email address for the Lead. |
| Invalid_Email | Bool | False |
Whether email for the Lead has been marked as invalid. |
| Email_Opt_Out | Bool | False |
Whether the Lead has opted out of email. |
| Email_Addresses_Non_Primary | String | False |
The nonprimary email addresses of the lead. |
| Salutation | String | False |
The contact salutation (e.g., Mr., Ms.). |
| First_Name | String | False |
The first name of the lead. |
| Last_Name | String | False |
The last name of the lead. |
| Full_Name | String | False |
The full name of the lead. |
| Title | String | False |
The title of the lead. |
| String | False |
The Facebook name of the lead. | |
| String | False |
The Twitter name of the lead. | |
| Googleplus | String | False |
The Google Plus Id of the lead. |
| Department | String | False |
The department the lead belongs to. |
| Do_Not_Call | Bool | False |
An indicator of whether the lead can be called. |
| Phone_Home | String | False |
The home phone number of the lead. |
| Phone_Mobile | String | False |
The mobile phone number of the lead. |
| Phone_Work | String | False |
The work phone number of the lead. |
| Phone_Other | String | False |
Other phone number for the lead |
| Phone_Fax | String | False |
The contact 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 address. |
| 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 for the alternate address. |
| Alt_Address_Street_3 | String | False |
The third line for 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 lead. |
| Assistant_Phone | String | False |
The phone number of the assistant of the lead. |
| Picture | String | False |
The picture of the lead. |
| Converted | Bool | False |
Whether the lead been converted to a contact (and other Sugar objects). |
| Refered_By | String | False |
Identifies who refered the lead. |
| Lead_Source | String | False |
Lead source (e.g., Web or print). |
| Lead_Source_Description | String | False |
The description of the lead source. |
| Status | String | False |
The status of the lead. |
| Status_Description | String | False |
Description of the status of the lead. |
| Reports_To_Id | String | False |
Id of the contact the Lead reports to. |
| Report_To_Name | String | False |
The name of the contact the Lead reports to. |
| Dnb_Principal_Id | String | False |
The unique Id For the D. and B. Contact. |
| Account_Name | String | False |
The account name for lead. |
| Account_Description | String | False |
The description of lead account. |
| Contact_Id | String | False |
The Id of the contact resulting from the conversion. |
| Contact_Name | String | False |
The name of the contact resulting from the conversion. |
| Account_Id | String | False |
The account Id resulting from the conversion. |
| Opportunity_Id | String | False |
The opportunity Id resulting from the conversion. |
| Opportunity_Name | String | False |
The opportunity name resulting from the conversion. |
| Opportunity_Amount | String | False |
The amount of the opportunity. |
| Campaign_Id | String | False |
The Id of the campaign that generated the lead. |
| Campaign_Name | String | False |
The name of the campaign that generated the lead. |
| C_Accept_Status_Fields | String | False |
The fields in the accept status of the call. |
| M_Accept_Status_Fields | String | False |
The fields in the accept status of the meeting. |
| Accept_Status_Id | String | False |
The Id of the accept status. |
| Accept_Status_Name | String | False |
The name of the accept status. |
| Accept_Status_Calls | String | False |
The accept status of calls for the lead. |
| Accept_Status_Meetings | String | False |
The accept status of meetings for the lead. |
| Webtolead_Email1 | String | False |
The main email address of the lead. |
| Webtolead_Email2 | String | False |
The secondary email address of the lead. |
| Webtolead_Email_Opt_Out | Bool | False |
Whether the lead elects to opt out of email campaigns. |
| Webtolead_Invalid_Email | Bool | False |
Whether the email address for the lead is invalid. |
| Birthdate | Datetime | False |
The birthdate of the lead. |
| Portal_Name | String | False |
Portal user name when the lead was created via the lead portal. |
| Portal_App | String | False |
Portal application when the lead was created via lead portal. |
| Website | String | False |
The URL of the website for the company. |
| Preferred_Language | String | False |
The preferred language of the lead. |
| Mkto_Sync | Bool | False |
Whether the lead is to be synced to Marketo. |
| Mkto_Id | Int | False |
The associated Marketo lead Id. |
| Mkto_Lead_Score | Int | False |
The lead score of the associated Marketo lead. |