Třídová akce

Kód:

4

Tělo:

SELECT 
  SUM(A.Reserved - A.Supplied)
FROM 
  Reservations A
WHERE 
  (A.Store_ID = :Store_ID) 
  AND (A.Storecard_ID = :StoreCard_ID)
  AND (A.OrderDate$DATE <= :Order_Date) 
  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