Excel Add-In for FinancialForce

Build 20.0.7654

Data Type Mapping

The add-in maps types from the data source to the corresponding data type available in the schema. The following table documents these mappings.

Data Type Mapping

FinancialForce UI FinancialForce API Type CData Schema
Auto Number string string
Lookup Relationship ID string
Master-Detail Relationship ID string
External Lookup Relationship ID string
Checkbox boolean bool
Currency double float
Date date date
Date/Time datetime datetime
Email string string
Geolocation Location* string
Number double float
Percent double float
Phone string string
Picklist string string
Picklist (Multi-Select) string string
Text string string
Text Area string string
Text Area (Long) string string
Text Area (Rich) string string
Text (Encrypted) string string
Time string string
URL string string

Note: Entries marked with an asterisk "*" indicate a structured data type containing latitude and longitude.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654