project QadFinancials > class BMfgGLCalendar > business logic query GLCalendarYrByDateDomain
Parameters
| icDomainCode | character | |
| itDate | date | |
query condition
each glc_cal where
glc_cal.glc_domain = icDomainCode AND
glc_cal.glc_start <= itDate AND
glc_cal.glc_end >= itDate
query resultset tqGLCalendarYrByDateDomain
| field name | data type | db field | description |
|---|
| tcglc_domain | character | glc_cal.glc_domain | Domain |
| ttglc_end | date | glc_cal.glc_end | Period End |
| tiglc_per | integer | glc_cal.glc_per | Period |
| ttglc_start | date | glc_cal.glc_start | Period Start |
| tiglc_year | integer | glc_cal.glc_year | Year |
Internal usage
QadFinancials