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.
QuickBooks | CData Schema |
AMTTYPE | float |
BOOLTYPE | bool |
DATETIMETYPE | datetime |
DATETYPE | date |
FLOATTYPE | float |
IDTYPE | string |
INTTYPE | int |
PERCENTTYPE | float |
QUANTYPE | float |
STRTYPE | string |
TIMEINTERVALTYPE | datetime |