UFN_BATCHREVENUEADDITIONALAPPLICATIONBUSINESSUNIT_GETBUSINESSUNITS_FROMITEMLISTXML

Used to convert an xml string to a table based on UFN_BATCHREVENUEADDITIONALAPPLICATIONBUSINESSUNIT_GETBUSINESSUNITS.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@ITEMLISTXML xml IN

Definition

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

T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
T.c.value('(BUSINESSUNITCODEID)[1]','uniqueidentifier') AS 'BUSINESSUNITCODEID',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(REVENUESPLITBUSINESSUNITID)[1]','uniqueidentifier') AS 'REVENUESPLITBUSINESSUNITID'
FROM @ITEMLISTXML.nodes('/BUSINESSUNITS/ITEM') T(c)
)