UFN_REVENUEBATCH_ADDITIONALAPPLICATIONWITHCHILDREN_FROMITEMLISTXML

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