I need to find a checkNumber that was used to Pay off Invoice.  Is there any way to get that from a DepositLine table-? 
I have the Invoice TXNid, Customer ID... But how can I get the Check number from a DepositLine-?

Thank you
Harry

SELECT TxnID, CustomerRefFullName, RefNumber, Amount FROM ReceivePaymentToDeposit

The second step is to confirm the exact name of the Bank Account you want to deposit the payment into. To do this you run the following query in VB Demo:

SELECT ListID, Name FROM Account where Name = 'ABC Bank'

Now you're ready to receive the payment made to undeposited funds using the TxnID and Bank Account name found above. To do this you run the following query in VB Demo: 

INSERT INTO DepositLine (DepositLinePaymentTxnID,
DepositToAccountRefFullName,TxnDate,FQSaveToCache)
Values ('EDB-1197676347','ABC Bank',{d'2007-12-15'},0)

I could locate the Check No and even the Invoice No by doing this:

SELECT DepositLine.DepositLineTxnType, 
ReceivePaymentLine.TxnID, ReceivePaymentLine.RefNumber as CheckNo,
ReceivePaymentLine.AppliedToTxnRefNumber as InvoiceNo,
ReceivePaymentLine.AppliedToTxnTxnID as InvoiceListID
FROM DepositLine, ReceivePaymentLine
WHERE DepositLine.DepositLineTxnID = ReceivePaymentLine.TxnID

Please note: If you enconter the error: [QODBC] error : 3180 – There was an error when saving a deposit line. Quickbook error message : The Payment has been changed. (#10053), switch your company file to Single User Mode. This is a "confirmed by Intuit" bug in QuickBooks 2004 through to 2006 and only occurs when you try to do a deposit with the company file in multi-user mode.

Well I am still having seriouse problems.  And I am stuck with my code for weeks.

I am able to run Select statement with ONLY the field name txnID.  But when I include any other extra field names it won't run the query.  Also when I use Where statements for "AppliedToTxnTxnID" field it does not work either.

I decided to turn on the optimizer, I thought that might fix the problem but the optimizer does not even optimize the (ReceivePaymentLine) Table.  But it did Optimize all the other tables, like (Invoices,InvoiceLine,DepositLine..etc.) So I know the optimizer works fine but for some reason nothing works fine with the ReceivepaymentLine.

Is there anything I can do-? I need to finish this code and for three weeks now I have been fooling around with the ReceivePaymentLine table and I just can't get it to work properly.  Is there anything else I can do-? Are there any utilities that you might have I can run against the QB-DB or trace logs to find out where the problem lies-?

Thank you for all your support!
Harry

BottomLine:
   This works Fine:
             (Select TxnID from ReceivePaymentLine ) 

   This Does NOT work at all.
           (Select TxnID, CustomerRefListID, ARAccountRefListID, DepositToAccountRefListID, AppliedToTxnTxnID from ReceivePaymentLine)

You are mixing up your forum topics here. As per: Unable to retrieve records from ReceivePaymentLine...  use:

Select TxnId, TxnNumber, CustomerRefListID, DepositToAccountRefFullName,
ARAccountRefListID, DepositToAccountRefListID, AppliedToTxnTxnID
From  ReceivePaymentLine  Unoptimized