Objektová akce

Kód:

1

Tělo:

select
  idu.ID IssuedDepositUsage_ID,
  pn.ID POSCashNotAccountedPaid_ID
from
  IssuedDepositUsages idu
  join POSDocuments3 py on py.IssuedDepositInvoice_ID = idu.DepositDocument_ID
  join POSCashNotAccountedPaid pn on pn.ID = idu.PDocument_ID
  join POSDocuments pd on py.Parent_ID = pd.ID
  join IssuedDInvoices idi on idu.DepositDocument_ID = idi.ID
where
  py.ID = :OBJID and
  pn.VirtualPOS_ID = pd.VirtualPOS_ID and
  pn.POSReceipt_ID = pd.POSReceipt_ID and
  idu.Amount = py.Payment and
  idi.Currency_ID = pn.Currency_ID

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