UFN_PDACCOUNTCODEMAPPING_PAYMENTMETHODS_TOITEMLISTXML
Returns an xml string representation of the payment methods for a PDACCOUNTCODEMAPPINGID and OFFICEID
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PDACCOUNTCODEMAPPINGID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PDACCOUNTCODEMAPPING_PAYMENTMETHODS_TOITEMLISTXML(@PDACCOUNTCODEMAPPINGID uniqueidentifier)
returns xml
as
begin
return(
select t2.ID as PAYMENTMETHODID
from dbo.PDACCOUNTCODEMAPPING t1 inner join dbo.PDACCOUNTCODEMAPPAYMENTMETHODTYPE t2 on (t1.PAYMENTMETHOD & t2.NAMEID) > 0 and t1.OFFICEID = t2.OFFICEID
where t1.ID = @PDACCOUNTCODEMAPPINGID
for xml raw('ITEM'),type,elements,root('PAYMENTMETHODS'),BINARY BASE64 )
end