USP_STANDINGORDERSIMPORTPROCESS_VERIFYACCOUNT

Verifies constituent account for the standing orders import process.

Parameters

Parameter	Parameter Type	Mode	Description
@ACCOUNTNUMBER	nvarchar(50)	IN
@SORTCODE	nvarchar(8)	IN

Definition

Copy



            CREATE procedure dbo.USP_STANDINGORDERSIMPORTPROCESS_VERIFYACCOUNT
            (
                @ACCOUNTNUMBER nvarchar(50),
                @SORTCODE nvarchar(8)
            )
            as
                set nocount on;

                exec dbo.USP_GET_KEY_ACCESS

                select
                    CONSTITUENTACCOUNT.CONSTITUENTID,
                    CONSTITUENTACCOUNT.ID ACCOUNTID,
                    CONSTITUENT.LOOKUPID CONSTITUENTLOOKUPID,
                    CONSTITUENT.NAME CONSTITUENTNAME
                from
                    dbo.CONSTITUENTACCOUNT
                inner join dbo.FINANCIALINSTITUTION on 
                    CONSTITUENTACCOUNT.FINANCIALINSTITUTIONID = FINANCIALINSTITUTION.ID
                left join dbo.CONSTITUENT on
                    CONSTITUENTACCOUNT.CONSTITUENTID = CONSTITUENT.ID
                where
                    cast(decryptbykey(CONSTITUENTACCOUNT.ACCOUNTNUMBER)
                    as nvarchar(50)) = @ACCOUNTNUMBER
                and 
                    FINANCIALINSTITUTION.SORTCODE = @SORTCODE

                close symmetric key sym_BBInfinity;