Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              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

BL05.1    BL09.1    BL205     BL243     BL45.2    BL46.2
BL47.2    BL48.2    BL85.3    BL92.1    IC10.1    IC10.2
IC11.1    IC120     IC125     IC134     IC135     IC138
IC140     IC141     IC142     IC145     IC150     IC151
IC152     IC16.3    IC205     IC206     IC207     IC210
IC211     IC212     IC213     IC219     IC220     IC223
IC225     IC226     IC227     IC228     IC230     IC232
IC238     IC239     IC295     IC30.1    IC530     IC70.1
IC811     MA04.2    MA204     OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE113     OE114
OE129     OE14.4    OE15.1    OE15.2    OE15.3    OE15.4
OE15.5    OE15.7    OE289     OE510     OE810     OE920
PO20.1    PO213     PO22.3    PO280     PO31.1    PO550
PO821     POA2.1    RQ04.1    RQ10.1    RQ204     RQ250
SA04.1    SA80.3    SA90.3    SAA2.1    WH20.2    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)                      BL205   BL243
Description          This field contains the description of      IC05.1  IC06.1
                     the minor class.                            IC07.1  OE289
                                                                 SA04.1

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                                             BL05.1  BL09.1
          CLASS-TYPE                                             BL205   BL243
          MAJOR-CLASS                                            BL45.2  BL46.2
          MINOR-CLASS                                            BL47.2  BL48.2
                                                                 BL85.3  BL92.1
                                                                 IC05.1  IC06.1
                                                                 IC07.1  IC10.1
                                                                 IC10.2  IC11.1
                                                                 IC120   IC125
                                                                 IC134   IC135
                                                                 IC138   IC140
                                                                 IC141   IC142
                                                                 IC145   IC150
                                                                 IC151   IC152
                                                                 IC16.3  IC205
                                                                 ...

                         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