Třídová akce

Kód:

5

Tělo:

select DISTINCT
  (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 StoreDocuments2 SD2 on SD2.Parent_ID = SD.ID
  join DocQueues DQ on DQ.ID = SD.DocQueue_ID
  join Periods P on P.ID=SD.Period_ID
where 
  (SD.DocDate$DATE >= :DateFrom) and (SD.DocDate$DATE < :DateTo + 1)
  and DQ.DocumentType='21'
  and SD2.BusTransaction_ID=:ID

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