HOW QODBC INTERFACES WITH QUICKBOOKS (USA - 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
Banking These tables represent the tables related to Banking i.e.Currency,ReceivePaymentToDeposit,SalesTaxPaymentCheckLine 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.
Transactions Contains list of reports related to Transactions i.e Custom Summary Report,Custom Transaction Detail Report 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.
Employees & Payroll Contains list of reports related to Employees & Payroll i.e Employee Earnings Summary,Employee State Taxes Detail,Payroll Review Detail etc.
Inventory Contains list of reports related to Inventory i.e Inventory Stock Status by Item,Inventory Valuation Summary,Physical Inventory Worksheet etc.
Jobs, Time & Mileage Contains list of reports related to Jobs, Time & Mileage i.e Estimates by Job,Job Estimates vs. Actuals Detail,Open Purchase Orders by Job etc.
Purchases Contains list of reports related to Purchases i.e Purchase by Item Summary,Purchase by Item Detail, Purchase by Vendor Summary etc.
Sales Contains list of reports related to Sales i.e Sales by Customer Detail,Pending Sales,Sales by Rep Summary etc.
Banking Contains list of reports related to Banking i.e Check Detail,Deposit Detail,Missing Checks etc.
Budgets Contains list of reports related to Budget i.e Budget Overview,Budget vs. Actual,Profit & Loss Budget Performance etc.