Numerics

A numeric definition enables the user interface to properly position the values of fields that can be either numeric or alpha so that the database files can be accessed for Drill Arounds and Selects. There are several fields in the Lawson system—including vendor, voucher number, and purchase order number—that can be defined as numeric or alpha, based on the setting of another field. Because the system stores numeric and alpha data differently, it must know whether the field is numeric or alpha in order to be able to use the field's value to search for data.

The following entries make up a numeric definition.

Use To
DEFINE NUMERIC Begin each numeric definition.
ID Specify a unique identifier for this form rules object. For more information on IDs, see Form Rules Guidelines
SCRFLD Name the form field that invokes this rule. Only field names that can be set up as either numeric or alpha are valid.
FILENAME Name the file that this rule accesses records in.
INDEX Name the index used to access the records.
KEYRNG

Name the key fields or values used to access records for the Select window. Separate entries with a comma. The number of entries next to KEYRNG must be less than the number of key fields in the index (INDEX). The order of the entries next to KEYRNG must follow the order of the index fields.

The following are valid entries for KEYRNG:

  • A form field name

  • A function name

  • A constant value, in double quotes.

    Include any leading or trailing spaces or zeroes in the double quotes. For example, to search for the constant value 4 in a numeric field of length 3, type "004" next to KEYRNG.

  • ~SPACES for spaces

  • ~ZEROES for zeroes
VALIDITY Name the form field that the system should check to determine if the field named in SCRFLD is numeric or alpha.