project QadFinancials > class BMfgExchangeRate > business logic query ExrRateByKey


Parameters


icDomaincharacter
icCurr1character
icCurr2character
icRateTypecharacter
itStartDatedate


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 namedata typedb fielddescription
tcexr_domaincharacterexr_rate.exr_domainDomain
tcexr_curr1characterexr_rate.exr_curr1Cur 1
tcexr_curr2characterexr_rate.exr_curr2Cur 2
tcexr_ratetypecharacterexr_rate.exr_ratetypeRate Type
ttexr_start_datedateexr_rate.exr_start_dateStart


Internal usage


QadFinancials
method BMfgExchangeRate.ApiReplicateFromFinancials