Salesforce mappages de champs

Les tableaux ci-dessous contiennent les mappages entre les Salesforce champs source et leurs champs XDM correspondants.

Contact

Champ source Chemin du champ XDM cible Notes
AccountId b2b.accountKey.sourceID
iif(AccountId != null && AccountId != "", to_object("sourceType", "Salesforce", "sourceInstanceID", "${CRM_ORG_ID}", "sourceKey", concat(AccountId,"@${CRM_ORG_ID}.Salesforce")), null) b2b.accountKey
iif(AccountId != null && AccountId != "", to_object("sourceType", "Salesforce", "sourceInstanceID", "${CRM_ORG_ID}","sourceID", AccountId, "sourceKey", concat(AccountId,"@${CRM_ORG_ID}.Salesforce")), null) personComponents.sourceAccountKey
"Salesforce" b2b.personKey.sourceType
"${CRM_ORG_ID}" b2b.personKey.sourceInstanceID La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
concat(Id,"@${CRM_ORG_ID}.Salesforce") b2b.personKey.sourceKey Identité Principal. La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
AssistantName extendedWorkDetails.assistantDetails.name.fullName
AssistantPhone extendedWorkDetails.assistantDetails.phone.number
Birthdate person.birthDate
CreatedDate extSourceSystemAudit.createdDate
Department extendedWorkDetails.departments
Email workEmail.address Identité Secondaire.
Email personComponents.workEmail.address
Fax faxPhone.number
FirstName person.name.firstName
HomePhone homePhone.number
Id b2b.personKey.sourceID
"Salesforce" personComponents.sourcePersonKey.sourceType
"${CRM_ORG_ID}" personComponents.sourcePersonKey.sourceInstanceID
Id personComponents.sourcePersonKey.sourceID
concat(Id,"@${CRM_ORG_ID}.Salesforce") personComponents.sourcePersonKey.sourceKey
LastActivityDate extSourceSystemAudit.lastActivityDate
LastModifiedDate extSourceSystemAudit.lastUpdatedDate
LastName person.name.lastName
LastReferencedDate extSourceSystemAudit.lastReferencedDate
LastViewedDate extSourceSystemAudit.lastViewedDate
LeadSource b2b.personSource
LeadSource personComponents.personSource
MailingCity workAddress.city
MailingCountry workAddress.country
MailingLatitude workAddress._schema.latitude
MailingLongitude workAddress._schema.longitude
MailingPostalCode workAddress.postalCode
MailingState workAddress.state
MailingStreet workAddress.street1
MobilePhone mobilePhone.number
Name person.name.fullName
OtherCity otherAddress.city
OtherCountry otherAddress.country
OtherLatitude otherAddress._schema.latitude
OtherLongitude otherAddress._schema.longitude
OtherPhone otherPhone.number
OtherPostalCode otherAddress.postalCode
OtherState otherAddress.state
OtherStreet otherAddress.street1
Phone workPhone.number
ReportsToId extendedWorkDetails.reportsToID
Salutation person.name.courtesyTitle
Title extendedWorkDetails.jobTitle

prospect

Champ source Chemin du champ XDM cible Remarques
City workAddress.city
ConvertedContactId b2b.convertedContactID
ConvertedContactId personComponents.sourceConvertedContactID
ConvertedDate b2b.convertedDate
Country workAddress.country
Email workEmail.address Identité Secondaire.
Email personComponents.workEmail.address
Fax faxPhone.number
FirstName person.name.firstName
IsConverted b2b.isConverted
"Salesforce" b2b.personKey.sourceType
"${CRM_ORG_ID}" b2b.personKey.sourceInstanceID
Id b2b.personKey.sourceID
concat(Id,"@${CRM_ORG_ID}.Salesforce") b2b.personKey.sourceKey Identité Principal. La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
"Salesforce" personComponents.sourcePersonKey.sourceType
"${CRM_ORG_ID}" personComponents.sourcePersonKey.sourceInstanceID
Id personComponents.sourcePersonKey.sourceID
concat(Id,"@${CRM_ORG_ID}.Salesforce") personComponents.sourcePersonKey.sourceKey
LastActivityDate extSourceSystemAudit.lastActivityDate
LastModifiedDate extSourceSystemAudit.lastUpdatedDate
LastName person.name.lastName
LastReferencedDate extSourceSystemAudit.lastReferencedDate
LastViewedDate extSourceSystemAudit.lastViewedDate
LeadSource b2b.personSource
LeadSource personComponents.personSource
Latitude workAddress._schema.latitude
Longitude workAddress._schema.longitude
MiddleName person.name.middleName
Name person.name.fullName
PostalCode workAddress.postalCode
Salutation person.name.courtesyTitle
State workAddress.state
Status b2b.personStatus
Status personComponents.personStatus
Street workAddress.street1
Title extendedWorkDetails.jobTitle
Suffix person.name.suffix
Company b2b.companyName
Website b2b.companyWebsite

