|



|
 |
 |


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.
R EPORT
DETAILS: For sp_reports (stored procedure reports) you will be able to get
information about columns and parameters for each report.

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:
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:

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 |
|
 |
|