Exchange rate daily - Chargebee Data Catalog

The exchange_rate_daily table contains site-specific end-of-day exchange rates. These rates are used to convert amounts from their original currencies to the site’s reporting currency. You can join this table with financial entities such as subscriptions, invoices, or transactions to normalize revenue and payment amounts into a single reporting currency.

Note:

The exchange rates reflect the site's configuration, using manual exchange rates when configured, and automatic exchange rates otherwise.
It includes exchange rate data only for currencies configured on your site.
Exchange rate data is generated only for configured currencies; when a new currency is added, the next export includes its full historical exchange rate data.

Columns

currency_code string, not null

The three-letter ISO currency code representing the currency in which product prices were charged. To convert an amount into the site’s reporting currency, multiply it by the corresponding exchange_rate.

date timestamp, null

The calendar date for which the exchange rate applies. The exchange rate for Day X is published at 03:00 AM UTC on Day X+1.

exchange_rate decimal, null

The end-of-day exchange rate between the currency_code and the site’s reporting currency. The value is determined based on the site’s configured exchange rate settings (manual or auto).

record_extracted_at timestamp

The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.

record_exported_at timestamp

The column represents the timestamp when the data was exported to the configured destination.

change_type string

The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.