UFN_TRANSLATIONFUNCTION_DISBURSEMENT

Return

Return Type
nvarchar(50)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_TRANSLATIONFUNCTION_DISBURSEMENT(@ID uniqueidentifier) returns nvarchar(50
as
begin
    declare @s nvarchar(50);
    select @s = BAT.TRANSACTIONNUMBER
    from dbo.BANKACCOUNTTRANSACTION BAT 
    where BAT.ID = @ID
    return @s;
end