CurrencyConversionRate

A currency conversion rate defines the daily conversion rates between two currencies to convert foreign currency amounts or translate and remeasure account balances to a reporting currency.

Expand all

Collapse all

Business Views

** Available for extracting data

• currencyConversionRatesExtract**

  A currency conversion rate defines the daily conversion rates between two currencies to convert foreign currency amounts or translate and remeasure account balances to a reporting currency.

  Label

  Currency Conversion Rates

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • conversionDate (date)

    The date for the conversion rate that's matched to the date to convert an amount to another currency.

    Label

    Conversion Date

    Properties

    • searchable
    • sortable
    • not nullable
  • conversionRate (big-decimal)

    The conversion rate at which an amount from Source Currency is converted into Target currency.

    Label

    Conversion Rate Type

    Properties

    • searchable
    • sortable
    • not nullable
  • conversionType (string)

    The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

    Label

    Conversion Rate Type

    Properties

    • searchable
    • sortable
    • not nullable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • fromCurrency (string)

    The source currency applicable to the conversion rate. The amount denominated in the from or source currency multiplied by the conversion rate gives the amount denominated in the to or target currency.

    Label

    From Currency

    Properties

    • searchable
    • sortable
    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • toCurrency (string)

    The currency to which another currency is being converted.

    Label

    To Currency

    Properties

    • searchable
    • sortable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable

Back to Top