UFN_REVENUE_GETTRIBUTESFORVIEW_2

            CREATE function dbo.UFN_REVENUE_GETTRIBUTESFORVIEW_2
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            as 
            return (
                select 
                    REVENUETRIBUTE.ID,
                    TRIBUTE.ID as TRIBUTEID,
                    TRIBUTE.TRIBUTETEXT,
                    TYPE.DESCRIPTION as TRIBUTETYPE,
                    REVENUETRIBUTE.AMOUNT,
                    coalesce(REVENUETRIBUTE.AMOUNT + RTTCA.TAXCLAIMAMOUNT, REVENUETRIBUTE.AMOUNT) as GROSSAMOUNT,
                    REVENUETRIBUTE.BASECURRENCYID,
          REVENUETRIBUTE.ISTRIBUTEANONYMOUS
                    from 
                        dbo.REVENUETRIBUTE
                    inner join
                        dbo.TRIBUTE on REVENUETRIBUTE.TRIBUTEID = TRIBUTE.ID
                    inner join
                        dbo.TRIBUTETYPECODE TYPE on TRIBUTE.TRIBUTETYPECODEID = TYPE.ID
                    left join
                        dbo.REVENUETRIBUTETAXCLAIMAMOUNT RTTCA on REVENUETRIBUTE.ID = RTTCA.ID
                    where 
                        REVENUETRIBUTE.REVENUEID = @REVENUEID
            )