USP_DATALIST_FINANCIALBATCH_JOURNALENTRY

CREATE procedure dbo.USP_DATALIST_FINANCIALBATCH_JOURNALENTRY(@CONTEXTID uniqueidentifier)
as
    set nocount on;
    select 
        JE.ID
        ,JE.SEQUENCE
        ,JE.TRANSACTIONAMOUNT as AMOUNT
        ,JE.TRANSACTIONTYPE
        ,JE.POSTDATE                
        ,JE.CLASS
        ,DE1.SHORTID
        ,DE2.SHORTID
        ,DE3.SHORTID
        ,DE4.SHORTID
        ,DE5.SHORTID
        ,DE6.SHORTID
        ,DE7.SHORTID
        ,DE8.SHORTID
        ,DE9.SHORTID
        --,DE10.SHORTID

        --,DE11.SHORTID

        --,DE12.SHORTID

        --,DE13.SHORTID

        --,DE14.SHORTID

        --,DE15.SHORTID

        --,DE16.SHORTID

        --,DE17.SHORTID

        --,DE18.SHORTID

        --,DE19.SHORTID

        --,DE20.SHORTID

        --,DE21.SHORTID

        --,DE22.SHORTID

        --,DE23.SHORTID

        --,DE24.SHORTID

        --,DE25.SHORTID

        --,DE26.SHORTID

        --,DE27.SHORTID

        --,DE28.SHORTID

        --,DE29.SHORTID

        --,DE30.SHORTID

    from        
        dbo.JOURNALENTRY AS JE
        left outer join DATAELEMENT as DE1 ON JE.DATAELEMENT1ID = DE1.ID
        left outer join DATAELEMENT as DE2 ON JE.DATAELEMENT2ID = DE2.ID
        left outer join DATAELEMENT as DE3 ON JE.DATAELEMENT3ID = DE3.ID
        left outer join DATAELEMENT as DE4 ON JE.DATAELEMENT4ID = DE4.ID
        left outer join DATAELEMENT as DE5 ON JE.DATAELEMENT5ID = DE5.ID
        left outer join DATAELEMENT as DE6 ON JE.DATAELEMENT6ID = DE6.ID
        left outer join DATAELEMENT as DE7 ON JE.DATAELEMENT7ID = DE7.ID
        left outer join DATAELEMENT as DE8 ON JE.DATAELEMENT8ID = DE8.ID
        left outer join DATAELEMENT as DE9 ON JE.DATAELEMENT9ID = DE9.ID        
        left outer join DATAELEMENT as DE10 ON JE.DATAELEMENT10iD = DE10.ID
        left outer join DATAELEMENT as DE11 ON JE.DATAELEMENT11iD = DE11.ID
        left outer join DATAELEMENT as DE12 ON JE.DATAELEMENT12iD = DE12.ID
        left outer join DATAELEMENT as DE13 ON JE.DATAELEMENT13iD = DE13.ID
        left outer join DATAELEMENT as DE14 ON JE.DATAELEMENT14iD = DE14.ID
        left outer join DATAELEMENT as DE15 ON JE.DATAELEMENT15ID = DE15.ID
        left outer join DATAELEMENT as DE16 ON JE.DATAELEMENT16ID = DE16.ID
        left outer join DATAELEMENT as DE17 ON JE.DATAELEMENT17ID = DE17.ID
        left outer join DATAELEMENT as DE18 ON JE.DATAELEMENT18ID = DE18.ID
        left outer join DATAELEMENT as DE19 ON JE.DATAELEMENT19ID = DE19.ID
        left outer join DATAELEMENT as DE20 ON JE.DATAELEMENT20ID = DE20.ID
        left outer join DATAELEMENT as DE21 ON JE.DATAELEMENT21ID = DE21.ID
        left outer join DATAELEMENT as DE22 ON JE.DATAELEMENT22ID = DE22.ID
        left outer join DATAELEMENT as DE23 ON JE.DATAELEMENT23ID = DE23.ID
        left outer join DATAELEMENT as DE24 ON JE.DATAELEMENT24ID = DE24.ID
        left outer join DATAELEMENT as DE25 ON JE.DATAELEMENT25ID = DE25.ID
        left outer join DATAELEMENT as DE26 ON JE.DATAELEMENT26ID = DE26.ID
        left outer join DATAELEMENT as DE27 ON JE.DATAELEMENT27ID = DE27.ID
        left outer join DATAELEMENT as DE28 ON JE.DATAELEMENT28ID = DE28.ID
        left outer join DATAELEMENT as DE29 ON JE.DATAELEMENT29ID = DE29.ID
        left outer join DATAELEMENT as DE30 ON JE.DATAELEMENT30ID = DE30.ID        
    where FINANCIALBATCHID = @CONTEXTID
  ;