Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MINCUSTCL


                             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    AR10.1    AR501     AR550

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

MNC-USED-FL            Alpha 1                                   AR08.1  AR10.1
Element: Used          This is the minor customer class used     AR501   AR550
                       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.                                 AR10.1  AR150
                                                                 AR170   AR205
                                                                 AR210   AR234
                                                                 AR250   AR251
                                                                 AR253   AR260
                                                                 AR271   AR292
                                                                 AR501   AR550
                                                                 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