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