USP_DATALIST_RECOGNITIONDEFAULTS_2

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
@MGSPLITID	uniqueidentifier	IN
@BATCHROWID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_DATALIST_RECOGNITIONDEFAULTS_2
(
    @GIVENANONYMOUSLY bit,
    @CONSTITUENTID uniqueidentifier,
    @AMOUNT money,
    @DATE datetime,
    @SOURCERECURRINGGIFTREVENUEID uniqueidentifier,
    @APPLICATIONTYPE tinyint = null,
    @APPLICATIONID uniqueidentifier = null,
    @MGSPLITID uniqueidentifier = null,
  @BATCHROWID uniqueidentifier = null
)
as
begin 
  set nocount on;

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