Currency conversion dataset

Currency conversion dataset for the Markdown & Promotions module, providing exchange rates between currency pairs for cross-region value normalisation.

The Currency conversion dataset provides exchange rates between currency pairs. It is used to normalise monetary values across regions that trade in different currencies.

This dataset acts as a reference dataset, providing exchange rates used to normalise values across regions.

Purpose

The Markdown & Promotions module uses the Currency conversion dataset to:

• Provide exchange rates between currency pairs
• Normalise values across regions for consistent analysis

Required fields

About the Constraint column: every field listed must be provided in your data. Non-null means its value cannot be null; Nullable means the value may be sent as null (or left blank in your source). Primary key, Unique, and Foreign key describe the field's role in the data model; a Primary key is always non-null.

Field	Description	Type	Constraint
from_currency	Currency to convert from.	string	Primary key
to_currency	Currency to convert to.	string	Primary key
exchange_rate	Exchange rate used to convert from the source to the target currency.	float	Non-null
updated_at	Timestamp when the record was last updated.	timestamp	Nullable
created_at	Timestamp when the record was created.	timestamp	Primary key

Usage notes

• Provide a rate for each currency pair used across the Locations dataset.
• Rates should be kept current to support accurate value normalisation.

Why this dataset matters

Consistent currency conversion lets the solution compare and aggregate values across regions that trade in different currencies.