UFN_FAFEVENT_GETREVENUEOPTION_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:25:46 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_FAFEVENT_GETREVENUEOPTION
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_FAFEVENT_GETREVENUEOPTION_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(ALLOWGIFTTYPEONETIMEDONATION)[1]','bit') AS 'ALLOWGIFTTYPEONETIMEDONATION',
T.c.value('(ALLOWGIFTTYPEPLEDGE)[1]','bit') AS 'ALLOWGIFTTYPEPLEDGE',
T.c.value('(ALLOWGIFTTYPERECURRING)[1]','bit') AS 'ALLOWGIFTTYPERECURRING',
T.c.value('(COPYBATCHGUID)[1]','uniqueidentifier') AS 'COPYBATCHGUID',
T.c.value('(COPYSOURCEID)[1]','uniqueidentifier') AS 'COPYSOURCEID',
T.c.value('(DONORONORBEFOREDATEGIFT)[1]','datetime') AS 'DONORONORBEFOREDATEGIFT',
T.c.value('(DONORONORBEFOREDATEPLEDGE)[1]','datetime') AS 'DONORONORBEFOREDATEPLEDGE',
T.c.value('(ID)[1]','varchar(36)') AS 'ID',
T.c.value('(ISALLOWCOMPANYDONATIONS)[1]','bit') AS 'ISALLOWCOMPANYDONATIONS',
T.c.value('(ISALLOWDONATIONSFROMORGS)[1]','bit') AS 'ISALLOWDONATIONSFROMORGS',
T.c.value('(ISALLOWDONORTOSELECTSTARTDATEGIFT)[1]','tinyint') AS 'ISALLOWDONORTOSELECTSTARTDATEGIFT',
T.c.value('(ISALLOWDONORTOSELECTSTARTDATEPLEDGE)[1]','tinyint') AS 'ISALLOWDONORTOSELECTSTARTDATEPLEDGE',
T.c.value('(ISALLOWEVENTDONATIONS)[1]','bit') AS 'ISALLOWEVENTDONATIONS',
T.c.value('(ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR)[1]','bit') AS 'ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR',
T.c.value('(ISALLOWTEAMDONATIONS)[1]','bit') AS 'ISALLOWTEAMDONATIONS',
T.c.value('(ISENABLEDONATIONS)[1]','bit') AS 'ISENABLEDONATIONS',
T.c.value('(ISENABLEPLEDGES)[1]','bit') AS 'ISENABLEPLEDGES',
T.c.value('(ISENABLERECURRINGGIFTS)[1]','bit') AS 'ISENABLERECURRINGGIFTS',
T.c.value('(ISFREQUENCYAVAILONLINEANNUALLYGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINEANNUALLYGIFT',
T.c.value('(ISFREQUENCYAVAILONLINEANNUALLYPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINEANNUALLYPLEDGE',
T.c.value('(ISFREQUENCYAVAILONLINEBIMONTHLYGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINEBIMONTHLYGIFT',
T.c.value('(ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE',
T.c.value('(ISFREQUENCYAVAILONLINEBIWEEKLYGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINEBIWEEKLYGIFT',
T.c.value('(ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE',
T.c.value('(ISFREQUENCYAVAILONLINEMONTHLYGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINEMONTHLYGIFT',
T.c.value('(ISFREQUENCYAVAILONLINEMONTHLYPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINEMONTHLYPLEDGE',
T.c.value('(ISFREQUENCYAVAILONLINEQUARTERLYGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINEQUARTERLYGIFT',
T.c.value('(ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE',
T.c.value('(ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT',
T.c.value('(ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE',
T.c.value('(ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT',
T.c.value('(ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE',
T.c.value('(ISFREQUENCYAVAILONLINESINGLEGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINESINGLEGIFT',
T.c.value('(ISFREQUENCYAVAILONLINESINGLEPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINESINGLEPLEDGE',
T.c.value('(ISFREQUENCYAVAILONLINEWEEKLYGIFT)[1]','bit') AS 'ISFREQUENCYAVAILONLINEWEEKLYGIFT',
T.c.value('(ISFREQUENCYAVAILONLINEWEEKLYPLEDGE)[1]','bit') AS 'ISFREQUENCYAVAILONLINEWEEKLYPLEDGE',
T.c.value('(ISPENDINGMATCHINGGIFTS)[1]','bit') AS 'ISPENDINGMATCHINGGIFTS',
T.c.value('(ISREGISTRATIONREVENUE)[1]','bit') AS 'ISREGISTRATIONREVENUE',
T.c.value('(ISSPONSORSHIPREVENUE)[1]','bit') AS 'ISSPONSORSHIPREVENUE',
T.c.value('(ISSTARTDATESAMEASDAYTOSUBMITGIFT)[1]','bit') AS 'ISSTARTDATESAMEASDAYTOSUBMITGIFT',
T.c.value('(ISSTARTDATESAMEASDAYTOSUBMITPLEDGE)[1]','bit') AS 'ISSTARTDATESAMEASDAYTOSUBMITPLEDGE',
T.c.value('(ISUNPAIDPLEDGES)[1]','bit') AS 'ISUNPAIDPLEDGES',
T.c.value('(ISUNPAIDRECURRINGGIFTS)[1]','bit') AS 'ISUNPAIDRECURRINGGIFTS',
T.c.value('(ISUNPAIDSPONSORSHIPREVENUE)[1]','bit') AS 'ISUNPAIDSPONSORSHIPREVENUE',
T.c.value('(MAXIMUMTRANSACTIONAMOUNT)[1]','money') AS 'MAXIMUMTRANSACTIONAMOUNT',
T.c.value('(MINIMUMDONATIONAMOUNT)[1]','money') AS 'MINIMUMDONATIONAMOUNT',
T.c.value('(STARTDATEONORBEFOREGIFT)[1]','datetime') AS 'STARTDATEONORBEFOREGIFT',
T.c.value('(STARTDATEONORBEFOREPLEDGE)[1]','datetime') AS 'STARTDATEONORBEFOREPLEDGE',
T.c.value('(UNCONFIRMEDPARTICIPANTGIFTENTRY)[1]','bit') AS 'UNCONFIRMEDPARTICIPANTGIFTENTRY'
FROM @ITEMLISTXML.nodes('/REVENUEOPTION/ITEM') T(c)
)