Compte

Champ source Chemin du champ XDM cible Remarques
"Salesforce" accountKey.sourceType
"${CRM_ORG_ID}" accountKey.sourceInstanceID La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
AccountNumber accountNumber
AccountSource accountSourceType
AnnualRevenue accountOrganization.annualRevenue.amount
BillingCity accountBillingAddress.city
BillingCountry accountBillingAddress.country
BillingLatitude accountBillingAddress._schema.latitude
BillingLongitude accountBillingAddress._schema.longitude
BillingPostalCode accountBillingAddress.postalCode
BillingState accountBillingAddress.state
BillingStreet accountBillingAddress.street1
CreatedDate extSourceSystemAudit.createdDate
Description accountDescription
DunsNumber accountOrganization.DUNSNumber fonctionnalité data.com
Fax accountFax.number
Id accountKey.sourceID
concat(Id,"@${CRM_ORG_ID}.Salesforce") accountKey.sourceKey Identité Principal. La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
Industry accountOrganization.industry
Jigsaw accountOrganization.jigsaw
LastActivityDate extSourceSystemAudit.lastActivityDate
LastModifiedDate extSourceSystemAudit.lastUpdatedDate
LastReferencedDate extSourceSystemAudit.lastReferencedDate
LastViewedDate extSourceSystemAudit.lastViewedDate
NaicsCode accountOrganization.NAICSCode fonctionnalité data.com
NaicsDesc accountOrganization.NAICSDescription fonctionnalité data.com
Name accountName
NumberOfEmployees accountOrganization.numberOfEmployees
Ownership accountOwnership
ParentId accountParentKey.sourceID
iif(ParentId != null && ParentId != "", to_object("sourceType", "Salesforce", "sourceInstanceID", "${CRM_ORG_ID}", "sourceKey", concat(ParentId,"@${CRM_ORG_ID}.Salesforce")), null) accountParentKey
Phone accountPhone.number
Rating accountOrganization.rating
ShippingCity accountShippingAddress.city
ShippingCountry accountShippingAddress.country
ShippingLatitude accountShippingAddress._schema.latitude
ShippingLongitude accountShippingAddress._schema.longitude
ShippingPostalCode accountShippingAddress.postalCode
ShippingState accountShippingAddress.state
ShippingStreet accountShippingAddress.street1
Sic accountOrganization.SICCode
SicDesc accountOrganization.SICDescription
Site accountSite
TickerSymbol accountOrganization.tickerSymbol
Tradestyle accountTradeStyle fonctionnalité data.com
Type accountType

Opportunité

Champ source Chemin du champ XDM cible Remarques
"Salesforce" opportunityKey.sourceType
"${CRM_ORG_ID}" opportunityKey.sourceInstanceID La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
concat(Id,"@${CRM_ORG_ID}.Salesforce") opportunityKey.sourceKey Identité Principal. La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
AccountId accountKey.sourceID
iif(AccountId != null && AccountId != "", to_object("sourceType", "Salesforce", "sourceInstanceID", "${CRM_ORG_ID}", "sourceKey", concat(AccountId,"@${CRM_ORG_ID}.Salesforce")), null) accountKey Relation.
Amount opportunityAmount.amount
CampaignId campaignKey.sourceID
iif(CampaignId != null && CampaignId != "", to_object("sourceType", "Salesforce", "sourceInstanceID", "${CRM_ORG_ID}", "sourceKey", concat(CampaignId,"@${CRM_ORG_ID}.Salesforce")), null) campaignKey
CloseDate actualCloseDate / expectedCloseDate
CreatedDate extSourceSystemAudit.createdDate
Description opportunityDescription
ExpectedRevenue expectedRevenue.amount
FiscalQuarter fiscalQuarter
FiscalYear fiscalYear
ForecastCategory forecastCategory
ForecastCategoryName forecastCategoryName
Id opportunityKey.sourceID
IsClosed isClosed
IsWon isWon
LastActivityDate extSourceSystemAudit.lastActivityDate
LastModifiedDate extSourceSystemAudit.lastUpdatedDate
LastReferencedDate extSourceSystemAudit.lastReferencedDate
LastViewedDate extSourceSystemAudit.lastViewedDate
LeadSource leadSource
Name opportunityName
NextStep nextStep
Probability probabilityPercentage
StageName opportunityStage
TotalOpportunityQuantity opportunityQuantity
Type opportunityType

