MyTetra Share
Делитесь знаниями!
2
Время создания: 11.08.2020 15:51
Раздел: INFO - JOB - rtneo - Работа над задачами - Исправление начислений
Запись: wwwlir/Tetra/master/base/1597132319jxd693hz1b/text.html на raw.githubusercontent.com

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'

 
MyTetra Share v.0.55
Яндекс индекс цитирования