UFN_CREDIT_REFUND_GETMERCHANDISETOTAL

        create function dbo.UFN_CREDIT_REFUND_GETMERCHANDISETOTAL
        (
            @CREDITID uniqueidentifier = null
        )
        returns money
        with execute as caller
        as begin
            return (
                select sum(CI.TOTAL)
                from dbo.CREDITITEM CI
                inner join dbo.CREDIT C on C.ID = CI.CREDITID
                where C.ID = @CREDITID
                and CI.TYPECODE = 14
            )
        end