Technical Information Guide
This functionality was introduced in version 7.0098.34, for the original specification please consult case 0000142648.
Relevant System Options
Program Name | Option ID | Values | Notes |
General | Use GMP Processing | Y,N | Default: N, must be set to Y to enable the functionality |
Technical Information Setup
This is a new screen added to support this functionality. If you have existing tabs, you can search for the database ID in the search box. This search is sorted by bigint (ascending).
Click the ‘Add’ button to create a new tab.
- Database Tab ID, must be unique;
- Tab Label;
- Tab Sequence, if another tab exists with the same sequence, the tabs are ordered by their database identifier (bigint).
Deleting a tab
Adding Rows and Columns
Rows and columns can be added by right clicking in the Row Definition or Column Definition box:
After clicking “Add row” or “Add column” the user is presented with an entry table.
Rows
- Row ID, the label used for the row;
- Sequence, if another row exists with the same sequence on the same level, the rows are ordered by bigint;
- Parent Row, if used will create this row as a node item of another row, this does not have a visual effect on the data input side, but can be used for reporting (indentation);
- Apply Min/Max Col, applies the minimum and maximum values of 5 and 6 to a selected numeric column;
- Minimum Value, the lower threshold of the column specified in 4;
- Maximum Value, the upper threshold of the column specified in 4;
- Max Value Overvlow, If the value specified in 6 is exceeded due to a cost roll up, specifies the row to apply the new value to.
Columns
- Column ID, the label used for the column;
- Sequence, if another column exists with the same sequence, the columns are ordered by bigint;
- DataType, can be “String”, “Numeric” or “Boolean”;
- Number Type, can be selected if 3 is set to “Numeric”;
- Mandatory When False, a list of columns with datatype of “Boolean”, indicates that this column needs a value if another column is not ticked (False).
Deleting a row or column
Entering Technical Information
Once all rows and columns are defined, the user can start inputting data. This can be done from the products screen after a record has been selected. Any data entered will be subject to the rules defined in the Technical Information Setup screen.
System Option
Technical Information Roll Up
Technical information can be rolled up to parent products, numeric values are summed and boolean values are maxed, i.e. if one value is true for any component then the next level up’s value will also be true.
There are two ways to do this, the first one via a new tool under product maintenance:
The second way is available as a utility so it can also be run via a maintenance plan: