Entities

FX rate

An exchange rate for a currency pair, effective-dated and keyed by convention (transaction date, period end, average).

Volume

Thousands per year

Retention

Indefinite — historical restatement depends on it

Entity attributes6
  • Exact decimal arithmetic end to end — database column, ORM mapping, API serialisation and client. Floating point anywhere in the chain is disqualifying.
  • Exchange rates must be effective-dated and keyed by convention. There is no single current rate.
  • Exchange rates must be effective-dated and keyed by convention. There is no single current rate.
  • fx_rate_id
  • from_currency / to_currency
  • source
Entity relationships1
Entity lifecycle

Not yet researched

Only the control-bearing entities were modelled for lifecycle. Defensible as a starting point, but it does leave the entity model uneven, and this is incompleteness rather than a finding.