UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK_TOITEMLISTXML

Return

Return Type
xml

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:28:21 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK_TOITEMLISTXML](
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [BALANCE],
  [DATE],
  [ID],
  [REVENUEID],
  [STATUSCODE],
  [TRANSACTIONAMOUNT],
  [WRITEOFFAMOUNT]
 FROM dbo.[UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK]()
 order by DATE, ID
 for xml path('ITEM'),type,elements,root('INSTALLMENTS'),BINARY BASE64

)

END