Contact
Holds details about individuals associated with accounts, tracking communication and relationships.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the contact. | |
| IsDeleted | Bool | True |
Indicates whether the contact has been deleted (true) or not (false). | |
| MasterRecordId | String | True |
Contact.Id |
ID of the master record if the contact is part of a merge operation. |
| AccountId | String | False |
Account.Id |
ID of the related account associated with the contact. |
| IsPersonAccount | Bool | True |
Indicates whether this account is a person account. | |
| LastName | String | False |
Last name of the contact. | |
| FirstName | String | False |
First name of the contact. | |
| Salutation | String | False |
Salutation for the contact, such as Mr., Ms., or Dr. | |
| Name | String | True |
Full name of the contact, automatically generated from first and last names. | |
| RecordTypeId | String | False |
RecordType.Id |
ID of the record type assigned to this object. |
| OtherStreet | String | False |
Street address for the contact's alternate (other) location. | |
| OtherCity | String | False |
City for the contact's alternate (other) location. | |
| OtherState | String | False |
State or province for the contact's alternate (other) location. | |
| OtherPostalCode | String | False |
ZIP or postal code for the contact's alternate (other) location. | |
| OtherCountry | String | False |
Country for the contact's alternate (other) location. | |
| OtherLatitude | Double | False |
Latitude for the contact's alternate (other) location, used for mapping and geolocation. | |
| OtherLongitude | Double | False |
Longitude for the contact's alternate (other) location, used for mapping and geolocation. | |
| OtherGeocodeAccuracy | String | False |
Accuracy level of the geocode for the Other address. | |
| MailingStreet | String | False |
Street address for the contact's mailing address. | |
| MailingCity | String | False |
City for the contact's mailing address. | |
| MailingState | String | False |
State or province for the contact's mailing address. | |
| MailingPostalCode | String | False |
ZIP or postal code for the contact's mailing address. | |
| MailingCountry | String | False |
Country for the contact's mailing address. | |
| MailingLatitude | Double | False |
Latitude for the contact's mailing address, used for mapping and geolocation. | |
| MailingLongitude | Double | False |
Longitude for the contact's mailing address, used for mapping and geolocation. | |
| MailingGeocodeAccuracy | String | False |
Accuracy level of the geocode for the Mailing address. | |
| Phone | String | False |
Primary business phone number for the contact. | |
| Fax | String | False |
Business fax number for the contact. | |
| MobilePhone | String | False |
Mobile phone number for the contact. | |
| HomePhone | String | False |
Home phone number for the contact. | |
| OtherPhone | String | False |
Alternate phone number for the contact. | |
| AssistantPhone | String | False |
Phone number of the contact's assistant. | |
| ReportsToId | String | False |
Contact.Id |
ID of another contact to whom this contact reports. |
| String | False |
Email address of the contact. | ||
| Title | String | False |
Job title of the contact. | |
| Department | String | False |
Department associated with the contact. | |
| AssistantName | String | False |
Name of the contact's assistant. | |
| LeadSource | String | False |
Source from which the contact was obtained, such as Web or Referral. | |
| Birthdate | Date | False |
Date of birth of the contact. | |
| Description | String | False |
Additional notes or descriptive information about the contact. | |
| CurrencyIsoCode | String | False |
ISO code for the currency in which the revenue amount is expressed. | |
| OwnerId | String | False |
User.Id |
ID of the user who owns this contact record. |
| CreatedDate | Datetime | True |
Date and time when the contact was created. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the contact record. |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the contact record. |
| LastActivityDate | Date | True |
Date of the last activity associated with the contact, such as a task or event. | |
| LastCURequestDate | Datetime | True |
Date when the last stay-in-touch request was sent to the contact. | |
| LastCUUpdateDate | Datetime | True |
Date when the contact last responded to a stay-in-touch update request. | |
| LastViewedDate | Datetime | True |
Most recent date and time the contact record was viewed. | |
| LastReferencedDate | Datetime | True |
Most recent date and time the contact record was referenced by a related record or process. | |
| EmailBouncedReason | String | False |
Reason why an email sent to this contact bounced. | |
| EmailBouncedDate | Datetime | False |
Date and time when the email to the contact bounced. | |
| IsEmailBounced | Bool | True |
Indicates whether an email to this contact has bounced (true) or not (false). | |
| PhotoUrl | String | True |
URL for the contact's photo. | |
| Jigsaw | String | False |
Unique identifier for the contact in Data.com (now a legacy product). | |
| JigsawContactId | String | True |
ID of the contact in Data.com, used for data enrichment. | |
| CleanStatus | String | False |
Indicates the record's clean status compared with Data.com. | |
| IndividualId | String | False |
Individual.Id |
ID of the data privacy record associated with this contact. |
| IsPriorityRecord | Bool | True |
Indicates whether the record has the PriorityRecord characteristic. | |
| ContactSource | String | False |
Field containing ContactSource information. | |
| SOQL | String | False |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | False |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | False |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. | |
| TriggerAutoResponseEmail | Bool | False |
Indicates whether to trigger auto-response rules (true) or not (false), for leads and cases. | |
| TriggerOtherEmail | Bool | False |
Indicates whether to trigger email outside the organization (true) or not (false). | |
| TriggerUserEmail | Bool | False |
Indicates whether to trigger email that is sent to users in the organization (true) or not (false). | |
| SystemModstamp | Datetime | True |
Timestamp of the last system update to the contact record. | |
| LastModifiedDate | Datetime | True |
Date and time when the contact record was last modified. |