UFN_REVENUE_GETAPPLICATIONS_FROMXML

CREATE function dbo.UFN_REVENUE_GETAPPLICATIONS_FROMXML(@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
  SELECT
    T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
    T.c.value('(APPLICATIONID)[1]','uniqueidentifier') AS 'APPLICATIONID',
    T.c.value('(APPLIED)[1]','money') AS 'APPLIED',
    T.c.value('(APPLICATIONCODE)[1]','tinyint') AS 'APPLICATIONCODE',
    c.query('./GIFTFIELDS') as 'GIFTFIELDS',
    c.query('./OTHERFIELDS') as 'OTHERFIELDS',
    T.c.query('./MEMBERSHIPFIELDS') as 'MEMBERSHIPS',
    T.c.value('(DECLINESGIFTAID)[1]','bit') AS 'DECLINESGIFTAID',
    T.c.value('(ISGIFTAIDSPONSORSHIP)[1]','bit') AS 'ISSPONSORSHIP',
    T.c.value('(OVERPAYMENTAPPLICATIONTYPECODE)[1]','tinyint') as 'OVERPAYMENTAPPLICATIONTYPECODE',
    T.c.value('(UPDATERECOGNITIONOPTION)[1]','tinyint') as 'UPDATERECOGNITIONOPTION',
    T.c.value('(APPLIEDBASEAMOUNT)[1]','money') AS 'APPLIEDBASEAMOUNT',
    T.c.value('(APPLIEDORGANIZATIONAMOUNT)[1]','money') AS 'APPLIEDORGANIZATIONAMOUNT',
    T.c.value('(UPDATESOLICITORSOPTION)[1]','tinyint') as 'UPDATESOLICITORSOPTION',
    T.c.query('./APPLICATIONSPLITS') as 'APPLICATIONSPLITS',
    T.c.value('(CATEGORYCODEID)[1]','uniqueidentifier') as 'CATEGORYCODEID'
  FROM @ITEMLISTXML.nodes('/REVENUESTREAMS/ITEM') T(c)
)