V_QUERY_PLANNEDGIFTTOPAYMENT

Provides a connection between planned gifts and their payments.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier	yes	System record ID
PLANNEDGIFTID	uniqueidentifier		Planned gift ID
AMOUNT	money	yes	Amount
APPLICATIONCURRENCYID	uniqueidentifier	yes	Application currency ID
APPLICATIONEXCHANGERATEID	uniqueidentifier	yes	Application exchange rate

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:27:38 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PLANNEDGIFTTOPAYMENT AS



                select 
                    INSTALLMENTSPLITPAYMENT.PAYMENTID as ID,
                    REVENUE.ID as PLANNEDGIFTID,
                    INSTALLMENTSPLITPAYMENT.AMOUNT,
                    INSTALLMENTSPLITPAYMENT.APPLICATIONCURRENCYID,
                    INSTALLMENTSPLITPAYMENT.APPLICATIONEXCHANGERATEID
                    /*#EXTENSION*/ 
                from REVENUE
                    left join INSTALLMENTSPLITPAYMENT on INSTALLMENTSPLITPAYMENT.PLEDGEID=REVENUE.ID
                where REVENUE.TRANSACTIONTYPECODE = 4