Třídová akce

Kód:

4

Tělo:

SELECT
  document_id
from
  sys$posdocumentsforexport pde
where
  Shop_ID =:Shop_ID and
  document_id like :SiteMask and
  docdate$date =
  (SELECT first 1
     Min(docdate$date)
   from
     sys$posdocumentsforexport pde
   where
     Shop_ID =:Shop_ID and
     document_id like :SiteMask and
     docdate$date >=:DocDate and
     period_id=
     (SELECT first 1
        pe.id
      from
        sys$posdocumentsforexport pde
        left join periods pe on pe.id=pde.period_id
      where
        pde.Shop_ID =:Shop_ID and
        pde.document_id like :SiteMask and
        pde.docdate$date >=:DocDate
      order by
        pe.datefrom$date, pde.docdate$date)
      group by
        docdate$date) and
  period_id=
   (SELECT first 1
      pe.id
    from
      sys$posdocumentsforexport pde
      left join periods pe on pe.id=pde.period_id
    where
      pde.Shop_ID =:Shop_ID and
      pde.document_id like :SiteMask and
      pde.docdate$date >=:DocDate
    order by
      pe.datefrom$date, pde.docdate$date)
order by 
  OrdNumber, document_id

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