Třídová akce

Kód:

11

Tělo:

SELECT
  A.ID,
  A.Reserved,
  A.Supplied
FROM 
  Reservations A 
WHERE 
  (A.Store_ID = :Store_ID) 
  AND (A.Storecard_ID = :StoreCard_ID) 
  AND (A.Priority > :Priority) 
  AND (A.Reserved > A.Supplied) 
  AND (((A.DateTo$DATE = 0) AND (A.DateFrom$DATE <= :Doc_Date)) 
    OR ((A.DateTo$DATE >= :Doc_Date2) AND (A.DateFrom$Date <= :Doc_Date)))
  AND (A.Revided_ID IS NULL)

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