2020.2

Note
The value must be all in lowercase: true, false. Any variation in case (True, TRUE) will
not work.
Boolean expressions
Boolean values can be set using an expression of which the result is true or false. This is done
using operators and comparisons.
Example: record.fields["isCanadian"] = (extract("Country") == "CA");
For more information on JavaScript comparison and logical operators, please see
w3schools.com or developer.mozilla.org.
Currency
The Currency data type is a signed, numeric, fixed-point 64-bit number with 4decimals.Values
range from -922 337 203 685 477.5808 to 922 337 203 685 477.5808. This data type is
routinely used for financial calculations: it is as precise as integers.
Defining Currency values
l
Preprocessor:
l
In the Step properties pane, under Properties, add or select a field.
l
Specify the Type as Currency and set a default value as a number with up to 4
decimal points, followed by a semicolon; such as 546513.8798;
l
Extraction:
l
In the Data Model, select a field.
l
On the Step properties pane, under Field Definition set the Type to Currency.
l
Under Data Format, specify how the value is formatted in the data source (see
"Extract step properties" on page337; for the default format settings, see "Data
source settings" on page222).
The field value will be extracted and treated as a Float.
l
JavaScript Expression: Set the desired value to any Float value. Example:
record.fields["PreciseTaxSubtotal"] = 27.13465;
Page 281