---
schema_version: "1"
id: 3928debe310b1c14d6739a5a381cb9d299e86a9924d14d9c11b715b6d42ae7a4
title: Considerations for Querying Currency Data Using SOQL
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-soql-sosl/guides/soql-sosl/sforce-api-calls-soql-consider-cur-data.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-consider-cur-data.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 181ca8ff21e1334d0b03f365da4fa561aa7a2d62e7ba85ef5c7acdab8af9ec44
products:
  - SOQL and SOSL Reference
  - Platform Developer Content
---

# Considerations for Querying Currency Data Using SOQL

These considerations apply when using SOQL to query Data Cloud objects, such as data lake objects (DLOs) and data model objects (DMOs).

- Use the `cdp_sys_record_currency__c` system field to query the ISO code value of a Data Cloud record.
- If an SOQL query on Data Cloud objects returns null values for all currency fields, the ISO code is unsupported or invalid. Check the `cdp_sys_record_currency__c` system field to make sure the ISO codes are supported by your org, or verify that it matches the default corporate currency if you're using a single currency. If all records are stored with valid ISO codes, make sure the org setup page has these ISO codes configured as supported currencies. To set up the supported currencies, see [Manage Multiple Currencies](https://help.salesforce.com/s/articleView?id=sales.admin_currency.htm&type=5).
- When querying currency data from Data Cloud objects using a SELECT clause, use an alias on the [`toLabel()`](https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-select-tolabel.md) function for the `CurrencyIsoCode` field. However, aliasing isn't required when using currency fields in a WHERE or ORDER BY clause.

  - Valid: `SELECT toLabel(CurrencyIsoCode) CurrencyCodeAlias, Currency__c FROM <DMO/DLO>`
  - Invalid: `SELECT toLabel(CurrencyIsoCode), Currency__c FROM <DMO/DLO>`

- The `convertCurrency()` function doesn't round the result to configured decimal places for the currency in your org when it's used on ‌currency fields from Data Cloud objects.