HOW QODBC INTERFACES WITH QUICKBOOKS (US Version)
 
TABLE & REPORTS OVERVIEW
 
LIST TABLES. QuickBooks contains detailed information about customers, vendors, payroll items, classes, etc. These tables can be used for listing reports, or to tie to other activity tables.
  VIEW TABLES. These are tables that are custom designed by QODBC to reduce the need for relating multiple tables to get the results you want. For instance, tying sales order and inventory tables together.
TRANSACTION TABLES. These tables represent the nuts and bolts of QuickBooks Accounting, i.e. invoice and invoice detail; bills and bills details, payroll, etc.
 ALPHABETICAL LISTING OF ALL TABLES
INFORMATION TABLES. Generally used for inserting data, information tables help programmers insure the integrity of the data. Quickbooks operating preferences and company information are also part of this group.
 REPORTS. QODBC gives you the ability to create reports that are replicas of the reports in QuickBooks which you are already familiar with - but with more options. Use these SQL statements to create your own options..
 
ON-LINE TOOLS
 
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. We have provided an example of the available tools.
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 leftmost 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 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 you will be able to get information about columns and parameters for each report.
EXAMPLES. This pop-up window will give you an example of how this field/table might be used in relation to other fields/tables, as well as a sample SQL query with a description of expected results.