UFN_JOURNALENTRYANNOTATIONS

Returns the annotations for the specified journal entry row.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@JOURNALENTRYID	uniqueidentifier	IN
@REFERENCENAME	nvarchar(255)	IN
@ANNOTATIONCATEGORYCODE	tinyint	IN

Definition

Copy



    CREATE function [dbo].[UFN_JOURNALENTRYANNOTATIONS](@JOURNALENTRYID uniqueidentifier, @REFERENCENAME nvarchar(255)=NULL, @ANNOTATIONCATEGORYCODE tinyint=NULL)
    returns @annotations table 
    (
      [ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL
      , [ANNOTATIONCATEGORYCODE] [tinyint] NOT NULL
      , [REFERENCENAME] [nvarchar](255) NULL
      , [SEQUENCE] [int] NOT NULL
    , VALIDATIONCODE [int] NOT NULL
      , [TEXT] [nvarchar](4000) NULL
    , APPUSERID [uniqueidentifier] NULL
    , [DATEADDED] [datetime] NOT NULL
    ) AS 
    begin
      insert
            @annotations
        select
        JOURNALENTRYANNOTATION.[ID]
        , JOURNALENTRYANNOTATION.[ANNOTATIONCATEGORYCODE]
        , JOURNALENTRYANNOTATION.[REFERENCENAME]
        , JOURNALENTRYANNOTATION.[SEQUENCE]
      , JOURNALENTRYANNOTATION.VALIDATIONCODE
        , JOURNALENTRYANNOTATION.[TEXT]
      , JOURNALENTRYANNOTATION.[APPUSERID]
      , JOURNALENTRYANNOTATION.[DATEADDED]
        from
            dbo.JOURNALENTRYANNOTATION
      where 
            JOURNALENTRYID=@JOURNALENTRYID AND 
      (REFERENCENAME=@REFERENCENAME OR @REFERENCENAME IS NULL) AND
      (ANNOTATIONCATEGORYCODE=@ANNOTATIONCATEGORYCODE OR @ANNOTATIONCATEGORYCODE IS NULL)
    order by 
      REFERENCENAME, ANNOTATIONCATEGORYCODE, SEQUENCE
    return
end