October 27, 2010

Add description field in the Unit of Measure lookup

By default Maximo 6 does not show the units of measure description in the lookup dialog.
To add this column you must edit the LOOKUPS.xml system configuration file.
Open th Maximo Application Designer: Go To > Configuration > Application Designer
In the dropdown box select 'Export System XML'.
Select the LOOKUPS entry and save the resulting xml file.
Locate the 'measureunit' table and add the description attribute. You will have something like this.

<table id="measureunit" inputmode="readonly" selectmode="single">
<tablebody id="measureunit_lookup_tablebody" filterexpanded="true" filterable="true" displayrowsperpage="20">
  <tablecol id="measureunit_lookup_tablebody_col_1" dataattribute="MEASUREUNITID" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" /> 
  <tablecol id="measureunit_lookup_tablebody_col_2" dataattribute="ABBREVIATION" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" /> 
  <tablecol id="measureunit_lookup_tablebody_col_desc" dataattribute="DESCRIPTION" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" /> 
  <tablecol id="measureunit_lookup_tablebody_col_3" dataattribute="siteid" mxevent_desc="" mxevent="selectrecord" sortable="true" type="link" /> 
</tablebody>
</table>

Import back the LOOKUPS.xml file as you would normally do to import an application definition using the Import Application Definition icon.

No comments:

Post a Comment