Excel Add-In for QuickBooks

Build 21.0.7930

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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930