UFN_JOURNALENTRYELEMENTS

CREATE function [dbo].[UFN_JOURNALENTRYELEMENTS](@JOURNALENTRYID uniqueidentifier, @RETURNALLELEMENTS bit=0)
    returns  table 
  return
    select GLACCOUNTSTRUCTUREID as GLACCOUNTSTRUCTUREID, JOURNALENTRYELEMENT as DATAELEMENTID, ACCOUNTSEQUENCE as SEQUENCE
  from
      ( select JE.ID,
          JE.DATAELEMENT1ID, JE.DATAELEMENT2ID, JE.DATAELEMENT3ID, JE.DATAELEMENT4ID, JE.DATAELEMENT5ID
          ,JE.DATAELEMENT6ID, JE.DATAELEMENT7ID, JE.DATAELEMENT8ID, JE.DATAELEMENT9ID, JE.DATAELEMENT10ID
          ,JE.DATAELEMENT11ID, JE.DATAELEMENT12ID, JE.DATAELEMENT13ID, JE.DATAELEMENT14ID, JE.DATAELEMENT15ID
          ,JE.DATAELEMENT16ID, JE.DATAELEMENT17ID, JE.DATAELEMENT18ID, JE.DATAELEMENT19ID, JE.DATAELEMENT20ID
          ,JE.DATAELEMENT21ID, JE.DATAELEMENT22ID, JE.DATAELEMENT23ID, JE.DATAELEMENT24ID, JE.DATAELEMENT25ID
          ,JE.DATAELEMENT26ID, JE.DATAELEMENT27ID, JE.DATAELEMENT28ID, JE.DATAELEMENT29ID, JE.DATAELEMENT30ID    
        from dbo.JOURNALENTRY as JE       
        where ID = @journalentryid
       ) P_JE
  unpivot
      ( JOURNALENTRYELEMENT FOR JOURNALENTRYCOLUMN IN
          (
          DATAELEMENT1ID, DATAELEMENT2ID, DATAELEMENT3ID, DATAELEMENT4ID, DATAELEMENT5ID
          ,DATAELEMENT6ID, DATAELEMENT7ID, DATAELEMENT8ID, DATAELEMENT9ID, DATAELEMENT10ID
          ,DATAELEMENT11ID, DATAELEMENT12ID, DATAELEMENT13ID, DATAELEMENT14ID, DATAELEMENT15ID
          ,DATAELEMENT16ID, DATAELEMENT17ID, DATAELEMENT18ID, DATAELEMENT19ID, DATAELEMENT20ID
          ,DATAELEMENT21ID, DATAELEMENT22ID, DATAELEMENT23ID, DATAELEMENT24ID, DATAELEMENT25ID
          ,DATAELEMENT26ID, DATAELEMENT27ID, DATAELEMENT28ID, DATAELEMENT29ID, DATAELEMENT30ID    
          )
      ) as UP_JE
  join 
      dbo.DATAELEMENT as DE
          on DE.ID = JOURNALENTRYELEMENT    
  where JOURNALENTRYELEMENT is not NULL or @RETURNALLELEMENTS=1