USP_DATALIST_RECOGNITIONCREDIT_DONORCHALLENGE

Displays a list of recognition credits including donor challenge recognition credits and revenue recognition credits.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_RECOGNITIONCREDIT_DONORCHALLENGE
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select 
    RECOGNITION.ID,
    RECOGNITION.CONSTITUENTID,
    RECOGNITION.CONSTITUENT,
    RECOGNITION.DONOR,
    RECOGNITION.AMOUNT,
    convert(date,RECOGNITION.EFFECTIVEDATE) EFFECTIVEDATE,
    RECOGNITION.REVENUERECOGNITIONTYPECODEID,
    RECOGNITION.RECOGNITIONTYPE,
    RECOGNITION.BASECURRENCYID,
    RECOGNITION.GROSSAMOUNT,
    RECOGNITION.DESIGNATION
  from 
    dbo.UFN_RECOGNITIONCREDIT_DONORCHALLENGE_GETRECOGNITIONS(@ID) RECOGNITION    
  order by EFFECTIVEDATE asc, CONSTITUENT asc