The float datatype represents a floating point number. More precisely, a sequence of digits with an optional minus sign character -, and an optional decimal point .. The absence of the decimal point within the string will be interpreted as the float representation of an integer value.
float values may contain leading zeros, e.g. 00023.23 = 23.23. Values may contain or omit trailing zeros after the decimal point, e.g. “23.0” = “23.0000” = “23” = “23.”.
All float fields must accommodate up to fifteen significant digits. The number of decimal places used should be a factor of business/market needs and mutual agreement between counterparties.
| Example | Valid | Notes |
|---|---|---|
| 23.23 | ||
| 0023.2300 | ||
| -23.23 | ||
| 25 | ||
| +23 | Positive values are represented without a sign character | |
| 10.0a | 'a' is not a valid digit |