Currency fields added to the data source export
Currency conversion fields that are automatically added to your data source export
The following table describes the currency conversion fields that are automatically added to your data source export.
|
Field Name |
Example |
Description |
|---|---|---|
|
<Object>.Amount<Currency> |
Invoice.AmountEUR |
The transaction amount converted into the specified currency. Note that this field has a different name depending on the object. |
|
<Object>.AmountCurrencyRounding <Currency> |
Invoice.AmountCurrencyRoundingJPY |
Rounding difference in the amount.
|
|
<Object>.ExchangeRate<Currency> |
Invoice.ExchangeRateEUR |
The exchange rate used to convert the transaction currency into the specified currency. |
|
<Object>.ExchangeRateDate |
Invoice.ExchangeRateDate |
The date used to determine the exchange rate. |
|
<Object>.ProviderExchangeRateDate |
Invoice.ProviderExchangeRateDate |
The exact date used to get the rate from the exchange rate provider. For example, you use the monthly rate and set the day of month to 1. For a transaction with the date "2015-10-15", the Exchange Rate Date is "2015-10-15" while the Provider Exchange Rate Date is "2015-10-01". |
|
<Object>.TransactionCurrency |
Invoice.TransactionCurrency |
The currency used by the customer. |