Sorry, the "Foreign Account" and "Foreign Balance" columns are currently not avaliable for selection in the TxnDetailByAccount stored procedure report:

sp_report TxnDetailByAccount show Text, Blank, TxnType, Date, RefNumber, Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisMonthToDate'

However, the Amounts and Balance shown in the report are in your local currency values. To see the Foreign Currency value itself, look at the actual transaction in the transaction table for the corresponding transaction "Type".

The Exchange Rate represents further problems as the ExchangeRate column is often blank in the transaction tables. See: Error parsing complete XML return string, when creating multi-line invoice for more. 

Our current requirement is only for reading purpose. We are using QODBC to only read data from QuickBooks. You have mentioned that Exchange Rate field will create problem incase of record insertion. 

Is this problem related to QuickBooks SDK?

As far as Foreign Amount is concerned, we will need to retreive the Exchange Rate from transaction tables for every distict Transaction Type and then calculate Foregin Amount accordingly. Could you please confirm whether we are correct in our understanding?

Also, can you please provide us a list of tables, which provides/does not provide the Exchange Rate field?

The Foreign Amount is already in the actual transactions concerned and I've already pointed you to the currency table. For ExchangeRate columns see: Where are the schema rules for using QODBC? How do I use sp_columns? 

Foreign currency is not used within USA, so there hasn't been a strong requirement to work on opening QODBC to these features and seeing that everyone outside USA is still on Intuit's qbXML SDK Release 3.0 while USA is about to go to the qbXML SDK Release 6 for QuickBooks 2007, there's not much point right now.

There are few trasaction tables listed below which do not provide Exchange Rate

BillPaymentCheck, BillPaymentCredit, Deposit

Please confirm.

Also, ItemReceipt table has this field but it always contains value as Blank. Please advise.

I need Exchange Rate value for Historical Transactions. Hence i can not use current Exchange Rate from the Currency table.

This is not as simple as it sounds. For example I can pay the Foreign Amount into my USD$ Bank Account or my Canadian $ Bank Account and the Exchange Rate would not apply to the USD$ Bank Account but it would apply to the Canadian $ Bank Account  (boxed in red below)!

Foreign Currency really comes into play when a customer pays you a Foreign Amount or you pay a Foreign Amount. For example:

ACCOUNTS RECEIVEABLE
SELECT TxnID, ARAccountRefFullName, DepositToAccountRefFullName,
AppliedToTxnRefNumber, AppliedToTxnAmount, ExchangeRate 
FROM ReceivePaymentLine
where CustomerRefFullName='FLEXquarters.com LLC'

ACCOUNTS PAYABLE
SELECT BillLinkedTxn.TxnID, BillLinkedTxn.APAccountRefFullName,
BillPaymentCheck.BankAccountRefFullName, BillLinkedTxn.RefNumber,
BillPaymentCheck.Amount, BillLinkedTxn.ExchangeRate
FROM BillLinkedTxn, BillPaymentCheck
where BillLinkedTxn.LinkedTxnTxnID = BillPaymentCheck.TxnID
and BillLinkedTxn.VendorRefFullName='Intuit'

ItemReceipts are used to receive stock without a Bill, so Foreign currency doesn't apply.