project QadFinancials > class BVATPeriod > business logic query VATPeriodByStartDate

Description

VAT Period By Start Date


Parameters


iiCompanyIdintegerCompany id
iiYearintegerYear
itStartDatedateStart Date


query condition


  each VatPeriod where
VatPeriod.Company_Id = iiCompanyId AND
VatPeriod.VatPeriodYear = iiYear AND
VatPeriod.VatPeriodStartDate = itStartDate


query sort order


VatPeriod.Company_ID (ascending)
VatPeriod.VatPeriodStartDate (ascending)


query resultset tqVATPeriodByStartDate


field namedata typedb fielddescription
tiCompany_IDintegerVatPeriod.Company_IDLink to Company
tiVatPeriod_IDintegerVatPeriod.VatPeriod_IDRecord ID
ttVatPeriodEndDatedateVatPeriod.VatPeriodEndDateEnd Date
tiVatPeriodPeriodintegerVatPeriod.VatPeriodPeriodTax Period
ttVatPeriodStartDatedateVatPeriod.VatPeriodStartDateStart Date
tcVatPeriodStatuscharacterVatPeriod.VatPeriodStatusStatus
tiVatPeriodYearintegerVatPeriod.VatPeriodYearTax Year
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(VatPeriod)


Internal usage


QadFinancials
method BVATPeriod.AdditionalUpdates
method BVATPeriod.DefaultValues