Třídová akce

Kód:

9

Tělo:

select
  0 as Kind,
  FLOOR(A.docDate$DATE) as XDate,
  A.ID as id, 
  A.pamount as amount
from 
PaymentsForDocument('10', :ID, 0)
 A
union all
select
  1 as Kind,
  FLOOR(B.PaymentDate$DATE) as XDate,
  B.ID as id,
  B.Amount as amount
from IssuedDepositUsages B where B.DepositDocument_ID=:ID2
order by 2,1

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