gl_daily_rates table in r12

gl_daily_rates table in r12

In this post , We will discuss about GL daily rates table in r12. These tables stores GL currencies daily rates and their conversion rates too with different -different currencies. Here below we will describe complete details about gl daily rates table in r12.

 

 

Tables of GL Daily Rates in R12 

1.gl_daily_conversion_types

2.gl_daily_rates

 

 

SQL query Using gl_daily_rates table in r12

SELECT typ.user_conversion_type "Conversion Type"

,      rat.from_currency        "From Currency"

,      rat.to_currency          "To Currency"

,      MIN(conversion_date)     "Earliest Date"

,      MAX(conversion_date)     "Latest Date"

FROM   gl_daily_conversion_types typ

,      gl_daily_rates            rat

WHERE  rat.conversion_type = typ.conversion_type

AND    rat.from_currency   < rat.to_currency -- Ensure pairs only shown once.

GROUP BY typ.user_conversion_type

,        rat.from_currency  

,        rat.to_currency

ORDER BY typ.user_conversion_type, rat.from_currency, rat.to_currency;