UFN_FINANCIALINSTITUTION_GETREJECTIONCODES

This function returns all rejection codes for a given constituent financial institution.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@FINANCIALINSTITUTIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_FINANCIALINSTITUTION_GETREJECTIONCODES
            (
                @FINANCIALINSTITUTIONID uniqueidentifier
            )
            returns table
            as return
            (
                select 
                    FINANCIALINSTITUTIONREJECTIONCODE.ID,
                    FINANCIALINSTITUTIONREJECTIONCODE.REJECTIONCODE,
                    FINANCIALINSTITUTIONREJECTIONCODE.SEQUENCE
                from
                    dbo.FINANCIALINSTITUTIONREJECTIONCODE
                where
                    FINANCIALINSTITUTIONREJECTIONCODE.FINANCIALINSTITUTIONID = @FINANCIALINSTITUTIONID
            )