REVENUEGLDISTRIBUTION

  CREATE view dbo.REVENUEGLDISTRIBUTION with schemabinding as
    select 
    JOURNALENTRY_EXT.GLTRANSACTIONID as ID,
    case when FINANCIALTRANSACTION.DELETEDON is null then FINANCIALTRANSACTION.ID else null end as REVENUEID,
    isnull(JOURNALENTRY_EXT.GLPAYMENTMETHODREVENUETYPEMAPPINGID,'00000000-0000-0000-0000-000000000000') as GLPAYMENTMETHODREVENUETYPEMAPPINGID,
    JOURNALENTRY_EXT.PROJECT,
    JOURNALENTRY.COMMENT as REFERENCE,
    JOURNALENTRY.BASEAMOUNT as AMOUNT,
    JOURNALENTRY_EXT.ADDEDBYID,
    JOURNALENTRY_EXT.CHANGEDBYID,
    JOURNALENTRY_EXT.DATEADDED,
    JOURNALENTRY_EXT.DATECHANGED,
    JOURNALENTRY_EXT.TS,
    JOURNALENTRY_EXT.TSLONG,
    isnull(coalesce(GLACCOUNT.ACCOUNTNUMBER,JOURNALENTRY_EXT.ACCOUNT,''),'') as ACCOUNT,
    JOURNALENTRY.TRANSACTIONTYPECODE,
    JOURNALENTRY.ID as GLTRANSACTIONID,
    JOURNALENTRY_EXT.OUTDATED,
    case JOURNALENTRY.TRANSACTIONTYPECODE
      when 0 then N'Debit' 
      when 1 then N'Credit' 
    end as TRANSACTIONTYPE,
    case V.BASECURRENCYID 
      when '00000000-0000-0000-0000-000000000000' then null
      else V.BASECURRENCYID end as BASECURRENCYID,

    JOURNALENTRY.ORGAMOUNT as ORGANIZATIONAMOUNT,
    JOURNALENTRY_EXT.PRECALCORGANIZATIONEXCHANGERATEID as ORGANIZATIONEXCHANGERATEID,        
    JOURNALENTRY.TRANSACTIONAMOUNT as TRANSACTIONAMOUNT, 
        case JOURNALENTRY.TRANSACTIONCURRENCYID 
          when '00000000-0000-0000-0000-000000000000' then null
          else JOURNALENTRY.TRANSACTIONCURRENCYID end 
    as TRANSACTIONCURRENCYID,
    JOURNALENTRY_EXT.PRECALCBASEEXCHANGERATEID as BASEEXCHANGERATEID
    from dbo.JOURNALENTRY 
    inner join dbo.FINANCIALTRANSACTIONLINEITEM on JOURNALENTRY.FINANCIALTRANSACTIONLINEITEMID = FINANCIALTRANSACTIONLINEITEM.ID 
    inner join dbo.V_BASECURRENCYFORFINANCIALTRANSACTION_I V with (noexpand) on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = V.FINANCIALTRANSACTIONID
    inner join dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID 
    inner join dbo.JOURNALENTRY_EXT on JOURNALENTRY.ID = JOURNALENTRY_EXT.ID and JOURNALENTRY_EXT.TABLENAMECODE = 1
    left outer join dbo.GLACCOUNT on JOURNALENTRY.GLACCOUNTID = GLACCOUNT.ID
    --inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
    --inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID