Salesforce: Contact Enhanced

Description

• Each record represents a contact with additional account and owner information.

Supported Data Sources

• Salesforce

Columns

Type	Name	Description
STRING	contact_id	Unique contact ID.
STRING	contact_name	Name of contact.
STRING	account_id	ID of contact's account.
INTEGER	department	The contact’s department.
STRING	contact_description	A description of the contact.
STRING	email	The contact’s email address.
INTEGER	individual_id	ID of the data privacy record associated with this contact. This field is available if Data Protection and Privacy is enabled. This is a relationship field.
BOOLEAN	contact_is_deleted	Indicates whether the object has been moved to the Recycle Bin (true) or not (false). Label is Deleted.
DATETIME	last_activity_date	Value is the most recent of either:Due date of the most recent event logged against the record.Due date of the most recently closed task associated with the record.
STRING	lead_source	The lead’s source.
STRING	mailing_city	Mailing address details.
STRING	mailing_country	Mailing address details.
STRING	mailing_country_code	Mailing address details.
INTEGER	mailing_postal_code	The ISO codes for the mailing address’s state and country.
STRING	mailing_state	Mailing address details.
STRING	mailing_state_code	The ISO codes for the mailing address’s state and country.
STRING	mailing_street	Street address for mailing address.
INTEGER	master_record_id	If this record was deleted as the result of a merge, this field contains the ID of the record that remains. If this record was deleted for any other reason, or has not been deleted, the value is null.
INTEGER	mobile_phone	Contact’s mobile phone number.
STRING	contact_owner_id	The ID of the owner of the account associated with this contact.
STRING	phone	Telephone number for the contact. Label is Business Phone.
INTEGER	reports_to_id	This field doesn’t appear if IsPersonAccount is true.This is a relationship field.
STRING	contact_owner_name	Name of owner of the account associated with this contact.
STRING	account_name	Name of the account.
INTEGER	account_number	Account number assigned to this account (not the unique, system-generated ID assigned during creation).
STRING	account_source	The source of the account record. For example, Advertisement, Data.com, or Trade Show.
DECIMAL	account_annual_revenue	Estimated annual revenue of the account.
STRING	account_description	Text description of the account.
STRING	account_industry	An industry associated with this account.
BOOLEAN	account_is_deleted	Indicates whether the object has been moved to the Recycle Bin (true) or not (false).
INTEGER	account_number_of_employees	Number of employees working at the company represented by this account.
STRING	account_owner_id	The ID of the user who currently owns this account.
INTEGER	account_parent_id	ID of the account parent object, if any.
INTEGER	account_rating	The account’s prospect rating, for example Hot, Warm, or Cold.
STRING	account_type	Type of account, for example, Customer, Competitor, or Partner.