Maximo Data Types

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