UFN_INVOICE_SCHEDULES_TOITEMLISTXML
Returns the child collection in an xml format.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FINANCIALTRANSACTIONID | uniqueidentifier | IN |
Definition
Copy
CREATE function [dbo].[UFN_INVOICE_SCHEDULES_TOITEMLISTXML](
@FINANCIALTRANSACTIONID uniqueidentifier
)
returns xml
as
begin
return (
select AMOUNTPAID, AMOUNT, DUEDATE, ID
from dbo.UFN_INVOICE_SCHEDULES(@FINANCIALTRANSACTIONID)
order by DUEDATE
for xml raw('ITEM'),type,elements,root('INVOICESCHEDULES'),BINARY BASE64
);
end