V_QUERY_REVENUESPLIT_GIFTAID

Provides the ability to query revenue split gift aid.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
DECLINESGIFTAID	bit		Declines Gift Aid
ISSPONSORSHIP	bit		Gift Aid sponsorship
TAXCLAIMELIGIBILITY	nvarchar(20)	yes	Tax claim eligibility
TAXCLAIMNUMBER	nvarchar(10)		Tax claim number
TAXCLAIMAMOUNT	money		Tax claim amount
QUALIFICATIONSTATUS	nvarchar(50)		Gift Aid qualification status
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
GROSSAMOUNT	money		Gross amount
CLAIMABLEGIFTAIDAMOUNT	money		Claimable tax claim amount
RECEIVEDGIFTAIDAMOUNT	money		Received tax claim amount
TRANSACTIONTAXCLAIMAMOUNT	money		Tax claim amount (transaction currency)
ORGANIZATIONTAXCLAIMAMOUNT	money		Tax claim amount (organization currency)
TRANSACTIONGROSSAMOUNT	money		Gross amount (transaction currency)
ORGANIZATIONGROSSAMOUNT	money		Gross amount (organization currency)
TRANSACTIONCLAIMABLEGIFTAIDAMOUNT	money		Claimable tax claim amount (transaction currency)
ORGANIZATIONCLAIMABLEGIFTAIDAMOUNT	money		Claimable tax claim amount (organization currency)
TRANSACTIONRECEIVEDGIFTAIDAMOUNT	money		Received tax claim amount (transaction currency)
ORGANIZATIONRECEIVEDGIFTAIDAMOUNT	money		Received tax claim amount (organization currency)
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
TRANSACTIONPOTENTIALGROSSAMOUNT	money
ORGANIZATIONPOTENTIALGROSSAMOUNT	money
REFRESHDATE	datetime	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:28:57 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REVENUESPLIT_GIFTAID AS



                select
                    REVENUESPLITGIFTAIDAMOUNTS.ID,
                    REVENUESPLITGIFTAIDAMOUNTS.DECLINESGIFTAID,
                    REVENUESPLITGIFTAIDAMOUNTS.ISSPONSORSHIP,
                    REVENUESPLITGIFTAIDAMOUNTS.ELIGIBILITY as TAXCLAIMELIGIBILITY,
                    REVENUESPLITGIFTAIDAMOUNTS.TAXCLAIMNUMBER,
                    REVENUESPLITGIFTAIDAMOUNTS.TAXCLAIMAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.QUALIFICATIONSTATUS,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUESPLITGIFTAIDADDEDBYUSERNAME as ADDEDBY_USERNAME,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUESPLITGIFTAIDCHANGEDBYUSERNAME as CHANGEDBY_USERNAME,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUESPLITGIFTAIDDATEADDED as DATEADDED,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUESPLITGIFTAIDDATECHANGED as DATECHANGED,
                    REVENUESPLITGIFTAIDAMOUNTS.REVENUESPLITGIFTAIDTSLONG as TSLONG,                        
                    REVENUESPLITGIFTAIDAMOUNTS.GROSSAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.CLAIMABLEGIFTAIDAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.RECEIVEDGIFTAIDAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONTAXCLAIMAMOUNT,                    
                    REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONTAXCLAIMAMOUNT,                            
                    REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONGROSSAMOUNT,                        
                    REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONGROSSAMOUNT,                    
                    REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONCLAIMABLEGIFTAIDAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONCLAIMABLEGIFTAIDAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONRECEIVEDGIFTAIDAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONRECEIVEDGIFTAIDAMOUNT,                    
                    REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONEXCHANGERATEID,
                    REVENUESPLITGIFTAIDAMOUNTS.BASEEXCHANGERATEID,
                    REVENUESPLITGIFTAIDAMOUNTS.BASECURRENCYID,
                    REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONCURRENCYID,
                    REVENUESPLITGIFTAIDAMOUNTS.POTENTIALGROSSAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.TRANSACTIONPOTENTIALGROSSAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.ORGANIZATIONPOTENTIALGROSSAMOUNT,
                    REVENUESPLITGIFTAIDAMOUNTS.REFRESHDATE
                    /*#EXTENSION*/                
                from
                    dbo.REVENUESPLITGIFTAIDAMOUNTS;