USP_GIFTAIDDISQUALIFICATIONATTRIBUTE_GETINFORMATIONBYID

Returns information about a revenue attribute disqualified for Gift Aid.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



      CREATE procedure [dbo].[USP_GIFTAIDDISQUALIFICATIONATTRIBUTE_GETINFORMATIONBYID]
      (
          @ID uniqueidentifier = null
      )
          as        
              set nocount on;

        select ID,
          ATTRIBUTECATEGORYID,
          CONSTITUENTID,
          CURRENCYVALUE,
          DATEVALUE,
          FUZZYDATEVALUE,
          MEMOVALUE,
          NUMBERVALUE,
          TEXTVALUE,
          HOURMINUTEVALUE,
          BOOLEANVALUE,
          TSLONG,
          CODETABLEVALUE,
          DATATYPE
        from dbo.[GIFTAIDDISQUALIFIEDBYATTRIBUTE]
        where
            ID = @ID;