NEED SQL FOR CHECK REGISTER REPORT

i need a report that shows the check that have been printed. i need to see the bank account used to pay the check.

check number, check date, check total, check payable to, what the check was paying

ap invoice number, ap invoice date, ap invoice total, ap invoice amount paid(this can be different that the ap invoice doc total.

ap down payment invoice, etc.

i basically need to see what is on the outgoing payment

thank you