UFN_ACCOUNTSTRUCTURE_GETMETADATA_FROMITEMLISTXML
Used to convert an xml string to a table based on UFN_ACCOUNTSTRUCTURE_GETMETADATA.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
CREATE function [dbo].[UFN_ACCOUNTSTRUCTURE_GETMETADATA_FROMITEMLISTXML]
(
@ITEMLISTXML xml
)
returns table as
return (
select
T.c.value('(CLOSINGELEMENT)[1]','bit') AS 'CLOSINGELEMENT',
T.c.value('(ELEMENTTYPECODE)[1]','tinyint') AS 'ELEMENTTYPECODE',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(LENGTH)[1]','int') AS 'LENGTH',
T.c.value('(DESCRIPTION)[1]','nvarchar(100)') AS 'DESCRIPTION',
T.c.value('(SEGMENTCOLUMN)[1]','tinyint') AS 'SEGMENTCOLUMN',
T.c.value('(SEGMENTSEQUENCE)[1]','tinyint') AS 'SEGMENTSEQUENCE',
T.c.value('(ELEMENTDEFINITIONCODE)[1]','tinyint') AS 'ELEMENTDEFINITIONCODE',
T.c.value('(SEQUENCE)[1]','tinyint') AS 'SEQUENCE',
T.c.value('(SEPARATORCODE)[1]','tinyint') AS 'SEPARATORCODE',
T.c.value('(SEPARATOR)[1]','nvarchar(1)') AS 'SEPARATOR'
from @ITEMLISTXML.nodes('/ACCOUNTSTRUCTURE/ITEM') T(c)
)