UFN_REVENUE_GETPREVIOUSRECEIPTNUMBER

            CREATE function dbo.UFN_REVENUE_GETPREVIOUSRECEIPTNUMBER
            (
                @REVENUEID uniqueidentifier
            )
            returns int
            with execute as caller
            as
            begin
                declare @RECEIPTNUMBER int;

                select top 1 
                    @RECEIPTNUMBER = RR.RECEIPTNUMBER 
                from 
                    dbo.REVENUERECEIPT RR 
                where 
                    RR.REVENUEID = @REVENUEID
                order by 
                    RR.RECEIPTPROCESSDATE desc;

                return @RECEIPTNUMBER; 
            end