Třídová akce

Popis:

Výkon OK

Kód:

66

Tělo:

select
  pd.ID, dq.code,  pd.OrdNumber,  pe.code, ss.code, pd.chair
from
  sys$posdocumentsopened sys
  join posdocuments pd on pd.id=sys.id
  left join periods pe on pe.id=pd.period_id
  left join docqueues dq on dq.id=pd.docqueue_id
  left join posshops sh on sh.id=pd.shop_id
  left join virtualposs vp on vp.id=pd.virtualpos_id
  left join posshops6 ss on ss.id=pd.sellingstand_id
where
  ((sys.Opened = 'A') or
   (sys.IsPayChange = 'A')) and
  (pd.sellingstand_id is not null) and
  sys.ID like :SiteMask
order by
  sh.code, vp.name, ss.code, pd.chair

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