Default Field Mappings for Exchange <> Sugar

Article ID: 848

Last updated: 19 Sep, 2023

The table lists the field mappings between Exchange and Sugar.

Contacts

Exchange Field Name	Sugar Contact Attribute Name
Naming Fields
First Name	first_name
Last Name	last_name
Notes	description
Title	salutation

Company Name	account_name
Job Title	title
Department	department
AssistantName	assistant
Birthday	birthdate

Telephone Numbers
Primary Phone	phone_work ^{Note 1}
Business Phone	phone_work
Home Phone	phone_home
Mobile Phone	phone_mobile
Business Fax	phone_fax
Assistant's Phone	assistant_phone

Primary Address
Business Street	primary_address_street
Business City	primary_address_city
Business State/Province	primary_address_state
Business Zip/Postal Code	primary_address_postalcode
Business Country	primary_address_country

Alternate Address
Home Street	alt_address_street
Home City	alt_address_city
Home State/Province	alt_address_state
Home Zip/Postal Code	alt_address_postalcode
Home Country	alt_address_country

Email Addresses
Email	email1
Email 2	email2