Data Documentation

How QODBC Interfaces with QuickBooks

We have provided tools to help you determine where field information comes from in QuickBooks, which tables contain the information you want, how tables can be related, and sample SQL statements.

GENERAL TABLE INFORMATION: Designed to be your starting point for information research, these lists tell you the table name, how it is used, which other tables it can be related to, and a QuickBooks screenshot to demonstrate where the table information originates from.

DETAILED TABLE/FIELD INFORMATION: This tool shows you the detail of each field in a table, how it is used, and its relation to other tables/fields (if any).

RELATIONSHIPS: We have provided one-click access to table/field relationships at both the table and the field levels.

REPORT DETAILS: For sp_reports (stored procedure reports), you will get information about columns and parameters for each report. 

Click on the region of the QuickBooks edition you are using:
	United States of America		Australia
	United Kingdom		New Zealand / South East Asia
	Canada

Function Reference
This is a list of all of the SQL functions supported by the QODBC Driver and their associated syntax.
>> Function Reference

Stored Procedure Reference
This is a list of all the SQL stored procedures supported by the ODBC Driver and their associated syntax.
>> Stored Procedure Reference