UFN_FINANCIALTRANSACTION_GETBBPSTRANSACTIONID

create function dbo.UFN_FINANCIALTRANSACTION_GETBBPSTRANSACTIONID(@ID uniqueidentifier)
returns uniqueidentifier
as begin
    return (
        select CREDITCARDPAYMENTMETHODDETAIL.TRANSACTIONID
        from dbo.REVENUEPAYMENTMETHOD
        inner join dbo.CREDITCARDPAYMENTMETHODDETAIL on CREDITCARDPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID
        where REVENUEPAYMENTMETHOD.REVENUEID = @ID
    );
end