How to Fetch all values from Receipt

Dear Experts.,

I tried to fetch all values from Receipt using select query., This sql query works fine but i don't know how to fetch agst.ref bill no and agst.ref bill amount., here i include my select sql query as well as collection also., please give me some solution as soon as possible.,


SELECT SQL QUERY
---------------------------------
Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from VouchersCol where $$IsReceipt:$VoucherTypeName
COLLECTION
---------------------
[Collection: VouchersCol]
Type : Vouchers
IsODBCTable: Yes
Fetch : *,AllLedgerEntries.*,LedgerEntries.*


Thanks.,

 

Thanks for your reply., can u give some example collection?