Třídová akce

Kód:

6

Tělo:

select DISTINCT
  (DQ.Code || '-' || CAST(II.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,  
  II.Description as Description,
  II.DocDate$Date as Date$Date,
  II.ID as ID,
  II.Firm_ID as FirmID
from
  IssuedInvoices II
  join IssuedInvoices2 II2 on II2.Parent_ID = II.ID
  join DocQueues DQ on DQ.ID = II.DocQueue_ID
  join Periods P on P.ID=II.Period_ID
where 
  (II.DocDate$DATE >= :DateFrom) and (II.DocDate$DATE < :DateTo + 1)
  and II2.Division_ID=:ID
  

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