project QadFinancials > class BPeriod > business logic query PeriodForStartEndDateYearPd
Description
PeriodForStartEndDateYearPd: Query that returns the start and end date of a period based upon the company, year and period.
Parameters
| iiCompanyId | integer | Company id |
| iiPeriodYear | integer | Year of period |
| iiPeriodPeriod | integer | GL Period |
query condition
each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodPeriod = iiPeriodPeriod
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = Period.Company_ID AND
query resultset tqPeriodForStartEndDateYearPd
| field name | data type | db field | description |
|---|
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiCompany_ID | integer | Period.Company_ID | Link to Company |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| ttPeriodStartDate | date | Period.PeriodStartDate | Start Date |
| ttPeriodEndDate | date | Period.PeriodEndDate | End Date |
| tcPeriodStatus | character | Period.PeriodStatus | Status |
| tcPeriodTypeCode | character | Period.PeriodTypeCode | GL Period Type |
Internal usage
QadFinancials