Třídová akce

Kód:

13

Tělo:

SELECT DISTINCT
  (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code) as DisplayName,
  a.DocDate$Date as Date$Date,
  a.ID as ID,
  '0000000000' as FirmID
from WageListPartial a, DocQueues b, Periods c, WorkingRelations d
where a.DocQueue_ID=b.id and a.Period_ID=c.id and
a.WorkingRelation_ID=d.ID and d.Division_ID=:ID
and (a.DocDate$DATE >= :DateFrom) and (a.DocDate$DATE < :DateTo + 1)

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