Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MINORCL


                              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    BL120     BL122     BL130     BL20.1
BL20.3    BL205     BL21.2    BL21.5    BL243     BL29.1
BL29.2    BL45.2    BL46.2    BL47.2    BL48.2    BL520
BL820     BL85.3    BL92.1    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     IC46.1    IC530
IC55.1    IC59.1    IC70.1    IC811     IC83.1    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
OE111     OE113     OE114     OE116     OE129     OE13.2
OE13.3    OE13.5    OE14.4    OE289     OE30.1    OE30.2
OE30.3    OE30.4    OE30.5    OE30.6    OE30.7    OE30.9
OE510     OE530     OE810     OE830     PO04.2    PO100
PO150     PO204     PO213     PO223     PO23.5    PO25.6
PO25.7    PO254     PO275     PO276     PO277     PO280
PO36.2    PO536     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
SA04.1    SA80.3    SA90.3    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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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                                             BL120   BL122
          MAJOR-CLASS                                            BL130   BL20.1
          MINOR-CLASS                                            BL20.3  BL205
                                                                 BL21.2  BL21.5
                                                                 BL243   BL29.1
                                                                 BL29.2  BL45.2
                                                                 BL46.2  BL47.2
                                                                 BL48.2  BL520
                                                                 BL820   BL85.3
                                                                 BL92.1  DR100
                                                                 IC05.1  IC06.1
                                                                 IC07.1  IC10.1
                                                                 IC10.2  IC11.1
                                                                 IC120   IC125
                                                                 ...

                         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