Třídová akce

Popis:

S ohledem na zemi DPH přiznání

Kód:

5

Tělo:

SELECT A.ID
FROM VATClosings A
JOIN VATSummaryDefinitions VS ON VS.ID=A.VATDefinition_ID
WHERE
((:WithCountry = 'N') OR (VS.Country_ID = :Country_ID))
AND
((:VATDate BETWEEN A.DateFrom$DATE AND A.DateTo$DATE) OR (:VATDeductionDate BETWEEN A.DateFrom$DATE AND A.DateTo$DATE))
AND
(
(:ClosingKind = -1) /* vsechny */ 
OR
((:ClosingKind = -2) AND (VS.ClosingKind IN (0,3))) /* tuzemsko a VIES */
OR
((:ClosingKind = -3) AND (VS.ClosingKind IN (0,2,3,4))) /* tuzemsko, MOSS, VIES a IOSS */
OR 
(VS.ClosingKind = :ClosingKind)
)

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