UFN_DISBURSEMENTPROCESS_SIGNATURES_TOITEMLISTXML

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

Return Type
xml
Parameters

Parameter	Parameter Type	Mode	Description
@DISBURSEMENTPROCESSID	uniqueidentifier	IN
@TYPECODE	tinyint	IN
Definition

Copy


            CREATE function dbo.UFN_DISBURSEMENTPROCESS_SIGNATURES_TOITEMLISTXML
            (
                @DISBURSEMENTPROCESSID 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.DISBURSEMENTPROCESSSIGNATURE TS
                            left outer join dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B on B.ID = TS.BANKACCOUNTAUTHORIZEDSIGNATUREID
                            left outer join dbo.SIGNATURE S on S.ID = B.SIGNATUREID
                            where DISBURSEMENTPROCESSID = @DISBURSEMENTPROCESSID 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.DISBURSEMENTPROCESSSIGNATURE TS
                        left outer join dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B on B.ID = TS.BANKACCOUNTAUTHORIZEDSIGNATUREID
                        left outer join dbo.SIGNATURE S on S.ID = B.SIGNATUREID
                        where DISBURSEMENTPROCESSID = @DISBURSEMENTPROCESSID and TYPECODE = @TYPECODE
                        order by FROMAMOUNT
                    for xml raw('ITEM'), type, elements, root('SIGNATURES2XML'), BINARY BASE64)
                return @XML
            end