UFN_REVENUE_GETORIGINALRECEIPTNUMBER

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

                select top 1 
                    @RECEIPTNUMBER = coalesce(REC.RECEIPTNUMBER, RR.RECEIPTNUMBER)
                from 
                    dbo.REVENUERECEIPT RR 
                left join 
                    dbo.REVENUERECEIPT REC on RR.ORIGINALREVENUERECEIPTID = REC.ID
                where 
                    RR.REVENUEID = @REVENUEID
                order by 
                    RR.RECEIPTPROCESSDATE desc;

                return @RECEIPTNUMBER; 
            end