Damaged Asset Condition Options

The possible values for the damaged asset condition drop-down list are configured in the MESSAGE_CODE_LOOKUP database table. MESSAGE_TOPIC is 'DA_ASSET_CONDITION'. Drop-down list items are sorted according to the values in the MESSAGE_ORDER column.

Example

INSERT INTO message_code_lookup (message_topic, message_code,

message_string, message_order)

VALUES ('DA_ASSET_CONDITION', 'OK', 'OK', 2);

INSERT INTO message_code_lookup (message_topic, message_code,

message_string, message_order)

VALUES ('DA_ASSET_CONDITION', 'DAMAGED', 'Damaged', 1);

INSERT INTO message_code_lookup (message_topic, message_code,

message_string, message_order)

VALUES ('DA_ASSET_CONDITION', 'DOWN', 'Down', 3);