USP_DATALIST_GIFTINKINDAPPRAISAL

Returns a list of appraisals for a gift-in-kind payment method detail.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_GIFTINKINDAPPRAISAL
(
    @GIFTINKINDPAYMENTMETHODDETAILID uniqueidentifier
)
as
    set nocount on;

    select
        ID,
        DATE,
        TRANSACTIONAMOUNT,
        APPRAISERID,
        (select CONSTITUENT.NAME from dbo.CONSTITUENT where CONSTITUENT.ID = APPRAISERID) [NAME],
        DESCRIPTION,
        TRANSACTIONCURRENCYID,
        TRANSACTIONAPPRAISALFEE
    from
        dbo.GIFTINKINDAPPRAISAL
    where
        GIFTINKINDPAYMENTMETHODDETAILID = @GIFTINKINDPAYMENTMETHODDETAILID;