UFN_SELECTION_REVENUE_NOPLEDGES

Selects all revenue except pledges and recurring gifts.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_SELECTION_REVENUE_NOPLEDGES()
            returns table
            as return
                select distinct
                    ID
                from 
                    dbo.REVENUE
                where
                    TRANSACTIONTYPECODE not in (1,2);