V_SEARCH_REVENUE

Search for Revenue

Fields

Field	Field Type	Null
ID	uniqueidentifier
NAME	nvarchar(154)	yes
AMOUNT	money
PAYMENTMETHOD	nvarchar(14)	yes
DATE	datetime	yes
TRANSACTIONTYPE	nvarchar(27)	yes
TRANSACTIONCURRENCYID	uniqueidentifier

Definition

Copy

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



                select FINANCIALTRANSACTION.ID,
                    CONSTITUENT.NAME,
                    FINANCIALTRANSACTION.TRANSACTIONAMOUNT as AMOUNT,
                    REVENUEPAYMENTMETHOD.PAYMENTMETHOD,
                    cast(FINANCIALTRANSACTION.DATE as datetime) as DATE,
                    FINANCIALTRANSACTION.TYPE as TRANSACTIONTYPE,
                    FINANCIALTRANSACTION.TRANSACTIONCURRENCYID
                from dbo.FINANCIALTRANSACTION
                inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                inner join dbo.REVENUEPAYMENTMETHOD on REVENUEPAYMENTMETHOD.REVENUEID = FINANCIALTRANSACTION.ID
                inner join dbo.CONSTITUENT on FINANCIALTRANSACTION.CONSTITUENTID = CONSTITUENT.ID
                where FINANCIALTRANSACTION.DELETEDON is null;