UFN_REVENUEBATCH_GETAPPLICATIONSWITHCHILDREN_TOITEMLISTXML

            CREATE function [dbo].[UFN_REVENUEBATCH_GETAPPLICATIONSWITHCHILDREN_TOITEMLISTXML]
            (
                @BATCHREVENUEID uniqueidentifier
            )
            returns xml
            as
            begin
                return
                (
                    select ID, APPLICATIONID, CONSTITUENTID, CONSTITUENTNAME, APPLIED, BALANCE, AMOUNTDUE, DATEDUE, TYPECODE, RECEIPTAMOUNT, DONOTRECEIPT, [DESCRIPTION], WASGENERATED, PLEDGES, MEMBERSHIPS, BATCHREVENUEREGISTRANTID, OVERPAYMENTAPPLICATIONTYPECODE, DESIGNATIONLIST, SPONSORSHIPOPPORTUNITY, REVENUESPLITID, APPLICATIONCURRENCYID, PDACCOUNTSYSTEMID, SPONSORSHIPRGADDITIONALGIFT
          from dbo.UFN_REVENUEBATCH_GETAPPLICATIONSWITHCHILDREN(@BATCHREVENUEID)
                    for xml raw('ITEM'), type, elements, root('REVENUESTREAMS'), binary base64
                )
            end