UFN_REVENUEUPDATEBATCH_GETSOLICITORSFOREDIT_FROMITEMLISTXML

CREATE function dbo.UFN_REVENUEUPDATEBATCH_GETSOLICITORSFOREDIT_FROMITEMLISTXML(@ITEMLISTXML xml) returns TABLE as
return(    
        SELECT
            T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
            T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') AS 'CONSTITUENTID',
            T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
            T.c.value('(SEQUENCE)[1]','integer') AS 'SEQUENCE',
            T.c.value('(REVENUESOLICITORID)[1]','uniqueidentifier') AS 'REVENUESOLICITORID',
            T.c.value('(APPLICATIONCODE)[1]','tinyint') AS 'APPLICATIONCODE',
            T.c.value('(DESIGNATIONID)[1]','uniqueidentifier') AS 'DESIGNATIONID',
            T.c.value('(APPLICATIONID)[1]','uniqueidentifier') AS 'APPLICATIONID',
            T.c.value('(DECLINESGIFTAID)[1]','bit') AS 'DECLINESGIFTAID',
         T.c.value('(SPONSORSHIPID)[1]','uniqueidentifier') AS 'SPONSORSHIPID'
            FROM @ITEMLISTXML.nodes('/SOLICITORS/ITEM') T(c)
    )