Třídová akce

Kód:

54

Tělo:

select CU.Code as Currency, PT.name as PaymentType, sum(pd3.payment-pd3.refund) as Payment
from
  posdocuments PD
  join posdocuments3 pd3 on pd.id=pd3.parent_id
  join paymenttypes PT on PT.id=pd3.paymenttype_id
  join currencies CU on CU.id=pd3.currency_id
where
  PD.posshift_id=:POSShift_ID and
  PD.opened='N'
group by
  CU.Code, PT.name
order by
  CU.Code

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