ODBC Driver for NetSuite

Build 25.0.9434

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434