MAJCUSTCL FILE

                        AR Major Customer Class

AR Major Customer Class

REFERENCED BY

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

UPDATED BY

AR05.1    AR10.1    AR501     AR550     BL02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

MJC-ACTIVE-STATUS    Alpha 1                                     AR05.1
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
Used                 This is the used flag for the major         AR501   AR550
                     customer class. If this class has been      BL02.1
                     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   AR973
                                                                 BL02.1  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