UFN_REVENUE_GETTRIBUTESFORVIEW

            CREATE function dbo.UFN_REVENUE_GETTRIBUTESFORVIEW
            (
                @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
                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
            )