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

Details

CurrencyRateSnapshotID

Type: integer. Key. Generated ID

Unique identifier for this record.

SnapshotName

Type: text (max 256 characters)

Name of the currency snapshot.

SnapshotResourceID

Type: text (max 64 characters). Nullable

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

SnapshotDate

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.

IsStandardRateSnapshot

Type: boolean. Key

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

UpdatedUser

Type: text (max 256 characters). Nullable

Operator who last modified this record.

UpdatedDate

Type: datetime. Nullable

Date this record was last modified.