USP_BBNC_SIGNUP_GETTRANIDPROCESSORID

Retrieves the Blackbaud Internet Solutions transaction and processor id fields for a signup batch row.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_SIGNUP_GETTRANIDPROCESSORID(@ID uniqueidentifier) 

            as

            set nocount on;

            select top 1
                BBNCTRANID, NETCOMMUNITYTRANSACTIONPROCESSORID
            from 
                dbo.BATCHBBNCSIGNUP
            where 
                ID = @ID;