Field Mapping for Salesforce Standard Objects
Introduction: This integration guide describes how to connect the Salesforce.com CRM platform to the Docupace document management system for the companies that use both systems.
Overview of Field Mapping for Salesforce
This page is an index of the Standard Object Fields from Salesforce that Docupace supports. These are categorized by the type of information that they contain.
Warning: The Docupace integration supports only default fields from Salesforce. All custom fields must be added individually.
Note: Formerly the Docupace integration package required the SSN (Social Security Number) field to be filled out for all Salesforce Accounts and Contacts. With R2 2022 release of Docupace the SSN field is no longer mandatory and is not part of the standard field mapping.
Audience: Business Analysts and Developers who need to connect Salesforce.com to Docupace.
Functionality: Field Mapping from Salesforce Standard Objects to Docupace.
Related Pages
-
-
Confirming Successful Docupace Update (Docupace Platform User Guides)
-
-
Working with Docupace Work Items in Salesforce (Docupace Platform User Guides)
-
Working with Docupace Documents in Salesforce (Docupace Platform User Guides)
System Information
Field/Data | From Namespace | To Namespace | From Field Mask | To Field Mask | Value Mapping | FM Overwrite Option | |
---|---|---|---|---|---|---|---|
1 | Client ID | SALESFORCE | BASE | *[].Id | PARTY.HOLDER\2.ClientID |
| Overwrite Nullable Only |
2 | Client ID | SALESFORCE | BASE | Contact1.Id | PARTY.HOLDER1.ClientID |
|
|
3 | Entity ID | SALESFORCE | BASE | *[].Id
| PARTY.HOLDER\2.EntityType |
| Overwrite Nullable Only |
4 | Source CRM Id | SALESFORCE | BASE | *[].Id | PARTY.HOLDER\2.SourceCRM |
| Overwrite Nullable Only |
5 | Description/Notes | SALESFORCE | BASE | Contact1.Description | PARTY.HOLDER1.Notes |
|
|
6 | Household ID | BASE | ARI_RECORD | Owner1.HouseholdID | 110.100105 |
|
|
Identity Information
Field/Data | From Namespace | To Namespace | Field Mask From | Field Mask TO | Value Mapping | Condition | FM Overwrite Option | |
---|---|---|---|---|---|---|---|---|
1 | Social Security Number | SALESFORCE | BASE | *[].SocSecNumber__c | PARTY.HOLDER\2.SocSecNumber |
|
|
|
2 | Social Security Number | SALESFORCE | BASE | *[].practifi__SSN__c | PARTY.HOLDER\2.SocSecNumber |
|
| Overwrite Nullable Only |
3 | Salutation/ Prefix | SALESFORCE | BASE | Account1.Salutation | PARTY.HOLDER1.Prefix |
|
|
|
4 | Salutation/ Prefix | SALESFORCE | BASE | Account1.Salutation | PARTY.HOLDER1.Prefix |
|
|
|
5 | Salutation/Prefix | SALESFORCE | BASE | Contact1.Salutation | PARTY.HOLDER1.Prefix |
|
|
|
6 | Salutation/Prefix/Suffix | SALESFORCE | BASE | Contact1.Salutation | PARTY.HOLDER1.Suffix |
|
|
|
7 | Title | SALESFORCE | BASE | Contact1.Title | PARTY.HOLDER1.Title |
|
|
|
8 | First Name | SALESFORCE | BASE | Account1.FirstName | PARTY.HOLDER1.FirstName |
|
|
|
9 | First Name | SALESFORCE | BASE | Contact1.FirstName | PARTY.HOLDER1.FirstName |
|
|
|
10 | Middle Name | SALESFORCE | BASE | *[].practifi__Middle_Name__c | PARTY.HOLDER1.MiddleName |
|
|
|
11 | Middle Name | SALESFORCE | BASE | Account1.MiddleName | PARTY.HOLDER1.MiddleName |
|
|
|
12 | Middle Name | SALESFORCE | BASE | Contact1.MiddleName | PARTY.HOLDER1.MiddleName |
|
|
|
13 | Last Name | SALESFORCE | BASE | Account1.LastName | PARTY.HOLDER1.LastName |
|
|
|
14 | Last Name | SALESFORCE | BASE | Contact1.LastName | PARTY.HOLDER1.LastName |
|
|
|
15 | Suffix | SALESFORCE | BASE | Account1.Suffix | PARTY.HOLDER1.Suffix |
|
|
|
16 | Suffix | SALESFORCE | BASE | Account1.Suffix | PARTY.HOLDER1.Suffix |
|
|
|
17 | Suffix | SALESFORCE | BASE | Contact1.Suffix | PARTY.HOLDER1.Suffix |
|
|
|
18 | Full Name | SALESFORCE | BASE | Contact1.Name | PARTY.HOLDER1.FullName |
|
|
|
19 | Entity Name | SALESFORCE | BASE | Account1.Name | PARTY.HOLDER1.EntityName |
|
|
|
20 | Entity Name to Household ID (Disabled) | SALESFORCE | BASE | Account1.Name | PARTY.HOLDER1.HouseholdID |
|
|
|
21 | Date Of Birth | SALESFORCE | BASE | Account1.PersonBirthdate | PARTY.HOLDER1.DateOfBirth |
|
|
|
22 | Date Of Birth | SALESFORCE | BASE | Account1.PersonBirthdate | PARTY.HOLDER1.DateOfBirth |
|
|
|
23 | Date Of Birth | SALESFORCE | BASE | Contact1.Birthdate | PARTY.HOLDER1.DateOfBirth |
|
|
|
24 | Gender | SALESFORCE | BASE | *[].practifi__Gender__c | PARTY.HOLDER1.Gender |
|
| Overwrite All |
25 | Marital Status | SALESFORCE | BASE | *[].practifi__Marital_Status__c | PARTY.HOLDER1.MaritalStatus |
|
|
|
26 | Marital Status | SALESFORCE | BASE | Contact1.FinServ__MaritalStatus__c | PARTY.HOLDER1.MaritalStatus |
|
|
|
27 | Citizenship (US or other) | SALESFORCE | BASE | *[].practifi__Citizenship_Status__c | PARTY.HOLDER1.CitizenshipType |
|
| Overwrite All |
28 | Occupation | SALESFORCE | BASE | *[].practifi__Occupation__c | PARTY.HOLDER1.Occupation |
|
|
|
29 | Occupation | SALESFORCE | BASE | *[].practifi__Occupation__c | PARTY.HOLDER1.OccupationType |
|
|
|
30 | Occupation | SALESFORCE | BASE | Contact1.FinServ__Occupation__c | PARTY.HOLDER1.Occupation |
|
|
|
31 | Department/Employer | SALESFORCE | BASE | *[].practifi__Employer__c | PARTY.HOLDER1.Employer |
|
|
|
32 | Department/Employer | SALESFORCE | BASE | *[].practifi__Employer__c | PARTY.HOLDER1.EmployerBusType |
|
|
|
Communication Details
Field/Data | From Namespace | To Namespace | From Field Mask | To Field Mask | Condition | |
---|---|---|---|---|---|---|
1 | Legal Email | SALESFORCE | BASE | Account1.PersonEmail | PARTY.HOLDER1.Legal.Email |
|
2 | Legal Email | SALESFORCE | BASE | Contact1.Email | PARTY.HOLDER1.Legal.Email |
|
3 | Mailing Email | SALESFORCE | BASE | Contact1.Email | PARTY.HOLDER1.HomeEmailAddr |
|
4 | Phone Number | SALESFORCE | BASE | Contact1.Phone | PARTY.HOLDER1.HomePhone |
|
5 | Home Phone | SALESFORCE | BASE | Contact1.Phone | PARTY.HOLDER1.Phone |
|
6 | Home Phone Number | SALESFORCE | BASE | Account1.Phone | PARTY.HOLDER1.HomePhone |
|
7 | Home/Legal Phone Number | SALESFORCE | BASE | Contact1.HomePhone | PARTY.HOLDER1.Legal.Phone |
|
8 | Mobile/Legal Phone Number | SALESFORCE | BASE | Contact1.MobilePhone | PARTY.HOLDER1.Legal.Mobile |
|
9 | Other Phone Number | SALESFORCE | BASE | Contact1.OtherPhone | PARTY.HOLDER1.OtherPhone |
|
10 | Mailing Fax Number | SALESFORCE | BASE | Contact1.Fax | PARTY.HOLDER1.Mailing.Fax |
|
Address
Field/Data | From Namespace | To Namespace | From Field Mask | To Field Mask | Value Mapping | Condition | |
---|---|---|---|---|---|---|---|
1 | Billing/Legal Street Address | SALESFORCE | BASE | Account1.BillingStreet | PARTY.HOLDER1.Legal.AddrAllLines |
|
|
2 | Billing/Legal City | SALESFORCE | BASE | Account1.BillingCity | PARTY.HOLDER1.Legal.AddrCity |
|
|
3 | Billing/Legal Postal/Zip Code | SALESFORCE | BASE | Account1.BillingPostalCode | PARTY.HOLDER1.Legal.AddrZip |
|
|
4 | Billing/Legal State | SALESFORCE | BASE | Account1.BillingState | PARTY.HOLDER1.Legal.AddrState |
|
|
5 | Billing/Legal Address Country | SALESFORCE | BASE | Account1.BillingCountry | PARTY.HOLDER1.Legal.Country |
|
|
6 | Legal Address Country | SALESFORCE | BASE | * | PARTY.HOLDER1.Legal.Country |
|
|
7 | Mailing Street | SALESFORCE | BASE | Contact1.MailingStreet | PARTY.HOLDER1.Mailing.AddrLine1 |
|
|
8 | Mailing Street Address | SALESFORCE | BASE | Contact1.MailingStreet | PARTY.HOLDER1.Mailing.AddrAllLines |
|
|
9 | Mailing City | SALESFORCE | BASE | Contact1.MailingCity | PARTY.HOLDER1.Mailing.AddrCity |
|
|
10 | Mailing Postal/Zip Code | SALESFORCE | BASE | Contact1.MailingPostalCode | PARTY.HOLDER1.Mailing.AddrZip |
|
|
11 | Mailing State | SALESFORCE | BASE | Contact1.MailingState | PARTY.HOLDER1.Mailing.AddrState |
|
|
12 | Mailing Country | SALESFORCE | BASE | * | PARTY.HOLDER1.Mailing.Country |
|
|
13 | Mailing Country | SALESFORCE | BASE | Contact1.MailingCountry | PARTY.HOLDER1.Mailing.Country |
|
|
14 | Mailing/Legal Street | SALESFORCE | BASE | Account1.PersonMailingStreet | PARTY.HOLDER1.Legal.AddrLine1 |
|
|
15 | Mailing/Legal City | SALESFORCE | BASE | Account1.PersonMailingCity | PARTY.HOLDER1.Legal.AddrCity |
|
|
16 | Mailing/Legal Postal/Zip Code | SALESFORCE | BASE | Account1.PersonMailingPostalCode | PARTY.HOLDER1.Legal.AddrZip |
|
|
17 | Mailing/Legal State | SALESFORCE | BASE | Account1.PersonMailingState | PARTY.HOLDER1.Legal.AddrState |
|
|
18 | Mailing/Legal Address Country | SALESFORCE | BASE | Account1.PersonMailingCountry | PARTY.HOLDER1.Legal.Country |
|
|
19 | Other/Legal Street Address | SALESFORCE | BASE | Contact1.OtherStreet | PARTY.HOLDER1.Legal.AddrAllLines |
|
|
20 | Other/Legal Street | SALESFORCE | BASE | Contact1.OtherStreet | PARTY.HOLDER1.Legal.AddrLine1 |
|
|
21 | Other/Legal Street Address | SALESFORCE | BASE | Contact1.OtherStreet | PARTY.HOLDER1.LegalAddrAllLines |
|
|
22 | Other/Legal Street | SALESFORCE | BASE | Contact1.OtherStreet | PARTY.HOLDER1.LegalAddrLine1 |
|
|
23 | Other/Legal City | SALESFORCE | BASE | Contact1.OtherCity | PARTY.HOLDER1.Legal.AddrCity |
|
|
24 | Other/Legal Postal/Zip Code | SALESFORCE | BASE | Contact1.OtherPostalCode | PARTY.HOLDER1.Legal.AddrZip |
|
|
25 | Other/Legal State | SALESFORCE | BASE | Contact1.OtherState | PARTY.HOLDER1.Legal.AddrState |
|
|
26 | Other/Legal Address Country | SALESFORCE | BASE | Contact1.OtherCountry | PARTY.HOLDER1.Legal.Country |
|
|
Household Members’ Information
Field/Data | From Namespace | To Namespace | From Field Mask | To Field Mask | |
---|---|---|---|---|---|
1 | Household Member's Client Id | SALESFORCE | BASE | ContactByAccount[].Id | PARTY.HOUSEHOLDER[].ClientID |
2 | Household Member's Salutation/Suffix | SALESFORCE | BASE | ContactByAccount[].Salutation | PARTY.HOUSEHOLDER[].Suffix |
3 | Household Member's Title | SALESFORCE | BASE | ContactByAccount[].Title | PARTY.HOUSEHOLDER[].Title |
4 | Household Member's First Name | SALESFORCE | BASE | ContactByAccount[].FirstName | PARTY.HOUSEHOLDER[].FirstName |
5 | Household Member's Last Name | SALESFORCE | BASE | ContactByAccount[].LastName | PARTY.HOUSEHOLDER[].LastName |
6 | Household Member's Full Name | SALESFORCE | BASE | ContactByAccount[].Name | PARTY.HOUSEHOLDER[].FullName |
7 | Household Member's Birthdate | SALESFORCE | BASE | ContactByAccount[].Birthdate | PARTY.HOUSEHOLDER[].DateOfBirth |
8 | Household Member's Email | SALESFORCE | BASE | ContactByAccount[].Email | PARTY.HOUSEHOLDER[].Mailing.Email |
9 | Household Member's Phone | SALESFORCE | BASE | ContactByAccount[].Phone | PARTY.HOUSEHOLDER[].Phone |
10 | Household Member's Mobile/Legal Phone | SALESFORCE | BASE | ContactByAccount[].MobilePhone | PARTY.HOUSEHOLDER[].Legal.Mobile |
11 | Household Member's Home/Legal Phone | SALESFORCE | BASE | ContactByAccount[].HomePhone | PARTY.HOUSEHOLDER[].Legal.Phone |
12 | Household Member's Other Phone | SALESFORCE | BASE | ContactByAccount[].OtherPhone | PARTY.HOUSEHOLDER[].OtherPhone |
13 | Household Member's Fax | SALESFORCE | BASE | ContactByAccount[].Fax | PARTY.HOUSEHOLDER[].Mailing.Fax |
14 | Household Member's Mailing Street Address | SALESFORCE | BASE | ContactByAccount[].MailingStreet | PARTY.HOUSEHOLDER[].Mailing.AddrAllLines |
15 | Household Member's Mailing City | SALESFORCE | BASE | ContactByAccount[].MailingCity | PARTY.HOUSEHOLDER[].Mailing.AddrCity |
16 | Household Member's Mailing Postal/Zip Code | SALESFORCE | BASE | ContactByAccount[].MailingPostalCode | PARTY.HOUSEHOLDER[].Mailing.AddrZip |
17 | Household Member's Mailing State | SALESFORCE | BASE | ContactByAccount[].MailingState | PARTY.HOUSEHOLDER[].Mailing.AddrState |
18 | Household Member's Mailing Country | SALESFORCE | BASE | ContactByAccount[].MailingCountry | PARTY.HOUSEHOLDER[].Mailing.Country |
19 | Household Member's Other/Legal Street Address | SALESFORCE | BASE | ContactByAccount[].OtherStreet | PARTY.HOUSEHOLDER[].Legal.AddrAllLines |
20 | Household Member's Other/Legal City | SALESFORCE | BASE | ContactByAccount[].OtherCity | PARTY.HOUSEHOLDER[].Legal.AddrCity |
21 | Household Member's Other/Legal Postal/Zip Code | SALESFORCE | BASE | ContactByAccount[].OtherPostalCode | PARTY.HOUSEHOLDER[].Legal.AddrZip |
22 | Household Member's Other/Legal State | SALESFORCE | BASE | ContactByAccount[].OtherState | PARTY.HOUSEHOLDER[].Legal.AddrState |
23 | Household Member's Other/Legal Address Country | SALESFORCE | BASE | ContactByAccount[].OtherCountry | PARTY.HOUSEHOLDER[].Legal.Country |
24 | Household Member's Employer | SALESFORCE | BASE | ContactByAccount[].Department | PARTY.HOUSEHOLDER[].Employer |
25 | Household Member's Notes | SALESFORCE | BASE | ContactByAccount[].Description | PARTY.HOUSEHOLDER[].Notes |