USP_BBNC_GETORCREATEFINANCIALINSTITUTION

Gets or create a financial institution for use in committing donation transactions from Blackbaud Internet Solutions.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@FINANCIALINSTITUTION	nvarchar(100)	IN
@BRANCHNAME	nvarchar(100)	IN
@ROUTINGNUMBER	nvarchar(9)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@SORTCODE	nvarchar(6)	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_GETORCREATEFINANCIALINSTITUTION
            (
                @ID uniqueidentifier = null output,
                @FINANCIALINSTITUTION nvarchar(100),
                @BRANCHNAME nvarchar(100),
                @ROUTINGNUMBER nvarchar(9),
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null,
                @SORTCODE nvarchar(6) = ''

            )
            as
            set nocount on;

     declare @BICCODE nvarchar(11)= '';
     declare @BANKCODE nvarchar(25)= '';
     declare @BSBNUMBER nvarchar(6)= '';

      exec dbo.USP_BBNC_GETORCREATEFINANCIALINSTITUTION_1_1
      @ID output,
      @FINANCIALINSTITUTION,
      @BRANCHNAME,
            @ROUTINGNUMBER,
            @CHANGEAGENTID,
            @CHANGEDATE,
            @SORTCODE,
      @BICCODE,
      @BANKCODE,
      @BSBNUMBER

            return 0;