Contact

Print
General informations

Name: Contact
Label: Contact
Comment:

Fields (66)
Name Label Type Description
Id Contact ID ID
IsDeleted Deleted CHECKBOX
MasterRecordId Master Record ID LOOKUP
AccountId Account ID LOOKUP
LastName Last Name TEXT(80)
FirstName First Name TEXT(40)
Salutation Salutation PICKLIST
Name Full Name TEXT(121)
OtherStreet Other Street TEXT AREA(255)
OtherCity Other City TEXT(40)
OtherState Other State/Province TEXT(80)
OtherPostalCode Other Zip/Postal Code TEXT(20)
OtherCountry Other Country TEXT(80)
OtherLatitude Other Latitude NUMBER(3,15)
OtherLongitude Other Longitude NUMBER(3,15)
OtherGeocodeAccuracy Other Geocode Accuracy PICKLIST
OtherAddress Other Address AUTO NUMBER
MailingStreet Mailing Street TEXT AREA(255)
MailingCity Mailing City TEXT(40)
MailingState Mailing State/Province TEXT(80)
MailingPostalCode Mailing Zip/Postal Code TEXT(20)
MailingCountry Mailing Country TEXT(80)
MailingLatitude Mailing Latitude NUMBER(3,15)
MailingLongitude Mailing Longitude NUMBER(3,15)
MailingGeocodeAccuracy Mailing Geocode Accuracy PICKLIST
MailingAddress Mailing Address AUTO NUMBER
Phone Business Phone PHONE
Fax Business Fax PHONE
MobilePhone Mobile Phone PHONE
HomePhone Home Phone PHONE
OtherPhone Other Phone PHONE
AssistantPhone Asst. Phone PHONE
ReportsToId Reports To ID LOOKUP
Email Email EMAIL
Title Title TEXT(128)
Department Department TEXT(80)
AssistantName Assistant's Name TEXT(40)
LeadSource Lead Source PICKLIST
Birthdate Birthdate DATE
Description Contact Description TEXT AREA (LONG)(32000)
OwnerId Owner ID LOOKUP
CreatedDate Created Date DATETIME
CreatedById Created By ID LOOKUP
LastModifiedDate Last Modified Date DATETIME
LastModifiedById Last Modified By ID LOOKUP
SystemModstamp System Modstamp DATETIME
LastActivityDate Last Activity DATE
LastCURequestDate Last Stay-in-Touch Request Date DATETIME
LastCUUpdateDate Last Stay-in-Touch Save Date DATETIME
LastViewedDate Last Viewed Date DATETIME
LastReferencedDate Last Referenced Date DATETIME
EmailBouncedReason Email Bounced Reason TEXT(255)
EmailBouncedDate Email Bounced Date DATETIME
IsEmailBounced Is Email Bounced CHECKBOX
PhotoUrl Photo URL URL
Jigsaw Data.com Key TEXT(20)
JigsawContactId Jigsaw Contact ID TEXT(20)
CleanStatus Clean Status PICKLIST
IndividualId Individual ID LOOKUP
Level__c Level PICKLIST
Languages__c Languages TEXT(100)
Account_Id_1 Account_Account ID_1 LOOKUP
Product2_Id_1 Product2_Product ID_1 MASTER-DETAIL
Product2_Id_2 Product2_Product ID_2 LOOKUP
Product2_Id_3 Product2_Product ID_3 LOOKUP
Product2_Id_4 Product2_Product ID_4 LOOKUP
Fields Details (66)
Name Id
Label Contact ID
Type ID
Required Yes
Name IsDeleted
Label Deleted
Type CHECKBOX
Required Yes
Default value false
Name MasterRecordId
Label Master Record ID
Type LOOKUP
Foreign key Yes
Name AccountId
Label Account ID
Type LOOKUP
Name LastName
Label Last Name
Type TEXT(80)
Required Yes
Name FirstName
Label First Name
Type TEXT(40)
Name Salutation
Label Salutation
Type PICKLIST
Picklist values Mr. Ms. Mrs. Dr. Prof.
Name Name
Label Full Name
Type TEXT(121)
Required Yes
Name OtherStreet
Label Other Street
Type TEXT AREA(255)
Name OtherCity
Label Other City
Type TEXT(40)
Name OtherState
Label Other State/Province
Type TEXT(80)
Name OtherPostalCode
Label Other Zip/Postal Code
Type TEXT(20)
Name OtherCountry
Label Other Country
Type TEXT(80)
Name OtherLatitude
Label Other Latitude
Type NUMBER(3,15)
Name OtherLongitude
Label Other Longitude
Type NUMBER(3,15)
Name OtherGeocodeAccuracy
Label Other Geocode Accuracy
Type PICKLIST
Picklist values Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown
Name OtherAddress
Label Other Address
Type AUTO NUMBER
Name MailingStreet
Label Mailing Street
Type TEXT AREA(255)
Name MailingCity
Label Mailing City
Type TEXT(40)
Name MailingState
Label Mailing State/Province
Type TEXT(80)
Name MailingPostalCode
Label Mailing Zip/Postal Code
Type TEXT(20)
Name MailingCountry
Label Mailing Country
Type TEXT(80)
Name MailingLatitude
Label Mailing Latitude
Type NUMBER(3,15)
Name MailingLongitude
Label Mailing Longitude
Type NUMBER(3,15)
Name MailingGeocodeAccuracy
Label Mailing Geocode Accuracy
Type PICKLIST
Picklist values Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown
Name MailingAddress
Label Mailing Address
Type AUTO NUMBER
Name Phone
Label Business Phone
Type PHONE
Name Fax
Label Business Fax
Type PHONE
Name MobilePhone
Label Mobile Phone
Type PHONE
Name HomePhone
Label Home Phone
Type PHONE
Name OtherPhone
Label Other Phone
Type PHONE
Name AssistantPhone
Label Asst. Phone
Type PHONE
Name ReportsToId
Label Reports To ID
Type LOOKUP
Foreign key Yes
Name Email
Label Email
Type EMAIL
Name Title
Label Title
Type TEXT(128)
Name Department
Label Department
Type TEXT(80)
Name AssistantName
Label Assistant's Name
Type TEXT(40)
Name LeadSource
Label Lead Source
Type PICKLIST
Picklist values Web Phone Inquiry Partner Referral Purchased List Other
Name Birthdate
Label Birthdate
Type DATE
Name Description
Label Contact Description
Type TEXT AREA (LONG)(32000)
Name OwnerId
Label Owner ID
Type LOOKUP
Foreign key Yes
Required Yes
Name CreatedDate
Label Created Date
Type DATETIME
Required Yes
Name CreatedById
Label Created By ID
Type LOOKUP
Foreign key Yes
Required Yes
Name LastModifiedDate
Label Last Modified Date
Type DATETIME
Required Yes
Name LastModifiedById
Label Last Modified By ID
Type LOOKUP
Foreign key Yes
Required Yes
Name SystemModstamp
Label System Modstamp
Type DATETIME
Required Yes
Name LastActivityDate
Label Last Activity
Type DATE
Name LastCURequestDate
Label Last Stay-in-Touch Request Date
Type DATETIME
Name LastCUUpdateDate
Label Last Stay-in-Touch Save Date
Type DATETIME
Name LastViewedDate
Label Last Viewed Date
Type DATETIME
Name LastReferencedDate
Label Last Referenced Date
Type DATETIME
Name EmailBouncedReason
Label Email Bounced Reason
Type TEXT(255)
Name EmailBouncedDate
Label Email Bounced Date
Type DATETIME
Name IsEmailBounced
Label Is Email Bounced
Type CHECKBOX
Required Yes
Default value false
Name PhotoUrl
Label Photo URL
Type URL
Name Jigsaw
Label Data.com Key
Type TEXT(20)
Name JigsawContactId
Label Jigsaw Contact ID
Type TEXT(20)
Name CleanStatus
Label Clean Status
Type PICKLIST
Picklist values Matched Different Acknowledged NotFound Inactive Pending SelectMatch Skipped
Name IndividualId
Label Individual ID
Type LOOKUP
Foreign key Yes
Name Level__c
Label Level
Type PICKLIST
Picklist values Secondary Tertiary Primary
Name Languages__c
Label Languages
Type TEXT(100)
Name Account_Id_1
Label Account_Account ID_1
Type LOOKUP
Foreign key Yes
Name Product2_Id_1
Label Product2_Product ID_1
Type MASTER-DETAIL
Foreign key Yes
Name Product2_Id_2
Label Product2_Product ID_2
Type LOOKUP
Foreign key Yes
Name Product2_Id_3
Label Product2_Product ID_3
Type LOOKUP
Foreign key Yes
Name Product2_Id_4
Label Product2_Product ID_4
Type LOOKUP
Foreign key Yes