Numeric Fields

Articles

Number
A Number field is a field that enables the user to type a whole number. General field properties can be found in General Field Properties. Value range: -999,999,999 ~ 999,999,999 Can be defined as Mandatory Can be defined as Read-only Can ...
AutoNumber Fields
AutoNumber fields are fields that 'automatically increment'; i.e. they are automatically assigned a number when a new record is created and the number increases by 1 for each new record.  This means they can be used to create an identity column whic...
Decimal
A Decimal field is a field that enables the user to type a number as a decimal. General field properties can be found in  General Field Properties. Can be defined as Mandatory Can be defined as Read-only Can specify a minimum or maximum valu...
Currency
A Currency field is similar to the Decimal Field , and includes the currency symbol in the field label. General field properties can be found in  General Field Properties. The maximum value allowed in a currency field is 1 000 000 000. ...