Home HelpDesk Contact Us Downloads Links Search

Search for Answers

Intelligent FAQ Search. Type in your keywords to search for the answers you need.


Back to Main Website
What is QODBC?
What is QReportBuilder?
What is Electos?
What is Visual DataFlex?
What is DataFlex?
What is FlexODBC?
Downloads
Buy Now!
Support
Tutorials
Data Schema
Reseller Program
Accredited Trainers
About us
Privacy Policy
Worldwide Offices









Data Schema

QuickBooks Visual Field Explorer

Find the QODBC table or report you need by selecting and exploring QuickBooks screens.

How QODBC Interfaces with QuickBooks

We have provided the QuickBooks Visual Field Explorer and the following interactive 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:
QODBC Schema HTML Format for QuickBooks 2004 USA
QODBC Schema HTML Format for QuickBooks 2003 USA
QODBC Schema HTML Format for QuickBooks 2002 USA

QuickBooks Canada Editions:
QODBC Schema HTML Format for QuickBooks 2004 Canada
QODBC Schema HTML Format for QuickBooks 2003 Canada

QuickBooks UK Editions:
QODBC Schema HTML Format for QuickBooks 2004 United Kingdom
QODBC Schema HTML Format for QuickBooks 2003 United Kingdom

QuickBooks Australia/New Zealand/SE Asia/Singapore Editions:
QODBC Schema HTML Format for QuickBooks 2004 Australia/New Zealand/South East Asia/Singapore
QODBC Schema HTML Format for QuickBooks 2003 Australia/New Zealand/South East Asia/Singapore

QODBC uses qbXML (The QuickBooks SDK) to access data in QuickBooks files. Click the link below for a document on this interface for further technical details on the process of communication with QuickBooks see the:

Developers qbXML 2002 FAQ

Data Access Worldwide are members of the Intuit and Quicken Developer Program for QuickBooks. Our products use 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.
 

Telephone Support
One-to-One support issues will be subject to a A$33.00 per incident fee. Make sure you have the Serial Number of your purchased product and call 03 9761 3644 or +61 3 9761 3644 during our normal office business hours between 9am to 5pm week days Australian EST (with the exception of Public Holidays).
Support Incidents

Evaluation and non-installation support issues are subject to a A$33.00 per incident fee. Payments for Support Incidents may be made by clicking here


 
Copyright © 2010
Data Access Worldwide ABN: 86 544 223 459
All rights reserved


 Back Next