UFN_REVENUEINFORMATION_TOITEMLISTXML

Used to convert the results of UFN_REVENUEINFORMATION to xml.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@INFORMATIONSOURCECODE	tinyint	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:22:56 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_REVENUEINFORMATION
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_REVENUEINFORMATION_TOITEMLISTXML](
@REVENUEID uniqueidentifier
, @INFORMATIONSOURCECODE tinyint
, @CURRENTAPPUSERID uniqueidentifier
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [AMOUNT],
  [APPEALID],
  [BASECURRENCYID],
  [BASEEXCHANGERATEID],
  [BENEFITID],
  [BENEFITSWAIVED],
  [CHANNELCODEID],
  [CONSTITUENTID],
  [CREDITTYPECODEID],
  [CUSTOMIDENTIFIER],
  [DATE],
  [DONOTACKNOWLEDGE],
  [DONOTPOST],
  [DONOTRECEIPT],
  [ELIGIBLEFORMATCHINGGIFTCLAIM],
  [FINDERNUMBER],
  [GIFTINKINDSUBTYPECODEID],
  [GIVENANONYMOUSLY],
  [ID],
  [ISREIMBURSABLE],
  [MAILINGID],
  [ORGANIZATIONAMOUNT],
  [ORGANIZATIONEXCHANGERATEID],
  [OTHERPAYMENTMETHODCODEID],
  [PAYMENTMETHODCODE],
  [PDACCOUNTSYSTEMID],
  [PLEDGESUBTYPEID],
  [POSTDATE],
  [PROPERTYSUBTYPECODEID],
  [RECEIPTAMOUNT],
  [RECEIPTTYPECODE],
  [SENDBENEFIT],
  [SOURCECODE],
  [TRANSACTIONAMOUNT],
  [TRANSACTIONCURRENCYID],
  [TRANSACTIONTYPECODE]
 FROM dbo.[UFN_REVENUEINFORMATION](@REVENUEID, @INFORMATIONSOURCECODE, @CURRENTAPPUSERID)
 for xml path('ITEM'),type,elements,root('REVENUEINFORMATION'),BINARY BASE64

)

END