UFN_WRITEOFF_GETINSTALLMENTSFOREDIT_TOITEMLISTXML
Returns a xml of pledge installment information for a given write-off.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @WRITEOFFID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_WRITEOFF_GETINSTALLMENTSFOREDIT_TOITEMLISTXML
(
@WRITEOFFID uniqueidentifier
)
returns xml
as
begin
return
(
select
[AMOUNT],
[BALANCE],
[DATE],
[ID],
[SEQUENCE],
[WRITEOFFAMOUNT],
[BASECURRENCYID],
[ORGANIZATIONAMOUNT],
[ORGANIZATIONEXCHANGERATEID],
[TRANSACTIONAMOUNT],
[TRANSACTIONCURRENCYID],
[BASEEXCHANGERATEID]
from
dbo.[UFN_WRITEOFF_GETINSTALLMENTSFOREDIT](@WRITEOFFID)
order by
SEQUENCE,
ID
for xml raw('ITEM'),type,elements,root('INSTALLMENTS'),BINARY BASE64
)
end