Data types

The following table describes the supported Dynamics 365 Business Central data types and their mapping to the Python data types. The type codes returned in the description cursor attribute can be used in the addtypecast() cursor method.

Dynamics 365 BC data type	Type code	Python data type
BigInteger	3013	int
Byte	3003	int
Char	3011	int
Duration	3013	int
Integer	3012	int
BigText	3017	str
Code	3017	str
DateFormula	3017	str
Label	3017	str
Text	3017	str
XmlText	3017	str
Guid	3017	str
Blob	3002	binary
Boolean	3004	bool
Decimal	3008	float
Date	3006	datetime.date
DateTime	3007	datetime.datetime
Time	3018	datetime.time

Request Support

Python Connectors Forum

Provide Feedback