Data Layouts

How QODBC Interfaces with QuickBooks

We have provided the following 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 used, which other tables it can be related to, and a QuickBooks screen shot to demonstrate where the table information originates from.

QUICKBOOKS VIEW: By clicking on the left most field in the table, you will see a pop-up window showing you a picture of the QuickBooks Window or Report Window; and the specific place where the field or sp_reports (stored procedure reports) information comes from.

DETAILED TABLE/FIELD INFORMATION: This tool shows you the detail for 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 level and the field level.

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

Click on the country version of QuickBooks Pro or higher you are using?
United States of America Australia
United Kingdom New Zealand
Canada South East Asia

QODBC Data Schema

To view the raw data tables and field names for QODBC Driver for QuickBooks, click the appropriate link below. The files are large and may take a while to load in your browser. Alternatively, you may want to right click on your country link and “Save Target As…” as a downloaded file on your hard disk.

QuickBooks USA Editions:

QuickBooks Canada Editions:

QuickBooks UK Editions:

QuickBooks Australia/New Zealand/SE Asia/Singapore Editions:

FLEXquarters.com Limited, the developers of QODBC Driver for QuickBooks, are Premier Developer Members of the Intuit Developer Network, and were included in the Intuit QuickBooks 2003 Power Launch. Our product uses the QuickBooks SDK to make sure that all of your data is 100% validated by QuickBooks, the product which is supported by thousands of accountants.