Parameters
| iiCompanyId | integer | Company id |
| iiAccYear | integer | |
| iiAccPeriod | integer | |
query condition
each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodYear = iiAccYear AND
Period.PeriodPeriod = iiAccPeriod
each RevalHeader (inner-join) where
RevalHeader.Company_Id = iiCompanyId AND
RevalHeader.Period_ID = Period.Period_ID AND
query resultset tqPeriodForRevReport
| field name | data type | db field | description |
|---|
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiRevalHeaderNumber | integer | RevalHeader.RevalHeaderNumber | Rev Number |
Internal usage
QadFinancials