UFN_REVENUEBATCH_GETAPPLICATIONSWITHCHILDREN_FROMITEMLISTXML

            CREATE function dbo.UFN_REVENUEBATCH_GETAPPLICATIONSWITHCHILDREN_FROMITEMLISTXML(@ITEMLISTXML xml)
      returns table as
      return (
        select
        T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
        T.c.value('(AMOUNTDUE)[1]','money') AS 'AMOUNTDUE',
        T.c.value('(APPLICATIONID)[1]','uniqueidentifier') AS 'APPLICATIONID',
        T.c.value('(APPLIED)[1]','money') AS 'APPLIED',
        T.c.value('(BALANCE)[1]','money') AS 'BALANCE',
        T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') AS 'CONSTITUENTID',
        T.c.value('(CONSTITUENTNAME)[1]','nvarchar(700)') AS 'CONSTITUENTNAME',
        T.c.value('(DATEDUE)[1]','datetime') AS 'DATEDUE',
        T.c.value('(DESCRIPTION)[1]','nvarchar(300)') AS 'DESCRIPTION',
        T.c.value('(DONOTRECEIPT)[1]','bit') AS 'DONOTRECEIPT',
        T.c.value('(RECEIPTAMOUNT)[1]','money') AS 'RECEIPTAMOUNT',
        T.c.value('(TYPECODE)[1]','tinyint') AS 'TYPECODE',
        T.c.value('(WASGENERATED)[1]','bit') AS 'WASGENERATED',
        case when T.c.exist('./PLEDGES/ITEM') = 1 then T.c.query('(PLEDGES)[1]') else null end AS 'PLEDGES',
        case when T.c.exist('./MEMBERSHIPS/ITEM') = 1 then T.c.query('(MEMBERSHIPS)[1]') else null end AS 'MEMBERSHIPS',
        T.c.value('(ISCOVENANT)[1]','bit') AS 'ISCOVENANT',
        T.c.value('(OVERPAYMENTAPPLICATIONTYPECODE)[1]','tinyint') as 'OVERPAYMENTAPPLICATIONTYPECODE',
        T.c.value('(APPLICATIONCOMMITMENTID)[1]','uniqueidentifier') as 'APPLICATIONCOMMITMENTID',
        T.c.value('(SPONSORSHIPOPPORTUNITY)[1]','nvarchar(300)') AS 'SPONSORSHIPOPPORTUNITY',
        T.c.value('(REVENUESPLITID)[1]','uniqueidentifier') AS 'REVENUESPLITID',
        T.c.value('(PDACCOUNTSYSTEMID)[1]','uniqueidentifier') as 'PDACCOUNTSYSTEMID',
          T.c.value('(SPONSORSHIPRGADDITIONALGIFT)[1]','bit') AS 'SPONSORSHIPRGADDITIONALGIFT'
        from @ITEMLISTXML.nodes('/REVENUESTREAMS/ITEM') T(c)
      )