V_QUERY_REVENUE_GIFTAID

Provides the ability to query revenue gift aid.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier	yes	System record ID
GROSSAMOUNT	money	yes	Gross amount
CLAIMABLEGIFTAIDAMOUNT	money	yes	Claimable tax claim amount
RECEIVEDGIFTAIDAMOUNT	money	yes	Received tax claim amount
TRANSACTIONGROSSAMOUNT	money	yes	Gross amount (transaction currency)
ORGANIZATIONGROSSAMOUNT	money	yes	Gross amount (organization currency)
TRANSACTIONCLAIMABLEGIFTAIDAMOUNT	money	yes	Claimable tax claim amount (transaction currency)
ORGANIZATIONCLAIMABLEGIFTAIDAMOUNT	money	yes	Claimable tax claim amount (organization currency)
TRANSACTIONRECEIVEDGIFTAIDAMOUNT	money	yes	Received tax claim amount (transaction currency)
ORGANIZATIONRECEIVEDGIFTAIDAMOUNT	money	yes	Received tax claim amount (organization currency)
ADDEDBY_USERNAME	nvarchar(128)		Added by user name
CHANGEDBY_USERNAME	nvarchar(128)		Changed by user name
DATEADDED	datetime	yes	Date added
DATECHANGED	datetime	yes	Date changed
TSLONG	bigint	yes	Timestamp value
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	yes	Organization exchange rate ID
BASEEXCHANGERATEID	uniqueidentifier	yes	Base exchange rate
BASECURRENCYID	uniqueidentifier	yes	Base currency ID
TRANSACTIONCURRENCYID	uniqueidentifier	yes	Transaction currency ID
POTENTIALGROSSAMOUNT	money	yes
TRANSACTIONPOTENTIALGROSSAMOUNT	money	yes
ORGANIZATIONPOTENTIALGROSSAMOUNT	money	yes
REFRESHDATE	datetime	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  9/30/2015 1:01:53 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REVENUE_GIFTAID AS



                select
                    REVENUESPLITGIFTAIDAMOUNTS.FINANCIALTRANSACTIONID as ID,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.GROSSAMOUNT) as GROSSAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.CLAIMABLEGIFTAIDAMOUNT) as CLAIMABLEGIFTAIDAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.RECEIVEDGIFTAIDAMOUNT) as RECEIVEDGIFTAIDAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONGROSSAMOUNT) as TRANSACTIONGROSSAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONGROSSAMOUNT) as ORGANIZATIONGROSSAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONCLAIMABLEGIFTAIDAMOUNT) as TRANSACTIONCLAIMABLEGIFTAIDAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONCLAIMABLEGIFTAIDAMOUNT) as ORGANIZATIONCLAIMABLEGIFTAIDAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONRECEIVEDGIFTAIDAMOUNT) as TRANSACTIONRECEIVEDGIFTAIDAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONRECEIVEDGIFTAIDAMOUNT) as ORGANIZATIONRECEIVEDGIFTAIDAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEADDEDBYUSERNAME as ADDEDBY_USERNAME,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUECHANGEDBYUSERNAME as CHANGEDBY_USERNAME,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEDATEADDED as DATEADDED,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEDATECHANGED as DATECHANGED,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUETSLONG as TSLONG,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEORGANIZATIONEXCHANGERATEID as ORGANIZATIONEXCHANGERATEID,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEBASEEXCHANGERATEID as BASEEXCHANGERATEID,
                    REVENUESPLITGIFTAIDAMOUNTS.BASECURRENCYID as BASECURRENCYID,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUETRANSACTIONCURRENCYID as TRANSACTIONCURRENCYID,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.POTENTIALGROSSAMOUNT) as POTENTIALGROSSAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONPOTENTIALGROSSAMOUNT) as TRANSACTIONPOTENTIALGROSSAMOUNT,
                    sum(REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONPOTENTIALGROSSAMOUNT) as ORGANIZATIONPOTENTIALGROSSAMOUNT,
                    max(REVENUESPLITGIFTAIDAMOUNTS.REFRESHDATE) as REFRESHDATE
                    /*#EXTENSION*/
                from 
                    dbo.REVENUESPLITGIFTAIDAMOUNTS
                group by 
                    REVENUESPLITGIFTAIDAMOUNTS.FINANCIALTRANSACTIONID,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEADDEDBYUSERNAME,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUECHANGEDBYUSERNAME,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEDATEADDED,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEDATECHANGED,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUETSLONG,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEORGANIZATIONEXCHANGERATEID,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUEBASEEXCHANGERATEID,
                    REVENUESPLITGIFTAIDAMOUNTS.BASECURRENCYID,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUETRANSACTIONCURRENCYID