UFN_REVENUEBATCH_ENHANCEDMATCHINGGIFTSWITHCHILDREN_FROMITEMLISTXML

CREATE function dbo.UFN_REVENUEBATCH_ENHANCEDMATCHINGGIFTSWITHCHILDREN_FROMITEMLISTXML
(
    @ITEMLISTXML xml
)
returns table as
return (

    select 
        T.c.value('(ID)[1]','uniqueidentifier') as 'ID',
        T.c.value('(MATCHINGCONSTITUENTID)[1]','uniqueidentifier') as 'MATCHINGCONSTITUENTID',
        T.c.value('(ORGANIZATIONID)[1]','uniqueidentifier') as 'ORGANIZATIONID',
        T.c.value('(RELATIONSHIPID)[1]','uniqueidentifier') as 'RELATIONSHIPID',
        T.c.value('(MATCHINGGIFTCONDITIONID)[1]','uniqueidentifier') as 'MATCHINGGIFTCONDITIONID',
        T.c.value('(DATE)[1]','date') as 'DATE',        
        T.c.value('(AMOUNT)[1]','money') as 'AMOUNT',
        T.c.value('(COULDNOTDEFAULTMATCHINGGIFT)[1]','bit') as 'COULDNOTDEFAULTMATCHINGGIFT',
        T.c.value('(SINGLEDESIGNATIONID)[1]','uniqueidentifier') as 'SINGLEDESIGNATIONID',
        case when T.c.exist('./SPLITS/ITEM') = 1 then T.c.query('(SPLITS)[1]') else null end as 'SPLITS',
        T.c.value('(REVENUEMATCHINGGIFTID)[1]','uniqueidentifier') as 'REVENUEMATCHINGGIFTID',
        T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') as 'TRANSACTIONCURRENCYID',
        T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') as 'BASEEXCHANGERATEID',
        T.c.value('(EXCHANGERATE)[1]','decimal(20,8)') as 'EXCHANGERATE',
        T.c.value('(APPLYBYPERCENT)[1]','bit') as 'APPLYBYPERCENT',
    T.c.value('(OPPORTUNITYID)[1]','uniqueidentifier') as 'OPPORTUNITYID',
    T.c.value('(RESETSOLICITORCREDITS)[1]','bit') as 'RESETSOLICITORCREDITS'

    from @ITEMLISTXML.nodes('/MATCHINGGIFTS/ITEM') T(c)

)