Třídová akce

Kód:

3

Tělo:

SELECT A.ID, A.DocumentType, DQ.Code, P.Code, A.OrdNumber, A.DocumentStatus
FROM VATClosings3 A
JOIN DocQueues DQ ON DQ.ID=A.DocQueue_ID
JOIN Periods P ON P.ID=A.Period_ID
WHERE 
 A.Parent_ID =:VATClosing_ID
 AND
 ((:DocumentStatus = -1) OR (A.DocumentStatus = :DocumentStatus))   
ORDER BY
A.DocumentType, DQ.Code, P.Code, A.OrdNumber

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