SQL Select Query to retrieve cost centre allocations

Hi All,

I am trying to retrieve voucher data from tally using SQL Select Statements.

I can retrieve data on voucher level. That is I am able to get the date, voucher number, voucher type name, party ledger name, amount, etc.

However, in some cases, the amount is split by allocations to multiple cost centres. I am not able to retrieve that data as I am not sure about the collection name and the field/method names.

I am able to use the following statements

Select $Date,$Reference,$Narration,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers

select $$FullList:LedgerEntries:$LedgerName,$$FullList:LedgerEntries:$Amount from RTSAllVouchers where $VoucherNumber='xxxxxxxxx'

select $Name from listofcostcentres

However, I am stuck at cost centre allocations or cost center vouchers collections.

I hope I will find the solution here.

Thanks in advance