project QadFinancials > class BVATPeriod > business logic query VatPeriodByVatYearPeriod

Description

give all fields for that company, year and period,
sort on year and period


Parameters


iiCompanyIdintegerCompany id
iiVatPeriodYearintegerVat Year
iiVatPeriodPeriodintegerTax Period


query condition


  each VatPeriod where
VatPeriod.Company_Id = iiCompanyId AND
VatPeriod.VatPeriodYear = iiVatPeriodYear AND
VatPeriod.VatPeriodPeriod = iiVatPeriodPeriod

      first PeriodMark (inner-join) where
PeriodMark.Company_Id = iiCompanyId AND
PeriodMark.PeriodMark_ID = VatPeriod.PeriodMark_ID AND


query sort order


VatPeriod.VatPeriodYear (ascending)
VatPeriod.VatPeriodPeriod (ascending)


query resultset tqVatPeriodByVatYearPeriod


field namedata typedb fielddescription
tiCompany_IDintegerVatPeriod.Company_IDLink to Company
tiPeriodMark_IDintegerVatPeriod.PeriodMark_IDMark
tcPeriodMarkCodecharacterPeriodMark.PeriodMarkCodeMark
tiVatPeriod_IDintegerVatPeriod.VatPeriod_IDRecord ID
ttVatPeriodEndDatedateVatPeriod.VatPeriodEndDateEnd Date
tlVatPeriodIsReportCheckedlogicalVatPeriod.VatPeriodIsReportCheckedChecked for Reported
tiVatPeriodPeriodintegerVatPeriod.VatPeriodPeriodTax Period
ttVatPeriodStartDatedateVatPeriod.VatPeriodStartDateStart Date
tcVatPeriodStatuscharacterVatPeriod.VatPeriodStatusStatus
tiVatPeriodYearintegerVatPeriod.VatPeriodYearTax Year


Internal usage


QadFinancials
method BVATExportListing.AdditionalUpdates
method BVATExportListing.ApiExportYearlyVatBE
method BVATPeriod.DataLoadMultiple
method BVATPeriod.DataNewMultipleCopyYear
method BVATReport.DelayedTax
method BVATReport.GetPostingDateFromFilter