industry-department-solutions
latest
false
Supply Chain & Retail Solutions user guide
- Overview
- Platform setup and administration
- Platform setup and administration
- Platform architecture
- Data Bridge onboarding overview
- Connecting a Peak-managed data lake
- Connecting a customer-managed data lake
- Creating an AWS IAM role for Data Bridge
- Connecting a Snowflake data warehouse
- Connecting a Redshift data warehouse (public connectivity)
- Connecting a Redshift data warehouse (private connectivity)
- Reauthorizing a Snowflake OAuth connection
- Using Snowflake with Peak
- SQL Explorer overview
- Roles and permissions
- User management
- Inventory management solution
- Commercial pricing solution
- Merchandising solution
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
| Field | Description | Type | Use | Notes |
|---|---|---|---|---|
from_currency | Currency to convert from. | string | Application / Presales | Required. Primary key. |
to_currency | Currency to convert to. | string | Application / Presales | Required. Primary key. |
exchange_rate | Exchange rate used to convert from the source to the target currency. | float | Application / Presales | Required. |
updated_at | Timestamp when the record was last updated. | timestamp | Application | Optional. |
created_at | Timestamp when the record was created. | timestamp | Application | Required. 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.