Microsoft Dynamics 365 for Sales to MySQL mapping

AutoSync maps Dynamics 365 for Sales data types to the following MySQL column types:


Microsoft Dynamics 365 for sales data type	MySQL column type
`BigIntType`	`BIGINT`
`BooleanType`	`BIT`
`CalendarRulesType`	`VARCHAR`
`CustomerType`	`VARCHAR`
`CustomType`	`VARCHAR`
`DateTimeType`	`DATETIME`
`DecimalType`	`DECIMAL`
`DoubleType`	`DOUBLE`
`EntityNameType`	`VARCHAR`
`FileType`	`VARCHAR`
`ImageType`	`BLOB`
`IntegerType`	`INT`
`LookupType`	`VARCHAR`
`ManagedPropertyType`	`JSON`
`MemoType`	`VARCHAR`
`MoneyType`	`DECIMAL`
`MultiSelectPicklistType`	`VARCHAR`
`OwnerType`	`VARCHAR`
`PartyListType`	`VARCHAR`
`PicklistType`	`INT`
`StateType`	`INT`
`StatusType`	`INT`
`StringType`	`VARCHAR`
`UniqueidentifierType`	`VARCHAR`
`sl_timestamp`	`DATETIME`