UFN_FINANCIALINSTITUTION_SINGLEBANKID

Validates that the bank id from only one country is entered.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@ROUTINGNUMBER	nvarchar(9)	IN
@SORTCODE	nvarchar(8)	IN
@BSB	nvarchar(7)	IN
@INSTITUTIONID	nvarchar(8)	IN
@BANKNUMBER	nvarchar(7)	IN

Definition

Copy



        CREATE function dbo.UFN_FINANCIALINSTITUTION_SINGLEBANKID
        (
            @ROUTINGNUMBER nvarchar(9),
            @SORTCODE nvarchar(8),
            @BSB nvarchar(7),
            @INSTITUTIONID nvarchar(8),
            @BANKNUMBER nvarchar(7)
        )
        returns bit
        with execute as caller
        as begin

            return dbo.UFN_FINANCIALINSTITUTION_SINGLEBANKID_2(@ROUTINGNUMBER,@SORTCODE,@BSB,@INSTITUTIONID,@BANKNUMBER,'','')

        end