Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MINCUSTCL FILE

                        AR Minor Customer Class

The AR Minor Customer Class file holds all customer minor classes. Every
minor class must belong to one customer major class (major classes are kept in
the AR Major Customer file). Many minor classes can have the same major class.
Every customer must belong to one major and minor class. These classes are
used for reporting selection criteria.

REFERENCED BY

AR150     AR170     AR205     AR210     AR234     AR250
AR251     AR253     AR260     AR271     AR292     DT150

UPDATED BY

AR05.1    AR08.1    AR501     AR550     BL02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MNC-MAJOR-CLASS      Alpha 4                                     AR05.1
Major Class          This is the major customer class.

MNC-MINOR-CLASS      Alpha 4                                     AR05.1
Minor Class          This is the minor customer class.

MNC-DESC             Alpha 30  (Lower Case)                      AR05.1
Description          This is the minor customer class
                     description.

MNC-USED-FL          Alpha 1                                     AR08.1  AR501
Used                 This is the minor customer class used       AR550   BL02.1
                     flag. If this minor class has been used,
                     it may not be deleted. Valid values are:

                     N = No; Class not used
                     Y = Yes; Class has been used

                         MINCUSTCL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MNCSET1   MAJOR-CLASS   This is the primary path used to access  AR05.1  AR08.1
          MINOR-CLASS   records.                                 AR150   AR170
                                                                 AR205   AR210
                                                                 AR234   AR250
                                                                 AR251   AR253
                                                                 AR260   AR271
                                                                 AR292   AR501
                                                                 AR550   BL02.1
                                                                 DT150

                         MINCUSTCL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Majcustclass   MAJCUSTCL    Required

                            MNC-MAJOR-CLASS    -> MJC-MAJOR-CLASS