UFN_BBNC_DONATION_GETROWBBNCIDS

Returns a list of Blackbaud Internet Solutions transaction IDs that are part of a Blackbaud Internet Solutions donation batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_DONATION_GETROWBBNCIDS
            (
                @BATCHID uniqueidentifier
            )
            returns table
            as
                return
                (
                    select 
            bbnc.BBNCID as VALUE
          from 
            dbo.BATCHREVENUE br inner join
            dbo.BATCHREVENUEBBNCINFO bbnc on br.ID = bbnc.BATCHREVENUEID
          where 
            BATCHID = @BATCHID
                );