Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAJCUSTCL


                             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    AR150     AR170     AR205     AR210     AR234
AR250     AR251     AR253     AR260     AR271     AR290
AR292     DT150

UPDATED BY

AR05.1    AR10.1    AR501     AR550

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: 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  AR10.1
Element: Used          This is the used flag for the major       AR501   AR550
                       customer class. If this class has been
                       used, the class may not be deleted.
                       Valid values are:

                       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   This is the primary path used to access  AR05.1  AR08.1
                        records.                                 AR10.1  AR150
                                                                 AR170   AR205
                                                                 AR210   AR234
                                                                 AR250   AR251
                                                                 AR253   AR260
                                                                 AR271   AR290
                                                                 AR292   AR501
                                                                 AR550   DT150

                         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