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