UFN_REVENUE_GETAPPLICATIONS_TOITEMLISTXML

Used to convert the results of UFN_REVENUE_GETAPPLICATIONS to xml.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONID	uniqueidentifier	IN

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  7/12/2019 5:26:22 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2103.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_REVENUE_GETAPPLICATIONS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_REVENUE_GETAPPLICATIONS_TOITEMLISTXML](
@TRANSACTIONID uniqueidentifier
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [AMOUNTDUE],
  [APPLICATIONCODE],
  [APPLICATIONCURRENCYID],
  [APPLICATIONID],
  [APPLICATIONTRANSACTIONTYPECODE],
  [APPLIED],
  [BALANCE],
  [CATEGORYCODEID],
  [DATEDUE],
  [DECLINESGIFTAID],
  [DESCRIPTION],
  [EXCHANGERATE],
  [GIFTAIDCOMMITTED],
  [GIFTFIELDS],
  [ID],
  [ISGIFTAIDSPONSORSHIP],
  [MEMBERSHIPFIELDS],
  [OTHERFIELDS],
  [RECURRINGGIFTFIELDS],
  [TRANSACTIONCURRENCYID],
  [TYPECODE]
 FROM dbo.[UFN_REVENUE_GETAPPLICATIONS](@TRANSACTIONID)
 for xml path('ITEM'),type,elements,root('REVENUESTREAMS'),BINARY BASE64

)

END