---
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


---

# Life cycle of records containing FX Currency fields

# Life cycle of records containing FX Currency fields {#ariaid-title1}

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

The behavior of FX Currency fields varies during the processing that occurs during the
lifetime of a record containing them.

## Insert / Update {#fx-currency-records-lifecycle__section_p5n_dnl_1kb}

The FX Currency field points to a Currency Instance \[fx_currency2_instance\] record. When you change the currency value in an FX Currency field, it determines the conversion rate and calculates the reference currency before:

* The before business rules run.
* The after business rules run, and it includes any further changes you may have made to the before business rules.

{#fx-currency-records-lifecycle__ul_pqg_5hw_5jb}  
Note:  
If the FX Currency field contains an invalid currency code, an exception condition may appear before these two stages occur.

## Auditing {#fx-currency-records-lifecycle__section_cbf_hnl_1kb}

Since an FX Currency field points to a Currency Instance record that stores multiple
values, the audit string is a composite that contains this information. The string stored in
the System Audit \[sys_audit\] table is in the format of
`EUR;111.222;4555525f5553445f3230313931323033`, with the following values,
separated by semicolons:

* Three letter ISO currency code. For example, `EUR`.
* Amount as an unformatted number. For example, `111.222`.
* System identifier (sys_id) for the conversion rate record in the Currency Conversion Rate \[fx_conversion_rate\] table. For example, `4555525f5553445f3230313931323033`.

{#fx-currency-records-lifecycle__ul_g3g_pvb_5jb}  
When creating history lines for a user, the audited string is formatted, using the locale of the user. It's in the format of `€111.22;2019-12-03 17:00:00-3000-01-01
23:59:59;fx_system_rate`, with the following values, separated by semicolons:

* Formatted currency string in the user locale. For example, `€111.22`.
* Start span-End span, as expressed in the conversion rate record in the System Rate \[fx_system_rate\] table. For example, `2019-12-03 17:00:00-3000-01-01
  23:59:59`.
* Name of the conversion rate table. For example, `fx_system_rate`.
{#fx-currency-records-lifecycle__ul_rj4_lzp_1y}
**Related concepts**   

* [Dot-walkable Currency Instance fields](https://servicenow-prod.fluidtopics.net/Sb9F7dy0Jeg7gStx5yWkWg "You can dot-walk certain fields in the Currency Instance [fx_currency2_instance] record, and field values stored in the database are consistent with each other. However, in script, since fields can be changed individually, and you change only some of the fields, they can be inconsistent.")