UFN_REVENUEUPDATEBATCH_GETNOTES

Returns a list of notes associated with a certain revenue batch ID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_REVENUEUPDATEBATCH_GETNOTES(
    @BATCHREVENUEID uniqueidentifier
) returns table
as
return
(
    select
      ID,
      NOTETITLE,
      NOTEAUTHORID,
      NOTETEXTNOTE,        
      NOTETYPECODEID,
      NOTEDATEENTERED,
      REVENUENOTEID,
      NOTEHTMLNOTE
    from (select
        ID,
        TITLE as [NOTETITLE],
        AUTHORID  as [NOTEAUTHORID],
        TEXTNOTE  as [NOTETEXTNOTE],        
        [NOTETYPECODEID],
        DATEENTERED  as [NOTEDATEENTERED],
        [REVENUENOTEID],
        HTMLNOTE  as [NOTEHTMLNOTE]
    from
        dbo.BATCHREVENUENOTE 
    where
        BATCHREVENUEID = @BATCHREVENUEID) QRY
);