Lawson Insight Technical Documentation

                              MAJORCL FILE

                              Major Class

The Major Class file contains the major class codes which are entered on Item
Master records. There are three different types of major classes: inventory,
sales, and purchasing.

REFERENCED BY

BL05.1    BL09.1    BL205     BL243     BL41.1    BL45.2
BL46.2    BL47.2    BL48.2    BL85.3    DR100     IC00.1
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     IC236     IC238     IC239     IC295     IC30.1
IC330     IC530     IC70.1    IC811     IC83.1    PO04.2
PO204     PO213     PO275     PO276     PO277     PO280
PO550     POA2.3    POIJ.1    RQ04.1    RQ11.1    RQ204
RQ250     WH140

UPDATED BY

IC05.1    IC06.1    IC07.1    IC39.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

MAJ-CLASS-TYPE       Alpha 1                                     IC05.1  IC06.1
Class Type           This field indicates which group of         IC07.1  IC39.1
                     classes is assigned to this record.
                     I = Inventory Class
                     P = Purchasing Class
                     S = Sales Class
                     F = Freight Class

MAJ-MAJOR-CLASS      Alpha 4                                     IC05.1  IC06.1
Major Class          This field contains a classification        IC07.1  IC39.1
                     for a group of items within the class
                     type.

MAJ-DESCRIPTION      Alpha 30  (Lower Case)                      BL243   IC05.1
Description          This field contains the description of      IC06.1  IC07.1
                     the major class.                            IC39.1

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

                         MAJORCL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAJSET1   ITEM-GROUP                                             BL05.1  BL09.1
          CLASS-TYPE                                             BL205   BL243
          MAJOR-CLASS                                            BL41.1  BL45.2
                                                                 BL46.2  BL47.2
                                                                 BL48.2  BL85.3
                                                                 DR100   IC00.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
                                                                 ...

                         MAJORCL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            MAJ-ITEM-GROUP     -> ITG-ITEM-GROUP

                         MAJORCL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemmast       ITEMMAST

                            MAJ-ITEM-GROUP     -> ITE-ITEM-GROUP
                            MAJ-MAJOR-CLASS    -> ITE-PURCH-MAJCL
                                                  ITE-PURCH-MINCL
                                                  ITE-ITEM

Itemsales      ITEMMAST

                            MAJ-ITEM-GROUP     -> ITE-ITEM-GROUP
                            MAJ-MAJOR-CLASS    -> ITE-SALES-MAJCL
                                                  ITE-SALES-MINCL
                                                  ITE-ITEM

Minorclass     MINORCL      Delete Restricted

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