UFN_DISBURSEMENTPROCESSTEMPLATE_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_DISBURSEMENTPROCESSTEMPLATE_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)
)