Customer 360 Extension for Salesforce > Customer 360 Extension for Salesforce assets > Field mapping
  

Field mapping

The Data Integration mappings map the fields of Customer 360 and Salesforce. Based on the mappings, the Salesforce data is stored in Customer 360.
The following table lists the Salesforce objects and the Customer 360 assets to which they are mapped:
Salesforce Object Name
Customer 360 Asset
Customer 360 Asset Type
Accounts
Organization
Business entity
Contacts
Person
Business entity
Person Accounts
Person
Business entity
Account to Contact Relationship
Contact
Relationship
Account to Partner Relationship
Partner
Relationship
Account Hierarchy
Salesforce Account Hierarchy
Hierarchy

Mapping of Organization business entity and Salesforce Accounts object fields

The fields from the Salesforce Accounts objects are mapped to the Organization business entity for data integration.

General fields of the Organization business entity

The following table lists the Salesforce Accounts object fields that are mapped to the General fields:
Salesforce Display Name
Customer 360 Display Name
Customer 360 Internal ID
Name
Name
name
NumberOfEmployees
Number Of Employees
numberOfEmployees
Industry
Industry
X_infac360sf_industry
OwnershipType
Company Type
companyType
Site
Site
X_infac360sf_site
Website
Website
X_infac360sf_website
YearStarted
Year Started
X_infac360sf_yearStarted

Address field group of the Organization business entity

The following table lists Salesforce Accounts object fields that are mapped to the Address field group fields:
Salesforce Display Name
Customer 360 Display Name
Customer 360 Internal ID
BillingStreet
Address Line 1
addressLine1
ShippingStreet
Address Line 1
addressLine1
BillingCity
City
city
ShippingCity
City
city
BillingState
State
state
ShippingState
State
state
BillingCountry
Country
country
ShippingCountry
Country
country
BillingPostalCode
Postal Code
postalCode
ShippingPostalCode
Postal Code
postalCode

Accounts field group of the Organization business entity

The following table lists the Salesforce Accounts object fields that are mapped to the Accounts field group fields:
Salesforce Display Name
Customer 360 Display Name
Customer 360 Internal ID
Account Number
Account Number
X_infac360sf_accountNumber
Name
Account Name
X_infac360sf_accountName
Account Source
Account Source
X_infac360sf_accountSource
Type
Account Type
X_infac360sf_accountType
Rating
Rating
X_infac360sf_rating

Financial field group of the Organization business entity

The following table lists the Salesforce Accounts object field that is mapped to the Financial field group field:
Salesforce Display Name
Customer 360 Display Name
Customer 360 Internal ID
AnnualRevenue
Amount
amount

Phone field group of the Organization business entity

The following table lists the Salesforce Accounts object fields that are mapped to the Phone field group fields:
Salesforce Display Name
Customer 360 Display Name
Customer 360 Internal ID
Fax
Phone Number
phoneNumber
Phone
Phone Number
phoneNumber

Stock field group of the Organization business entity

The following table lists the Salesforce Accounts object fields that are mapped to the Stock field group fields:
Salesforce Display Name
Customer 360 Display Name
Customer 360 Internal ID
TickerSymbol
Ticker Symbol
tickerSymbol

Mapping of Person business entity and Salesforce Contacts object fields

The fields from the Salesforce Contacts and Person Accounts objects are mapped to the Person business entity for data integration.

General fields of the Person business entity

The following table lists the Salesforce Contacts and Person Accounts object fields that are mapped to the General fields:
Salesforce Field Name
Customer 360 Display Name
Customer 360 Internal ID
AssistantName
Assistant Name
X_infac360sf_assistantName
HasOptedOutOfEmail
Email Opt Out Indicator
X_infac360sf_emailOptOutIndicator
Department
Department
X_infac360sf_department
Industry
Industry
X_infac360sf_industry
FirstName
First Name
firstName
MiddleName
Middle Name
middleName
LastName
Last Name
lastName
PersonTitle
Title
title
PersonBirthDate
Birth Date
birthDate
Salutation
Prefix Name
prefixName
Suffix
Suffix Name
suffixName

Account field group of the Person business entity

The following table lists the Salesforce Person Accounts object fields that are mapped to the Account field group fields:
Salesforce Field Name
Customer 360 Display Name
Customer 360 Internal ID
AccountNumber
Account Number
X_infac360sf_accountNumber
Name
Account Name
X_infac360sf_accountName
AccountSource
Account Source
X_infac360sf_accountSource
Type
Account Type
X_infac360sf_accountType

Address field group of the Person business entity

The following table lists the Salesforce Contacts and Person Accounts object fields that are mapped to the Address field group fields:
Salesforce Field Name
Customer 360 Display Name
Customer 360 Internal ID
BilllingStreet
Address Line 1
addressLine1
MailingStreet
Address Line 1
addressLine1
PersonMailingStreet
Address Line 1
addressLine1
PersonOtherStreet
Address Line 1
addressLine1
ShippingStreet
Address Line 1
addressLine1
OtherStreet
Address Line 1
addressLine1
BillingCity
City
city
MailingCity
City
city
ShippingCity
City
city
OtherCity
City
city
PersonMailingCity
City
city
PersonOtherCity
City
city
BillingState
State
state
MailingState
State
state
ShippingState
State
state
OtherState
State
state
PersonOtherState
State
state
BillingCountry
Country
country
MailingCountry
Country
country
ShippingCountry
Country
country
OtherCountry
Country
country
PersonOtherCountry
Country
country
BillingPostalCode
Postal Code
postalCode
MailingPostalCode
Postal Code
postalCode
ShippingPostalCode
Postal Code
postalCode
OtherPostalCode
Postal Code
postalCode
PersonOtherPostalCode
Postal Code
postalCode

