get the Invoice number in vendtrans table

how can i join na spectrans, ledgerjournaltrans, vendtransopen and vendtrans, to get the invoice number in the vendtrans table …i need it to appear on my report when i settle a transaction in the Account Payable module, under payment journal.

hope you could help me guys…thank you in advance… i need it badly