UFN_REVENUE_GETAPPLICATIONS_2_TOITEMLISTXML

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONID	uniqueidentifier	IN
@USEDESIGNATIONUSERID	bit	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_2
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_REVENUE_GETAPPLICATIONS_2_TOITEMLISTXML](
@TRANSACTIONID uniqueidentifier
, @USEDESIGNATIONUSERID bit
    )
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_2](@TRANSACTIONID, @USEDESIGNATIONUSERID)
 for xml path('ITEM'),type,elements,root('REVENUESTREAMS'),BINARY BASE64

)

END