Objektová akce

Kód:

3

Tělo:

select DISTINCT
  'PH', POSShift_ID
FROM
  POSReceipts PH
WHERE
 PH.POSShift_ID is NOT NULL AND
 PH.ID = :OBJID

union
SELECT DISTINCT
  'PD', PD.id
FROM
  posdocuments PD
WHERE
  Pd.posreceipt_id = :OBJID

union
select distinct
  'CP', pp.id
from
  poscashpaid pp
where
  pp.posreceipt_id = :OBJID
  
union
select distinct
  'CN', pp.id
from
  poscashnotaccountedpaid pp
where
  pp.posreceipt_id = :OBJID
  
union
select distinct
  'CR', PR.id
from
  poscashreceived PR
where
  PR.posreceipt_id = :OBJID
  
union
select distinct
  'CT', CT.id
from
  POSCashNotAccountedReceived CT
where
  CT.posreceipt_id = :OBJID 

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