UFN_REVENUERECEIPT_GETRERECEIPTREASONCODE

create function dbo.UFN_REVENUERECEIPT_GETRERECEIPTREASONCODE
            (
                @REVENUEID uniqueidentifier
            )
            returns nvarchar(10)
            with execute as caller
            as
            begin
                declare @REASONCODE nvarchar(10) = '';

                select top 1 
                    @REASONCODE = RE.CODE

                from 
                    dbo.REVENUERECEIPT RR 
                inner join dbo.REVENUERECEIPTRERECEIPTDETAIL RD on RD.REVENUERECEIPTID = RR.ID
                inner join dbo.RERECEIPTREASONCODE RE on RD.RERECEIPTREASONCODEID = RE.ID
                where 
                    RR.REVENUEID = @REVENUEID
                order by 
                    RR.RECEIPTPROCESSDATE desc;

                return @REASONCODE; 
end