CurrencyRateSnapshot Table

Each record in CurrencyRateSnapshot represents a single currency snapshot.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for CurrencyRateSnapshot table

Database Column



Type: integer. Key. Generated ID

Unique identifier for this record.


Type: text (max 256 characters)

Name of the currency snapshot.


Type: text (max 64 characters). Nullable

The resource string containing the name of the snapshot to display on the user interface.


Type: datetime. Nullable

Start date of the currency snapshot.

SnapshotReference CurrencyID

Type: integer. Nullable

Reference currency used for this snapshot. Foreign key to the Currency table.


Type: boolean. Key

Set to True if this is the default standard rate snapshot, which is created for each FNMP installation.


Type: text (max 256 characters). Nullable

Operator who last modified this record.


Type: datetime. Nullable

Date this record was last modified.