Třídová akce

Kód:

5

Tělo:

SELECT DISTINCT ID
FROM
  POSDocuments
WHERE
  POSStation_ID = :POSStation_ID and
  Period_ID = :Period_ID and
  Shop_ID = :Shop_ID and
  DocDate$Date=:DocDate$Date and
  ID like :SiteMask and
  OrdNumber IN
    (SELECT MAX(OrdNumber)
    from
      POSDocuments
    where
      POSStation_ID = :POSStation_ID and
      Period_ID = :Period_ID and
      Shop_ID = :Shop_ID and
      DocDate$Date=:DocDate$Date and
      Opened = 'N' and
      ID like :SiteMask)

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