select uk.nazev_ukazatele,
       ur.AcctCode + '-' + ur.AcctName AS Ucet,
	   ur.AcctCode,
	   ur.AcctName,
       DATEPART(YEAR, hl.RefDate)  as Rok,
       DATEPART(MONTH, hl.RefDate) as Mesic,
       CONVERT(varchar(10),hl.RefDate,120) as Datum,
       ISNULL(pol.ProfitCode, 'Neurčeno') as Stredisko,
       ISNULL(pol.Project, 'Neurčeno') as Zakazka,
       case when sl.strana = 'MD' then pol.Debit * sl.znamenko else pol.Credit * sl.znamenko end as Castka,
       convert(varchar(20),hl.TransId) + ': ' + hl.memo  as 'Popis_dokladu',
	   convert(varchar(20),hl.TransId) + '-' + convert(varchar(10),pol.Line_ID) + '-' + uk.Kod_ukazatele  COLLATE Czech_CI_AS as klic

from [SKOLA_MIS_CZ].dbo.Ukazatele uk join [SKOLA_MIS_CZ].dbo.Slozeni_ukazatele sl on uk.kod_ukazatele = sl.kod_ukazatele join
     [dbo].[journal_lines] pol on pol.Account like sl.cislo_uctu COLLATE Czech_CI_AS join 
     [dbo].[journal_header] hl on pol.transId = HL.TransId  join
     [dbo].[accounts] ur on ur.AcctCode = pol.Account
where uk.typ = 'I' and hl.RefDate is not null
  and ((sl.strana = 'MD' and pol.Debit <> 0) or (sl.strana = 'D'and pol.Credit <> 0) )