UFN_REVENUEINFORMATION_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:22:56 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_REVENUEINFORMATION
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_REVENUEINFORMATION_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
T.c.value('(APPEALID)[1]','uniqueidentifier') AS 'APPEALID',
T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') AS 'BASEEXCHANGERATEID',
T.c.value('(BENEFITID)[1]','uniqueidentifier') AS 'BENEFITID',
T.c.value('(BENEFITSWAIVED)[1]','bit') AS 'BENEFITSWAIVED',
T.c.value('(CHANNELCODEID)[1]','uniqueidentifier') AS 'CHANNELCODEID',
T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') AS 'CONSTITUENTID',
T.c.value('(CREDITTYPECODEID)[1]','uniqueidentifier') AS 'CREDITTYPECODEID',
T.c.value('(CUSTOMIDENTIFIER)[1]','nvarchar(100)') AS 'CUSTOMIDENTIFIER',
T.c.value('(DATE)[1]','datetime') AS 'DATE',
T.c.value('(DONOTACKNOWLEDGE)[1]','bit') AS 'DONOTACKNOWLEDGE',
T.c.value('(DONOTPOST)[1]','bit') AS 'DONOTPOST',
T.c.value('(DONOTRECEIPT)[1]','bit') AS 'DONOTRECEIPT',
T.c.value('(ELIGIBLEFORMATCHINGGIFTCLAIM)[1]','bit') AS 'ELIGIBLEFORMATCHINGGIFTCLAIM',
T.c.value('(FINDERNUMBER)[1]','bigint') AS 'FINDERNUMBER',
T.c.value('(GIFTINKINDSUBTYPECODEID)[1]','uniqueidentifier') AS 'GIFTINKINDSUBTYPECODEID',
T.c.value('(GIVENANONYMOUSLY)[1]','bit') AS 'GIVENANONYMOUSLY',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(ISREIMBURSABLE)[1]','bit') AS 'ISREIMBURSABLE',
T.c.value('(MAILINGID)[1]','uniqueidentifier') AS 'MAILINGID',
T.c.value('(ORGANIZATIONAMOUNT)[1]','money') AS 'ORGANIZATIONAMOUNT',
T.c.value('(ORGANIZATIONEXCHANGERATEID)[1]','uniqueidentifier') AS 'ORGANIZATIONEXCHANGERATEID',
T.c.value('(OTHERPAYMENTMETHODCODEID)[1]','uniqueidentifier') AS 'OTHERPAYMENTMETHODCODEID',
T.c.value('(PAYMENTMETHODCODE)[1]','tinyint') AS 'PAYMENTMETHODCODE',
T.c.value('(PDACCOUNTSYSTEMID)[1]','uniqueidentifier') AS 'PDACCOUNTSYSTEMID',
T.c.value('(PLEDGESUBTYPEID)[1]','uniqueidentifier') AS 'PLEDGESUBTYPEID',
T.c.value('(POSTDATE)[1]','datetime') AS 'POSTDATE',
T.c.value('(PROPERTYSUBTYPECODEID)[1]','uniqueidentifier') AS 'PROPERTYSUBTYPECODEID',
T.c.value('(RECEIPTAMOUNT)[1]','money') AS 'RECEIPTAMOUNT',
T.c.value('(RECEIPTTYPECODE)[1]','tinyint') AS 'RECEIPTTYPECODE',
T.c.value('(SENDBENEFIT)[1]','bit') AS 'SENDBENEFIT',
T.c.value('(SOURCECODE)[1]','nvarchar(50)') AS 'SOURCECODE',
T.c.value('(TRANSACTIONAMOUNT)[1]','money') AS 'TRANSACTIONAMOUNT',
T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
T.c.value('(TRANSACTIONTYPECODE)[1]','tinyint') AS 'TRANSACTIONTYPECODE'
FROM @ITEMLISTXML.nodes('/REVENUEINFORMATION/ITEM') T(c)
)