UFN_DISBURSEMENTPROCESSTEMPLATE_SIGNATURES_TOITEMLISTXML

Get an xml list of the signatures for a given disbursement process template

Return

Return Type
xml

Parameters

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

Definition

Copy



CREATE function dbo.UFN_DISBURSEMENTPROCESSTEMPLATE_SIGNATURES_TOITEMLISTXML
(
  @DISBURSEMENTPROCESSTEMPLATEID uniqueidentifier,
  @TYPECODE tinyint
)
returns xml
as begin
    declare @XML xml
    if @TYPECODE = 0
    begin
        set @XML = (
      select TS.ID, TS.FROMAMOUNT, TS.BANKACCOUNTAUTHORIZEDSIGNATUREID --, S.SIGNATURETHUMBNAIL as 'PREVIEW'

      from dbo.DISBURSEMENTPROCESSTEMPLATESIGNATURE TS
      left outer join dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B on B.ID = TS.BANKACCOUNTAUTHORIZEDSIGNATUREID
      left outer join dbo.SIGNATURE S on S.ID = B.SIGNATUREID
      where DISBURSEMENTPROCESSTEMPLATEID = @DISBURSEMENTPROCESSTEMPLATEID and TYPECODE = @TYPECODE
      order by FROMAMOUNT
      for xml raw('ITEM'), type, elements, root('SIGNATURES1XML'), BINARY BASE64)
    end
    else
        set @XML = (
      select TS.ID, TS.FROMAMOUNT, TS.BANKACCOUNTAUTHORIZEDSIGNATUREID --, S.SIGNATURETHUMBNAIL as 'PREVIEW'

      from dbo.DISBURSEMENTPROCESSTEMPLATESIGNATURE TS
      left outer join dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B on B.ID = TS.BANKACCOUNTAUTHORIZEDSIGNATUREID
      left outer join dbo.SIGNATURE S on S.ID = B.SIGNATUREID
      where DISBURSEMENTPROCESSTEMPLATEID = @DISBURSEMENTPROCESSTEMPLATEID and TYPECODE = @TYPECODE
      order by FROMAMOUNT
      for xml raw('ITEM'), type, elements, root('SIGNATURES2XML'), BINARY BASE64)

    return @XML
end