Where to look to query AR Miscellaneous receipt's status and distribution .....

Dear All,

I'd like to retrieve information about AR Miscellaneous Receipts from the system. Specifically, I need the status, GL Date, Bank Account, distribution account (Credit side),

If the status is cleared

Clearing date, Statement Number, Statement Line number, and any other relevant details. Can you please advise me on the necessary table(s) and provide a suitable SELECT query?"

Please Help 😿

Thank You very much