Contacts
Stores contact records representing individual people who are associated with accounts, opportunities, or leads. This table supports relationship management, communication workflows, and customer engagement activities.
Columns
| Name | Type | ReadOnly | Description |
| Accept_Status_Calls | String | False |
The contact's acceptance status for call invitations. This field reflects whether the contact has accepted, declined, or not responded to the call request. |
| Accept_Status_Id | String | False |
The internal reference value that represents the contact's current acceptance status across supported activity types. |
| Accept_Status_Meetings | String | False |
The contact's acceptance status for meeting invitations. This field indicates whether the contact has accepted, declined, or not responded to meeting requests. |
| Accept_Status_Messages | String | False |
The contact's acceptance status for message-based interactions or communications that are associated with the CRM record. |
| Accept_Status_Name | String | False |
The descriptive label that corresponds to the contact's acceptance status. This value is typically displayed in the user interface. |
| Account_Id | String | False |
The identifier (Id) of the account that is associated with the contact. This field establishes the primary organizational relationship for account-based workflows. |
| Account_Name | String | True |
The display name of the account that is associated with the contact. This field provides readable context for the account_id relationship. |
| Accounting_Bulletins_C | Bool | False |
A Boolean field that returns a value of 'true' when the contact is subscribed to receive accounting bulletins or financial communications. It returns a value of 'false' when the contact is not subscribed. |
| Acl_Team_Names | String | True |
A system-managed list of team names that grant the current user access to this contact record. This field supports access control and data visibility enforcement. |
| Acl_Team_Set_Id | String | False |
The Id that references the team set that is associated with this contact record. Team sets allow multiple teams to share access to a record. |
| Alt_Address_City | String | False |
The city of the contact's alternate address location. This address can be used for secondary mailing or communication purposes. |
| Alt_Address_Country | String | False |
The country of the contact's alternate address location. |
| Alt_Address_Postalcode | String | False |
The postal code of the contact's alternate address location. |
| Alt_Address_State | String | False |
The state or region of the contact's alternate address location. |
| Alt_Address_Street | String | False |
The street address of the contact's alternate address location. |
| Alt_Address_Street_2 | String | False |
The second address line of the contact's alternate address location. This field is used for suite numbers, unit identifiers, or extended address details. |
| Alt_Address_Street_3 | String | False |
The third address line of the contact's alternate address location. This field supports additional addressing needs. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned ownership of the contact record. This field supports workload distribution and accountability. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned ownership of the contact record. |
| Assistant | String | False |
The name of the assistant who supports the contact in business-related activities. |
| Assistant_Phone | String | False |
The assistant's phone number, used for scheduling and direct communication on behalf of the contact. |
| Birthdate | Date | False |
The contact's date of birth. This information can support age-based personalization, demographic analysis, or compliance-driven documentation. |
| Business_Center_Id | String | False |
The Id of the business center that is associated with the contact. Business centers are used to determine hours of service and region-specific handling. |
| Business_Center_Name | String | True |
The display name of the business center that is associated with the contact. This value corresponds to the business_center_id field. |
| C_Accept_Status_Fields | String | True |
A stored representation of acceptance status values across multiple communication channels for the contact. This field supports user interface rendering and workflow logic. |
| Campaign_Id | String | False |
The Id of the marketing campaign that originally generated or influenced the contact. This field supports campaign attribution and performance analysis. |
| Campaign_Name | String | True |
The display name of the marketing campaign that is associated with the contact. This value provides readable context for the campaign_id field. |
| Commentlog | String | True |
A free-form text field for storing internal comments that are related to the contact record. This field supports collaborative communication among CRM users. |
| Contact_Type_C | String | False |
The classification of the contact based on organizational category, relationship role, or segmentation criteria. |
| Contactid_C | String | False |
An internal or external reference Id for the contact that is used in integrated business systems. |
| Cookie_Consent | Bool | False |
A Boolean field that returns a value of 'true' when the contact provides consent for cookie usage within portal or digital service interfaces. It returns a value of 'false' when consent is not provided. |
| Cookie_Consent_Received_On | Datetime | False |
The date and time when cookie consent was received from the contact. This field supports privacy compliance auditing. |
| Created_By | String | True |
The Id of the user who created the contact record. This field supports record lineage and audit history. |
| Created_By_Name | String | True |
The display name of the user who created the contact record. |
| Date_Entered | Datetime | True |
The date and time when the contact record was created. |
| Date_Modified | Datetime | True |
The date and time when the contact record was last modified. |
| Day_Of_Birth_Yr_Optional_C | String | False |
An optional user-provided date-of-birth field that can store only month and day information when the year is not required or is unavailable. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the contact record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and data recovery. |
| Department | String | False |
The department or organizational division that is associated with the contact, typically used for business demographic segmentation or reporting. |
| Description | String | False |
A free-form descriptive text field that is used to store additional narrative or contextual information about the contact. |
| Dnb_Principal_Id | String | False |
The external reference Id that is used to identify the contact within Dun & Bradstreet (DNB) business intelligence systems. |
| Do_Not_Call | Bool | False |
A Boolean field that returns a value of 'true' when the contact requests not to be contacted by phone. It returns a value of 'false' when phone communication is permitted. This field supports compliance with consent and privacy requirements. |
| Dp_Business_Purpose | String | True |
A list or descriptor of the business purposes for which the contact has granted consent. This field supports regulatory documentation such as privacy and consent audits. |
| Dp_Consent_Last_Updated | Date | False |
The date when the contact's consent preferences were most recently reviewed or updated for compliance tracking. |
| Dri_Workflow_Template_Id | String | False |
The Id of the Customer Journey workflow template that is associated with this contact. This field links the contact to guided process flows. |
| Dri_Workflow_Template_Name | String | True |
The display name of the Customer Journey workflow template that is associated with this contact. |
| String | False |
The primary email address for the contact, used for direct communication, campaign outreach, or portal account identity. | |
| Email_Addresses_Non_Primary | String | False |
A collection of additional email addresses that are associated with the contact but are not designated as the primary email address. |
| Email_And_Name1 | String | False |
A formatted reference that combines the contact's name and primary email address for display in messaging or selection fields. |
| Email_Opt_Out | Bool | False |
A Boolean field that returns a value of 'true' when the contact has opted out of email communications. It returns a value of 'false' when email communication is permitted. This field supports compliance with digital communication regulations. |
| Email1 | String | False |
The primary email address value that is stored for the contact. This field is typically used internally in messaging workflows. |
| Email2 | String | False |
A secondary email address for the contact. This field supports alternative communication or account recovery. |
| Entry_Source | String | True |
The origin of the contact record, indicating whether it was created directly within the SugarCRM application or imported from an external system. |
| Escrow_Bulletins_C | Bool | False |
A Boolean field that returns a value of 'true' when the contact is subscribed to receive escrow-related bulletins or notifications. It returns a value of 'false' when the contact is not subscribed. |
| String | False |
The contact's Facebook profile name or handle, which can be used for social engagement or identity reference. | |
| First_Name | String | False |
The contact's first name. |
| Fnf_Agencies_Contacts_1_Name | String | True |
The display name of the associated agency record when the contact is linked through Fidelity National Financial (FNF) organizational relationships. |
| Fnf_Agencies_Contacts_1fnf_Agencies_Ida | String | False |
The Id of the agency record that is associated with the contact in FNF organizational relationships. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the contact record. It returns a value of 'false' when the record is not being followed. |
| Full_Name | String | True |
The fully formatted name of the contact, typically composed from first name, last name, and any applicable prefixes or suffixes. |
| General_Bulletins_C | Bool | False |
A Boolean field that returns a value of 'true' when the contact is subscribed to receive general informational bulletins. It returns a value of 'false' when the contact is not subscribed. |
| Googleplus | String | False |
The contact's Google+ profile Id. This field remains for legacy reference and archival historical data. |
| Hint_Account_Annual_Revenue | String | False |
The estimated or reported annual revenue for the associated organization, as supplied by Sugar Hint enrichment data. |
| Hint_Account_Description | String | False |
A descriptive profile summary of the associated organization, as enriched by Sugar Hint. |
| Hint_Account_Facebook_Handle | String | False |
The Facebook profile handle of the associated account, as provided by Sugar Hint. |
| Hint_Account_Fiscal_Year_End | String | False |
The fiscal year-end month for the associated organization, as provided by Sugar Hint enrichment data. |
| Hint_Account_Founded_Year | String | False |
The year in which the associated organization was founded, as supplied by Sugar Hint data enrichment. |
| Hint_Account_Industry | String | False |
The industry classification of the associated organization, as determined through Sugar Hint data enrichment. |
| Hint_Account_Location | String | False |
The primary location of the associated organization, as provided by Sugar Hint data enrichment. |
| Hint_Account_Logo | String | False |
The logo image reference for the associated account, obtained via Sugar Hint data services. |
| Hint_Account_Naics_Code_Lbl | String | False |
The NAICS classification code that is associated with the organization, provided by Sugar Hint enrichment data. |
| Hint_Account_Sic_Code_Label | String | False |
The SIC classification code that is associated with the organization, provided by Sugar Hint enrichment data. |
| Hint_Account_Size | String | False |
The estimated organization size that is based on employee count or operational scale, provided by Sugar Hint enrichment. |
| Hint_Account_Twitter_Handle | String | False |
The Twitter handle of the associated organization, as retrieved through Sugar Hint. |
| Hint_Account_Website | String | False |
The public website of the associated organization, as retrieved through Sugar Hint enrichment. |
| Hint_Contact_Pic | String | False |
The avatar or profile image reference for the contact, provided through Sugar Hint data services. |
| Hint_Education | String | False |
The primary educational history or degree information that is associated with the contact, as retrieved via Sugar Hint. |
| Hint_Education_2 | String | False |
Additional educational background data for the contact, also supplied by Sugar Hint enrichment. |
| Hint_Facebook | String | False |
The contact's Facebook profile Id, as sourced via Sugar Hint enrichment services. |
| Hint_Industry_Tags | String | False |
Industry-related tags that are associated with the contact as identified by Sugar Hint enrichment. These tags support segmentation and industry-specific analytics. |
| Hint_Job_2 | String | False |
Additional job role or title information for the contact, as provided by Sugar Hint enrichment. |
| Hint_Phone_1 | String | False |
An additional phone number that is associated with the contact, sourced from Sugar Hint data enrichment. |
| Hint_Phone_2 | String | False |
A second additional phone number that is associated with the contact, sourced from Sugar Hint data enrichment. |
| Hint_Photo | String | False |
A reference to the contact's profile image that is retrieved through Sugar Hint. |
| Hint_Twitter | String | False |
The contact's Twitter handle or profile Id, sourced via Sugar Hint enrichment. |
| Id [KEY] | String | True |
The unique Id of the contact record. |
| Invalid_Email | Bool | False |
A Boolean field that returns a value of 'true' when the primary email address associated with the contact is flagged as invalid. It returns a value of 'false' when the email address is valid and deliverable. |
| Last_Name | String | False |
The contact's last name or family name. |
| Lead_Registered_User_C | Bool | False |
A Boolean field that returns a value of 'true' when the contact is recognized as a registered user for lead-related systems or workflows. It returns a value of 'false' when no registration association exists. |
| Lead_Source | String | False |
The source from which the contact originated (for example,'referral', 'campaign', 'web form submission', or 'internal creation'). |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from modification. This field preserves data integrity and enforces configuration protections. |
| M_Accept_Status_Fields | String | True |
A stored representation of acceptance status values for message-related communication events. This field supports user interface rendering and workflow logic. |
| Market_Interest_Prediction_Score | String | True |
A predictive scoring value that estimates the contact's level of interest or likelihood to engage with offerings. |
| Market_Score | Int | True |
A numeric score representing activity or engagement strength in market-facing interactions. |
| Mkto_Id | Int | True |
The Id that identifies the contact within the Marketo marketing automation platform. |
| Mkto_Lead_Score | Int | True |
The lead scoring value assigned within Marketo based on engagement and behavioral activity. |
| Mkto_Sync | Bool | False |
A Boolean field that returns a value of 'true' when the contact is configured to synchronize with Marketo. It returns a value of 'false' when the contact is excluded from synchronization. |
| Modified_By_Name | String | True |
The display name of the user who last modified the contact record. |
| Modified_User_Id | String | True |
The Id of the user who last modified the contact record. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the contact record is marked as a favorite by the current user. It returns a value of 'false' when the record is not designated as a favorite. |
| Name | String | True |
The formatted display name of the contact, typically composed from first name, last name, and any applicable prefixes or suffixes. |
| No_Longer_At_Account_C | Bool | False |
A Boolean field that returns a value of 'true' when the contact is no longer associated with the previously linked account. It returns a value of 'false' when the association remains current. |
| Opportunity_Role | String | False |
The contact's role in sales or opportunity engagements, (for example, 'decision maker', 'influencer', or 'evaluator'. |
| Opportunity_Role_Fields | String | True |
A stored representation of role attributes that is applied to the contact during opportunity-related activities. |
| Opportunity_Role_Id | String | False |
The Id that is associated with the opportunity role linking the contact to opportunity records. |
| Owner_Only_Bulletins_C | Bool | False |
A Boolean field that returns a value of 'true' when only the record owner should receive bulletins or notifications related to this contact. It returns a value of 'false' when bulletins may apply to a broader audience. |
| Perform_Sugar_Action | Bool | False |
A Boolean field that returns a value of 'true' when automated Sugar actions can be triggered from workflows that reference this contact. It returns a value of 'false' when automated workflow-triggered actions are disabled. |
| Phone_Fax | String | False |
The contact's fax number used for document transmission or business communication. |
| Phone_Home | String | False |
The contact's home phone number. |
| Phone_Mobile | String | False |
The contact's mobile phone number. |
| Phone_Other | String | False |
An additional phone number that is associated with the contact. |
| Phone_Work | String | False |
The contact's work phone number. |
| Picture | String | False |
A reference to the contact's avatar or profile image that is used in the interface. |
| Portal_Active | Bool | False |
A Boolean field that returns a value of 'true' when the contact has an active portal account. It returns a value of 'false' when no active portal access is configured. |
| Portal_App | String | False |
The portal application with which the contact is associated. |
| Portal_Name | String | True |
The name or username that the contact uses when accessing the portal. |
| Portal_Password | String | True |
The encrypted or stored password value that is used for portal authentication. This field is typically managed by system processes. |
| Portal_Password1 | String | True |
A secondary field that stores the portal password for compatibility and system migration purposes. This field is used when older authentication data needs to be preserved or transitioned. |
| Portal_User_Company_Name | String | False |
The company name that is associated with the contact's portal user profile. |
| Preferred_Language | String | False |
The preferred language for communication with the contact. This field supports localization and personalized messaging. |
| Primary_Address_City | String | False |
The city of the contact's primary address. |
| Primary_Address_Country | String | False |
The country of the contact's primary address. |
| Primary_Address_Postalcode | String | False |
The postal code of the contact's primary address. |
| Primary_Address_State | String | False |
The state or region of the contact's primary address. |
| Primary_Address_Street | String | False |
The street address of the contact's primary address. |
| Primary_Address_Street_2 | String | False |
The second address line for the contact's primary address, typically used for suite or unit identifiers. |
| Primary_Address_Street_3 | String | False |
The third address line for the contact's primary address, used when additional address detail is required. |
| Report_To_Name | String | True |
The display name of the contact to whom this contact reports, typically used in organizational hierarchy relationships. |
| Reports_To_Id | String | False |
The Id of the contact to whom this contact reports. |
| Salutation | String | False |
The salutation or greeting prefix that is used when addressing the contact (for example, 'Mr' or 'Ms'). |
| Site_User_Id | String | True |
The Id that associates the contact with a linked site user profile, typically used in portal or multi-site access scenarios. |
| Source_Id | String | False |
The Id that is associated with the source system from which the contact originated. |
| Source_Meta | String | False |
Additional metadata that describes the source or import characteristics of the contact record. |
| Source_Type | String | False |
The classification of the system or data source from which the contact record originated. |
| Sync_Contact | Bool | False |
A Boolean field that returns a value of 'true' when the contact is configured to synchronize with external mail and scheduling systems such as Outlook. It returns a value of 'false' when synchronization is disabled. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile the contact record across systems or integrations. |
| Tag | String | False |
Tags that are assigned to the contact record. Tags support categorization, filtering, and search. |
| Team_Count | String | False |
The number of teams that have access to the contact record. |
| Team_Id | String | False |
The Id of the primary team that is associated with the contact record. |
| Team_Name | String | False |
The display name of the primary team that is associated with the contact record. |
| Team_Set_Id | String | False |
The Id of the team set that grants shared access permissions for the contact record. |
| Title | String | False |
The professional title or role of the contact within their organization. |
| Title_Wave_User_C | Bool | False |
A Boolean field that returns a value of 'true' when the contact is associated with TitleWave system features or workflows. It returns a value of 'false' when the contact has no TitleWave association. |
| String | False |
The Twitter handle or profile name of the contact. | |
| Underwriting_Bulletins_C | Bool | False |
A Boolean field that returns a value of 'true' when the contact is subscribed to receive underwriting-related bulletins. It returns a value of 'false' when the contact is not subscribed. |