V_QUERY_MATCHINGGIFTPLEDGE

Provides the ability to query on a revenue record's matching gifts.

Fields

Field	Field Type	Null	Description
MATCHINGGIFTCONDITIONID	uniqueidentifier	yes	Matching Gift Condition ID
AMOUNT	money		Amount
ID	uniqueidentifier		System record ID
MGSOURCEREVENUEID	uniqueidentifier		Matching Gift Source ID
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value
ADDEDBY_APPLICATION	nvarchar(200)	yes	Added by application
ADDEDBY_USERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBY_USERNAME	nvarchar(128)	yes	Changed by user name
BASECURRENCYID	uniqueidentifier	yes	Base currency ID
BASEEXCHANGERATEID	uniqueidentifier	yes	Base exchange rate
ORGANIZATIONAMOUNT	money		Amount (organization currency)
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	Organization exchange rate
TRANSACTIONAMOUNT	money		Amount (transaction currency)
TRANSACTIONCURRENCYID	uniqueidentifier	yes	Transaction currency ID

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:32 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MATCHINGGIFTPLEDGE AS



                select
                    REVENUEMATCHINGGIFT.MATCHINGGIFTCONDITIONID,
                    REVENUE.AMOUNT,
                    REVENUEMATCHINGGIFT.ID,
                    REVENUEMATCHINGGIFT.MGSOURCEREVENUEID,
                    REVENUEMATCHINGGIFT.DATEADDED,
                    REVENUEMATCHINGGIFT.DATECHANGED,
                    REVENUEMATCHINGGIFT.TSLONG,
                    [ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    [ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
                    [CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
                    REVENUE.BASECURRENCYID,
                    REVENUE.BASEEXCHANGERATEID,
                    REVENUE.ORGANIZATIONAMOUNT,
                    REVENUE.ORGANIZATIONEXCHANGERATEID,
                    REVENUE.TRANSACTIONAMOUNT,
                    REVENUE.TRANSACTIONCURRENCYID
                    /*#EXTENSION*/ 
                from dbo.REVENUEMATCHINGGIFT
                inner join dbo.REVENUE on REVENUE.ID = REVENUEMATCHINGGIFT.ID
                left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = REVENUEMATCHINGGIFT.ADDEDBYID
                left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = REVENUEMATCHINGGIFT.CHANGEDBYID