UFN_REVENUE_GETDOCUMENTATION

            CREATE function dbo.UFN_REVENUE_GETDOCUMENTATION
            (
                @REVENUEID uniqueidentifier
            )
            returns @RESULT table
            (
                ID uniqueidentifier,
                DOCUMENTATIONTYPECODE tinyint,
                MEDIAURL nvarchar(max),
                FILENAME nvarchar(255),
                FILEFIELDID nvarchar(50),
                DATEENTERED datetime,
                NOTETYPECODEID uniqueidentifier,
                TITLE nvarchar(50),
                AUTHORID uniqueidentifier,
                NOTETYPEDESCRIPTION nvarchar(100)
            )
            as
            begin
                insert into @RESULT
                select    
                    REVENUENOTE.ID,
                    0 as [DOCUMENTATIONTYPECODE],
                    null as [MEDIAURL],
                    null as [FILENAME],
                    null as [FILEFIELDID],
                    REVENUENOTE.DATEENTERED,
                    REVENUENOTE.REVENUENOTETYPECODEID as [NOTETYPECODEID],
                    REVENUENOTE.TITLE,
                    REVENUENOTE.AUTHORID,
                    REVENUENOTETYPECODE.DESCRIPTION as [NOTETYPEDESCRIPTION]
                from
                    dbo.REVENUENOTE
                left outer join dbo.REVENUENOTETYPECODE
                    on REVENUENOTETYPECODE.ID = REVENUENOTE.REVENUENOTETYPECODEID
                where 
                    REVENUENOTE.REVENUEID = @REVENUEID

                union all

                select    
                    REVENUEMEDIALINK.ID,
                    1 as [DOCUMENTATIONTYPECODE],
                    REVENUEMEDIALINK.MEDIAURL,
                    null,
                    null,
                    REVENUEMEDIALINK.DATEENTERED,
                    REVENUEMEDIALINK.REVENUEMEDIALINKTYPECODEID as [NOTETYPECODEID],
                    REVENUEMEDIALINK.TITLE,
                    REVENUEMEDIALINK.AUTHORID,
                    REVENUEMEDIALINKTYPECODE.DESCRIPTION as [NOTETYPEDESCRIPTION]
                from
                    dbo.REVENUEMEDIALINK
                left outer join dbo.REVENUEMEDIALINKTYPECODE
                    on REVENUEMEDIALINKTYPECODE.ID = REVENUEMEDIALINK.REVENUEMEDIALINKTYPECODEID
                where 
                    REVENUEMEDIALINK.REVENUEID = @REVENUEID

                union all

                select    
                    REVENUEATTACHMENT.ID,
                    2 as [DOCUMENTATIONTYPECODE],
                    null,
                    REVENUEATTACHMENT.FILENAME,
                    'FILE',
                    REVENUEATTACHMENT.DATEENTERED,
                    REVENUEATTACHMENT.REVENUEATTACHMENTTYPECODEID as [NOTETYPECODEID],
                    REVENUEATTACHMENT.TITLE,
                    REVENUEATTACHMENT.AUTHORID,
                    REVENUEATTACHMENTTYPECODE.DESCRIPTION as [NOTETYPEDESCRIPTION]
                from
                    dbo.REVENUEATTACHMENT
                left outer join dbo.REVENUEATTACHMENTTYPECODE
                    on REVENUEATTACHMENTTYPECODE.ID = REVENUEATTACHMENT.REVENUEATTACHMENTTYPECODEID
                where 
                    REVENUEATTACHMENT.REVENUEID = @REVENUEID

                order by
                    DATEENTERED desc;

            return;
            end