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