Currency
Create, update, delete, and query QuickBooks Currencies. This table requires QBXML version 8.0 or higher, and you will need to enable multiple Currencies in your QuickBooks company file to use it.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The Id of the currency. | |
| Name | String | False | 64 |
The name of the currency. | |
| IsActive | Boolean | False |
Boolean indicating if the currency is active. | ||
| CurrencyCode | String | False | 3 |
A maximum of 3 characters describing the code for the currency. For example: USD. | |
| CurrencyFormat_ThousandSeparator | String | False | 10 |
The separating character for thousands. For example, in 1,000,000 the comma is the separator. The allowed values are Comma, Period, Space, Apostrophe. The default value is Comma. | |
| CurrencyFormat_ThousandSeparatorGrouping | String | False | 50 |
Controls how the display of the currency value is grouped. For example, 10,000,000 is XX_XXX_XXX, but could be replaced by X_XX_XX_XXX. | |
| CurrencyFormat_DecimalPlaces | String | False | 50 |
Controls the display of the decimal value. For example, in 1.00 the value would be 2. You can change to 0 if you do not want decimals to be displayed. The default value is 2. | |
| CurrencyFormat_DecimalSeparator | String | False | 6 |
Controls the character used to separate decimal values from whole numbers. For example, in 1.00 the value is Period. The allowed values are Comma, Period. The default value is Period. | |
| IsUserDefinedCurrency | Boolean | True |
Indicates whether the currency is a built-in currency or a currency created by a QuickBooks user. | ||
| ExchangeRate | Double | True |
The market price for which the currency can be exchanged for the currency used by the QuickBooks company file as the home currency. The exchange rate should be considered a snapshot of the rates in effect at the AsOfDate. | ||
| AsOfDate | Date | True |
The date when the exchange rate was last changed. | ||
| EditSequence | String | True | 16 |
A string indicating the revision of the currency. | |
| TimeCreated | Datetime | True |
The time the currency was created. | ||
| TimeModified | Datetime | True |
The time the currency was last modified. |