BEGIN
/* VATDocReportCSY */
FOR
SELECT
sectionid sectionid,
documenttype documenttype,
document_id document_id,
CAST(MAX(simplifiedvatdocument) AS CHAR(1)) simplifiedvatdocument,
CAST(MAX(firm_id) AS CHAR(10)) firm_id,
CAST(MAX(vatidentnumber) AS VARCHAR(20)) vatidentnumber,
MAX(vatdate$date) vatdate$date,
CAST(MAX(documentnumber) AS VARCHAR(30)) documentnumber,
CAST(MAX(sortdocnumber) AS VARCHAR(28)) sortdocnumber,
CAST(MAX(externalnumber) AS VARCHAR(30)) externalnumber,
CAST(MAX(varsymbol) AS VARCHAR(30)) varsymbol,
CAST(MAX(vatindex_id) AS CHAR(10)) vatindex_id,
vatrate_id vatrate_id,
MAX(vatrate) vatrate,
SUM(baseamount) baseamount,
SUM(vatamount) vatamount,
drcarticle_id drcarticle_id,
CAST(MAX(definitionrow_id) AS CHAR(10)) definitionrow_id,
CAST(MAX(baselinenumber) AS VARCHAR(10)) baselinenumber,
CAST(MAX(taxlinenumber) AS VARCHAR(10)) taxlinenumber,
vatreportmode vatreportmode,
CAST(MAX(sourcedoc_id) AS CHAR(10)) sourcedoc_id,
CAST(MAX(sourcedoctype) AS CHAR(2)) sourcedoctype,
CAST(MAX(sourcedocnumber) AS VARCHAR(30)) sourcedocnumber,
CAST(MAX(possumdoc_id) AS CHAR(10)) possumdoc_id,
MAX(svatadmitdate$date) svatadmitdate$date,
MAX(sdocumenttradetype) sdocumenttradetype
FROM
VATDocReportCSY1(:avatcountry_id, :avatdefinitionid, :avatdatefrom, :avatdateto,
:afirmselid, :adivisionsselid, :abusordersselid, :abustransactionsselid, :abusprojectsselid,
:adivisionswithchilds, :abusorderswithchilds, :abustransactionswithchilds, :abusprojectswithchilds)
GROUP BY
sectionid, documenttype, document_id, vatrate_id, drcarticle_id, vatreportmode
ORDER BY
sectionid, documenttype, document_id, vatrate_id, drcarticle_id, vatreportmode
INTO
:sectionid,
:documenttype,
:document_id,
:simplifiedvatdocument,
:firm_id,
:vatidentnumber,
:vatdate$date,
:documentnumber,
:sortdocnumber,
:externalnumber,
:varsymbol,
:vatindex_id,
:vatrate_id,
:vatrate,
:baseamount,
:vatamount,
:drcarticle_id,
:definitionrow_id,
:baselinenumber,
:taxlinenumber,
:vatreportmode,
:sourcedoc_id,
:sourcedoctype,
:sourcedocnumber,
:possumdoc_id,
:svatadmitdate$date,
:sdocumenttradetype
DO
BEGIN
SUSPEND;
END
END