report issue

hi all,

i need to make a custom query to show the incoming payments transaction and outgoing payment transaction by payment types. on check register it shows only checks. i need to buld the same kind of report like check register. can anyone tell me from which tables i need to pull the report are already any reports are available,