UFN_SELECTION_REVENUE_ALLPLEDGES

Returns all revenue details where type is equal to Pledge.

Return

Return Type
table

Definition

Copy



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