Rôle de contact d’opportunité

Champ source Chemin du champ XDM cible Remarques
"Salesforce" opportunityPersonKey.sourceType
"${CRM_ORG_ID}" opportunityPersonKey.sourceInstanceID La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
"Salesforce" personKey.sourceType
"${CRM_ORG_ID}" personKey.sourceInstanceID
ContactId personKey.sourceID
concat(ContactId,"@${CRM_ORG_ID}.Salesforce") personKey.sourceKey
CreatedDate extSourceSystemAudit.createdDate
Id opportunityPersonKey.sourceID
concat(Id,"@${CRM_ORG_ID}.Salesforce") opportunityPersonKey.sourceKey Identité Principal. La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
IsPrimary isPrimary
LastModifiedDate extSourceSystemAudit.lastUpdatedDate
"Salesforce" opportunityKey.sourceType
"${CRM_ORG_ID}" opportunityKey.sourceInstanceID
OpportunityId opportunityKey.sourceID
concat(OpportunityId,"@${CRM_ORG_ID}.Salesforce") opportunityKey.sourceKey
Role personRole

Campaign

Champ source Chemin du champ XDM cible Remarques
"Salesforce" campaignKey.sourceType
"${CRM_ORG_ID}" campaignKey.sourceInstanceID La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
Id campaignKey.sourceID
concat(Id,"@${CRM_ORG_ID}.Salesforce") campaignKey.sourceKey Identité Principal. La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
Name campaignName
ParentId parentCampaignKey.sourceID
iif(ParentId != null && ParentId != "", to_object("sourceType", "Salesforce", "sourceInstanceID", "${CRM_ORG_ID}", "sourceKey", concat(ParentId,"@${CRM_ORG_ID}.Salesforce")), null) parentCampaignKey
Type campaignType
Status campaignStatus
StartDate campaignStartDate
EndDate campaignEndDate
ExpectedRevenue expectedRevenue.amount
BudgetedCost budgetedCost.amount
ActualCost actualCost.amount
ExpectedResponse expectedResponse
IsActive isActive
Description campaignDescription
CreatedDate extSourceSystemAudit.createdDate
LastModifiedDate extSourceSystemAudit.lastUpdatedDate
LastActivityDate extSourceSystemAudit.lastActivityDate
LastViewedDate extSourceSystemAudit.lastViewedDate
LastReferencedDate extSourceSystemAudit.lastReferencedDate

membre de la campagne

Champ source Chemin du champ XDM cible Remarques
"Salesforce" campaignMemberKey.sourceType
"${CRM_ORG_ID}" campaignMemberKey.sourceInstanceID La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
Id campaignMemberKey.sourceID
concat(Id,"@${CRM_ORG_ID}.Salesforce") campaignMemberKey.sourceKey Identité Principal. La valeur de "${CRM_ORG_ID}" sera automatiquement remplacé.
"Salesforce" campaignKey.sourceType
${CRM_ORG_ID} campaignKey.sourceInstanceID
CampaignId campaignKey.sourceID
concat(CampaignId,"@${CRM_ORG_ID}.Salesforce") campaignKey.sourceKey
"Salesforce" personKey.sourceType
${CRM_ORG_ID} personKey.sourceInstanceID
LeadOrContactId personKey.sourceID
concat(LeadOrContactId,"@${CRM_ORG_ID}.Salesforce") personKey.sourceKey
Status memberStatus
HasResponded hasResponded
CreatedDate extSourceSystemAudit.createdDate
LastModifiedDate extSourceSystemAudit.lastUpdatedDate
FirstRespondedDate firstRespondedDate

Étapes suivantes

En lisant ce document, vous avez découvert la relation de mappage entre Salesforce champs source et leurs champs XDM correspondants. Consultez la documentation relative à création d’un Salesforce connexion source pour plus d’informations.

Sur cette page