UFN_CLOSINGREQUIREMENTDETAILS_TOITEMLISTXML
Converts closing requirements table into an xml
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CLOSINGREQUIREMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CLOSINGREQUIREMENTDETAILS_TOITEMLISTXML(
@CLOSINGREQUIREMENTID uniqueidentifier
)
returns xml
as
BEGIN
RETURN (
SELECT [ACCOUNTREQUIREMENTSCODE], [ACCOUNTSTRUCTUREID], [CLOSINGREQUIREMENTID],[ELEMENTTYPECODE], [ID], [PRESERVEDETAILSDURINGCLOSING], [REQUIRETOBALANCE], [SEGMENTNAME]
FROM dbo.[UFN_CLOSINGREQUIREMENTDETAIL](@CLOSINGREQUIREMENTID)
order by SEGMENTNAME
for xml raw('ITEM'),type,elements,root('CLOSINGREQUIREMENTDETAIL'),BINARY BASE64
)
END