| iiCompanyId | integer | Company id |
| ilPeriodIsPostingPCAllowed | logical | PeriodIsPostingPCAllowed |
| itPeriodEndDateBefore | date | PeriodEndDateBefore: pass a value for this parameter and the result-set will only contains records with a lower end-date |
each Period where
| field name | data type | db field | description |
|---|---|---|---|
| tiCompany_ID | integer | Period.Company_ID | Link to Company |
| tiPeriod_ID | integer | Period.Period_ID | Record ID |
| ttPeriodEndDate | date | Period.PeriodEndDate | End Date |
| tlPeriodIsPostingPCAllowed | logical | Period.PeriodIsPostingPCAllowed | Periodic Costing |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| ttPeriodStartDate | date | Period.PeriodStartDate | Start Date |
| tcPeriodStatus | character | Period.PeriodStatus | Status |
| tcPeriodTypeCode | character | Period.PeriodTypeCode | GL Period Type |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
QadFinancials