Currency
Manages currency definitions and exchange rates for multi-currency transactions in NetSuite.
Columns
| Name | Type | ReadOnly | Description |
| InternalId [KEY] | String | True |
The internal identifier for the currency record in NetSuite, used for system tracking and integrations. |
| CurrencyPrecision | String | False |
The level of decimal precision used for this currency, defining the number of decimal places in transactions. The allowed values are _one, _two, _zero. |
| DisplaySymbol | String | False |
The currency symbol as displayed in NetSuite, such as '$' for USD or '€' for EUR. |
| ExchangeRate | Double | False |
The current exchange rate of this currency relative to the base currency, used in financial calculations. |
| ExternalId | String | False |
A unique external identifier for this currency, used for integrations with third-party systems. |
| FormatSample | String | False |
A sample format demonstrating how this currency is displayed in transactions, including thousands separators and decimal formatting. |
| FxRateUpdateTimezone | String | False |
The timezone applied when updating foreign exchange rates for this currency, ensuring accurate rate conversions. The allowed values are _americaNewYork, _asiaMagadan, _asiaTokyo, _europeParis. |
| InclInFxRateUpdates | Boolean | False |
Indicates whether this currency is included in automatic foreign exchange rate updates within NetSuite. |
| IsBaseCurrency | Boolean | False |
Indicates whether this is the base currency for the company, used as the default currency for financial reporting. |
| IsInactive | Boolean | False |
Specifies whether this currency is inactive in NetSuite, preventing it from being used in transactions. |
| Locale | String | False |
The locale associated with this currency, defining regional display settings such as number formatting. The allowed values are _afghanistanPashto, _afghanistanPersian, _alandIslandsSwedish, _albaniaAlbanian, _algeriaArabic, _angolaPortuguese, _anguillaEnglish, _antiguaAndBarbudaEnglish, _argentinaSpanish, _armeniaArmenian, _arubaEnglish, _arubaPortuguese, _australiaEnglish, _austriaGerman, _azerbaijanAzerbaijani, _bahamasEnglish, _bahrainArabic, _barbadosEnglish, _belarusByelorussian, _belgiumDutch, _belgiumFrench, _belizeEnglish, _bengali, _beninFrench, _bermudaEnglish, _bhutanDzongkha, _boliviaSpanish, _bonaireSaintEustatiusAndSabaDutch, _bosniaAndHerzegovinaBosnian, _botswanaEnglish, _brazilPortuguese, _bruneiMalay, _bulgariaBulgarian, _burkinaFasoFrench, _burundiFrench, _cambodiaKhmer, _cameroonFrench, _canadaEnglish, _canadaFrench, _canaryIslandsSpanish, _capeVerdePortuguese, _caymanIslandsEnglish, _centralAfricanRepublicFrench, _ceutaAndMelillaSpanish, _chadFrench, _chileSpanish, _chinaChinese, _colombiaSpanish, _comorosFrench, _congoDemocraticRepublicEnglish, _congoDemocraticRepublicFrench, _congoRepublicOfFrench, _costaRicaSpanish, _coteDivoireFrench, _croatiaCroatian, _cubaSpanish, _curacaoDutch, _cyprusEnglish, _cyprusEnglishEuro, _czechRepublicCzech, _denmarkDanish, _djiboutiArabic, _djiboutiFrench, _dominicaEnglish, _dominicanRepublicSpanish, _ecuadorSpanish, _egyptArabic, _elSalvadorSpanish, _equatorialGuineaSpanish, _eritreaAfar, _estoniaEstonian, _ethiopiaAmharic, _falklandIslandsEnglish, _fijiFijian, _finlandFinnish, _finlandFinnishEuro, _franceFrench, _franceFrenchEuro, _frenchPolynesiaFrench, _gabonFrench, _gambiaEnglish, _georgiaGeorgian, _germanyGerman, _germanyGermanEuro, _ghanaEnglish, _gibraltarEnglish, _goldOunce, _greeceGreek, _grenadaEnglish, _guatemalaSpanish, _guineaBissauPortuguese, _guineaFrench, _guyanaEnglish, _haitian, _hondurasSpanish, _hongKongChinese, _hungaryHungarian, _icelandIcelandic, _indiaEnglish, _indiaGujarati, _indiaHindi, _indiaKannada, _indiaMarathi, _indiaPanjabi, _indiaTamil, _indiaTelugu, _indonesiaIndonesian, _iranPersian, _iraqArabic, _irelandEnglish, _israelHebrew, _italyItalian, _italyItalianEuro, _jamaicaEnglish, _japanJapanese, _jordanArabic, _jordanEnglish, _kazakhstanRussian, _kenyaEnglish, _kuwaitArabic, _kuwaitEnglish, _kyrgyzstanRussian, _laosLao, _latviaLatvianLettish, _lebanonArabic, _lesothoEnglish, _liberiaEnglish, _libyaArabic, _lithuaniaLithuanian, _luxembourgFrench, _luxembourgGerman, _luxembourgLuxembourgish, _macauChinese, _macedoniaMacedonian, _malawiEnglish, _malaysiaMalay, _maldivesDhivehi, _maliFrench, _mauritiusEnglish, _mexicoSpanish, _moldovaRomanian, _moldovaRussian, _mongoliaMongolian, _moroccoArabic, _mozambiquePortuguese, _myanmarBurmese, _namibiaEnglish, _nepalNepali, _netherlandsAntillesDutch, _netherlandsDutch, _netherlandsDutchEuro, _newCaledoniaFrench, _newZealandEnglish, _nicaraguaSpanish, _nigerFrench, _nigeriaEnglish, _northKoreaKorean, _norwayNorwegian, _omanArabic, _pakistanUrdu, _palladiumOunce, _panamaSpanish, _papuaNewGuineaEnglish, _paraguaySpanish, _peruSpanish, _philippinesEnglish, _philippinesTagalog, _platinumOunce, _polandPolish, _portugalPortuguese, _portugalPortugueseEuro, _puertoRicoSpanish, _qatarArabic, _qatarEnglish, _romaniaRomanian, _russiaRussian, _rwandaFrench, _saintBarthelemyFrench, _saintHelenaEnglish, _saintKittsAndNevisEnglish, _saintLuciaEnglish, _saintMartinEnglish, _saintVincentAndTheGrenadinesEnglish, _samoaSamoan, _saoTomeAndPrincipePortuguese, _saudiArabiaArabic, _senegalFrench, _serbiaAndMontenegroSerbian, _serbiaSerbian, _serbiaSerboCroatian, _seychellesEnglish, _seychellesFrench, _sierraLeoneEnglish, _silverOunce, _singaporeEnglish, _sintMaartenDutch, _slovakiaSlovak, _slovakiaSlovakEuro, _sloveniaSlovenian, _sloveniaSlovenianEuro, _solomonIslandsEnglish, _somaliaSomali, _southAfricaAfrikaans, _southAfricaEnglish, _southKoreaKorean, _southSudanEnglish, _spainCatalan, _spainSpanish, _spainSpanishEuro, _sriLankaSinhalese, _sudanArabic, _surinameDutch, _swazilandSwati, _swedenSwedish, _switzerlandFrench, _switzerlandGerman, _switzerlandItalian, _syriaArabic, _taiwanChinese, _tajikistanTajik, _tanzaniaEnglish, _thailandThai, _togoFrench, _tongaTonga, _trinidadAndTobagoEnglish, _tunisiaArabic, _turkeyTurkish, _turkmenistanTurkmen, _turksAndCaicosIslandsEnglish, _ugandaEnglish, _ukraineUkrainian, _unitedArabEmiratesArabic, _unitedArabEmiratesEnglish, _unitedKingdomEnglish, _unitedStatesEnglish, _uruguaySpanish, _uzbekistanUzbek, _vanuatuEnglish, _vanuatuFrench, _venezuelaSpanish, _vietnamVietnamese, _wallisAndFutunaFrench, _yemenArabic, _zambiaEnglish. |
| Name | String | False |
The official name of the currency, such as 'United States Dollar' or 'Japanese Yen.' |
| OverrideCurrencyFormat | Boolean | False |
Indicates whether custom formatting overrides the standard currency display format in NetSuite. |
| Symbol | String | False |
The standard currency symbol, such as '$' for USD, '£' for GBP, or '¥' for JPY. |
| SymbolPlacement | String | False |
Defines whether the currency symbol appears before or after the amount, such as '$1,000' or '1,000$.' The allowed values are _afterNumber, _beforeNumber. |