UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONS_FROMITEMLISTXML

            CREATE function dbo.UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONS_FROMITEMLISTXML
            (
                @ITEMLISTXML xml
            )
            returns table 
            as
            return
            (
                select
                    T.c.value('(APPLIED)[1]','money') AS 'APPLIED',
                    case when T.c.exist('./CAMPAIGNS/ITEM') = 1 then T.c.query('(CAMPAIGNS)[1]') else null end as 'CAMPAIGNS',
                    T.c.value('(DECLINESGIFTAID)[1]','bit') AS 'DECLINESGIFTAID',
                    T.c.value('(DESIGNATIONID)[1]','uniqueidentifier') AS 'DESIGNATIONID',
                    T.c.value('(CATEGORYCODEID)[1]','uniqueidentifier') AS 'CATEGORYCODEID',
                    T.c.value('(DIDCAMPAIGNSDEFAULT)[1]','bit') AS 'DIDCAMPAIGNSDEFAULT',
                    T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                    T.c.value('(ISGIFTAIDSPONSORSHIP)[1]','bit') AS 'ISGIFTAIDSPONSORSHIP',
                    T.c.value('(OPPORTUNITYID)[1]','uniqueidentifier') AS 'OPPORTUNITYID',
                    T.c.value('(OTHERTYPECODEID)[1]','uniqueidentifier') AS 'OTHERTYPECODEID',
                    T.c.value('(SPONSORSHIPID)[1]','uniqueidentifier') AS 'SPONSORSHIPID',
                    T.c.value('(TYPECODE)[1]','tinyint') AS 'TYPECODE',
          T.c.value('(REVENUESPLITID)[1]','uniqueidentifier') AS 'REVENUESPLITID'
                from @ITEMLISTXML.nodes('/ADDITIONALAPPLICATIONSSTREAM/ITEM') T(c)
            );