UFN_REVENUEBATCH_GETRECOGNITIONDEFAULTS_2

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@GIVENANONYMOUSLY	bit	IN
@CONSTITUENTID	uniqueidentifier	IN
@AMOUNT	money	IN
@DATE	datetime	IN
@SOURCERECURRINGGIFTREVENUEID	uniqueidentifier	IN
@APPLICATIONTYPE	tinyint	IN
@APPLICATIONID	uniqueidentifier	IN

Definition

Copy




    CREATE function dbo.UFN_REVENUEBATCH_GETRECOGNITIONDEFAULTS_2
    (
      @GIVENANONYMOUSLY bit,
        @CONSTITUENTID uniqueidentifier,
        @AMOUNT money,
        @DATE datetime,
        @SOURCERECURRINGGIFTREVENUEID uniqueidentifier,
        @APPLICATIONTYPE tinyint = null,
        @APPLICATIONID uniqueidentifier = null
    )
    returns @RECOGNITIONS table
        (
            CONSTITUENTID uniqueidentifier,
            NAME nvarchar(500),
            AMOUNT money,
            REVENUERECOGNITIONTYPECODEID uniqueidentifier
        )
        as
        begin

      insert into @RECOGNITIONS 
      select RECOGNITIONS.CONSTITUENTID, 
          RECOGNITIONS.NAME, 
          RECOGNITIONS.AMOUNT,
          RECOGNITIONS.REVENUERECOGNITIONTYPECODEID
        from dbo.UFN_REVENUEBATCH_GETRECOGNITIONDEFAULTS_3(@GIVENANONYMOUSLY,
          @CONSTITUENTID,
          @AMOUNT,
          @DATE,
          @SOURCERECURRINGGIFTREVENUEID,
          @APPLICATIONTYPE,
          @APPLICATIONID,
          null) as RECOGNITIONS

        return;
        end