UFN_SELECTION_COMMUNICATION_ALLRECURRINGGIFTS

Returns all revenue transactions of type recurring gift for the communications to use.

Return

Return Type
table

Definition

Copy



create function dbo.UFN_SELECTION_COMMUNICATION_ALLRECURRINGGIFTS()
returns table
as return
    select distinct
        ID
    from 
        dbo.REVENUE
    where
        TRANSACTIONTYPECODE = 2;