Valutaopslagschemaet

Valutaopslagschemaet is a data model used in Danish financial information systems to store and retrieve currency metadata for lookup and processing tasks. The schema provides a standardized way to reference currencies across applications such as accounting, invoicing, ERP, and reporting, ensuring consistency in data exchange and presentation.

Core concepts and fields

A valutaopslagschema typically defines key attributes for each currency entry. Common fields include:

- code: the ISO 4217 currency code (eg, USD, EUR)

- numeric_code: the ISO 4217 numeric code

- name: the display name of the currency

- symbol: the customary symbol used in formatting

- decimal_places: the number of fractional digits (eg, 2)

- country or region: primary area where the currency is used

- exchange_rate_source: provider or method used to obtain rates

- last_updated: timestamp of the most recent rate or metadata update

- valid_from / valid_to: dates indicating the period during which the entry is valid

- status: active, inactive, or deprecated

- notes: additional remarks or conventions

Implementation and usage

The schema can be implemented as a relational table (eg, CURRENCY_LOOKUP), a JSON or XML schema for APIs, or as part of master data in ERP systems. It supports currency conversion, price formatting, invoicing, taxation, and financial reporting by providing a single source of truth for currency codes and related metadata. Data governance processes typically maintain accuracy and historical validity, often integrating updates from official rate providers.

Relation to standards

The schema aligns with international standards such as ISO 4217 for currency codes and ISO 3166 for country information. It may also reference recognized exchange rate sources (central banks, IMF, or commercial providers) to ensure traceability and auditable rate data.