fx_rates

source

Exchange rates for currency translation.

Definition

Spot / average / closing FX rates by date. UNIQUE on (from_currency, to_currency, rate_date, rate_type). Monetary rows reference an fx_rate_id to compute their functional-USD amount.

7 of 7

Column

Description

Tests · PII

fx_rate_id

Primary key — BIGSERIAL on the source.

2 tests

from_currency

Source currency (ISO-4217, normalised uppercase).

to_currency

Target currency (defaults to `USD`).

rate_date

Date the rate applies to.

rate_type

Rate basis — `spot` / `average` / `closing`.

1 test

rate

Conversion rate. NUMERIC(18,8).

created_at

Row insert timestamp in the source DB.