UFN_TREASURYDEPOSITTEMPLATE_GETUNLINKEDPAYMENTS_TOITEMLISTXML
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESDEPOSITTEMPLATEID | uniqueidentifier | IN | |
| @POSTSTATUSCODE | tinyint | IN | |
| @TRANSACTIONDATE | date | IN | |
| @PAYMENTDATE | date | IN | |
| @TRANSACTIONCURRENCYID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_TREASURYDEPOSITTEMPLATE_GETUNLINKEDPAYMENTS_TOITEMLISTXML
(
@SALESDEPOSITTEMPLATEID uniqueidentifier
,@POSTSTATUSCODE tinyint = null -- 1 = Not posted, 2 = Posted, 3 = Do not post
,@TRANSACTIONDATE date = null
,@PAYMENTDATE date = null
,@TRANSACTIONCURRENCYID uniqueidentifier = null
)
returns xml
as
BEGIN
RETURN (
SELECT AMOUNT, ID, PAYMENTMETHOD, TRANSACTIONDATE, TRANSACTIONTYPE, TRANSACTIONCURRENCYID
FROM dbo.UFN_TREASURYDEPOSITTEMPLATE_GETUNLINKEDPAYMENTS(@SALESDEPOSITTEMPLATEID, @POSTSTATUSCODE, @TRANSACTIONDATE, @PAYMENTDATE)
where TRANSACTIONCURRENCYID = isnull(@TRANSACTIONCURRENCYID, TRANSACTIONCURRENCYID)
for xml raw('ITEM'),type,elements,root('PAYMENTS'),BINARY BASE64
)
END