How to Rename fields in APM-UI Configuration

Document ID : KB000111889
Last Modified Date : 22/08/2018
Show Technical Document Details
Introduction:
We have displayed the Country field for Location in APM. 
But in the APM GUI the field has a label of "Name" and we need that label to be "Country". 
The same applies to the "Alias" field in "Company Bought For", this should be labeled as "Company Code". 
When we are in the CONFIGURATION : ON editing mode, these field labels are not editable.
Question:
We have displayed the Country field for Location in APM. 
But in the APM GUI the field has a label of "Name" and we need that label to be "Country". 
The same applies to the "Alias" field in "Company Bought For", this should be labeled as "Company Code". 
When we are in the CONFIGURATION : ON editing mode, these field labels are not editable.
Environment:
Windows
Answer:
MDB manual update:
==================
1 Execute this query
SELECT form_attribute_id,control_type_id,form_id
,attribute_name,attribute_path,class_name,search_formlet
,group_in,visibility,label_format,sort_dirctn_id
,custom_attribute_label,core
FROM al_form_attribute_def
where attribute_name = 'preferredvendor'
OR
select custom_attribute_label,* from al_form_attribute_def WHERE custom_attribute_label is not NULL
OR
select custom_attribute_label,* from al_form_attribute_def 
WHERE custom_attribute_label is not NULL
and (custom_attribute_label like '%and%' or custom_attribute_label like '%Name%')

2 From the result write down the value of the column 'form_attribute_id'(12058 for me).

3a Then execute the following query
select custom_attribute_label,* from al_form_attribute_def WHERE form_attribute_id in (7,18)
3b Next I changed the label-text as follows:
UPDATE al_form_attribute_def SET custom_attribute_label = 'TEST LABEL' WHERE form_attribute_id = 12058

4 Open the APM-UI for the 'model' and confirm the label text changed.