V_SEARCH_TRANSACTION

Search for transactions in revenue update batch

Fields

Field	Field Type	Null
ID	uniqueidentifier
LOOKUPID	nvarchar(100)	yes
NAME	nvarchar(154)	yes
TRANSACTIONTYPE	nvarchar(21)	yes
AMOUNT	money	yes
PAYMENTMETHOD	nvarchar(14)	yes
DATE	datetime	yes
DETAILS	nvarchar(max)	yes
REVENUELOOKUPID	nvarchar(100)	yes
TRANSACTIONCURRENCYID	uniqueidentifier	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  9/1/2024 11:53:10 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_TRANSACTION AS



                select REVENUE.ID [ID],
                    CONSTITUENT.LOOKUPID,
                    CONSTITUENT.NAME,
                    REVENUE.TRANSACTIONTYPE,
                    sum(REVENUE.TRANSACTIONAMOUNT) AMOUNT,
                    REVENUEPAYMENTMETHOD.PAYMENTMETHOD,
                    REVENUE.DATE,
                    dbo.UDA_BUILDLIST(' ' + REVENUESPLIT.APPLICATION + '(' + convert(nvarchar(20), REVENUESPLIT.AMOUNT) + ' ' + CURRENCY.ISO4217 + ')') as [DETAILS],
                    REVENUE.LOOKUPID [REVENUELOOKUPID],
                    REVENUE.TRANSACTIONCURRENCYID
                from dbo.REVENUE
                    inner join dbo.REVENUEPAYMENTMETHOD on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
                    inner join dbo.REVENUESPLIT on REVENUE.ID = REVENUESPLIT.REVENUEID
                    inner join dbo.CONSTITUENT on REVENUE.CONSTITUENTID = CONSTITUENT.ID
                    inner join dbo.CURRENCY on CURRENCY.ID = REVENUE.TRANSACTIONCURRENCYID
                group by REVENUE.ID, 
                    CONSTITUENT.LOOKUPID, 
                    CONSTITUENT.NAME, 
                    REVENUE.TRANSACTIONTYPE, 
                    PAYMENTMETHOD, 
                    DATE,
                    REVENUE.LOOKUPID,
                    REVENUE.TRANSACTIONCURRENCYID;