SQL Receivables Accounting Period

Summary

I need to report on receipts, and link to the appropriate accounting period in bi publisher.

Content

I have been unable to find an appropriate table/link between AR_CASH_RECEIPTS_ALL (or any receivable table) and accounting period. I have managed to find the link in payables easily, but receivables doesn't appear to be as simple? I have attempted to link to general ledger tables to resolve this issue but i am unsure how i could filter the results down to only get the correct accounting periods.

Hopefully i have explained this well enough, and appreciate any help. Many thanks.