UFN_COMMUNICATION_GETLETTERS_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:42:42 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_COMMUNICATION_GETLETTERS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_COMMUNICATION_GETLETTERS_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(CHANNELCODE)[1]','tinyint') AS 'CHANNELCODE',
T.c.value('(CHANNELPREFERENCECODE)[1]','tinyint') AS 'CHANNELPREFERENCECODE',
T.c.value('(COMMUNICATIONTYPESXML)[1]','nvarchar(max)') AS 'COMMUNICATIONTYPESXML',
T.c.value('(EMAILCONTENTHTML)[1]','nvarchar(max)') AS 'EMAILCONTENTHTML',
T.c.value('(EMAILEXPORTDEFINITIONID)[1]','uniqueidentifier') AS 'EMAILEXPORTDEFINITIONID',
T.c.value('(EMAILFROMADDRESS)[1]','nvarchar(100)') AS 'EMAILFROMADDRESS',
T.c.value('(EMAILFROMDISPLAYNAME)[1]','nvarchar(255)') AS 'EMAILFROMDISPLAYNAME',
T.c.value('(EMAILPACKAGEID)[1]','uniqueidentifier') AS 'EMAILPACKAGEID',
T.c.value('(EMAILREPLYTOADDRESS)[1]','nvarchar(100)') AS 'EMAILREPLYTOADDRESS',
T.c.value('(EMAILSEGMENTID)[1]','uniqueidentifier') AS 'EMAILSEGMENTID',
T.c.value('(EMAILSUBJECT)[1]','nvarchar(255)') AS 'EMAILSUBJECT',
T.c.value('(EXCLUDEBASEDONRECENTCOMMUNICATION)[1]','bit') AS 'EXCLUDEBASEDONRECENTCOMMUNICATION',
T.c.value('(EXCLUDEBASEDONRECENTGIVING)[1]','bit') AS 'EXCLUDEBASEDONRECENTGIVING',
T.c.value('(EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR)[1]','bit') AS 'EXCLUDEBASEDONTOTALCOMMUNICATIONSINPASTYEAR',
T.c.value('(EXCLUDEBASEDONTOTALGIVINGINPASTYEAR)[1]','bit') AS 'EXCLUDEBASEDONTOTALGIVINGINPASTYEAR',
T.c.value('(EXCLUDEDSELECTIONSXML)[1]','nvarchar(max)') AS 'EXCLUDEDSELECTIONSXML',
T.c.value('(EXCLUDEDSOLICITCODESXML)[1]','nvarchar(max)') AS 'EXCLUDEDSOLICITCODESXML',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(INCLUDEINACTIVE)[1]','bit') AS 'INCLUDEINACTIVE',
T.c.value('(MAILCONTENTHTML)[1]','nvarchar(max)') AS 'MAILCONTENTHTML',
T.c.value('(MAILEXPORTDEFINITIONID)[1]','uniqueidentifier') AS 'MAILEXPORTDEFINITIONID',
T.c.value('(MAILPACKAGEID)[1]','uniqueidentifier') AS 'MAILPACKAGEID',
T.c.value('(MAILSEGMENTID)[1]','uniqueidentifier') AS 'MAILSEGMENTID',
T.c.value('(MARGINBOTTOM)[1]','decimal(20, 4)') AS 'MARGINBOTTOM',
T.c.value('(MARGINLEFT)[1]','decimal(20, 4)') AS 'MARGINLEFT',
T.c.value('(MARGINRIGHT)[1]','decimal(20, 4)') AS 'MARGINRIGHT',
T.c.value('(MARGINTOP)[1]','decimal(20, 4)') AS 'MARGINTOP',
T.c.value('(MKTASKLADDERID)[1]','uniqueidentifier') AS 'MKTASKLADDERID',
T.c.value('(NAME)[1]','nvarchar(100)') AS 'NAME',
T.c.value('(NUMRECENTCOMMUNICATIONPERIODS)[1]','int') AS 'NUMRECENTCOMMUNICATIONPERIODS',
T.c.value('(NUMRECENTGIVINGPERIODS)[1]','int') AS 'NUMRECENTGIVINGPERIODS',
T.c.value('(NUMTOTALCOMMUNICATIONSINPASTYEAR)[1]','int') AS 'NUMTOTALCOMMUNICATIONSINPASTYEAR',
T.c.value('(OUTPUTTYPECODE)[1]','tinyint') AS 'OUTPUTTYPECODE',
T.c.value('(PAPERSIZECODE)[1]','tinyint') AS 'PAPERSIZECODE',
T.c.value('(RECENTCOMMUNICATIONPERIODTYPECODE)[1]','tinyint') AS 'RECENTCOMMUNICATIONPERIODTYPECODE',
T.c.value('(RECENTGIVINGPERIODTYPECODE)[1]','tinyint') AS 'RECENTGIVINGPERIODTYPECODE',
T.c.value('(RUNNOW)[1]','bit') AS 'RUNNOW',
T.c.value('(RUNSCHEDULED)[1]','bit') AS 'RUNSCHEDULED',
T.c.value('(SELECTIONSXML)[1]','nvarchar(max)') AS 'SELECTIONSXML',
T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
T.c.value('(TOTALREVENUEAMOUNTINPASTYEAR)[1]','money') AS 'TOTALREVENUEAMOUNTINPASTYEAR'
FROM @ITEMLISTXML.nodes('/LETTERS/ITEM') T(c)
)