Question & Answer
Question
Is there a list of Maximo Data types that can be used in Maximo?
Answer
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
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21614047