Currency

Internal ID: currency

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
currencyformatsample	text	false	Format Sample	false
displaysymbol	text	false	Symbol	false
exchangerate	currency2	false	Default Exchange Rate ( to root subsidiary currency )	true
externalid	text	false	ExternalId	false
includeinfxrateupdates	checkbox	false	Automatic Update	false
isbasecurrency	checkbox	false	Is Base Currency	false
isinactive	checkbox	false	Inactive	false
name	text	false	Name	true	Enter a unique name for the currency. Because many countries use the same name for their currencies, you should use a combined name that includes the country name or abbreviation as well as the name of the currency. For example, pesos are the currency in the Philippines, Uruguay, and Mexico. In the Name field, you might enter “Mexican peso.” This name appears in the Currency field on records and transactions.
overridecurrencyformat	checkbox	false	Override Currency Format	false
symbol	text	false	ISO Code	true	Determines the way currency figures appear on reports and printed transactions. Defaults to the symbol associated with the value set in the locale field.
symbolplacement	select	false	Symbol Placement	false

Search Filters

Internal ID	Type	Label
exchangerate	float	Exchange Rate
externalid	select	External ID
externalidstring	text	External ID (Text)
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isinactive	checkbox	Inactive
name	text	Name
symbol	text	Symbol

Search Columns

Internal ID	Type	Label
exchangerate	float	Exchange Rate
externalid	select	External ID
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
internalid	select	Internal ID
isinactive	checkbox	Inactive
name	text	Name
symbol	text	Symbol