UFN_SELECTION_COMMUNICATIONS_ALLPLEDGES

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

Return

Return Type
table

Definition

Copy



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