UFN_REVENUEUPDATEBATCH_GETAPPLICATIONSTREAM_TOITEMLISTXML

Used to convert the results of UFN_REVENUEUPDATEBATCH_GETAPPLICATIONSTREAM to xml.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  9/30/2015 1:00:17 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_REVENUEUPDATEBATCH_GETAPPLICATIONSTREAM
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_REVENUEUPDATEBATCH_GETAPPLICATIONSTREAM_TOITEMLISTXML](
@REVENUEID uniqueidentifier
, @CONSTITUENTID uniqueidentifier
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [AMOUNTDUE],
  [APPLICATIONCURRENCYID],
  [APPLICATIONID],
  [APPLIED],
  [BALANCE],
  [CONSTITUENTID],
  [CONSTITUENTNAME],
  [DATEDUE],
  [DESCRIPTION],
  [DESIGNATIONLIST],
  [ID],
  [MEMBERSHIPS],
  [PDACCOUNTSYSTEMID],
  [RECEIPTAMOUNT],
  [REVENUESPLITID],
  [SPONSORSHIPOPPORTUNITY],
  [SPONSORSHIPRGADDITIONALGIFT],
  [TRANSACTIONCURRENCYID],
  [TYPECODE]
 FROM dbo.[UFN_REVENUEUPDATEBATCH_GETAPPLICATIONSTREAM](@REVENUEID, @CONSTITUENTID)
 for xml path('ITEM'),type,elements,root('REVENUESTREAMS'),BINARY BASE64

)

END