UFN_BANKACCOUNTDEPOSIT_ISOPEN

This function returns the status of the deposit.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@DEPOSITID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BANKACCOUNTDEPOSIT_ISOPEN(@DEPOSITID uniqueidentifier)
      returns bit
            with execute as caller
            as begin

            declare @ISOPEN bit

            select @ISOPEN = BANKACCOUNTDEPOSIT.STATUSCODE 
            from dbo.BANKACCOUNTDEPOSIT
            where BANKACCOUNTDEPOSIT.ID = @DEPOSITID

            return @ISOPEN
        end