V_QUERY_DESIGNATIONREVENUESPLITINFO

Provides the ability to query for details of a designation split.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
TRANSACTIONPLEDGEBALANCE	money	yes	Pledge balance (transaction currency)
PLEDGEBALANCE	money	yes	Pledge balance
REVALUEDORGANIZATIONPLEDGEBALANCE	money	yes	Pledge balance (organization currency)
TRANSACTIONCURRENCYID	uniqueidentifier	yes	Transaction currency ID
BASECURRENCYID	uniqueidentifier	yes	Base currency ID

Definition

Copy

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



                select
                    REVENUESPLIT.ID,
                    dbo.UFN_PLEDGE_GETDESIGNATIONBALANCE(REVENUESPLIT.REVENUEID, REVENUESPLIT.DESIGNATIONID) TRANSACTIONPLEDGEBALANCE,
                    BALANCES.BASEBALANCE PLEDGEBALANCE,
                    BALANCES.ORGANIZATIONBALANCE REVALUEDORGANIZATIONPLEDGEBALANCE,
                    REVENUE.TRANSACTIONCURRENCYID,
                    REVENUE.BASECURRENCYID
                from dbo.REVENUESPLIT
                    inner join REVENUE on REVENUESPLIT.REVENUEID=REVENUE.ID
                    cross apply dbo.UFN_PLEDGE_GETREVALUEDSPLITBALANCES(REVENUE.ID, getdate(), 0) BALANCES
                where REVENUE.TRANSACTIONTYPECODE=1
                    and BALANCES.ID = REVENUESPLIT.ID