business logic query VatPeriodByVatYearPeriod

Description

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

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

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

field name	data type	db field	description
tiCompany_ID	integer	VatPeriod.Company_ID	Link to Company
tiPeriodMark_ID	integer	VatPeriod.PeriodMark_ID	Mark
tcPeriodMarkCode	character	PeriodMark.PeriodMarkCode	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

QadFinancials