Parameters
| icDomain | character | |
| icCurr1 | character | |
| icCurr2 | character | |
| icRateType | character | |
| itStartDate | date | |
query condition
each exr_rate where
exr_rate.exr_domain = icDomain AND
exr_rate.exr_curr1 = icCurr1 AND
exr_rate.exr_curr2 = icCurr2 AND
exr_rate.exr_ratetype = icRateType AND
exr_rate.exr_start_date = itStartDate
query sort order
exr_rate.exr_domain (ascending)
exr_rate.exr_ratetype (ascending)
exr_rate.exr_curr1 (ascending)
exr_rate.exr_curr2 (ascending)
exr_rate.exr_start_date (ascending)
query resultset tqExrRateByKey
| field name | data type | db field | description |
|---|
| tcexr_domain | character | exr_rate.exr_domain | Domain |
| tcexr_curr1 | character | exr_rate.exr_curr1 | Cur 1 |
| tcexr_curr2 | character | exr_rate.exr_curr2 | Cur 2 |
| tcexr_ratetype | character | exr_rate.exr_ratetype | Rate Type |
| ttexr_start_date | date | exr_rate.exr_start_date | Start |
Internal usage
QadFinancials