Třídová akce

Popis:

Pro načtení do záložky Souvislosti

Kód:

3

Tělo:

select
  (DQ.Code || '-' || CAST(D.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,
  D.Description as Description,
  D.DocDate$Date as Date$Date,
  D.ID as ID,
  D.Firm_ID as FirmID
from 
  Documents D
  join DocQueues DQ on DQ.ID = D.DocQueue_ID
  join Periods P on P.ID = D.Period_ID
  join Firms F on F.ID = D.Firm_ID   
where 
  (F.ID = :ID or F.Firm_ID = :ID)
  and (D.DocDate$DATE >= :DateFrom) and (D.DocDate$DATE < :DateTo + 1)
  AND Revided_ID IS NULL  

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