USP_DATALIST_BATCHDETAILS_JOURNALENTRY

CREATE procedure dbo.USP_DATALIST_BATCHDETAILS_JOURNALENTRY(@CONTEXTID uniqueidentifier)
as
    set nocount on;
    select 
        JE.ID
    ,FT.ID as FINANCIALTRANSACTIONID
        ,FT.TYPE as FINANCIALTRANSACTIONTYPE
        ,FT.TYPECODE as TYPECODE
        ,FT.CALCULATEDUSERDEFINEDID USERDEFINEDID
        ,FT.DESCRIPTION as FTDESCRIPTION
        ,V.NAME as VENDORNAME

        ,FTLI.SEQUENCE as LISEQUENCE
        ,FTLI.DESCRIPTION as LIDESCRIPTION    

        ,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        
        inner join dbo.FINANCIALTRANSACTIONLINEITEM as FTLI on JE.FINANCIALTRANSACTIONLINEITEMID = FTLI.ID
        inner join dbo.FINANCIALTRANSACTION as FT on FTLI.FINANCIALTRANSACTIONID = FT.ID
        inner join dbo.CONSTITUENT as V on FT.CONSTITUENTID = V.ID
    where SUMMARYID = @CONTEXTID
  ;