Text string. This is a series of one or more alphanumeric characters, possibly including a letter, number, space, punctuation mark or other special characters.
Alphabetic
I
Integer. This is a numeric field without a fractional component.
Numeric
F
Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator.
Numeric
FF
Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. Forced formatting of data columns.
Numeric
FC
Numeric or float value and may contain numeric separators including a comma for decimal separator and a period for thousands separator.
Numeric
C
Similar to F with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored.
Numeric
CC
Similar to FC with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored.
Numeric
M
Date format in many popular formats. SeeAdvanced Date Sorting for more information. This is the preferred date sorting type.
Date
D
Date in the browser date format. SeeAdvanced Date Sorting for more information. The D type is available for compatibility with older releases - the M type is recommended.
Date
E
Emoticons or other HTML elements.
Alphabetic on the inner HTML value
X
Indicates to exclude this column from user selectable sorting.
Disabled
.
Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '.'.
Numeric on each separated value
:
Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by ':'.
Numeric on each separated value
-
Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '-'.
Numeric on each separated value
/
Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '/'.
