USP_DATALIST_BANKACCOUNTAUTHORIZEDSIGNATURE

This data list displays bank account authorized signature data.

Parameters

Parameter	Parameter Type	Mode	Description
@BANKACCOUNTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



        CREATE procedure dbo.USP_DATALIST_BANKACCOUNTAUTHORIZEDSIGNATURE(
            @BANKACCOUNTID uniqueidentifier
        )
        as
        set nocount on;

        select BANKACCOUNTAUTHORIZEDSIGNATURE.ID,
            BANKACCOUNTAUTHORIZEDSIGNATURE.SIGNATUREID,
            case when BANKACCOUNTAUTHORIZEDSIGNATURE.AUTOSIGNATURECODE = 1 then 
                dbo.UFN_SIGNATURE_USERNAME(SIGNATURE.SIGNERCODE, SIGNATURE.NAME, SIGNATURE.APPUSERID)
                else BANKACCOUNTAUTHORIZEDSIGNATURE.MANUALSIGNATURENAME end as [NAME],
                BANKACCOUNTAUTHORIZEDSIGNATURE.AUTOSIGNATURECODE,
            dbo.UFN_SIGNATURE_APPLICATIONSDESCRIPTION(SIGNATURE.ID) as [APPLICATIONS]
        from dbo.BANKACCOUNTAUTHORIZEDSIGNATURE
        left outer join SIGNATURE on SIGNATURE.ID = BANKACCOUNTAUTHORIZEDSIGNATURE.SIGNATUREID
        left outer join dbo.APPUSER on APPUSER.ID = SIGNATURE.APPUSERID 
        where BANKACCOUNTAUTHORIZEDSIGNATURE.BANKACCOUNTID = @BANKACCOUNTID 
        order by [NAME]