invantive documentation
Invantive Support ForumsLog In / Sign Up

CurrencyRate: Visma.net Financials Currency Rates

insert REST

  • Catalog: VismaNet
  • Schema: CurrencyRate
  • Label: Currency Rates

Get all currency rates.

Can retrieve data and change data using insert.

API Source

  • Endpoint: /v2/currencyrate
  • Operation: get /v2/currencyrate

Performance Characteristics

Characteristic Value
Average access latency (ms) 239
Full scan rows per minute 3,010,000
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
fromCurrency `` Identifies from currency.
fromDate `` From effective date.
rateType `` Identifies rate type.
toCurrency `` Identifies to currency.
toDate `` To effective date.

Table Columns

The columns of the table CurrencyRate are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
effectiveDate datetime Effective Date filters on the platform, writable, effectiveDate EffectiveDate
fromCurrencyId varchar2 From Currency ID filters on the platform, writable, fromCurrencyId From Currency Id.
id int32 ID filters on the platform, writable, id Currency rate Id.
multDiv varchar2 itgen_vnet_multdiv filters on the platform, writable, multDiv Mult/Div
rate double itgen_vnet_rate filters on the platform, writable, rate Currency rate.
rateReciprocal double itgen_vnet_ratereciprocal filters on the platform, writable, rateReciprocal Rate reciprocal
rateType varchar2 itgen_vnet_ratetype filters on the platform, writable, rateType Currency rate type.
timeStamp blob Timestamp filters on the platform, writable, timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
toCurrencyId varchar2 itgen_vnet_tocurrencyid filters on the platform, writable, toCurrencyId To Currency Id.

Keys

Key Column Refers to Kind Description
CurrencyRate_fromCurrencyId_fk fromCurrencyId Currencies.id Key
CurrencyRate_toCurrencyId_fk toCurrencyId Currencies.id Key

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: