Objektová akce

Popis:

Doklady upomínek s vazbou na odeslaný e-mail

Kód:

8

Tělo:

select
  (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code) as DisplayName
from 
  PaymentReminders a
  join DocQueues b on b.id = a.DocQueue_ID
  join Periods c on c.ID = a.period_id
where 
  a.EmailSent_ID = :OBJID
  

Generated by ABRA Software a.s. 27.10.2021 16:35:16