Data type
|
Format
|
Options
|
Boolean
|
A true or false value
|
|
Character
|
A single character value
|
You can set a default value and select rules for converting the case of what the user types.
|
Date
|
A date value with the year, month, and day
|
|
DBCS Only
|
A double-byte character string
|
|
Decimal
|
A decimal value
|
You can set options for the minimum and maximum values, U.S. or European separators, sign placement, and other settings
|
Float
|
A floating point number
|
You can set options for the minimum and maximum values, U.S. or European separators, sign placement, number of decimal places, and other settings
|
Integer
|
A whole integer value
|
You can set options for the minimum and maximum values, the currency symbol, sign placements, and other settings
|
Monetary Amount
|
A currency value
|
You can set options for the minimum and maximum values, the currency symbol, symbol placements, and other settings
|
Number
|
A numeric value
|
You can set options for the minimum and maximum values, U.S. or European separators, sign placement, and other settings.
|
Social Security Number
|
A U.S. social security number
|
You can set options for the minimum, maximum, and default values.
|
String
|
A character string
|
You can set options for the minimum number of characters required, the default value, and any case conversion that you need.
|
Time
|
A time value with hours, minutes, and seconds
|
You can set options for 12- or 24-hour format, separator character, and default value.
|
Timestamp
|
A system time stamp that specifes a date and time
|
|
USA State
|
A full name or abbreviation of a U.S.A. state, a territory, or the District of Columbia
|
You can enter and display either the full name or the two-character postal abbreviation for the state.
|
Zip Code
|
A U.S. postal zip code value
|
You can select either the 5-digit format or the zip-plus-4 format.
|