unapplied payments and credits

Can anyone tell me how i can diffrentiate between unapplied payment, credit and invoice entries in custTrans table? Also where can i get the check number (if it exists) for payments? I’ve been asked to write a report that lists those and decided to go off the CustTrans table… is that a good choice?