The table below contains type mapping rules that are used to map SugarCRM field types to .NET types.

SugarCRM Native Data Type	Provider Data Type	.NET Data Type
none	STRING	String
assigned_user_name	STRING	String
char	STRING	String
varchar	STRING	String
text	STRING	String
longtext	STRING	String
html	STRING	String
json	STRING	String
email	STRING	String
enum	STRING	String
multienum	STRING	String
radioenum	STRING	String
image	STRING	String
link	STRING	String
name	STRING	String
fullname	STRING	String
phone	STRING	String
relate	STRING	String
team_list	STRING	String
url	STRING	String
password	STRING	String
currency_id	STRING	String
file	STRING	String
parent_type	STRING	String
parent	STRING	String
pricing-formula	STRING	String
string	STRING	String
timeperiod	STRING	String
time	STRING	String
function	STRING	String
encrypt	STRING	String
user_name	STRING	String
modified_user_name	STRING	String
default	STRING	String
iframe	STRING	String
download-link	STRING	String
bool	BOOLEAN	Boolean
id	GUID	Guid
decimal	DECIMAL	Decimal
currency	DECIMAL	Decimal
float	SINGLE	Single
int	INT	Int32
integer	INT	Int32
long	LONG	Int64
discount	DOUBLE	Double
date	DATE	DateTime
datetime	DATETIME	DateTime
datetimecombo	DATETIME	DateTime