Třídová akce

Kód:

1

Tělo:

select cast(a.Amount as varchar(20)) || ' ' || b.Code as DisplayName,
  a.Description as Description,
  a.DueDate$DATE as Date$Date,
  a.ID as ID,
  a.Firm_ID as FirmID
from
  PaymentOrders2 a, Currencies b
where
  a.Currency_ID = b.ID and A.Parent_ID is Null
  and (a.Firm_ID IN (SELECT ID FROM Firms WHERE ID=:ID or Firm_ID=:ID))
  and (a.DueDate$DATE >= :DateFrom) and (a.DueDate$DATE < :DateTo + 1)

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