UFN_GLACCOUNTMAPPINGERROR_MAPPEDVALUES_FROMITEMLISTXML

create function dbo.UFN_GLACCOUNTMAPPINGERROR_MAPPEDVALUES_FROMITEMLISTXML(@ITEMXML xml)
returns table
as 
return(
    select T.c.value('(ERRORCODE)[1]', 'Integer') as ERRORCODE
        ,T.c.value('(ERRORMESSAGE)[1]', 'nvarchar(max)') as ERRORMESSAGE
        ,T.c.value('(PDACCOUNTCODEMAPOFFICEID)[1]', 'uniqueidentifier') as PDACCOUNTCODEMAPOFFICEID
        ,T.c.value('(REVENUETYPEID)[1]', 'uniqueidentifier') as REVENUETYPEID
        ,T.c.value('(APPLICATIONTYPEID)[1]', 'uniqueidentifier') as APPLICATIONTYPEID
        ,T.c.value('(PAYMENTMETHODID)[1]', 'uniqueidentifier') as PAYMENTMETHODID
        ,T.c.value('(SUBTYPEID)[1]', 'uniqueidentifier') as SUBTYPEID
        ,T.c.value('(PDACCOUNTSYSTEMID)[1]', 'uniqueidentifier') as PDACCOUNTSYSTEMID
        ,T.c.value('(SEGMENT02TABLEID)[1]', 'uniqueidentifier') as SEGMENT02TABLEID
        ,T.c.value('(SEGMENT02ID)[1]', 'uniqueidentifier') as SEGMENT02ID
        ,T.c.value('(SEGMENT03TABLEID)[1]', 'uniqueidentifier') as SEGMENT03TABLEID
        ,T.c.value('(SEGMENT03ID)[1]', 'uniqueidentifier') as SEGMENT03ID
        ,T.c.value('(SEGMENT04TABLEID)[1]', 'uniqueidentifier') as SEGMENT04TABLEID
        ,T.c.value('(SEGMENT04ID)[1]', 'uniqueidentifier') as SEGMENT04ID
        ,T.c.value('(SEGMENT05TABLEID)[1]', 'uniqueidentifier') as SEGMENT05TABLEID
        ,T.c.value('(SEGMENT05ID)[1]', 'uniqueidentifier') as SEGMENT05ID
        ,T.c.value('(SEGMENT06TABLEID)[1]', 'uniqueidentifier') as SEGMENT06TABLEID
        ,T.c.value('(SEGMENT06ID)[1]', 'uniqueidentifier') as SEGMENT06ID
        ,T.c.value('(SEGMENT07TABLEID)[1]', 'uniqueidentifier') as SEGMENT07TABLEID
        ,T.c.value('(SEGMENT07ID)[1]', 'uniqueidentifier') as SEGMENT07ID
        ,T.c.value('(SEGMENT08TABLEID)[1]', 'uniqueidentifier') as SEGMENT08TABLEID
        ,T.c.value('(SEGMENT08ID)[1]', 'uniqueidentifier') as SEGMENT08ID
        ,T.c.value('(SEGMENT09TABLEID)[1]', 'uniqueidentifier') as SEGMENT09TABLEID
        ,T.c.value('(SEGMENT09ID)[1]', 'uniqueidentifier') as SEGMENT09ID
        ,T.c.value('(SEGMENT10TABLEID)[1]', 'uniqueidentifier') as SEGMENT10TABLEID
        ,T.c.value('(SEGMENT10ID)[1]', 'uniqueidentifier') as SEGMENT10ID
        ,T.c.value('(SEGMENT11TABLEID)[1]', 'uniqueidentifier') as SEGMENT11TABLEID
        ,T.c.value('(SEGMENT11ID)[1]', 'uniqueidentifier') as SEGMENT11ID
        ,T.c.value('(SEGMENT12TABLEID)[1]', 'uniqueidentifier') as SEGMENT12TABLEID
        ,T.c.value('(SEGMENT12ID)[1]', 'uniqueidentifier') as SEGMENT12ID
        ,T.c.value('(SEGMENT13TABLEID)[1]', 'uniqueidentifier') as SEGMENT13TABLEID
        ,T.c.value('(SEGMENT13ID)[1]', 'uniqueidentifier') as SEGMENT13ID
        ,T.c.value('(SEGMENT14TABLEID)[1]', 'uniqueidentifier') as SEGMENT14TABLEID
        ,T.c.value('(SEGMENT14ID)[1]', 'uniqueidentifier') as SEGMENT14ID
        ,T.c.value('(SEGMENT15TABLEID)[1]', 'uniqueidentifier') as SEGMENT15TABLEID
        ,T.c.value('(SEGMENT15ID)[1]', 'uniqueidentifier') as SEGMENT15ID
        ,T.c.value('(SEGMENT16TABLEID)[1]', 'uniqueidentifier') as SEGMENT16TABLEID
        ,T.c.value('(SEGMENT16ID)[1]', 'uniqueidentifier') as SEGMENT16ID
        ,T.c.value('(SEGMENT17TABLEID)[1]', 'uniqueidentifier') as SEGMENT17TABLEID
        ,T.c.value('(SEGMENT17ID)[1]', 'uniqueidentifier') as SEGMENT17ID
        ,T.c.value('(SEGMENT18TABLEID)[1]', 'uniqueidentifier') as SEGMENT18TABLEID
        ,T.c.value('(SEGMENT18ID)[1]', 'uniqueidentifier') as SEGMENT18ID
        ,T.c.value('(SEGMENT19TABLEID)[1]', 'uniqueidentifier') as SEGMENT19TABLEID
        ,T.c.value('(SEGMENT19ID)[1]', 'uniqueidentifier') as SEGMENT19ID
        ,T.c.value('(SEGMENT20TABLEID)[1]', 'uniqueidentifier') as SEGMENT20TABLEID
        ,T.c.value('(SEGMENT20ID)[1]', 'uniqueidentifier') as SEGMENT20ID
        ,T.c.value('(SEGMENT21TABLEID)[1]', 'uniqueidentifier') as SEGMENT21TABLEID
        ,T.c.value('(SEGMENT21ID)[1]', 'uniqueidentifier') as SEGMENT21ID
        ,T.c.value('(SEGMENT22TABLEID)[1]', 'uniqueidentifier') as SEGMENT22TABLEID
        ,T.c.value('(SEGMENT22ID)[1]', 'uniqueidentifier') as SEGMENT22ID
        ,T.c.value('(SEGMENT23TABLEID)[1]', 'uniqueidentifier') as SEGMENT23TABLEID
        ,T.c.value('(SEGMENT23ID)[1]', 'uniqueidentifier') as SEGMENT23ID
        ,T.c.value('(SEGMENT24TABLEID)[1]', 'uniqueidentifier') as SEGMENT24TABLEID
        ,T.c.value('(SEGMENT24ID)[1]', 'uniqueidentifier') as SEGMENT24ID
        ,T.c.value('(SEGMENT25TABLEID)[1]', 'uniqueidentifier') as SEGMENT25TABLEID
        ,T.c.value('(SEGMENT25ID)[1]', 'uniqueidentifier') as SEGMENT25ID
        ,T.c.value('(SEGMENT26TABLEID)[1]', 'uniqueidentifier') as SEGMENT26TABLEID
        ,T.c.value('(SEGMENT26ID)[1]', 'uniqueidentifier') as SEGMENT26ID
        ,T.c.value('(SEGMENT27TABLEID)[1]', 'uniqueidentifier') as SEGMENT27TABLEID
        ,T.c.value('(SEGMENT27ID)[1]', 'uniqueidentifier') as SEGMENT27ID
        ,T.c.value('(SEGMENT28TABLEID)[1]', 'uniqueidentifier') as SEGMENT28TABLEID
        ,T.c.value('(SEGMENT28ID)[1]', 'uniqueidentifier') as SEGMENT28ID
        ,T.c.value('(SEGMENT29TABLEID)[1]', 'uniqueidentifier') as SEGMENT29TABLEID
        ,T.c.value('(SEGMENT29ID)[1]', 'uniqueidentifier') as SEGMENT29ID
        ,T.c.value('(SEGMENT30TABLEID)[1]', 'uniqueidentifier') as SEGMENT30TABLEID
        ,T.c.value('(SEGMENT30ID)[1]', 'uniqueidentifier') as SEGMENT30ID
    from @ITEMXML.nodes('/MAPPEDVALUES/ROW') T(c)
)