Data Type Mapping
Data Type Mappings
The cmdlet 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 |