---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Select the rate and target table fields used for filtering

# Select the rate and target table fields used for filtering {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Optionally specify the rate table and target table fields to use for filtering
conversion rate information.

## About this task

For example, you maintain interfaces to several ERP systems, have currency conversion rates that are unique to each ERP, but you maintain all rates in a single table.

* To identify rates for a specific ERP system, there is a System field in the rate table that contain entries identifying each ERP system, for example, ABC, XYZ. In the target table with the FX Currency field, you have a similarly named field for identifying the conversion rates required for specific ERP systems.
* When you perform currency conversions, and the rate and target table field entries match, it uses the rates that are unique to that specific ERP.
{#fx-currency-rate-target-table-fields__ul_cjy_1ks_xjb}

## Procedure

1. Click the Rate Filter tab.
2. In the Rate Table Field field, select the field in the rate table to match against the specified target table field for conversion rate filtering.  
   Select --None-- skip use of a rate table field for conversion rate filtering.
3. In the Target Table Field field, select the field in the target table to match against the specified rate table field for rate filtering.  
   Select --None-- skip use of a target table field for rate filtering.
4. Click Save.
{#fx-currency-rate-target-table-fields__steps_qdg_tr5_rjb}
**Related concepts**   

* [Understanding FX Currency values in lists and reports](https://servicenow-prod.fluidtopics.net/0Y1LTpILTGUL5qz1ge23fA "By default, the currency values that appear in the FX Currency fields in lists and reports are the values that you directly enter into the FX Currency fields. For reports, the aggregations of FX Currency fields are, by default, reference currency values.")
* [Understanding FX Currency values in forms](https://servicenow-prod.fluidtopics.net/TPQHDkHckgWdUOH4_FagzQ "In forms, the FX Currency field behaves like a dot walkable field in script. It consists of an entry field, and an accompanying list for selection of a currency code.")