UFN_REVENUEUPDATEBATCH_GETTRIBUTES

    CREATE function dbo.UFN_REVENUEUPDATEBATCH_GETTRIBUTES(@REVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select
           '00000000-0000-0000-0000-000000000000' as ID, 
           TRIBUTEID,
           AMOUNT,
           DESIGNATIONID,
           ROW_NUMBER() OVER(order by REVENUETRIBUTE.DATEADDED) as SEQUENCE,
           REVENUETRIBUTE.ID as REVENUETRIBUTEID,
           BASECURRENCYID
        from dbo.REVENUETRIBUTE 
        inner join dbo.TRIBUTE on REVENUETRIBUTE.TRIBUTEID = TRIBUTE.ID
        where REVENUEID = @REVENUEID

            )