Exchange rate daily - Chargebee Data Catalog

This table stores daily exchange rates that enable conversion of amounts from transaction currencies into the reporting currency configured in the Chargebee site. It can be joined with financial resources such as Subscriptions, Invoices, or Transactions to normalize revenue and payment amounts into a single reporting currency.

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.