1.6

Table Of Contents
Building Float Values
Float values can be the result of direct attribution or mathematical operations just like Integer
values.
Currency Data Types
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
Pre-Processor: In the step properties selection under Properties specify the "Type" as
"Currency" and set a default value as a number with up to 4 decimal points, such as
546513.8798
l
Extraction: In the step properties under Field Definition specify "Type" as "Currency"
and configure how the value will be read from the Source Record (see Extract Step). 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;
While currency values can be set to up to 4 significant digits, only 2 are displayed on screen.
Building Currency Values
Currency values can be the result of direct attribution or mathematical operations just like
Integer and Float values.
Date Data Type
Dates are values that represent a specific point in time, precise up to the second. They can also
be referred to as datetime values. While dates are shown visually under the system's regional
settings, in reality they are stored unformatted.
Page 144