UFN_RE7INTEGRATION_GETPHONES_FROMXML_ATTRIBUTES

            CREATE function dbo.UFN_RE7INTEGRATION_GETPHONES_FROMXML_ATTRIBUTES(
                @PHONES xml
            ) returns table
            as
            return
            (
                select
                    T.c.value('(@RE7PHONEID)[1]','int') as RE7PHONEID,
                    T.c.value('(@PHONETYPE)[1]','nvarchar(100)') as PHONETYPE,
                    T.c.value('(@NUMBER)[1]','nvarchar(100)') as NUMBER,
                    T.c.value('(@DONOTCALL)[1]','bit') as DONOTCALL,
                    T.c.value('(@ISPRIMARY)[1]','bit') as ISPRIMARY
                from 
                    @PHONES.nodes('/PHONES/ITEM') T(c)
            );