Currency fields in FX data
The 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 field> |
Invoice.Total Amount |
The transaction amount converted into the specified currency. Note that this field has a different name depending on the object. |
|
<Object>.AmountCurrencyRounding |
Invoice.AmountCurrencyRounding |
Rounding difference in the amount.
|
|
<Object>.Home Currency Rate |
Invoice.HomeCurrencyRate |
The exchange rate used to convert the transaction currency into the specified currency. |
|
<Object>.Home Currency Rate Date |
Invoice.Home Currency Rate Date |
The date used to determine the exchange rate. |
|
<Object>.Reporting Currency Rate |
Invoice.Reporting Currency Rate |
The exchange rate used to convert the transaction currency into the specified currency. |
|
<Object>.Reporting Currency Rate Date |
Invoice.Reporting Currency Rate Date |
The date used to determine the exchange rate. |
|
<Object>.Reporting Currency Amount Rounding |
Invoice.Reporting Currency Amount Rounding |
Rounding difference in the amount. |
|
<Object>.Reporting Currency Amount Without Tax Rounding |
Invoice.Reporting Currency Amount Without Tax Rounding |
Rounding difference in the amount. |