Its all good solved my problem....
We were looking for a way where we could send our accounts people a payflow reference to look up payments in Payflow.
As it turns out you can search on the comment 1 field within payflow pro fro transactions.
I used the following sql on a hidden field and passed it to the payflow pro comment1 token.
select substring(replace(newid(),'-',''),1,10) as DefaultValue
I then used an email event to email the unique number to our accounts. They are now able to search transactions upon every purchase.
What can I say DF always gets the job done!!!