Třídová akce

Popis:

Výběr servisních listů k hromadné fakturaci za firmu a časové období

Kód:

7

Tělo:

SELECT A.ID 
FROM ServiceDocuments A
LEFT JOIN ServiceDocStates SDS ON A.ServiceDocState_ID = SDS.ID
WHERE
  (A.DocDate$DATE <= :DATETO) and
  (A.Currency_ID = :Currency_ID) and
  (((A.PayerFirm_ID is null) and (A.Firm_ID = :FIRM_ID)) or (A.PayerFirm_ID = :FIRM_ID)) and
  (A.PaymentType = 1) and
  (((A.InvoicedAmount < A.TotalAmount) and (SDS.IsInvoiced = 'A')) or (SDS.IsClosed = 'A'))
ORDER BY 
  A.DocDate$DATE, A.ServicedObjectIDCode  
  

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