UFN_REVENUE_GETORIGINALRECEIPTRECORD

            create function dbo.UFN_REVENUE_GETORIGINALRECEIPTRECORD
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            as
            return
            (
                select top 1
                    coalesce(REC.ID, RR.ID) as ID,
                    coalesce(REC.RECEIPTNUMBER, RR.RECEIPTNUMBER) as RECEIPTNUMBER,
                    coalesce(REC.UNIQUERECEIPTNUMBER, RR.UNIQUERECEIPTNUMBER) as UNIQUERECEIPTNUMBER,
                    coalesce(REC.RECEIPTSTACKSHORTNAME, RR.RECEIPTSTACKSHORTNAME) as RECEIPTSTACKSHORTNAME,
                    coalesce(REC.RECEIPTSTACKINFOID, RR.RECEIPTSTACKINFOID) as RECEIPTSTACKINFOID
                from dbo.REVENUERECEIPT RR 
                left join dbo.REVENUERECEIPT REC on RR.ORIGINALREVENUERECEIPTID = REC.ID
                where 
                    RR.REVENUEID = @REVENUEID                
                order by 
                    RR.RECEIPTPROCESSDATE asc
            )