UFN_SELECTION_REVENUE_ALLGIFTS

Returns all revenue where type is equal to Gift.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_SELECTION_REVENUE_ALLGIFTS()
            returns table
            as return
                select distinct
                    ID
                from 
                    dbo.REVENUE
                where
                    TRANSACTIONTYPECODE = 0;