select 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 where PD.posshift_id=:POSShift_ID and PD.opened='N'
Generated by ABRA Software a.s. 27.10.2021 16:34:30