Loading...
 

Technical Information

Technical Information Guide


This functionality was introduced in version 7.0098.34, for the original specification please consult case 0000142648.

Relevant System Options

Program NameOption IDValuesNotes
GeneralUse GMP ProcessingY,NDefault: 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.

  1. Database Tab ID, must be unique;
  2. Tab Label;
  3. Tab Sequence, if another tab exists with the same sequence, the tabs are ordered by their database identifier (bigint).

 Deleting a tab

If you wish to delete a tab, any existing values in row/column combinations will be deleted alongside, use at your own risk. This data is not retained anywhere in the database. A database backup would need to be restored to retrieve this data.

Adding Rows and Columns


Rows and columns can be added by right clicking in the Row Definition or Column Definition box:

2 Add Row Technical Information


After clicking “Add row” or “Add column” the user is presented with an entry table.

Rows

  1. Row ID, the label used for the row;
  2. Sequence, if another row exists with the same sequence on the same level, the rows are ordered by bigint;
  3. 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);
  4. Apply Min/Max Col, applies the minimum and maximum values of 5 and 6 to a selected numeric column;
  5. Minimum Value, the lower threshold of the column specified in 4;
  6. Maximum Value, the upper threshold of the column specified in 4;
  7. 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

  1. Column ID, the label used for the column;
  2. Sequence, if another column exists with the same sequence, the columns are ordered by bigint;
  3. DataType, can be “String”, “Numeric” or “Boolean”;
  4. Number Type, can be selected if 3 is set to “Numeric”;
  5. 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

If you wish to delete a row or column, any existing values in row/column combinations will be deleted alongside, use at your own risk. This data is not retained anywhere in the database. A database backup would need to be restored to retrieve this data.

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

To see the action, the “Use GMP Processing” system option to be enabled and set to ‘Y’.

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:

 System Option

To see the tool, the “Use GMP Processing” system option to be enabled and set to ‘Y’.