Assistant Phone field group of the Person business entity

The following table lists the Salesforce Contacts and Person Accounts object fields that are mapped to the Assistant Phone field group fields:
Salesforce Field Name
Customer 360 Display Name
Customer 360 Internal ID
AssistantPhone
Phone Number
phoneNumber
PersonAssistantPhone
Phone Number
phoneNumber

Email field group of the Person business entity

The following table lists the Salesforce Contacts and Person Accounts object fields that are mapped to the Email field group fields:
Salesforce Field Name
Customer 360 Display Name
Customer 360 Internal ID
Email
Electronic Address
electronicAddress
PersonEmail
Electronic Address
electronicAddress

Indicator field group of the Person business entity

The following table lists the Salesforce Person Accounts object fields that are mapped to the Indicator field group fields:
Salesforce Display Name
Customer 360 Display Name
Customer 360 Internal ID
IsPersonAccount
Is Customer
X_infac360sf_isCustomer

Phone field group of the Person business entity

The following table lists the Salesforce Contacts and Person Accounts object fields that are mapped to the Phone field group fields:
Salesforce Field Name
Customer 360 Display Name
Customer 360 Internal ID
DoNotCall
Do Not Call Indicator
doNotCallIndicator
Fax
Phone Number
phoneNumber
HomePhone
Phone Number
phoneNumber
MobilePhone
Phone Number
phoneNumber
OtherPhone
Phone Number
phoneNumber
PersonHomePhone
Phone Number
phoneNumber
PersonMobilePhone
Phone Number
phoneNumber
PersonOtherPhone
Phone Number
phoneNumber
Phone
Phone Number
phoneNumber

Mapping of Salesforce Account to Contact relationship and Customer 360 Contact relationship

The following table lists the mapping of the Salesforce and Customer 360 fields for importing and exporting account to contact relationships:
Salesforce Field
Customer 360 Field
Description
Id, AccountId
sourcePKey
The values of Id and AccountId fields of Salesforce, concatenated and separated by an underscore, are mapped to the sourcePKey of the Customer 360 relationship object.
AccountId
Contact>_from >id> sourcePKey
The AccountId field of Salesforce is mapped to the sourcePKey of the from object of the Contact relationship.
Id
Contact>_to> id> sourcePKey
The Id field of Salesforce is mapped to the sourcePKey of the to object of the Contact relationship.
The following table lists the Customer 360 fields that specify the source system when you import and export the account to contact relationships:
Customer 360 Field
Description
sourceSystem
The source system for the contact relationship.
Contact>_from >id> sourceSystem
The source system for the from record.
Contact >_to> id> sourceSystem
The source system for the to record.

Mapping of Salesforce Account to Partner relationship and Customer 360 Partner relationship

The following table lists the attribute mapping of Salesforce and Customer 360 fields for importing and exporting account to partner relationships:
Salesforce Field
Customer 360 Field
Description
Id
sourcePKey
The Id field of Salesforce is mapped to the sourcePKey of the Customer 360 relationship object.
AccountId
Contact>_from >id> sourcePKey
The AccountId field of Salesforce is mapped to the sourcePKey of the from object of the Partner relationship.
Id
Contact >_to> id> sourcePKey
The Id field of Salesforce is mapped to the sourcePKey of the to object of the Partner relationship.
The following table lists the Customer 360 fields that specify the source system when you import and export the account to contact relationships:
Customer 360 Field
Description
sourceSystem
The source system for the contact relationship.
Contact>_from >id> sourceSystem
The source system for the from record.
Contact >_to> id> sourceSystem
The source system for the to record.

Mapping of Salesforce Account hierarchy to Customer 360 Organization hierarchy

The hierarchy mapping uses two instances of an account object to identify the name of the parent node in the hierarchy.
The following table lists the attribute mapping of Salesforce and Customer 360 fields for importing account hierarchies:
Salesforce Field
Customer 360 Field
Description
ParentId
sourcePKey
The ParentId field of Salesforce is mapped to the root sourcePKey of the Customer 360 hierarchy object.
Name1
name
The value of the name field of the second account instance and the hierarchy string, concatenated and separated by an underscore, are mapped to the name field of Customer 360.
ParentId
rootsourcePKey
The ParentId field of Salesforce is mapped to the root sourcePKey field of the Customer 360 hierarchy object.
ParentId, Id
Child >sourcePKey
The values of the ParentId and Id fields of Salesforce, concatenated and separated by an underscore, are mapped to the sourcePKey of the child node in the hierarchy.
Id
Child >child>sourcePKey
The Id field of Salesforce is mapped to the sourcePKey of the child node in the hierarchy.
ParentId
Child>parent>sourcePKey
The ParentId field of Salesforce is mapped to the sourcePKey of the parent node in the hierarchy.
The following table lists the Customer 360 fields that specify the source system when you import account hierarchies:
Customer 360 Field
Description
rootSourceSystem
The source system for the Salesforce account hierarchy.
Child > child > sourceSystem
The source system for the child node in the hierarchy.
Child > parent > sourceSystem
The source system for the parent node in the hierarchy.