MINCUSTCL FILE

                        AR Minor Customer Class

AR Minor Customer Class

REFERENCED BY

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

UPDATED BY

AR05.1    AR08.1    AR10.1    AR501     AR550     AR970
BL02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

MNC-USED-FL          Alpha 1                                     AR08.1  AR10.1
Used                 This is the minor customer class used       AR501   AR550
                     flag. If this minor class has been used,    AR970   BL02.1
                     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
                                                                 AR973   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