Leads
Stores prospective customer records representing individuals or organizations that might convert into opportunities. This table supports lead qualification, nurturing workflows, and conversion tracking into contacts, accounts, and opportunities.
Columns
| Name | Type | ReadOnly | Description |
| Accept_Status_Calls | String | False |
The user's availability status for accepting calls that are related to this lead (for example, 'Accept', 'Decline', or 'Tentative'. |
| Accept_Status_Id | String | False |
The unique identifier (Id) for the acceptance status record that is associated with this lead. This Id is used to determine the user's communication availability state. |
| Accept_Status_Meetings | String | False |
The user's availability status for accepting meeting invitations that are related to this lead. |
| Accept_Status_Messages | String | False |
The user's availability status for accepting message-based communications that are related to this lead. |
| Accept_Status_Name | String | False |
The display name of the acceptance status configuration that is applied to this lead's communication preferences. |
| Account_Description | String | False |
A descriptive summary of the account that is associated with the lead or that can result from lead conversion. This value can provide context for qualification decisions. |
| Account_Id | String | False |
The Id of the account that is created or linked when this lead is converted. This value is blank until conversion occurs. |
| Account_Name | String | False |
The display name of the account that is associated with the lead, either through conversion or manual association. |
| Account_To_Lead | String | True |
A field used internally to support lead-to-account association workflows, including matching and duplicate checking during conversion. |
| Acl_Team_Names | String | True |
The list of team names that are associated with this lead. These names determine which teams can view or collaborate on the lead record. |
| Acl_Team_Set_Id | String | False |
The Id of the team set that is associated with this lead. The team set defines the complete group of teams that are granted access. |
| Ai_Conv_Bin_Accuracy | Decimal | True |
The accuracy value of the AI lead conversion binary prediction model. Higher values indicate stronger prediction reliability for conversion likelihood. |
| Ai_Conv_Multiplier | Decimal | True |
The weighting factor that is applied to the AI conversion score to influence prioritization or routing decisions. |
| Ai_Conv_Score_Absolute | Decimal | True |
The absolute AI-generated score that estimates how likely the lead is to convert into an account, contact, or opportunity. |
| Ai_Conv_Score_Classification | String | True |
The classification label that is assigned to the AI conversion score (for example, 'High', 'Medium', or 'Low' likelihood). |
| Ai_Icp_Fit_Bin_Accuracy | Decimal | True |
The accuracy value of the Ideal Customer Profile (ICP) fit model, indicating how well the lead aligns with known successful customer attributes. |
| Ai_Icp_Fit_Multiplier | Decimal | True |
The weighting factor that is applied to the ICP fit score when calculating prioritization rankings. |
| Ai_Icp_Fit_Score_Absolute | Decimal | True |
The absolute score that indicates how closely this lead matches the organization's ICP. |
| Ai_Icp_Fit_Score_Classification | String | True |
The classification label that describes the ICP fit score quality (for example, 'Excellent', 'Average', or 'Poor'). |
| Alt_Address_City | String | False |
The city of the lead's alternate address. |
| Alt_Address_Country | String | False |
The country of the lead's alternate address. |
| Alt_Address_Postalcode | String | False |
The postal code or ZIP code of the lead's alternate address. |
| Alt_Address_State | String | False |
The state or province of the lead's alternate address. |
| Alt_Address_Street | String | False |
The street address of the lead's alternate address. |
| Alt_Address_Street_2 | String | False |
An additional street address line for the lead's alternate address, if it is required for mailing or location detail. |
| Alt_Address_Street_3 | String | False |
A third street address line for the lead's alternate address, used when extended address formatting is needed. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned ownership of this lead. This user is responsible for qualification and follow-up. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned ownership of this lead. This value appears in record headers and assignment views. |
| Assistant | String | False |
The name of the assistant who supports the lead, when relevant to outreach or scheduling. |
| Assistant_Phone | String | False |
The phone number of the lead's assistant, when direct scheduling or contact coordination is needed. |
| Base_Rate | Decimal | False |
The currency conversion rate that is applied when revenue or valuation metrics are calculated for this lead. |
| Birthdate | Date | False |
The date of birth of the lead contact. This value can support demographic or segmentation analysis. |
| Brand_C | String | False |
A brand-related classification or segmentation code that is assigned to the lead for marketing or routing purposes. |
| Business_Center_Id | String | False |
The Id of the business center that is associated with this lead. Business centers can define geographic, organizational, or operational routing zones. |
| Business_Center_Name | String | True |
The display name of the business center that is associated with this lead. This value appears in user interfaces and routing workflows. |
| C_Accept_Status_Fields | String | True |
A list of acceptance status fields that are configured for communication tracking with this lead. |
| Campaign_Id | String | False |
The Id of the campaign that generated or influenced this lead. This value is used for marketing attribution and Return on Investment (ROI) reporting. |
| Campaign_Name | String | True |
The display name of the campaign that is associated with this lead. This value appears in lead source and campaign performance reporting. |
| Classification_C | String | False |
An internal classification or segmentation code that is used to categorize the lead for routing, scoring, or reporting. |
| Commentlog | String | True |
The log of comments and discussion notes that are associated with this lead. This field supports collaboration and activity context. |
| Contact_Id | String | False |
The Id of the contact that is created when this lead is converted. This value remains blank until conversion occurs. |
| Contact_Name | String | True |
The display name of the contact that results from lead conversion. |
| Converted | Bool | False |
A Boolean field that returns a value of 'true' when this lead has been converted into one or more SugarCRM records such as an account, contact, or opportunity. It returns a value of 'false' when the lead remains unconverted. |
| Converted_Opp_Name | String | True |
The display name of the opportunity that is created during lead conversion, when applicable. |
| Created_By | String | True |
The Id of the user who created this lead record. This value supports audit tracking and origin identification. |
| Created_By_Name | String | True |
The display name of the user who created this lead record. This value appears in audit history and detail views. |
| Currency_Id | String | False |
The Id of the currency that is associated with this lead. This value ensures accurate financial display in multi-currency environments. |
| Date_Entered | Datetime | True |
The date and time when this lead record was created. This timestamp supports history and audit review. |
| Date_Modified | Datetime | True |
The date and time when this lead record was last modified. This timestamp supports version tracking and change review. |
| Dead_End_Other_C | String | False |
A reason value recorded when the lead is marked as dead end for a reason that does not fall under standard categories. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this lead record is marked as deleted. It returns a value of 'false' when the record remains active. |
| Department | String | False |
The department or functional area that the lead belongs to within their organization. |
| Description | String | False |
A free-form descriptive note that provides context, history, or qualification background for this lead. |
| Dnb_Principal_Id | String | False |
The Id that is assigned by Dun & Bradstreet for the principal contact associated with this lead, when third-party business data enrichment is enabled. |
| Do_Not_Call | Bool | False |
A Boolean field that returns a value of 'true' when the lead requests not to be contacted by phone. It returns a value of 'false' when calling is permitted. |
| Dp_Business_Purpose | String | True |
The list of business purposes for which the lead has consented to data usage, used to support privacy and compliance obligations. |
| Dp_Consent_Last_Updated | Date | False |
The date when the lead's consent preferences were last updated. |
| Dri_Workflow_Template_Id | String | False |
The Id of the Customer Journey or engagement workflow template that is associated with this lead, when journey automation is used. |
| Dri_Workflow_Template_Name | String | True |
The display name of the workflow template that is associated with this lead, used to track guided engagement steps. |
| String | False |
The primary email address of the lead. | |
| Email_Addresses_Non_Primary | String | False |
A list of additional email addresses that are associated with the lead but are not marked as primary. |
| Email_Opt_Out | Bool | False |
A Boolean field that returns a value of 'true' when the lead has opted out of email communication. It returns a value of 'false' when email communication is permitted. |
| Email1 | String | False |
The primary email address of the lead, frequently used in legacy configurations. |
| Email2 | String | False |
A secondary email address for the lead, used when alternate contact routing is necessary. |
| Estimate_Remittance_C | Decimal | False |
An estimated financial amount that is associated with remittance or revenue expectation for this lead, when tracked. |
| String | False |
The Facebook profile or handle that is associated with the lead. | |
| First_Name | String | False |
The first name of the lead contact. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this lead. It returns a value of 'false' when the lead is not being followed. |
| Full_Name | String | True |
The full name of the lead contact, formatted according to system settings. |
| Googleplus | String | False |
The Google Plus profile Id that is associated with the lead. This field is retained for legacy social profile storage. |
| Hint_Account_Annual_Revenue | String | False |
The annual revenue amount of the associated company, as provided by Hint enrichment data sources. |
| Hint_Account_Description | String | False |
A company description that is enriched from Hint data sources to support contextual qualification. |
| Hint_Account_Facebook_Handle | String | False |
The company's Facebook handle as enriched from Hint data sources. |
| Hint_Account_Fiscal_Year_End | String | False |
The fiscal year-end date for the company, as provided by Hint enrichment. |
| Hint_Account_Founded_Year | String | False |
The year in which the company was founded, as provided by Hint enrichment. |
| Hint_Account_Industry | String | False |
The industry classification of the company, enriched to support segmentation and ICP scoring. |
| Hint_Account_Location | String | False |
The primary geographic location of the company, enriched for routing and regional assignment. |
| Hint_Account_Logo | String | False |
A URL or encoded image reference for the company's logo, enriched from Hint data sources. |
| Hint_Account_Naics_Code_Lbl | String | False |
The NAICS industry classification label that is associated with the company. |
| Hint_Account_Sic_Code_Label | String | False |
The SIC industry classification label that is associated with the company. |
| Hint_Account_Size | String | False |
The company size classification, enriched for segmentation and ICP fit scoring. |
| Hint_Account_Twitter_Handle | String | False |
The company's Twitter handle, enriched for engagement or research. |
| Hint_Account_Website | String | False |
The company's website URL, enriched to support research and qualification. |
| Hint_Contact_Pic | String | False |
A URL or encoded image reference for the lead's contact photo, enriched from Hint sources. |
| Hint_Education | String | False |
Education details that are enriched from Hint data sources. |
| Hint_Education_2 | String | False |
Additional education details that are enriched from Hint data sources. |
| Hint_Facebook | String | False |
The lead's Facebook profile, enriched when it is available. |
| Hint_Industry_Tags | String | False |
Industry-related tags or keywords that are enriched for segmentation and targeting. |
| Hint_Job_2 | String | False |
Additional job or role information for the contact, enriched from third-party sources. |
| Hint_Phone_1 | String | False |
An additional phone number enriched through Hint sources. |
| Hint_Phone_2 | String | False |
A second additional phone number enriched through Hint sources. |
| Hint_Photo | String | False |
A profile image reference that is enriched from external data sources. |
| Hint_Twitter | String | False |
The lead's Twitter handle, enriched for outreach or research. |
| Id [KEY] | String | True |
The Id of this lead record. The system uses this Id to reference and manage the lead internally. |
| Invalid_Email | Bool | False |
A Boolean field that returns a value of 'true' when the primary email on file is known to be invalid. It returns a value of 'false' when the email is deliverable. |
| Last_Name | String | False |
The last name of the lead contact. |
| Lead_Source | String | False |
The source through which the lead was acquired (for example, 'Web Form', 'Trade Show', 'Referral', or 'Purchased List'). |
| Lead_Source_Description | String | False |
A descriptive explanation of the lead source, such as event details or acquisition notes. |
| Locked_Fields | String | True |
The list of fields that are restricted from modification to maintain lead data integrity or compliance requirements. |
| M_Accept_Status_Fields | String | True |
The set of acceptance status fields that are configured for messaging or communication transactions that are related to this lead. |
| Market_Interest_Prediction_Score | String | True |
The predictive score that indicates the lead's likelihood of expressing interest or responding to market outreach. |
| Market_Score | Int | True |
A numerical score that represents the lead's overall market fit, derived from behavioral, demographic, or segmentation data. |
| Mkto_Id | Int | True |
The Id of the corresponding Marketo lead record when lead synchronization with Marketo is enabled. |
| Mkto_Lead_Score | Int | True |
The lead score that is assigned by Marketo based on engagement, activity, and behavioral scoring models. |
| Mkto_Sync | Bool | False |
A Boolean field that returns a value of 'true' when this lead should be synchronized with Marketo. It returns a value of 'false' when synchronization is disabled. |
| Modified_By_Name | String | True |
The display name of the user who last modified this lead record. This value supports visibility in audit and review contexts. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this lead record. This value is used to track responsibility for changes. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the current user has marked this lead as a favorite. It returns a value of 'false' when the lead is not marked as a favorite. |
| Name | String | True |
The full display name of the lead, formatted according to system settings and naming conventions. |
| Opportunity_Amount | String | False |
The expected opportunity value that is associated with this lead when it progresses into an opportunity stage. |
| Opportunity_Id | String | False |
The Id of the opportunity that results from lead conversion, when applicable. |
| Opportunity_Name | String | False |
The display name of the opportunity that is associated with this lead through conversion or manual association. |
| Other_Underwriter_Notes_C | String | False |
Additional underwriting notes that are recorded for review, evaluation, or approval processes. |
| Perform_Sugar_Action | Bool | False |
A Boolean field that returns a value of 'true' when automated workflow actions should be performed on this lead. It returns a value of 'false' when no automation should be applied. |
| Phone_Fax | String | False |
The fax number that is associated with the lead's contact information. |
| Phone_Home | String | False |
The home phone number that is associated with the lead's contact record. |
| Phone_Mobile | String | False |
The mobile phone number for contacting the lead. |
| Phone_Other | String | False |
An additional phone number that is associated with the lead, used for alternative or backup contact methods. |
| Phone_Work | String | False |
The work phone number that is associated with the lead's primary business contact. |
| Picture | String | False |
The avatar or profile image that is associated with the lead's contact profile. |
| Portal_App | String | False |
The portal application that is used to create the lead record when the lead originates from a self-service portal. |
| Portal_Name | String | False |
The username or display name of the portal user who submitted the lead through a portal interface. |
| Preferred_Language | String | False |
The preferred communication language for the lead, used for outreach and localization. |
| Primary_Address_City | String | False |
The city of the lead's primary mailing address. |
| Primary_Address_Country | String | False |
The country of the lead's primary mailing address. |
| Primary_Address_Postalcode | String | False |
The postal code or ZIP code of the lead's primary mailing address. |
| Primary_Address_State | String | False |
The state or province of the lead's primary mailing address. |
| Primary_Address_Street | String | False |
The street address that is associated with the lead's primary mailing address. |
| Primary_Address_Street_2 | String | False |
An additional street address line for the lead's primary mailing address, when needed for location detail. |
| Primary_Address_Street_3 | String | False |
A third street address line for the lead's primary mailing address, when extended address formatting is required. |
| Refered_By | String | False |
The person, entity, or source that referred the lead to the organization. |
| Report_To_Name | String | True |
The display name of the manager, executive, or primary contact to whom the lead reports within their organization. |
| Reports_To_Id | String | False |
The Id of the contact record that the lead reports to within organizational hierarchy. |
| Salutation | String | False |
The contact salutation used when addressing the lead (for example, 'Mr', 'Ms', or 'Dr'). |
| Status | String | False |
The current status of the lead in the qualification lifecycle (for example, 'New', 'Working', 'Nurturing', or 'Converted'). |
| Status_Description | String | False |
A descriptive explanation of the lead's status, such as progress notes or qualification reasoning. |
| Sync_Key | String | True |
The synchronization key that is used to align this lead with external systems or other data sources. |
| Tag | String | False |
The tags that are applied to this lead for grouping, filtering, and classification. |
| Team_Count | String | False |
The number of teams that are associated with this lead. This value supports collaboration and visibility analysis. |
| Team_Id | String | False |
The Id of the primary team that is associated with this lead. The primary team defines the default access scope. |
| Team_Name | String | False |
The display name of the primary team that is associated with this lead. |
| Team_Set_Id | String | False |
The Id of the full team set that is associated with this lead. The team set defines all teams that are permitted to view or modify the record. |
| Title | String | False |
The job title or professional role of the lead. |
| String | False |
The Twitter handle or username that is associated with the lead. | |
| Underwriters_Non_Fntg_C | String | False |
Underwriting notes that are not related to funding considerations, where applicable. |
| Website | String | False |
The website URL of the lead's associated company or organization. |
| Webtolead_Email_Opt_Out | Bool | False |
A Boolean field that returns a value of 'true' when the lead has opted out of email marketing during Web-to-Lead capture. It returns a value of 'false' when email marketing is permitted. |
| Webtolead_Email1 | String | False |
The primary email address that is captured through web-to-lead submission. |
| Webtolead_Email2 | String | False |
The secondary email address that is captured through web-to-lead submission. |
| Webtolead_Invalid_Email | Bool | False |
A Boolean field that returns a value of 'true' when the email address that is captured through Web-to-Lead submission is invalid. It returns a value of 'false' when the email is valid. |