Třídová akce

Kód:

5

Tělo:

select
  (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code) as DisplayName,
  CAST(d.Amount AS VARCHAR(30)) || ' ' || e.Code as Description,
  d.DocDate$Date as Date$Date,
  a.ID as ID,
  d.Firm_ID as FirmID
from Compensations a,DocQueues b, Periods c, Compensations2 d, Currencies e
where a.DocQueue_ID=b.id and a.Period_ID=c.id and d.Division_ID = :ID
 and a.ID=d.Parent_ID
  and (a.DocDate$DATE >= :DateFrom) and (a.DocDate$DATE < :DateTo + 1)  
  and d.Currency_ID = e.ID

Generated by ABRA Software a.s. 27.10.2021 16:34:08