Excluded Field Types
Only Salesforce fields with the following datatypes can be downloaded. This table also shows the SQL type that a Salesforce type will be mapped to.
| Salesforce Type | SQL Type |
|---|---|
| boolean | Bit |
| date | Date |
| datetime | DateTime |
| percent | Decimal |
| currency | Decimal |
| double | Decimal |
| int | Int |
| time | Time |
| textarea | VarChar |
| phone | VarChar |
| id | VarChar |
| multipicklist | VarChar |
| combobox | VarChar |
| picklist | VarChar |
| url | VarChar |
| reference | VarChar |
| encryptedstring | VarChar |
| VarChar | |
| string | VarChar |
Complex compound types such as address are not included. Fields that exceed 8000 characters will be mapped to VarChar(max) in SQL Server.