UFN_BANKACCOUNT_GETDEPOSITNUMBER

                create function dbo.UFN_BANKACCOUNT_GETDEPOSITNUMBER(@ID uniqueidentifier) returns int 
                as
                begin
                    declare @DEPOSITNUMBER int;
                    select @DEPOSITNUMBER = TRANSACTIONNUMBER from dbo.BANKACCOUNTTRANSACTION where ID = @ID;
                    return @DEPOSITNUMBER;
                end