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 | Boolean | 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. |
| 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. | |
| 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. | |
| 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. | |
| 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 | Datetime | False |
Date of birth of the contact. | |
| Description | String | False |
Additional notes or descriptive information about the contact. | |
| 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. |
| LastModifiedDate | Datetime | True |
Date and time when the contact record was last modified. | |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the contact record. |
| SystemModstamp | Datetime | True |
Timestamp of the last system update to the contact record. | |
| LastActivityDate | Datetime | 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 | Boolean | True |
Indicates whether an email to this contact has bounced (true) or not (false). | |
| 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. | |
| Languages__c | String | False |
Languages spoken or preferred by the contact. | |
| Level__c | String | False |
Custom field representing the contact's level or seniority. | |
| MyNote__c | String | False |
Custom note or annotation field for internal use. | |
| MyExternalId__c | String | False |
Custom external ID used to map the contact to an external system. | |
| MyExternalId2__c | String | False |
Secondary custom external ID for the contact. | |
| AcctLookup__c | String | False |
Account.Id |
Custom lookup to associate the contact with an account record. |