UFN_MEMBERSHIPDUESBATCH_GETSOLICITCODES_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  7/27/2018 10:10:34 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.182.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_MEMBERSHIPDUESBATCH_GETSOLICITCODES
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_MEMBERSHIPDUESBATCH_GETSOLICITCODES_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(COMMENTS)[1]','nvarchar(100)') AS 'COMMENTS',
T.c.value('(CONSENTPREFERENCECODE)[1]','tinyint') AS 'CONSENTPREFERENCECODE',
T.c.value('(CONSENTSTATEMENT)[1]','nvarchar(max)') AS 'CONSENTSTATEMENT',
T.c.value('(CONSTITUENTSOLICITCODEID)[1]','uniqueidentifier') AS 'CONSTITUENTSOLICITCODEID',
T.c.value('(ENDDATE)[1]','datetime') AS 'ENDDATE',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(PRIVACYPOLICYFILEPATH)[1]','nvarchar(260)') AS 'PRIVACYPOLICYFILEPATH',
T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
T.c.value('(SOLICITCODEID)[1]','uniqueidentifier') AS 'SOLICITCODEID',
T.c.value('(SOURCECODEID)[1]','uniqueidentifier') AS 'SOURCECODEID',
T.c.value('(SOURCEFILEPATH)[1]','nvarchar(260)') AS 'SOURCEFILEPATH',
T.c.value('(STARTDATE)[1]','datetime') AS 'STARTDATE',
T.c.value('(SUPPORTINGINFORMATION)[1]','nvarchar(max)') AS 'SUPPORTINGINFORMATION'
FROM @ITEMLISTXML.nodes('/SOLICITCODES/ITEM') T(c)
)