I am trying to create a query using odbc in Excel for QuickBooks data that will show transaction type, name, chart of account name and number, reference number, amount, memo, and class.  Using the table "Transaction" I can get all of this except the class. 

1) How do I get the class to show up?

2) Using the SP_Reports doesn't work for what we need since I need to be able to use parameters.  How can I start from scratch and get the same data that is in some of the SP_Reports?  For example, the SP_REPORT CUstomTxnDetail would give me what I need but I need to do it for specific data ranges. How can this be done?

Thank you.

The Transaction table doesn't show the Class but it can be seen using a CustomTxnDetail report instead like this:-

sp_report CustomTxnDetail show Text, Blank, TxnType, Date, RefNumber, Name, Memo,
Account, ClearedStatus, SplitAccount, Class, Debit, Credit, RunningBalance
parameters DateMacro = 'ThisMonthToDate', SummarizeRowsBy = 'TotalOnly',
OpenBalanceAsOf = 'Today'

All the predefined DateMacro options available to you are:
|All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate
|ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter
|LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|

For specific date ranges you can do:-

sp_report CustomTxnDetail show Date, Account, AccountType, Amount, Class
parameters DateFrom = {d'2005-01-01'}, DateTo = {d'2005-12-31'},
SummarizeRowsBy = 'Account'

sp_report CustomTxnDetail show Date, Account, AccountType, Amount, Class
parameters DateFrom = {d'2006-01-01'}, DateTo = {d'2006-12-31'},
SummarizeRowsBy = 'Account'

sp_report CustomTxnDetail show Date, Account, AccountType, Amount, Class
parameters DateFrom = {d'2007-01-01'}, DateTo = {d'2007-12-31'},
SummarizeRowsBy = 'Account'

sp_report CustomTxnDetail show Date, Account, AccountType, Amount, Class
parameters DateFrom = {d'2008-01-01'}, DateTo = {d'2008-12-31'},
SummarizeRowsBy = 'Account'

See: How do I run a CustomTxnDetail Report? for more information.

Which one of these stores the dollar amount activities for transactions?  I don't see any table that will give me dollar amount and info for ALL transactions and include class name/number.

CustomTxnDetail	TextAccountName	Account.FullName
CustomTxnDetail	TextClassName	Class.Name
CustomTxnDetail	TextCustomerName	Customer.Name
CustomTxnDetail	TextCustomerTypeName	CustomerType.Name
CustomTxnDetail	TextEmployeeName	Employee.Name
CustomTxnDetail	TextItemName	Item.Name
CustomTxnDetail	TextPaymentMethodName	PaymentMethod.Name
CustomTxnDetail	TextSalesRepInitial	SalesRep.Initial
CustomTxnDetail	TextSalesTaxCodeDesc	SalesTaxCode.Desc
CustomTxnDetail	TextShipMethodName	ShipMethod.Name
CustomTxnDetail	TextTermsName	Terms.Name
CustomTxnDetail	TextVendorName	Vendor.Name
CustomTxnDetail	TextVendorTypeName	VendorType.Name
CustomTxnDetail	AccountFullName	Account.FullName
CustomTxnDetail	AccountListID	Account.ListID