HOW QODBC INTERFACES WITH QUICKBOOKS (POS - 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.
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.