Skip to main content
S
Samwise
August 29, 2025
Question

How to obtain FxRateId in BR.

  • August 29, 2025
  • 1 reply
  • 0 views

I am trying to write a query to the FxRates application table however, I cannot find a function to obtain the FxRateId as seen below. I see that the ID changes based on the year and not just the rate type.



 

1 reply

R
Russell
September 9, 2025

Can't you just join the 2 tables? FXRate and FXRateType?

SELECT 
    rt.UniqueID              AS FXRateID,           -- the GUID for the rate
    rt.Name                 AS RateTypeName,
    rt.Description          AS RateTypeDescription,
    r.TimeID,
    r.SourceCurrencyID,
    r.DestCurrencyID,
    r.Amount
FROM FXRate r
INNER JOIN FXRateType rt
    ON r.FXRateTypeID = rt.UniqueID

 

Terms & ConditionsAccessibility statement