business logic query VatPeriodByStartEndDate

Annotation

check if the given date is between the start and end date

Description

VatPeriodByStartEndDate

Parameters

iiCompanyId	integer	Company id
itDate	date	date
icStatus	character	Period Status

query condition

each VatPeriod where

VatPeriod.Company_Id = iiCompanyId AND
VatPeriod.VatPeriodEndDate >= itDate AND
VatPeriod.VatPeriodStartDate <= itDate AND
VatPeriod.VatPeriodStatus = icStatus

query sort order

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

query resultset tqVatPeriodByStartEndDate

field name	data type	db field	description
tiCompany_ID	integer	VatPeriod.Company_ID	Link to Company
tiPeriodMark_ID	integer	VatPeriod.PeriodMark_ID	Mark
tiVatPeriod_ID	integer	VatPeriod.VatPeriod_ID	Record ID
ttVatPeriodEndDate	date	VatPeriod.VatPeriodEndDate	End Date
tlVatPeriodIsReportChecked	logical	VatPeriod.VatPeriodIsReportChecked	Checked for Reported
tiVatPeriodPeriod	integer	VatPeriod.VatPeriodPeriod	Tax Period
ttVatPeriodStartDate	date	VatPeriod.VatPeriodStartDate	Start Date
tcVatPeriodStatus	character	VatPeriod.VatPeriodStatus	Status
tiVatPeriodYear	integer	VatPeriod.VatPeriodYear	Tax Year
tiVatPeriodYearPeriod	integer	VatPeriod.VatPeriodYearPeriod	Tax Year/GL Period

Internal usage

QadFinancials

method BCInvoice.ValidateComponentPost
method BDInvoice.ValidateTaxPointDate
method BPosting.AddTaxPosting
method BPosting.ValidateComponentPreAssignPostingVat
method BVATReport.VATFilterValidation