Contact
This is a table representing the Contact entities in Salesforce.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the Contact. | |
| IsDeleted | Boolean | True |
Label Deleted corresponds to this field. | |
| MasterRecordId | String | True |
Contact.Id |
Label Master Record ID corresponds to this field. |
| AccountId | String | False |
Account.Id |
Label Account ID corresponds to this field. |
| LastName | String | False |
Label Last Name corresponds to this field. | |
| FirstName | String | False |
Label First Name corresponds to this field. | |
| Salutation | String | False |
Label Salutation corresponds to this field. | |
| Name | String | True |
Label Full Name corresponds to this field. | |
| OtherStreet | String | False |
Label Other Street corresponds to this field. | |
| OtherCity | String | False |
Label Other City corresponds to this field. | |
| OtherState | String | False |
Label Other State/Province corresponds to this field. | |
| OtherPostalCode | String | False |
Label Other Zip/Postal Code corresponds to this field. | |
| OtherCountry | String | False |
Label Other Country corresponds to this field. | |
| OtherLatitude | Double | False |
Label Other Latitude corresponds to this field. | |
| OtherLongitude | Double | False |
Label Other Longitude corresponds to this field. | |
| MailingStreet | String | False |
Label Mailing Street corresponds to this field. | |
| MailingCity | String | False |
Label Mailing City corresponds to this field. | |
| MailingState | String | False |
Label Mailing State/Province corresponds to this field. | |
| MailingPostalCode | String | False |
Label Mailing Zip/Postal Code corresponds to this field. | |
| MailingCountry | String | False |
Label Mailing Country corresponds to this field. | |
| MailingLatitude | Double | False |
Label Mailing Latitude corresponds to this field. | |
| MailingLongitude | Double | False |
Label Mailing Longitude corresponds to this field. | |
| Phone | String | False |
Label Business Phone corresponds to this field. | |
| Fax | String | False |
Label Business Fax corresponds to this field. | |
| MobilePhone | String | False |
Label Mobile Phone corresponds to this field. | |
| HomePhone | String | False |
Label Home Phone corresponds to this field. | |
| OtherPhone | String | False |
Label Other Phone corresponds to this field. | |
| AssistantPhone | String | False |
Label Asst. Phone corresponds to this field. | |
| ReportsToId | String | False |
Contact.Id |
Label Reports To ID corresponds to this field. |
| String | False |
Label Email corresponds to this field. | ||
| Title | String | False |
Label Title corresponds to this field. | |
| Department | String | False |
Label Department corresponds to this field. | |
| AssistantName | String | False |
Label Assistant's Name corresponds to this field. | |
| LeadSource | String | False |
Label Lead Source corresponds to this field. | |
| Birthdate | Datetime | False |
Label Birthdate corresponds to this field. | |
| Description | String | False |
Label Contact Description corresponds to this field. | |
| OwnerId | String | False |
User.Id |
Label Owner ID corresponds to this field. |
| CreatedDate | Datetime | True |
Label Created Date corresponds to this field. | |
| CreatedById | String | True |
User.Id |
Label Created By ID corresponds to this field. |
| LastModifiedDate | Datetime | True |
Label Last Modified Date corresponds to this field. | |
| LastModifiedById | String | True |
User.Id |
Label Last Modified By ID corresponds to this field. |
| SystemModstamp | Datetime | True |
Label System Modstamp corresponds to this field. | |
| LastActivityDate | Datetime | True |
Label Last Activity corresponds to this field. | |
| LastCURequestDate | Datetime | True |
Label Last Stay-in-Touch Request Date corresponds to this field. | |
| LastCUUpdateDate | Datetime | True |
Label Last Stay-in-Touch Save Date corresponds to this field. | |
| LastViewedDate | Datetime | True |
Label Last Viewed Date corresponds to this field. | |
| LastReferencedDate | Datetime | True |
Label Last Referenced Date corresponds to this field. | |
| EmailBouncedReason | String | False |
Label Email Bounced Reason corresponds to this field. | |
| EmailBouncedDate | Datetime | False |
Label Email Bounced Date corresponds to this field. | |
| IsEmailBounced | Boolean | True |
Label Is Email Bounced corresponds to this field. | |
| Jigsaw | String | False |
Label Data.com Key corresponds to this field. | |
| JigsawContactId | String | True |
Label Jigsaw Contact ID corresponds to this field. | |
| Languages__c | String | False |
Label Languages corresponds to this field. | |
| Level__c | String | False |
Label Level corresponds to this field. | |
| MyNote__c | String | False |
Label MyNote corresponds to this field. | |
| MyExternalId__c | String | False |
Label MyExternalId corresponds to this field. | |
| MyExternalId2__c | String | False |
Label MyExternalId2 corresponds to this field. | |
| AcctLookup__c | String | False |
Account.Id |
Label Account corresponds to this field. |