Currency
Handles QuickBooks currency management, including creation, updates, deletion, and querying of supported currencies. Requires QBXML Version 8.0 or higher, with multi-currency enabled.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier for the currency. | |
| Name | String | False | 64 |
The full name of the currency, such as United States Dollar or Euro. | |
| IsActive | Boolean | False |
Indicates whether the currency is currently active and available for use in transactions. | ||
| CurrencyCode | String | False | 3 |
A three-character code that represents the currency, such as USD for United States Dollar or EUR for Euro. | |
| CurrencyFormat_ThousandSeparator | String | False | 10 |
The character used to separate thousands in currency values. For example, a comma in 1,000,000. The allowed values are Comma, Period, Space, Apostrophe. The default value is Comma. | |
| CurrencyFormat_ThousandSeparatorGrouping | String | False | 50 |
Specifies how currency values are grouped by thousands. For example, 10,000,000 may use a grouping pattern such as XX_XXX_XXX. | |
| CurrencyFormat_DecimalPlaces | String | False | 50 |
Specifies the number of decimal places to display in the currency value. For example, '2' for values like 1.00. The default value is 2. | |
| CurrencyFormat_DecimalSeparator | String | False | 6 |
The character used to separate whole numbers from decimal values in currency. For example, a period in 1.00. The allowed values are Comma, Period. The default value is Period. | |
| IsUserDefinedCurrency | Boolean | True |
Indicates whether the currency is a default currency provided by QuickBooks or a custom currency created by the user. | ||
| ExchangeRate | Double | True |
The exchange rate for converting this currency to the home currency in the QuickBooks company file. The rate reflects the snapshot in effect at the AsOfDate. | ||
| AsOfDate | Date | True |
The date when the exchange rate was last updated or modified. | ||
| EditSequence | String | True | 16 |
A string representing the version of this currency record. Useful for tracking changes. | |
| TimeCreated | Datetime | True |
The date and time when the currency record was originally created. | ||
| TimeModified | Datetime | True |
The date and time when the currency record was last modified. |