Data Type Mapping
The connector maps types from the data source to the corresponding data type available in the schema. The following table documents these mappings.
Data Type Mapping
| Certinia 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 |
| 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 |