USP_DATALIST_RECOGNITIONDEFAULTS
Provides look-up for a constituent's default recognition credits.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @GIVENANONYMOUSLY | bit | IN | |
| @CONSTITUENTID | uniqueidentifier | IN | |
| @AMOUNT | money | IN | |
| @DATE | datetime | IN | |
| @SOURCERECURRINGGIFTREVENUEID | uniqueidentifier | IN | |
| @APPLICATIONTYPE | tinyint | IN | |
| @APPLICATIONID | uniqueidentifier | IN | |
| @MGSPLITID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_RECOGNITIONDEFAULTS
(
@GIVENANONYMOUSLY bit,
@CONSTITUENTID uniqueidentifier,
@AMOUNT money,
@DATE datetime,
@SOURCERECURRINGGIFTREVENUEID uniqueidentifier,
@APPLICATIONTYPE tinyint = null,
@APPLICATIONID uniqueidentifier = null,
@MGSPLITID uniqueidentifier = null
)
as
begin
set nocount on;
exec dbo.USP_DATALIST_RECOGNITIONDEFAULTS_2
@GIVENANONYMOUSLY,
@CONSTITUENTID,
@AMOUNT,
@DATE,
@SOURCERECURRINGGIFTREVENUEID,
@APPLICATIONTYPE,
@APPLICATIONID,
@MGSPLITID,
null;
end