Here is the complete list of available data types in TPAE/Maximo. The most used are marked in bold.
- ALN - Alphanumeric characters, mixed case
- AMOUNT - Decimal number, used for currency
- BLOB - Binary large object
- CLOB - Character large object
- CRYPTO - Encrypted binary
- CRYPTOX - Encrypted binary (one-way)
- DATE - Date only, no time
- DATETIME - Date and time
- DECIMAL - Decimal number
- DURATION - Duration, 1:30 is displayed to mean one and one-half hours
- FLOAT - Floating number
- GL - General Ledger account
- INTEGER - Integer number
- LONGALN - Long Alphanumeric
- LOWER - Lowercase characters
- SMALLINT - Small integer
- TIME - Time only, no date
- UPPER - Uppercase characters
- YORN - Yes or No, the database contains 1 or 0
Labels: beginner, database