Field mappings in Salesforce synchronization tasks

You can map source columns to target columns on the Field Mapping page of the Synchronization Task wizard. You must map at least one source column to a target column. You can map columns with compatible data types or create field expressions to convert data types appropriately.

Based on the operation, the synchronization task requires certain fields in the field mapping. By default, the synchronization task maps the fields with similar names. When you configure the field mapping, ensure that the required fields remain mapped. If you do not map the required fields, the synchronization task fails.

The following table shows the required fields for each task operation and target type:

Required Field	Task Operations	Description
ID	Delete Update	Map the ID column to enable the synchronization task to identify records to delete or update in a Salesforce target.
Upsert Field	Upsert	Configure and map the upsert field to enable the synchronization task to identify records to upsert in a Salesforce target. The upsert field can be an external ID field or a field with the idLookup field property enabled.
Non-null fields	Insert Update Upsert	Map all fields that cannot be null in Salesforce.

When you configure field mappings, you can also perform the following tasks:

If you included multiple source objects in the task, you can select each source object in the Sources field to display the fields for the selected object. Or, you can view all source object fields. When displaying all source object fields, the Sources table displays field names grouped by source object. You can place the cursor over the Status icon for a source field to determine the Label and API names of Salesforce source fields. Label names appear in the Salesforce UI. API names are the names required by the Salesforce API.

To configure external IDs for related Salesforce objects, use Related Objects to select the external ID for each applicable related object. You do not need to specify the external ID for a related object if you do not want to update changes for that related object. If you do not specify the external ID, the synchronization task requires that the source provide the Salesforce ID to uniquely identify records in each related object.