project QadFinancials > class BHoliday > business logic query GetHolidayByYear

Parameters

iiCompanyId	integer	Company id
iiYear	integer

query condition

each Holiday where

Holiday.Company_Id = iiCompanyId AND
Year(Holiday.HolidayDate) = iiYear

query resultset tqGetHolidayByYear

field name	data type	db field	description
tiCompany_ID	integer	Holiday.Company_ID	Link to Company
tiHoliday_ID	integer	Holiday.Holiday_ID	Record ID
ttHolidayDate	date	Holiday.HolidayDate	Holiday Date
tcHolidayDescription	character	Holiday.HolidayDescription	Description
tcQADC01	character	Holiday.QADC01	unused QAD reserved field

Internal usage

QadFinancials

method BBill.GetToBillDInvoice
method BHoliday.ApiGetHolidayByYear
method BHoliday.ApiGetHolidayByYearAndCompany