HOW QODBC INTERFACES WITH QUICKBOOKS (Online - VERSION)
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.
Customers & Receivables These tables represent the tables related to Customer & Receivables i.e.CreditMemo,Customer,Invoice etc
Company & Financial These tables represent the tables related to Company & Financial i.e.Account,Class,Company etc
Employees & Payroll These tables represent the tables related to Employee i.e.Employee,TimeTracking etc
Jobs, Time & Mileage These tables represent the tables related to Customer & Receivables i.e.CreditMemo,Customer,Invoice etc
Inventory These tables represent the tables related to Inventory i.e.ItemService 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
Transactions These tables represent the nuts and bolts of QuickBooks Accounting, i.e. invoice and invoice detail; bills and bills details, payroll, etc.
Accounting & Taxes These tables represent the tables related to Accounts / Taxes of QuickBooks Accounting, i.e. Account,ClassJournalEntry etc..
Vendors & Payables These tables represent the tables related to Vendor/ Payable i.e.Bill,Check,Vendor 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.
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.
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.
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.
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.