CompanyCurrency
Defines each active currency configured for a QuickBooks Online company with multicurrency enabled, including currency codes, exchange rates, and activation status as seen in the Currency Center.
Table Specific Information
Select
All filterable columns support the following operators:
- =
- !=
- >=
- <=
- >
- <
- IN
- LIKE
- CONTAINS
The driver processes other filters client-side within the driver.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| Id [KEY] | String | True | True | True |
The identifier (Id) of the currency object. This Id uniquely identifies the currency record within QuickBooks Online. | |
| SyncToken | String | True | False | False |
The version number that is assigned to the currency object. The sync token locks the object for one application at a time, and QuickBooks Online increments it after each modification. An update or delete operation by using an older sync token fails, ensuring that only the latest version of the object is maintained. | |
| MetaData_CreateTime | Datetime | True | False | False |
The date and time when the currency record was originally created in QuickBooks Online. The CreateTime value provides a reference point for auditing and synchronization. | |
| MetaData_LastUpdatedTime | Datetime | True | False | False |
The date and time when the currency record was last updated in QuickBooks Online. The LastUpdatedTime value helps track changes and identify the most recent version of the record. | |
| Code | String | False | True | False |
The three-letter string that represents the ISO 4217 code for the currency (for example, USD or EUR). This code enables QuickBooks Online to apply the correct currency standards in multicurrency transactions. | |
| Name | String | False | False | False |
The full name of the currency object. This name allows users to identify the currency in reports and transactions. | |
| CustomFieldAggregate | String | False | False | False |
An XML aggregate that contains custom field information for the currency object. This column enables applications to retrieve or populate additional user-defined attributes in a structured format. | |
| Active | Boolean | False | True | False |
Indicates whether the currency is active. Inactive currencies cannot be posted to and are excluded from search results, although references to them are preserved for historical integrity. |