BEGIN
-- *****************************************************************************
-- VATDocReport export KV DPH na Slovensku
-- *****************************************************************************
FOR
SELECT
a.sectionid, a.documenttype, a.doc_id, a.firm_id, a.vatidentnumber, a.vatdate$date,
a.docnumber, a.source_id, a.sourcedoctype, a.sourcedocnumber,
a.vatrate, a.baseamount, a.vatamount, a.allowanceamount, a.drc_id, a.drccode, a.drcquantity, a.drcqunit,
a.definitionrow_id, a.taxlinenumber, a.vatreportmode, a.SortDocNumber, a.correctioncode,
a.varsymbol
FROM
VATDocReport_GRP(:afirmselid, :adivisionsselid, :abusordersselid,
:abustransactionsselid, :abusprojectsselid, :avatdatefrom, :avatdateto, :adivisionswithchilds,
:abusorderswithchilds, :abustransactionswithchilds, :abusprojectswithchilds, :avatcountry_id,
:avatdefinitionid) a
WHERE
((a.baseamount <> 0) OR (a.vatamount <> 0) OR (a.allowanceamount <> 0))
ORDER BY
a.sectionid, a.documenttype, a.vatdate$date, a.docnumber, a.doc_id
INTO
:sectionid, :documenttype, :doc_id, :firm_id, :vatidentnumber, :vatdate$date,
:docnumber, :source_id, :sourcedoctype, :sourcedocnumber, :vatrate, :baseamount, :vatamount, :allowanceamount,
:drc_id, :drccode, :drcquantity, :drcqunit, :definitionrow_id, :taxlinenumber, :vatreportmode, :SortDocNumber, :correctioncode,
:varsymbol
DO BEGIN
SUSPEND;
END
END