Lawson Insight Technical Documentation

                             MAJCUSTCL FILE

                        AR Major Customer Class

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

REFERENCED BY

AR08.1    AR120     AR150     AR170     AR205     AR210
AR234     AR250     AR251     AR253     AR260     AR264
AR271     AR290     AR292     AR300     DT150

UPDATED BY

AR05.1    AR09.1    AR10.1    AR301     AR501     AR550
BL02.1    BL802     PW550     TX140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MJC-MAJOR-CLASS        Alpha 4                                   AR05.1
Element: Major Class   This is the user-defined major customer
                       class.

MJC-DESC               Alpha 30  (Lower Case)                    AR05.1
Element: Description   This is the major customer class
                       description.


MJC-ACTIVE-STATUS      Alpha 1                                   AR05.1
Element: Active Status Active Status flag indicates whether or
                       not a particular customer major class is
                       active. Valid values are:

                       A = Active
                       I = Inactive

MJC-USED-FL            Alpha 1                                   AR05.1  AR09.1
Element: Used Fl       This is the used flag for the major       AR10.1  AR301
                       customer class. If this class has been    AR501   AR550
                       used, the class may not be deleted.       BL02.1  BL802
                       Valid values are:                         PW550   TX140

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

                         MAJCUSTCL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MJCSET1   MAJOR-CLASS                                            AR05.1  AR08.1
                                                                 AR09.1  AR10.1
                                                                 AR120   AR150
                                                                 AR170   AR205
                                                                 AR210   AR234
                                                                 AR250   AR251
                                                                 AR253   AR260
                                                                 AR264   AR271
                                                                 AR290   AR292
                                                                 AR300   AR301
                                                                 AR501   AR550
                                                                 BL02.1  BL802
                                                                 DT150   PW550
                                                                 TX140

                         MAJCUSTCL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mincustclass   MINCUSTCL    Delete Cascades

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