select a from rtneo$Accrual a where a.contragent.id = '2c06fd8e-483a-654b-1178-e0f7c081f051' and a.createdBy = 'a.kotvinskiy@groupstp.ru' and a.createTs between '2020-07-15' and '2020-07-30'
2.4? 495.44? 594.53
update rtneo$Accrual a set a.amount = a.calculationAmount*2.5, a.amountBase = a.calculationAmount*2.5 where a.contractPosition.contract.id = '9286033b-88b8-81d8-a1cf-361fbc5b7219'
update rtneo$Accrual a set a.sum = a.amount*a.price, a.totalSum = a.amount*a.price, a.totalSumBase = a.amount*a.price where a.contractPosition.contract.id = '9286033b-88b8-81d8-a1cf-361fbc5b7219'
update rtneo$Accrual a set a.ndsSum = a.sum-(a.amount*495.44), a.ndsSumBase = a.sum-(a.amount*495.44) where a.contractPosition.contract.id = '9286033b-88b8-81d8-a1cf-361fbc5b7219'
update rtneo$Accrual a set a.ndsSum = a.sum*20/120, a.ndsSumBase = a.sum*20/120 where a.contractPosition.contract.id = '974e7e1c-9d6c-4776-76b5-01a8fd366e52'