Třídová akce

Kód:

3

Tělo:

SELECT 
  Row_ID, 
  SUM(Amount), 
  SUM(LocalAmount), 
  SUM(TAmountWithoutVAT), 
  SUM(LocalTAmountWithoutVAT), 
  SUM(TAmount), 
  SUM(LocalTAmount),
  SUM(LocalAmountWithoutVATEET),
  SUM(LocalAmountEET)
FROM
  Payments 
WHERE 
  (PDocument_ID = :PDocument_ID AND PDocumentType = :PDocumentType)
  AND NOT (Document_ID = :Document_ID AND DocumentType = :DocumentType)
GROUP BY 
  Row_ID

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