MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Technical Library > Distribution > Expert Configurator > Programs > Matrix Detail Maintenance - Purpose > Matrix Detail Maintenance - Calculations

Matrix Detail Maintenance - Calculations

EC130E

A.   Housekeeping

1.   Common Processing routines - Housekeeping

2.   Work fields are defined and program constants are initialized.

3.   The following information is retrieved from the Reference file.

a.   The operating system's file access codes are retrieved from category 015.  If this record is not found, the program ends abnormally.

b.   The date format record (category 049) is retrieved.  If record is not found, the date format defaults to MMDDYY, a message is sent to the system operator, and processing continues.

4.   Retrieve number of decimals for quantity fields.

5.   An array with ten to the power of one through six is loaded to convert packed decimal fields.

6.   The database type (distribution, pricing, or manufacturing) is determined.

B.   Mainline

1.   The select screen is displayed and validated.

a.   The matrix number and part number must exist as a matrix of the current database type, and the part number must exist on the Part Master file.  If a group or subgroup is entered, it must exist on the Reference file.  If the matrix does not exist, is deactivated, or is in use, the select screen is displayed with the appropriate error message.

b.   If F4 is pressed for a promptable field, the valid values are displayed.

c.   The command window is displayed if F2 is pressed.  If a valid command or a fast path or a valid mnemonic code is entered on the command window, the program is ended.

2.   The keys select screen is displayed and validated.

a.   The matrix header information and key descriptions are retrieved from the Matrix Header file (EC120M1) and displayed.

b.   There can only be one X axis key and one Y axis key, and the rest (if any) must be fixed keys with a fixed value specified.  If there is only one key, it is defaulted to the Y axis key.

c.   The starting, ending, and fixed values are validated that they are of the correct data type and size.

d.   If F4 is pressed for a promptable field, the valid values are displayed.

e.   The command window is displayed if F2 is pressed.  If a valid command or a fast path or a valid mnemonic code is entered on the command window, the program is ended.3.            The matrix detail screen is displayed and validated.

a.   The open query files (EC120M2X, EC120M2Y) are opened and loaded with data matching the database type, matrix number, version number, and fixed key values.  If the matrix has only one dimension, EC120M2X is not used.

b.   The X axis is loaded (if the matrix is multi-dimensional).  Each X axis value is loaded separately  Only four values are loaded because only four values are displayed at one time.  If the X axis values are numeric, they are formatted to the correct length and decimal precision.  The first X value is saved and moved into the X axis header field.

c.   The Y axis values are loaded into the Y axis subfile until the end of file is reached or one full page has been loaded.  If the Y axis values are numeric, they are formatted to the correct length and decimal precision.  The first Y value is saved and moved into the Y axis header field.

d.   The matrix result values are loaded into the subfile until the end of file is reached or one full page has been loaded.  If the matrix is numeric, the values are formatted.  Result fields with no corresponding data are highlighted and protected (deactivated).

e.   If F20 (Y Addition) is pressed, the Y axis subfile and the results subfile are cleared.  If the X axis fields are already cleared, the X axis fields are reloaded and displayed.

f.    If F21 (X Addition) is pressed, the X axis fields and the results subfile are cleared.  If the Y axis subfile is already cleared, the subfile is reloaded and displayed.

g.   If F18 (Deactivation) is pressed, the cursor position is determined.  If the cursor is on a result field, the field is highlighted and protected.  If the cursor is on an X axis field, all the result fields currently being displayed that correspond to the X axis value are highlighted and protected.  If the cursor is on an Y axis field, all the result fields currently being displayed that correspond to the Y axis value are highlighted and protected.  If the cursor is on the origin, the entire result subfile is highlighted and protected.

h.   If F19 (Reactivation) is pressed, the cursor position is determined.  If the cursor is on a result field, the field is not highlighted and unprotected.  If the cursor is on an X axis field, all the result fields currently being displayed that correspond to the X axis value are not highlighted and unprotected.  If the cursor is on an Y axis field, all the result fields currently being displayed that correspond to the Y axis value are not highlighted and unprotected.  If the cursor is on the origin, the entire result subfile is not highlighted and unprotected.

i.    If ENTER is pressed, the screen is validated.

(1)  When in X or Y addition mode, the new key values are validated that they are unique.  The result subfile is checked that at least one field has been entered.  All new result fields that have no corresponding data are deactivated.

(2)  The new data (both result and key values) is validated for correct type, length, and precision.

(3)  If there are no validation errors, the Matrix Detail file is updated, the subfiles are reloaded with the new data, and they are displayed.

(4)  If the scroll fields have been changed, the subfiles are reloaded according to the new key values.

j.    If F9 or F24 are pressed, the data on the screen is not updated.

k.   If F10 is pressed, the data on the screen is not updated.

l.    The command window is displayed if F2 is pressed.  If a valid command or a fast path or a valid mnemonic code is entered on the command window, the program is ended.

m.  Pressing F14 displays the next set of available function keys.

EC130E Program Menu