project
QadFinancials
> class
BHoliday
> business logic query GetHolidayByDate
Parameters
iiCompanyId
integer
Company id
itInputDate
date
query condition
each Holiday where
Holiday.Company_Id = iiCompanyId AND
Holiday.HolidayDate = itInputDate
query resultset tqGetHolidayByDate
field name
data type
db field
description
tiCompany_ID
integer
Holiday.Company_ID
Link to Company
ttHolidayDate
date
Holiday.HolidayDate
Holiday Date
Internal usage
QadFinancials
method BBill.IsHoliday
method BBill.NextWorkingDay