UFN_FAFEVENT_GETEVENTSPONSORSHIPOPTION_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:26:52 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_FAFEVENT_GETEVENTSPONSORSHIPOPTION
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_FAFEVENT_GETEVENTSPONSORSHIPOPTION_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(ALLOWSPONSORWAIVEBENEFITS)[1]','bit') AS 'ALLOWSPONSORWAIVEBENEFITS',
T.c.value('(COMMUNICATIONS)[1]','int') AS 'COMMUNICATIONS',
T.c.value('(COPYBATCHGUID)[1]','uniqueidentifier') AS 'COPYBATCHGUID',
T.c.value('(COPYSOURCEID)[1]','uniqueidentifier') AS 'COPYSOURCEID',
T.c.value('(DESCRIPTION)[1]','nvarchar(1000)') AS 'DESCRIPTION',
T.c.value('(DISPLAYSPOTSAVAILABLE)[1]','bit') AS 'DISPLAYSPOTSAVAILABLE',
T.c.value('(DONORRETENTION)[1]','decimal(7, 2)') AS 'DONORRETENTION',
T.c.value('(EARLYREGISTRATIONDATE)[1]','int') AS 'EARLYREGISTRATIONDATE',
T.c.value('(EARLYREGISTRATIONDISCOUNT)[1]','money') AS 'EARLYREGISTRATIONDISCOUNT',
T.c.value('(FEESAMOUNT)[1]','money') AS 'FEESAMOUNT',
T.c.value('(ID)[1]','varchar(36)') AS 'ID',
T.c.value('(ISACTIVE)[1]','bit') AS 'ISACTIVE',
T.c.value('(ISNOTAVAILABLEONLINEREG)[1]','bit') AS 'ISNOTAVAILABLEONLINEREG',
T.c.value('(ISNOTLOWERCOMMUNICATION)[1]','bit') AS 'ISNOTLOWERCOMMUNICATION',
T.c.value('(ISNOTLOWERDONORRETENTION)[1]','bit') AS 'ISNOTLOWERDONORRETENTION',
T.c.value('(ISNOTLOWERFUNDRAISINGGOAL)[1]','bit') AS 'ISNOTLOWERFUNDRAISINGGOAL',
T.c.value('(ISNOTLOWERRECRUITEMENT)[1]','bit') AS 'ISNOTLOWERRECRUITEMENT',
T.c.value('(ISNOTLOWERUNIT)[1]','bit') AS 'ISNOTLOWERUNIT',
T.c.value('(ISNOTLOWERVOLUNTEERRECRUITEMENT)[1]','bit') AS 'ISNOTLOWERVOLUNTEERRECRUITEMENT',
T.c.value('(LABELFORUNITGOAL)[1]','nvarchar(50)') AS 'LABELFORUNITGOAL',
T.c.value('(LATEFEE)[1]','money') AS 'LATEFEE',
T.c.value('(LATEFEEDATE)[1]','int') AS 'LATEFEEDATE',
T.c.value('(MINFUNDRAISINGGOAL)[1]','money') AS 'MINFUNDRAISINGGOAL',
T.c.value('(NAME)[1]','nvarchar(50)') AS 'NAME',
T.c.value('(NUMBERAVAILABLE)[1]','int') AS 'NUMBERAVAILABLE',
T.c.value('(RECRUITEMENT)[1]','int') AS 'RECRUITEMENT',
T.c.value('(SENDEVENTCONTACTALERTMAXREACHED)[1]','bit') AS 'SENDEVENTCONTACTALERTMAXREACHED',
T.c.value('(SPONSORMUSTPAYBALANCE)[1]','bit') AS 'SPONSORMUSTPAYBALANCE',
T.c.value('(SPONSORPAYSBALANCEMESSAGE)[1]','nvarchar(1000)') AS 'SPONSORPAYSBALANCEMESSAGE',
T.c.value('(TAXDEDUCTIBLEAMOUNT)[1]','money') AS 'TAXDEDUCTIBLEAMOUNT',
T.c.value('(TURNONWAITLIST)[1]','bit') AS 'TURNONWAITLIST',
T.c.value('(UNIT)[1]','int') AS 'UNIT',
T.c.value('(VOLUNTEERRECRUITEMENT)[1]','int') AS 'VOLUNTEERRECRUITEMENT',
T.c.value('(WAITLISTMESSAGE)[1]','nvarchar(1000)') AS 'WAITLISTMESSAGE'
FROM @ITEMLISTXML.nodes('/SPONSORSHIPOPTIONS/ITEM') T(c)
)