UFN_REVENUEBATCH_SPLITSWITHCHILDREN_FROMITEMLISTXML

            CREATE function dbo.UFN_REVENUEBATCH_SPLITSWITHCHILDREN_FROMITEMLISTXML
            (
                @ITEMLISTXML xml
            ) 
            returns table as
            return
            (
            select
                T.c.value('(ID)[1]','uniqueidentifier') as 'ID',
                T.c.value('(DESIGNATIONID)[1]','uniqueidentifier') as 'DESIGNATIONID',
                T.c.value('(AMOUNT)[1]','money') as 'AMOUNT',
                T.c.value('(SEQUENCE)[1]','integer') as 'SEQUENCE',
                T.c.value('(APPLICATIONCODE)[1]','tinyint') as 'APPLICATIONCODE',
                T.c.value('(TYPECODE)[1]','tinyint') as 'TYPECODE',
                T.c.value('(CATEGORYCODEID)[1]','uniqueidentifier') as 'CATEGORYCODEID',
                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('(DECLINESGIFTAID)[1]','bit') as 'DECLINESGIFTAID',
                T.c.value('(ISGIFTAIDSPONSORSHIP)[1]','bit') as 'ISGIFTAIDSPONSORSHIP',
                T.c.value('(REVENUESPLITID)[1]','uniqueidentifier') as 'REVENUESPLITID'
            from @ITEMLISTXML.nodes('/SPLITS/ITEM') T(c)
            )