UFN_FINANCIALTRANSACTION_LINEITEM_GL_FROMITEMLISTXML

CREATE function [dbo].[UFN_FINANCIALTRANSACTION_LINEITEM_GL_FROMITEMLISTXML](@ITEMLISTXML xml, @MULTICURRENCY tinyint) returns table as 
    return (
        select
            T.c.value('(AMOUNT)[1]','money') as 'AMOUNT'
      ,case @MULTICURRENCY when 1 then T.c.value('(BASEAMOUNT)[1]','money') else T.c.value('(AMOUNT)[1]','money') end AS 'BASEAMOUNT' 
      ,case @MULTICURRENCY when 1 then T.c.value('(ORGAMOUNT)[1]','money') else T.c.value('(AMOUNT)[1]','money') end AS 'ORGAMOUNT' 
            ,T.c.value('(CLASSCODE)[1]','tinyint') as 'CLASSCODE'
            ,T.c.value('(COMMENT)[1]','nvarchar(60)') as 'COMMENT'
            ,case when T.c.exist('./ANNOTATIONS/ITEM') = 1 then T.c.query('(ANNOTATIONS)[1]') else null end as 'ANNOTATIONS'
            ,T.c.value('(JOURNALCODEID)[1]','uniqueidentifier') as 'JOURNALCODEID'
            ,T.c.value('(JOURNALENTRYID)[1]','uniqueidentifier') as 'JOURNALENTRYID'
            ,T.c.value('(PERCENTAGE)[1]','numeric(20, 4)') as 'PERCENTAGE'
            ,T.c.value('(SEQUENCE)[1]','int') as 'SEQUENCE'
            ,T.c.value('(POSTDATE)[1]','date') as 'POSTDATE'
            ,T.c.value('(TRANSACTIONTYPECODE)[1]','tinyint') as 'TRANSACTIONTYPECODE'
            ,T.c.value('(DATAELEMENT1ID)[1]','uniqueidentifier') as 'DATAELEMENT1ID'
            ,T.c.value('(DATAELEMENT2ID)[1]','uniqueidentifier') as 'DATAELEMENT2ID'
            ,T.c.value('(DATAELEMENT3ID)[1]','uniqueidentifier') as 'DATAELEMENT3ID'
            ,T.c.value('(DATAELEMENT4ID)[1]','uniqueidentifier') as 'DATAELEMENT4ID'
            ,T.c.value('(DATAELEMENT5ID)[1]','uniqueidentifier') as 'DATAELEMENT5ID'
            ,T.c.value('(DATAELEMENT6ID)[1]','uniqueidentifier') as 'DATAELEMENT6ID'
            ,T.c.value('(DATAELEMENT7ID)[1]','uniqueidentifier') as 'DATAELEMENT7ID'
            ,T.c.value('(DATAELEMENT8ID)[1]','uniqueidentifier') as 'DATAELEMENT8ID'
            ,T.c.value('(DATAELEMENT9ID)[1]','uniqueidentifier') as 'DATAELEMENT9ID'
            ,T.c.value('(DATAELEMENT10ID)[1]','uniqueidentifier') as 'DATAELEMENT10ID'
            ,T.c.value('(DATAELEMENT11ID)[1]','uniqueidentifier') as 'DATAELEMENT11ID'
            ,T.c.value('(DATAELEMENT12ID)[1]','uniqueidentifier') as 'DATAELEMENT12ID'
            ,T.c.value('(DATAELEMENT13ID)[1]','uniqueidentifier') as 'DATAELEMENT13ID'
            ,T.c.value('(DATAELEMENT14ID)[1]','uniqueidentifier') as 'DATAELEMENT14ID'
            ,T.c.value('(DATAELEMENT15ID)[1]','uniqueidentifier') as 'DATAELEMENT15ID'
            ,T.c.value('(DATAELEMENT16ID)[1]','uniqueidentifier') as 'DATAELEMENT16ID'
            ,T.c.value('(DATAELEMENT17ID)[1]','uniqueidentifier') as 'DATAELEMENT17ID'
            ,T.c.value('(DATAELEMENT18ID)[1]','uniqueidentifier') as 'DATAELEMENT18ID'
            ,T.c.value('(DATAELEMENT19ID)[1]','uniqueidentifier') as 'DATAELEMENT19ID'
            ,T.c.value('(DATAELEMENT20ID)[1]','uniqueidentifier') as 'DATAELEMENT20ID'
            ,T.c.value('(DATAELEMENT21ID)[1]','uniqueidentifier') as 'DATAELEMENT21ID'
            ,T.c.value('(DATAELEMENT22ID)[1]','uniqueidentifier') as 'DATAELEMENT22ID'
            ,T.c.value('(DATAELEMENT23ID)[1]','uniqueidentifier') as 'DATAELEMENT23ID'
            ,T.c.value('(DATAELEMENT24ID)[1]','uniqueidentifier') as 'DATAELEMENT24ID'
            ,T.c.value('(DATAELEMENT25ID)[1]','uniqueidentifier') as 'DATAELEMENT25ID'
            ,T.c.value('(DATAELEMENT26ID)[1]','uniqueidentifier') as 'DATAELEMENT26ID'
            ,T.c.value('(DATAELEMENT27ID)[1]','uniqueidentifier') as 'DATAELEMENT27ID'
            ,T.c.value('(DATAELEMENT28ID)[1]','uniqueidentifier') as 'DATAELEMENT28ID'
            ,T.c.value('(DATAELEMENT29ID)[1]','uniqueidentifier') as 'DATAELEMENT29ID'
            ,T.c.value('(DATAELEMENT30ID)[1]','uniqueidentifier') as 'DATAELEMENT30ID'
        from
            @ITEMLISTXML.nodes('/GLENTRIES/ITEM') T(c)
    )