Třídová akce

Kód:

51

Tělo:

select max(scc.code ||' '|| scc.name) as DisplayName, sum(pd2.quantity) as Quantity, sum(pd2.tamount) as Amount, sum(pd2.documentdiscount+pd2.rowdiscount+pd2.actiondiscount+pd2.dealerdiscount+pd2.financialdocumentdiscount) as Discounts
from
  posdocuments2 pd2
  join posdocuments PD on pd.id=pd2.parent_id
  join storecards SC on sc.id=pd2.storecard_id
  join storecardcategories SCC on scc.id=sc.storecardcategory_id
where 
  PD.posshift_id=:POSShift_ID and
  PD.opened='N'
group by
  sc.storecardcategory_id, scc.code, scc.name
order by scc.code ||' '|| scc.name

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