UFN_CONSTITUENT_GETOPPORTUNITIES_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  6/23/2017 11:54:02 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.170.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_CONSTITUENT_GETOPPORTUNITIES
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_CONSTITUENT_GETOPPORTUNITIES_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(PLANID)[1]','uniqueidentifier') AS 'PLANID',
T.c.value('(PLANNAME)[1]','nvarchar(100)') AS 'PLANNAME',
T.c.value('(PLANTYPE)[1]','nvarchar(100)') AS 'PLANTYPE',
T.c.value('(PRIMARYMANAGERID)[1]','uniqueidentifier') AS 'PRIMARYMANAGERID',
T.c.value('(PRIMARYMANAGERNAME)[1]','nvarchar(154)') AS 'PRIMARYMANAGERNAME',
T.c.value('(STARTDATE)[1]','datetime') AS 'STARTDATE',
T.c.value('(STATUS)[1]','nvarchar(16)') AS 'STATUS'
FROM @ITEMLISTXML.nodes('/OPPORTUNITIES/ITEM') T(c)
)