Field types for fields in the DataTable and DBDataSource objects.
The decimal precision of some of the fields is determined by settings located at Administration --> System Initialization --> General Settings.
Field types for fields in the DataTable and DBDataSource objects.
The decimal precision of some of the fields is determined by settings located at Administration --> System Initialization --> General Settings.
| Member | Value | Description |
|---|---|---|
| ft_NotDefined | 0 | Non-defined field |
| ft_AlphaNumeric | 1 | String field limited to 254 characters |
| ft_Integer | 2 | Integer field limited to numbers from −2,147,483,648 to +2,147,483,647 |
| ft_Text | 3 | String field without size limitation |
| ft_Date | 4 | Date field |
| ft_Float | 5 | Numeric field |
| ft_ShortNumber | 6 | Integer field limited to numbers from −32,768 to +32,767 |
| ft_Quantity | 7 | Numeric field whose decimal precision is defined by the Quantities administration setting. |
| ft_Price | 8 | Numeric field whose decimal precision is defined by the Prices administration setting. |
| ft_Rate | 9 | Numeric field whose decimal precision is defined by the Rates administration setting. |
| ft_Measure | 10 | Numeric field whose decimal precision is defined by the Units administration setting. |
| ft_Sum | 11 | Numeric field whose decimal precision is defined by the Amounts administration setting. |
| ft_Percent | 12 | Numeric field whose decimal precision is defined by the Percent administration setting. |