begin
VATIdentNumber2 = '';
ESLIndicator2 = '0';
/* Faktury vydane */
for
select e.DocumentType, e.Eslindicator, e.Localamount, e.Amount, e.Vatidentnumber, e.Documentcount
from ESLReportByVATDate03(:AFIRMSELID, :ADIVISIONSSELID, :ABUSORDERSSELID, :ABUSTRANSACTIONSSELID, :ABUSProjectSSELID, :AVATDateFROM, :AVATDateTO,
:ADIVISIONSWITHCHILDS, :ABUSORDERSWITHCHILDS, :ABUSTRANSACTIONSWITHCHILDS, :ABUSProjectSWITHCHILDS, :AVATCOUNTRY_ID,
:ACREATEDBYSELID, :ACORRECTEDBYSELID, :ACURRENCYSELID, :ACOUNTRYSELID) e
into :DocumentType, :ESLIndicator, :LocalAmount, :Amount, :VATIdentNumber, :DocumentCount
do suspend;
/* Pokladni prijmy */
for
select e.DocumentType, e.Eslindicator, e.Localamount, e.Amount, e.Vatidentnumber, e.Documentcount
from ESLReportByVATDate05(:AFIRMSELID, :ADIVISIONSSELID, :ABUSORDERSSELID, :ABUSTRANSACTIONSSELID, :ABUSProjectSSELID, :AVATDateFROM, :AVATDateTO,
:ADIVISIONSWITHCHILDS, :ABUSORDERSWITHCHILDS, :ABUSTRANSACTIONSWITHCHILDS, :ABUSProjectSWITHCHILDS, :AVATCOUNTRY_ID,
:ACREATEDBYSELID, :ACORRECTEDBYSELID, :ACURRENCYSELID, :ACOUNTRYSELID) e
into :DocumentType, :ESLIndicator, :LocalAmount, :Amount, :VATIdentNumber, :DocumentCount
do suspend;
/* Dobropisy faktur vydanych */
for
select e.DocumentType, e.Eslindicator, e.Localamount, e.Amount, e.Vatidentnumber, e.Documentcount
from ESLReportByVATDate60(:AFIRMSELID, :ADIVISIONSSELID, :ABUSORDERSSELID, :ABUSTRANSACTIONSSELID, :ABUSProjectSSELID, :AVATDateFROM, :AVATDateTO,
:ADIVISIONSWITHCHILDS, :ABUSORDERSWITHCHILDS, :ABUSTRANSACTIONSWITHCHILDS, :ABUSProjectSWITHCHILDS, :AVATCOUNTRY_ID,
:ACREATEDBYSELID, :ACORRECTEDBYSELID, :ACURRENCYSELID, :ACOUNTRYSELID) e
into :DocumentType, :ESLIndicator, :LocalAmount, :Amount, :VATIdentNumber, :DocumentCount
do suspend;
/* Vraceni pokladnich prijmu */
for
select e.DocumentType, e.Eslindicator, e.Localamount, e.Amount, e.Vatidentnumber, e.Documentcount
from ESLReportByVATDate07(:AFIRMSELID, :ADIVISIONSSELID, :ABUSORDERSSELID, :ABUSTRANSACTIONSSELID, :ABUSProjectSSELID, :AVATDateFROM, :AVATDateTO,
:ADIVISIONSWITHCHILDS, :ABUSORDERSWITHCHILDS, :ABUSTRANSACTIONSWITHCHILDS, :ABUSProjectSWITHCHILDS, :AVATCOUNTRY_ID,
:ACREATEDBYSELID, :ACORRECTEDBYSELID, :ACURRENCYSELID, :ACOUNTRYSELID) e
into :DocumentType, :ESLIndicator, :LocalAmount, :Amount, :VATIdentNumber, :DocumentCount
do suspend;
/* Danove zalohove listy vydane */
for
select e.DocumentType, e.Eslindicator, e.Localamount, e.Amount, e.Vatidentnumber, e.Documentcount
from ESLReportByVATDate62(:AFIRMSELID, :ADIVISIONSSELID, :ABUSORDERSSELID, :ABUSTRANSACTIONSSELID, :ABUSProjectSSELID, :AVATDateFROM, :AVATDateTO,
:ADIVISIONSWITHCHILDS, :ABUSORDERSWITHCHILDS, :ABUSTRANSACTIONSWITHCHILDS, :ABUSProjectSWITHCHILDS, :AVATCOUNTRY_ID,
:ACREATEDBYSELID, :ACORRECTEDBYSELID, :ACURRENCYSELID, :ACOUNTRYSELID) e
into :DocumentType, :ESLIndicator, :LocalAmount, :Amount, :VATIdentNumber, :DocumentCount
do suspend;
/* Dobropisy danovych zalohovych listu vydanych */
for
select e.DocumentType, e.Eslindicator, e.Localamount, e.Amount, e.Vatidentnumber, e.Documentcount
from ESLReportByVATDate63(:AFIRMSELID, :ADIVISIONSSELID, :ABUSORDERSSELID, :ABUSTRANSACTIONSSELID, :ABUSProjectSSELID, :AVATDateFROM, :AVATDateTO,
:ADIVISIONSWITHCHILDS, :ABUSORDERSWITHCHILDS, :ABUSTRANSACTIONSWITHCHILDS, :ABUSProjectSWITHCHILDS, :AVATCOUNTRY_ID,
:ACREATEDBYSELID, :ACORRECTEDBYSELID, :ACURRENCYSELID, :ACOUNTRYSELID) e
into :DocumentType, :ESLIndicator, :LocalAmount, :Amount, :VATIdentNumber, :DocumentCount
do suspend;
end;