{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":38662,"path":"platform-administration/currency-administration/fx-currency-records-lifecycle.md","title":"Life cycle of records containing FX Currency fields","bundle":null,"doc_type":null,"release":"australia","body":"\n# Life cycle of records containing FX Currency fields\n\nThe behavior of FX Currency fields varies during the processing that occurs during the lifetime of a record containing them.\n\n## Insert / Update\n\nThe 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:\n\n-   The **before** business rules run.\n-   The **after** business rules run, and it includes any further changes you may have made to the **before** business rules.\n\n**Note:** If the FX Currency field contains an invalid currency code, an exception condition may appear before these two stages occur.\n\n## Auditing\n\nSince 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:\n\n-   Three letter ISO currency code. For example, `EUR`.\n-   Amount as an unformatted number. For example, `111.222`.\n-   System identifier \\(sys\\_id\\) for the conversion rate record in the Currency Conversion Rate \\[fx\\_conversion\\_rate\\] table. For example, `4555525f5553445f3230313931323033`.\n\nWhen 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:\n\n-   Formatted currency string in the user locale. For example, `€111.22`.\n-   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`.\n-   Name of the conversion rate table. For example, `fx_system_rate`.\n\n**Parent Topic:**[Currency administration references](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/currency-administration/currency-admin-references.md)\n\n**Related topics**  \n\n\n[Dot-walkable Currency Instance fields]()\n\n"}}