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

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

UPDATED BY

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

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  AR09.1
Element: Used Fl       This is the minor customer class used     AR10.1  AR301
                       flag. If this minor class has been used,  AR501   AR550
                       it may not be deleted. Valid values are:  BL02.1  BL802
                                                                 PW550   TX140
                       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                                            AR05.1  AR08.1
          MINOR-CLASS                                            AR09.1  AR10.1
                                                                 AR120   AR150
                                                                 AR170   AR205
                                                                 AR210   AR234
                                                                 AR250   AR251
                                                                 AR253   AR260
                                                                 AR271   AR292
                                                                 AR300   AR301
                                                                 AR501   AR550
                                                                 BL02.1  BL802
                                                                 DT150   PW550
                                                                 TX140

                         MINCUSTCL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Majcustclass   MAJCUSTCL    Required

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