Data Type Mapping
Data Type Mappings
The add-in maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| Zoho CRM | CData Schema |
| Auto-Number | string |
| Checkbox | bool |
| Currency | float |
| Date | date |
| Date/Time | datetime |
| Decimal | string |
| string | |
| FileUpload | string |
| Formula | string |
| LongInteger | long |
| Lookup | string |
| Multi-Line | string |
| Multi-Select | string |
| Number | int |
| Percent | string |
| Phone | string |
| PickList | string |
| SingleLine | string |
| URL | string |
| User | string |