UFN_DISBURSEMENTPROCESSTEMPLATESIGNATURE_GETDESCRIPTION

Get a description of the signatures assigned to a disbursement process template

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@DISBURSEMENTPROCESSTEMPLATEID	uniqueidentifier	IN
@TYPECODE	tinyint	IN

Definition

Copy



CREATE function dbo.UFN_DISBURSEMENTPROCESSTEMPLATESIGNATURE_GETDESCRIPTION
(
  @DISBURSEMENTPROCESSTEMPLATEID uniqueidentifier,
  @TYPECODE tinyint
)
returns nvarchar(max)
with execute as caller
as begin
  declare @DESC nvarchar(max);
  select @DESC = substring((
    select char(10) + 
    case when LEN(dbo.UFN_DISBURSEMENTPROCESSTEMPLATESIGNATURE_GETRANGE(@DISBURSEMENTPROCESSTEMPLATEID, @TYPECODE, FROMAMOUNT)) > 0 
      then 'From $' + cast(ts.FROMAMOUNT as nvarchar) + ' to $' + dbo.UFN_DISBURSEMENTPROCESSTEMPLATESIGNATURE_GETRANGE(@DISBURSEMENTPROCESSTEMPLATEID, @TYPECODE, FROMAMOUNT)
      else 'Over $' + cast(ts.FROMAMOUNT as nvarchar)
    end + ' - ' + isnull(dbo.UFN_SIGNATURE_USERNAME(S.SIGNERCODE, S.NAME, S.APPUSERID), 'Do not print signature')
      from dbo.DISBURSEMENTPROCESSTEMPLATESIGNATURE TS
      left outer join dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B on TS.BANKACCOUNTAUTHORIZEDSIGNATUREID = B.ID
      left outer join dbo.SIGNATURE S on B.SIGNATUREID = S.ID
      where TS.DISBURSEMENTPROCESSTEMPLATEID = @DISBURSEMENTPROCESSTEMPLATEID and TS.TYPECODE = @TYPECODE
      order by TS.FROMAMOUNT
      for XML PATH( '' )), 2, 8000)
  return @DESC
end