UFN_PDACCOUNTCODEMAPPING_PAYMENTMETHODS_FROMITEMLISTXML
Returns a table of payment methods from an xml variable
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
CREATE function dbo.UFN_PDACCOUNTCODEMAPPING_PAYMENTMETHODS_FROMITEMLISTXML(@ITEMLISTXML xml)
returns table
as
return(select NameID
from
dbo.PDACCOUNTCODEMAPPAYMENTMETHODTYPE inner join
(select distinct T.c.value('(PAYMENTMETHODID)[1]','uniqueidentifier') as PAYMENTMETHODID from @ITEMLISTXML.nodes('/PAYMENTMETHODS/ITEM') T(c)) V1
on dbo.PDACCOUNTCODEMAPPAYMENTMETHODTYPE.ID = V1.PAYMENTMETHODID)