Objektová akce

Kód:

9

Tělo:

select '05' as DocumentType, ID
   from CashReceived
   where CashDesk_ID = :OBJID and Period_ID = :Period_ID
union ALL
select '06' as DocumentType, ID
   from CashPaid
   where CashDesk_ID = :OBJID and Period_ID = :Period_ID
union ALL
select '07' as DocumentType, ID
   from RefundedCashReceived
   where CashDesk_ID = :OBJID and Period_ID = :Period_ID
union ALL
select '08' as DocumentType, ID
   from RefundedCashPaid
   where CashDesk_ID = :OBJID and Period_ID = :Period_ID

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