Třídová akce

Kód:

2

Tělo:

select
  (DQ.Code || '-' || CAST(SD.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,
  SD.Description as Description,
  SD.DocDate$Date as Date$Date,
  SD.ID as ID,
  SD.Firm_ID as FirmID
from
  StoreDocuments SD
  join Firms F on F.ID = SD.Firm_ID and (F.ID = :ID or F.Firm_ID = :ID)
  left join DocQueues DQ on DQ.id=SD.DocQueue_ID
  left join Periods P on P.id=SD.Period_ID
where
 (SD.DocDate$DATE >= :DateFrom) and (SD.DocDate$DATE < :DateTo + 1)
 and DQ.DocumentType='29'  

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