UFN_CHARGELINEITEMRESPONSIBILITY_FROMITEMLISTXML

Returns a table representation of charge responsibility items from the XML passed to it.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITEMLISTXML	xml	IN

Definition

Copy



        create function dbo.UFN_CHARGELINEITEMRESPONSIBILITY_FROMITEMLISTXML
            (
                @ITEMLISTXML xml
            )
            RETURNS TABLE AS
                RETURN (
                    SELECT
                    T.c.value('(ID)[1]','uniqueidentifier') AS 'ID'
                    ,T.c.value('(FINANCIALTRANSACTIONLINEITEMID)[1]','uniqueidentifier') AS 'FINANCIALTRANSACTIONLINEITEMID'
                    ,T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') AS 'CONSTITUENTID'
                    ,T.c.value('(PERCENTAGE)[1]','decimal') AS 'PERCENTAGE'
                    FROM @ITEMLISTXML.nodes('/CHARGELINEITEMRESPONSIBILITY/ITEM') T(c)
                    )