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