Group Field Configuration

Explanation

All available group fields in demand planning are listed here the existing entries are the default group fields. To add your own group fields simply add a new entry in this table. You need to provide the following information:

• GROUP_ID this is a number start with 100 as your first user defined group then 101 and so on. You will then be sure that any new IFS default groups installed will not overwrite your own groups.
• GROUP_NAME the name of the group, this will be the group name in the Demand Plan Client
• FIELD_NAME the name of the field this group is taken from
• FIELD_DESCRIPTION the name of the field that will be used for the groups description. If left NULL the group will only have the ID field and no description in Demand Planning
• TABLE_NAME the name of the table the group will be read from, this table must contain the fields CONTRACT/SITE and PART_NO and <FIELD_NAME> from the entry.

To clarify this lets take an example: For some reason we want to group parts by the unit code. We can use any GROUP_ID we want but to be sure we do not crash with new standard ones we use 100. GROUP_NAME is the name group it is displayed to the user. The unit code for each part is stored in the table INVENTORY_PART_PUB. It is stored in the field UNIT_MEAS. Description can be found by using the function ISO_UNIT_API.Get_Description(UNIT_MEAS,NULL).

Unit measurement can be added by adding a row with the following data

• GROUP_ID = 100

• GROUP_NAME = Unit Measurement

• FIELD_NAME = UNIT_MEAS

• FIELD_DESCRIPTION = ISO_UNIT_API.Get_Description (UNIT_MEAS,NULL)

• TABLE_NAME = INVENTORY_PART_PUB

 

Prerequisites

Demand Plan Server setup info

System Effects

Increases the number of group fields that can be selected as group fields in Demand Plan Server setup Group 1..Group 6