Supported Field Type Mappings

The following table shows which field type mappings are supported in a field mapping definition. Note that fields are mapped according to their SOAPType, not their DisplayType. Standard Salesforce restrictions apply.

	Map To
Map	Type	anytype	base64	Boolean	Date	DateTime	Double	ID	Integer	String	Time
From	anytype
	base64
	Boolean
	Date
	DateTime
	Double
	ID
	Integer
	String
	Time

Notes:

• When populating a String field, the value in the source field will be copied to the target field. If the target field is shorter than the source value the mapping will fail.
• When the source field is an ID field and the target is a String, the Name from the source record (not its ID) will be copied to the target field.
• When populating a Boolean field, if the source record value = Value For True the target Boolean will be set to True unless Invert Boolean Result is enabled in which case it will be set to False. If the source record value does not equal Value For True, then the target Boolean will be set to the opposite value.
• When populating any field type other than String or Boolean, if the source field cannot be converted into the target field format, the whole update process will fail.
• When the source field is a DateTime and the target is a Date, the date is stored as GMT but is displayed in the user's Salesforce locale. If the source field is a DateTime and the target is a String, the GMT value is stored as text.
• When the source field is a Date and the target is a DateTime, the date and time is stored as midnight that day in GMT but is displayed in the user's Salesforce locale. If the source field is a Date and the target is a String, the GMT value is stored as text.