IBM Support

List Of Available Data Types In TPAE/Maximo

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

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Appl Designer","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21614047