UFN_REVENUE_GETLETTERS

            create function dbo.UFN_REVENUE_GETLETTERS
            (
                @ID uniqueidentifier
            )
            returns @RESULT table
            (
                ID uniqueidentifier,
                LETTERCODEID uniqueidentifier,
                PROCESSDATE datetime,
                ACKNOWLEDGEDATE datetime
            )
            as
            begin
                insert into @RESULT 

                select 
                    REVENUELETTER.ID as [ID],
                    REVENUELETTER.LETTERCODEID,
                    REVENUELETTER.PROCESSDATE,
                    REVENUELETTER.ACKNOWLEDGEDATE
                from 
                    dbo.REVENUELETTER
                where 
                    REVENUELETTER.REVENUEID = @ID;

            return;
        end