Lawson Insight Technical Documentation

                              MINORCL FILE

                              Minor Class

The Minor Class file is a detail file for the Major Class file. It breaks the
major class into smaller subclasses.

REFERENCED BY

DR100     IC10.1    IC10.2    IC11.1    IC120     IC125
IC134     IC135     IC138     IC140     IC141     IC142
IC145     IC150     IC151     IC152     IC205     IC206
IC207     IC210     IC211     IC212     IC213     IC219
IC220     IC223     IC225     IC226     IC227     IC228
IC230     IC232     IC238     IC239     IC295     IC30.1
IC330     IC530     IC59.1    IC70.1    IC811     IC83.1
PO04.2    PO204     PO213     PO23.5    PO254     PO275
PO276     PO277     PO280     PO54.1    PO54.2    PO54.3
PO54.4    PO550     POA2.3    POIJ.1    RQ04.1    RQ10.1
RQ10.3    RQ11.1    RQ204     RQ250     RQ35.1    RQ500
RQIF.1    WH20.7

UPDATED BY

IC05.1    IC06.1    IC07.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MIN-ITEM-GROUP       Alpha 5                                     IC05.1  IC06.1
Item Group           This field contains the identifier for      IC07.1
                     a group of items that can be shared by
                     one or more companies.

MIN-CLASS-TYPE       Alpha 1                                     IC05.1  IC06.1
Class Type           This field contains the class type,         IC07.1
                     which identifies the group of classes.
                     I = Inventory
                     P = Purchasing
                     S = Sales

MIN-MAJOR-CLASS      Alpha 4                                     IC05.1  IC06.1
Major Class          This field contains a classification of     IC07.1
                     item groups. This field is used for
                     reporting and inquiry purposes.

MIN-MINOR-CLASS      Alpha 4                                     IC05.1  IC06.1
Minor Class          This field contains the minor class,        IC07.1
                     which is a subdivision of the major
                     class.

MIN-DESCRIPTION      Alpha 30  (Lower Case)                      IC05.1  IC06.1
Description          This field contains the description of      IC07.1
                     the minor class.

MIN-ACTIVE-STATUS    Alpha 1                                     IC05.1  IC06.1
Status               This field contains the status of the       IC07.1
                     minor class which controls the use of
                     the class.
                     A = Active
                     I = Inactive

                         MINORCL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MINSET1   ITEM-GROUP                                             DR100   IC05.1
          CLASS-TYPE                                             IC06.1  IC07.1
          MAJOR-CLASS                                            IC10.1  IC10.2
          MINOR-CLASS                                            IC11.1  IC120
                                                                 IC125   IC134
                                                                 IC135   IC138
                                                                 IC140   IC141
                                                                 IC142   IC145
                                                                 IC150   IC151
                                                                 IC152   IC205
                                                                 IC206   IC207
                                                                 IC210   IC211
                                                                 IC212   IC213
                                                                 IC219   IC220
                                                                 IC223   IC225
                                                                 ...

                         MINORCL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            MIN-ITEM-GROUP     -> ITG-ITEM-GROUP

Majorclass     MAJORCL      Required

                            MIN-ITEM-GROUP     -> MAJ-ITEM-GROUP
                            MIN-CLASS-TYPE     -> MAJ-CLASS-TYPE
                            MIN-MAJOR-CLASS    -> MAJ-MAJOR-CLASS