HOW QODBC INTERFACES WITH QUICKBOOKS (Online - VERSION)
v18.0.0.325, Last Updated: 2017-12-27
TABLE OVERVIEW

ALPHABETICAL LISTING OF ALL 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.
ALPHABETICAL LISTING OF ALL TABLE'S DETAIL 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.
Accounting & Taxes These tables represent the tables related to Accounts / Taxes of QuickBooks Accounting, i.e. Account,ClassJournalEntry etc..
Company & Financial These tables represent the tables related to Company & Financial i.e.Account,Class,Company etc
Customers & Receivables These tables represent the tables related to Customer & Receivables i.e.CreditMemo,Customer,Invoice etc
Employees & Payroll These tables represent the tables related to Employee i.e.Employee,TimeTracking etc
Inventory These tables represent the tables related to Inventory i.e.ItemService etc
Jobs, Time & Mileage These tables represent the tables related to Customer & Receivables i.e.CreditMemo,Customer,Invoice etc
Lists 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.
Misc Other additional tables like, CustomField, Host etc
Purchases These tables represent the tables related to Purchase i.e.Bill, Check,CreditCardCredit etc
Sales These tables represent the tables related to Saless i.e.Invoice,ReceivePayment,SalesReceipt etc
Vendors & Payables These tables represent the tables related to Vendor/ Payable i.e.Bill,Check,Vendor etc
Transactions These tables represent the nuts and bolts of QuickBooks Accounting, i.e. invoice and invoice detail; bills and bills details, payroll, etc.
REPORT OVERVIEW

ALPHABETICAL LISTING OF ALL 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.
Accounting & Taxes Contains list of reports related to Accountant & Taxes i.e AuditTrail,General Ledger,Income Tax Summary,Trial Balance etc.
Accounting & Taxes Contains list of reports related to Accountant & Taxes i.e AuditTrail,General Ledger,Income Tax Summary,Trial Balance etc.
Company & Financial Contains list of reports related to Company & Financial i.e Balance Sheet ByClass,Balance Sheet Prev Year Comparison,Expense by Vendor Summary,Profit & Loss Standard etc.
Customers & Receivables Contains list of reports related to Customers & Receivables i.e A/R Aging Detail,A/R Aging Summary,Collections Report,Open Invoices etc.
Inventory Contains list of reports related to Inventory i.e Inventory Stock Status by Item,Inventory Valuation Summary,Physical Inventory Worksheet etc.
Sales Contains list of reports related to Sales i.e Sales by Customer Detail,Pending Sales,Sales by Rep Summary etc.
Vendors & Payables Contains list of reports related to Vendors & Payables i.e A/P Aging Detail,1099 Detail,Sales Tax Revenue Summary,Vendor Balance Summary etc.