V_QUERY_RECURRINGGIFTTOPAYMENT

Provides a connection between recurring gifts and their payments.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier	yes	System record ID
RECURRINGGIFTID	uniqueidentifier		Recurring gift ID
ACTIVITYAMOUNT	money	yes	Amount
ACTIVITYTYPE	nvarchar(8)	yes	Activity type
ACTIVITYSCHEDULEDATE	datetime	yes	Scheduled date
APPLICATIONCURRENCYID	uniqueidentifier	yes	Application currency ID
APPLICATIONEXCHANGERATEID	uniqueidentifier	yes	Application exchange rate

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  1/21/2016 5:07:48 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.154.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RECURRINGGIFTTOPAYMENT AS



                select 
                    RECURRINGGIFTACTIVITY.PAYMENTREVENUEID as ID,
                    FINANCIALTRANSACTION.ID as RECURRINGGIFTID,
                    RECURRINGGIFTACTIVITY.AMOUNT as ACTIVITYAMOUNT,
                    RECURRINGGIFTACTIVITY.TYPE as ACTIVITYTYPE,
                    RECURRINGGIFTACTIVITY.SCHEDULEDATE as ACTIVITYSCHEDULEDATE,
                    RECURRINGGIFTACTIVITY.APPLICATIONCURRENCYID,
                    RECURRINGGIFTACTIVITY.APPLICATIONEXCHANGERATEID
                    /*#EXTENSION*/ 
                from FINANCIALTRANSACTION
                    left join RECURRINGGIFTACTIVITY on RECURRINGGIFTACTIVITY.SOURCEREVENUEID = FINANCIALTRANSACTION.ID
                where FINANCIALTRANSACTION.TYPECODE = 2
                and FINANCIALTRANSACTION.DELETEDON is null