Name |
SQL type |
Description |
---|---|---|
VARCHAR |
VARCHAR |
All values are in upper case, e.g., all codes are in upper case in the system |
MIXVARCHAR |
VARCHAR |
Value could be in mixed case, e.g., Description |
NUMBER |
NUMBER |
Value is a number |
LONG |
NUMBER |
Value is a java long number |
CURRENCY |
NUMBER |
Value is a currency |
DECIMAL |
NUMBER |
Value is a java double. Can have decimals |
DURATION |
NUMBER |
Value is duration in minutes since an event |
DATE, DATETIME |
DATE |
Date / datetime |