IBM Support

List Of Available Data Types In TPAE/Maximo

Technote (FAQ)


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

Document information

More support for: Maximo Asset Management
Appl Designer

Software version: 7.1, 7.5, 7.6

Operating system(s): Linux, Windows

Reference #: 1614047

Modified date: 10 November 2015


Translate this page: