UFN_DISBURSEMENTPROCESS_SIGNATURE1_FROMITEMLISTXML

Returns a table representation of the xml parameter

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@TYPECODE tinyint IN
@ITEMLISTXML xml IN

Definition

Copy


            create function dbo.UFN_DISBURSEMENTPROCESS_SIGNATURE1_FROMITEMLISTXML(@TYPECODE tinyint, @ITEMLISTXML xml) RETURNS TABLE AS
            return 
            (
                SELECT
                    T.c.value('(ID)[1]', 'uniqueidentifier') as 'ID',
                    T.c.value('(FROMAMOUNT)[1]', 'money') as 'FROMAMOUNT',
                    T.c.value('(BANKACCOUNTAUTHORIZEDSIGNATUREID)[1]', 'uniqueidentifier') as 'BANKACCOUNTAUTHORIZEDSIGNATUREID'
                FROM @ITEMLISTXML.nodes('/SIGNATURES1XML/ITEM') T(c)
            )